Hi Guys,
I keep getting this error in a form that is suppose to insert data into a database table. Any ideas?
It is being inserted into a database called team_bnlproductions and into a table called hdd_archive
I keep getting this error in a form that is suppose to insert data into a database table. Any ideas?
It is being inserted into a database called team_bnlproductions and into a table called hdd_archive
PHP:
<html>
<head>
<title>Add New Record in MySQL Database</title>
</head>
<body>
<?php
if(isset($_POST['add']))
{
$dbhost = 'localhost';
$dbuser = '****';
$dbpass = '****';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
if(! get_magic_quotes_gpc() )
{
$hdd_name = addslashes ($_POST['hdd_name']);
$date_archived = addslashes ($_POST['date_archived']);
$project_name = addslashes ($_POST['project_name']);
$archived_by = addslashes ($_POST['archived_by']);
$other_information = addslashes ($_POST['other_information']);
}
else
{
$hdd_name = $_POST['hdd_name'];
$date_archived = $_POST['date_archived'];
$project_name = $_POST['project_name'];
$archived_by = $_POST['archived_by'];
$other_information = $_POST['other_information'];
}
$sql = "INSERT INTO hdd_archive ".
"(hdd_name,date_archived,project_name,archived_by,other_information) ".
"VALUES('$hdd_name','$date_archived','$project_name','$archived_by','$other_information', NOW())";
mysql_select_db('team_bnlproductions');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not enter data: ' . mysql_error());
}
echo "Entered data successfully\n";
mysql_close($conn);
}
else
{
?>
<form method="post" action="<?php $_PHP_SELF ?>">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="100">Hard Drive Name</td>
<td><input name="hdd_name" type="text" id="hdd_name"></td>
</tr>
<tr>
<td width="100">Date Archived</td>
<td><input name="date_archived" type="text" id="date_archived"></td>
</tr>
<tr>
<td width="100">Project Name </td>
<td><input name="project_name" type="text" id="project_name"></td>
</tr>
<tr>
<td width="100">Archived By</td>
<td><input name="archived_by" type="text" id="archived_by"></td>
</tr>
<tr>
<td width="100">Other Information</td>
<td><input name="other_information" type="text" id="other_information"></td>
</tr>
<tr>
<td width="100"> </td>
<td> </td>
</tr>
<tr>
<td width="100"> </td>
<td>
<input name="add" type="submit" id="add" value="Submit Entry">
</td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>
