PHP 'submit' cannot link with mysql
Posted: Mon Apr 28, 2008 5:27 am
solved
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
//link up to mysql database
$host = "localhost";
$user = "root";
$password = "";
$dbname = "agilent";
$table = "customerorder";
$link = mysql_connect($host, $user, $password) or die ("Connection: " . mysql_error() . mysql_errno());
mysql_select_db($dbname, $link) or die ("Database: " . mysql_error() . mysql_errno());
//if an entry has been submitted add it to the database
if (isset($_POST['submit'])) {
$result = mysql_query("INSERT INTO customerorder
(
model,
serialnumber,
caldate,
duedate,
assetid
) VALUES (
'".mysql_real_escape_string($_POST['model'])."',
'".mysql_real_escape_string($_POST['serialnumber'])."',
'".mysql_real_escape_string($_POST['caldate'])."',
'".mysql_real_escape_string($_POST['duedate'])."',
'".mysql_real_escape_string($_POST['assetid'])."'
)
");
if (!$result) {
die('Error in query: ' . mysql_error() . mysql_errno());
} else {
echo "<p align=\"center\"><font color=\"#9966FF\" size=\"4\" face=\"Arial Black\">We have received the following details already,thank you for your support. </font></p>";
echo "<p align=\"left\"><font size=\"2\" face=\"Arial Black\">Model: <b>".$_POST['model']."</b><br/></font></p>";
echo "<p align=\"left\"><font size=\"2\" face=\"Arial Black\">Serial Number: <b>".$_POST['serialnumber']."</b><br/></font></p>";
echo "<p align=\"left\"><font size=\"2\" face=\"Arial Black\">Calculate Date: <b>".$_POST['caldate']."</b><br/></font></p>";
echo "<p align=\"left\"><font size=\"2\" face=\"Arial Black\">Due Date: <b>".$_POST['duedate']."</b><br/></font></p>";
echo "<p align=\"left\"><font size=\"2\" face=\"Arial Black\">Asset ID: <b>".$_POST['assetid']."</b><br/></font></p>";
}
}