Simple form

Dennis99

I would like to have a simple form, with one text box and a submit button. I want to put my name in it, hit submit and have it add a record to the table I created in MySql. I have PHP and MySql running, and I know it works. Anybody got a snippet for this?
Thanks much

Diogin

I think you'd better read the cookbook first...

Dennis99

Either you have it or you don't. I don't need smart a-- answers.

Herk

Okay here you go.

<?
// Connect to your database
$dbconnection = mysql_connect(server, username, password)
  or die("Could not connect : " . mysql_error());
mysql_select_db(dbname)
  or die("Could not select database");
// This section will process the form
$text = $_POST['text'];
if (!empty($text)) {
  mysql_query("INSERT INTO table VALUES (\"".$text."\")");
}
// Draw the form
echo ("<form action=\"".$PHP_SELF."\" method=\"post\">
  <input type=\"text\" name=\"text\">
  <input type=\"submit\" value=\"Submit\">
</form>
");
?>

See if that helps you out.

Herk