Busy — Wed, 17 Nov 2004 22:28:50 +0000

insert the details into the database then send you an email on success, easier than the other way round

antoshka — Wed, 17 Nov 2004 19:50:20 +0000

1. create a new DB user and new database for your site. (in control panel?)
2. create a new table in the database with the fields Field1, Field2, etc as needed. (in phpMyAdmin)
2. write a small PHP script that will insert the necessary data in the database.

example:

<?php
mysql_connect("localhost", "<username>", "<password>");
mysql_select_db("<database>");

// write form data to PHP variables
$field1 = $_POST[Field1];
$field2 = $_POST[Field2];

mysql_query("INSERT INTO <database> (Field1, Field2) VALUES ('$field1', '$field2')");

echo "Thank you! Form submitted successfully"
?>

You need to replace , , with appropriate info. The $_POST[...] bit refers to the form data. If your form method is set to GET, then use $_GET[...] instead. You can modify the SQL query as needed to add more fields to the database.