I'll post the code, most of it is from a guide I was using because it's been a really long time since I've messed with php and I've forgotten most of it but here's the code.
<html>
<head>
</head>
<body>
<?php
if ( isset( $title ) && isset( $size ) && isset( $group ) )
{
// check user input here!
$dberror = "";
$ret = add_to_database( $title, $size, $group, $dberror );
if ( ! $ret )
print "Error: $dberror<BR>";
else
print "Thank you very much";
}
else {
write_form();
}
function add_to_database( $title, $size, $group, &$dberror )
{
$user = "nicpow1_collect";
$pass = "********";
$db = "nicpow1_collect";
$link = mysql_pconnect( "mysql1.100ws.com", $user, $pass );
if ( ! $link )
{
$dberror = "Couldn't connect to MySQL server";
return false;
}
if ( ! mysql_select_db( $db, $link ) )
{
$dberror = mysql_error();
return false;
}
$query = "INSERT INTO soccer ( title, size, group ) values('$title', '$size', '$group')";
if ( ! mysql_query( $query, $link ) )
{
$dberror = mysql_error();
return false;
}
return true;
}
function write_form()
{
global $PHP_SELF;
print "<form action=\"$PHP_SELF\" method=\"POST\">\n";
print "<input type=\"text\" name=\"title\"> ";
print "Title<p>\n";
print "<input TYPE=\"text\" name=\"size\"> ";
print "Size<p>\n";
print "<select name=\"group\">\n";
print "\t<option value=\"A\"> Group A\n";
print "\t<option value=\"B\"> Group B\n";
print "</select>\n";
print "<input type=\"submit\" value=\"submit!\">\n</form>\n";
}
?>
</body>
</html>
