bahattab
21-01-2008, 01:28 AM
How can i send form data to a mysql database using php?
Answer by: Stuart Pierce, Aplus.Net Knowledge Base Support
You can use a PHP script to send data collected by an online form to your MySQL database. In our example, two files are needed for this purpose:
the HTML online form where users' data will be collected (e.g. formindb.html);
and the PHP script which will send this data to your MySQL database (e.g. formindb.php).I. HTML online form file (formindb.html)
Here is the HTML code which creates an online form with two text fields to be filled in by the user: Your Name and Email Address.
<html>
<head>
<title>Formmail in DB</title>
</head>
<body>
<!-------------begin form------------>
<FORM ACTION="formindb.php" METHOD="POST" NAME="contact_form">
<TABLE>
<TR>
<TD><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Your Name:</font></TD>
<TD> <input type=text name="name"></TD>
</TR>
<TR>
<TD><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Email Address:</font></TD>
<TD><input type=text name="email"></TD>
</TR>
<TR>
<TD><input type="submit" value="Submit" name="Submit"></TD>
<TD><input type="reset" value="Reset" name="Reset"></TD>
</TR>
</TABLE>
</FORM>
<!-------------end form------------>
</body>
</html>
II. PHP scipt (formindb.php)
Here is the PHP scipt which will take the data input at the HTML file and send it to your MySQL database. Please pay special attention to the variables (in bold) which have to be modified.
<?php
$con = mysql_connect("localhost","yourDatabaseUsername","yourDatabasePassword"); //Replace with your actual MySQL DB Username and Password
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("yourDatabaseName", $con); //Replace with your MySQL DB Name
$name=mysql_real_escape_string($_POST['name']); //This value has to be the same as in the HTML form file
$email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file
$sql="INSERT INTO form_data (name,email) VALUES ('$name','$email')"; /*form_data is the name of the MySQL table where the form data will be saved. name and email are the respective table fields*/if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error());
}
echo "The form data was successfully added to your database.";
mysql_close($con);
?>
Important: The MySQL table and fields to store the form data (in our example: form_data, name and email) should exist prior to using the form. The script will not create them in your database. Here is how to create tables and fields in MySQL using the phpMyAdmin authoring tool:
How can I manipulate tables in MySQL using phpMyAdmin? (http://www.apluskb.com/scripts/How_can_I_add_or_answer2500.html)
How can I manipulate fields in MySQL using phpMyAdmin? (http://www.apluskb.com/scripts/search_kb.pl?catid=1&showquestion=2576)
III. Upload both formindb.html and formindb.php files to your html directory or one of its subdirectories. If you upload to your main html directory, the form will be available at http://yourdomain.com/formindb.html, where "yourdomain.com" is your actual hosted domain name.
According to the example above, users will be asked to enter a name and email address, and then submit. You can modify the formindb.html file to add additional input fields.
Note: The coding examples above are considered secure. However, we are not responsible for any security issues they might lead to.
http://www.apluskb.com/scripts/How_can_I_send_form_answer3591.html
Answer by: Stuart Pierce, Aplus.Net Knowledge Base Support
You can use a PHP script to send data collected by an online form to your MySQL database. In our example, two files are needed for this purpose:
the HTML online form where users' data will be collected (e.g. formindb.html);
and the PHP script which will send this data to your MySQL database (e.g. formindb.php).I. HTML online form file (formindb.html)
Here is the HTML code which creates an online form with two text fields to be filled in by the user: Your Name and Email Address.
<html>
<head>
<title>Formmail in DB</title>
</head>
<body>
<!-------------begin form------------>
<FORM ACTION="formindb.php" METHOD="POST" NAME="contact_form">
<TABLE>
<TR>
<TD><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Your Name:</font></TD>
<TD> <input type=text name="name"></TD>
</TR>
<TR>
<TD><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Email Address:</font></TD>
<TD><input type=text name="email"></TD>
</TR>
<TR>
<TD><input type="submit" value="Submit" name="Submit"></TD>
<TD><input type="reset" value="Reset" name="Reset"></TD>
</TR>
</TABLE>
</FORM>
<!-------------end form------------>
</body>
</html>
II. PHP scipt (formindb.php)
Here is the PHP scipt which will take the data input at the HTML file and send it to your MySQL database. Please pay special attention to the variables (in bold) which have to be modified.
<?php
$con = mysql_connect("localhost","yourDatabaseUsername","yourDatabasePassword"); //Replace with your actual MySQL DB Username and Password
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("yourDatabaseName", $con); //Replace with your MySQL DB Name
$name=mysql_real_escape_string($_POST['name']); //This value has to be the same as in the HTML form file
$email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file
$sql="INSERT INTO form_data (name,email) VALUES ('$name','$email')"; /*form_data is the name of the MySQL table where the form data will be saved. name and email are the respective table fields*/if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error());
}
echo "The form data was successfully added to your database.";
mysql_close($con);
?>
Important: The MySQL table and fields to store the form data (in our example: form_data, name and email) should exist prior to using the form. The script will not create them in your database. Here is how to create tables and fields in MySQL using the phpMyAdmin authoring tool:
How can I manipulate tables in MySQL using phpMyAdmin? (http://www.apluskb.com/scripts/How_can_I_add_or_answer2500.html)
How can I manipulate fields in MySQL using phpMyAdmin? (http://www.apluskb.com/scripts/search_kb.pl?catid=1&showquestion=2576)
III. Upload both formindb.html and formindb.php files to your html directory or one of its subdirectories. If you upload to your main html directory, the form will be available at http://yourdomain.com/formindb.html, where "yourdomain.com" is your actual hosted domain name.
According to the example above, users will be asked to enter a name and email address, and then submit. You can modify the formindb.html file to add additional input fields.
Note: The coding examples above are considered secure. However, we are not responsible for any security issues they might lead to.
http://www.apluskb.com/scripts/How_can_I_send_form_answer3591.html