mySQL/PHP Problem
Posted: Sat Jun 05, 2004 11:55 am
SUBMIT FORM :
PROBLEMS: Wont submit data to mySQL db
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
WEBSITE WITH THE LISTED MATERIAL(s)
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
ERRORS FOR ---^ PAGE:
Code: Select all
<?php
if (!empty($_POST['submitted']) && $_POST["submitted"] == 1){
error_reporting(E_ALL);
$date = $_POST["date"];
$name = $_POST["name"];
$info = $_POST["info"];
$cdproof = $_POST["cdproof"];
$vacproof = $_POST["vacproof"];
$dbh=mysql_connect ("localhost", "root", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("cheats");
$sql = "INSERT INTO cheats VALUES ('$date', '$name', '$info', '$cdproof', '$vacproof')";
$result = mysql_query($sql, $dbh);
echo mysql_error();
echo "Cheats submitted!";
}
else
{
//display the form
?>
<form action=cheatsubmit.php method=post>
<< BODY OF FORM REMOVED >>
<input type="hidden" name="submitted" value="1">
<input type="image" name=submitted src="submit.png" value="1">
<?php } echo mysql_error(); ?>-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
WEBSITE WITH THE LISTED MATERIAL(s)
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
Code: Select all
<?php
error_reporting(E_ALL);
$dbh=mysql_connect ("localhost", "root", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("cheats");
$sql = "SELECT * FROM cheats";
echo mysql_error();
$result = mysql_query($sql, $dbh);
echo mysql_error();
echo "<table width="100%" border="1" cellpadding="0" cellspacing="0">";
echo "<tr>";
echo "<td width="8%"><span class="style4">Release Date</span> </td>";
echo "<td width="23%"><span class="style4">Name</span></td>";
echo "<td width="47%"><span class="style4">Description</span></td>";
echo "<td width="6%"><span class="style4">C-D Proof</span></td>";
echo "<td width="7%"><span class="style4">VAC Proof</span></td>";
echo "</tr>";
while ($data = mysql_fetch_assoc($result)) {
echo "<tr>";
echo "<td width="8%"><span class="style1">";
echo $data["date"];
echo "</span></td>";
echo "<td width="23%"><span class="style1">";
echo $data["name"];
echo "</span> </td>";
echo "<td width="47%"><span class="style1">";
echo $data["info"];
echo "</span> </td>";
if ($data["cdproof"] == YES) {
echo "<td width="6%" bgcolor="#00FF00" bordercolor="#00FF00" bordercolordark="#000000" bordercolorlight="#00FF00"><span class="style5">YES</span></span></td>";
}
if ($data["cdproof"] == NO) {
echo "<td bgcolor="#FF0000" bordercolordark="#FF0000" bordercolor="#FF0000" bordercolorlight="#FF0000"><span class="style5">NO</span></span></td>";
}
echo "<td width="7%" bordercolor="#00FF00" bordercolorlight="#00FF00" bordercolordark="#000000" bgcolor="#00FF00" class="style5">";
echo $data["vacproof"];
echo "</span></td>";
echo "</tr>";
echo mysql_error();
}
echo "</table>";
?>how i fix that?Notice: Use of undefined constant YES - assumed 'YES' in cheatnetwork.php on line 52
YES
Notice: Use of undefined constant NO - assumed 'NO' in cheatnetwork.php on line 55
YES
Notice: Use of undefined constant YES - assumed 'YES' in cheatnetwork.php on line 52
Notice: Use of undefined constant NO - assumed 'NO' in cheatnetwork.php on line 55