[RESOLVED] insert query not working!!!!!!

[vishu56]

Hello guys, pls check this code n tel me whats wrong here. I got this code from PHPAcadamedy in video form. When i typed it n opened in browser, the insert query is not working.

CODE: (Added [noparse]

[/noparse] tags -- MOD)[/i]
[code=php]
<?php

//PHP Guestbook using mySQL database

echo "<h1> Guestbook </h1> <hr>";

$connect = mysql_connect("localhost","vish","dbserver") or die("Cannot Connect!");

mysql_select_db("guestbook") or die("Cannot select Database");

$queryget = mysql_query("SELECT * FROM guest") or die("Cannot Select!");

while($row = mysql_fetch_assoc($queryget))

{
	$id = $row['id'];

$name = $row['name'];

$email = $row['email'];

$message = $row['message'];

$date = $row['date'];

$time = $row['time'];

if($id%2)
$bgcolor="#FFFFFF";
else
    $bgcolor="#e1e1e1";

echo 
"

<table bgcolor = '$bgcolor'>

	<tr>
		<td> 
		<b>Posted by $name($email) on $date at $time</b>
		</td>
	</tr>

	<tr>
		<td>
		".nl2br(strip_tags($message))."

		</td

	</tr>


</table>

";

}

echo "<hr>";



echo "

<form action='guest.php' method='POST'>

<table width = '100%'>

<tr>
	<td width = '10%'>Your Name:
	</td>

	<td> <input type = 'text' name = 'name' maxlength = '25' />
	</td>

</tr>

<tr>
	<td>Your Email:
	</td>

	<td> <input type = 'text' name = 'email' maxlength = '25' />
	</td>

</tr>

<tr>
	<td valign = 'top'>Your Message:
	</td>

	<td> <textarea  cols = '20' rows = '2' name = 'message' > </textarea>
	<p> <input type = 'submit' Value = 'Post' /> </p>
	</td>

</tr>

</table> ";

if(isset($_POST['submit']))
{

$name = $_POST['name'];

$email = $_POST['email'];

$message = $_POST['message'];

$date = date("Y-m-d");

$time = date("H:i:s");


if ($name&&$email&&$message)

{
	$querypost = "INSERT into guest VALUES ('' ,'".$name."','".$email."','".$message."','".$date."','".$time."')";
             $res = mysql_query($querypost) or die ("Query failed");


    echo "Please wait... <meta http-equiv='refresh' content='2'>";
    }


	echo "Please fill out all the fields!";


}
?>

[djjjozsi]

PHPAcadamedy in video form??

learn from books instead.

have you closed your form? </form>

[bradgrafelman]

Do you have display_errors set to On and error_reporting set to E_ALL? If so, are you getting any errors?

[vishu56]

How to set that errors thing, i dont know. am new to php

[dagon]

are you new to goolge?

[PradeepKr]

First of all use mysql_error() to get the DB errors like this,

error_reporting(E_ALL); 

$hostName     = 'localhost';
$username     = 'vish';
$password     = 'dbserver';
$databaseName = 'guestbook';

$connect = mysql_connect($hostName, $username, $password) or die("Failed to connect to the database Server. Error: ".mysql_error());
mysql_select_db($databaseName, $connect) or die("Failed to connect to the database. Error: ".mysql_error());

then,
inside if () where you working with post data check whether execution is reaching there at all or not,

if(isset($_POST['submit'])) 
{ 
 echo 'I am inside post if';

then try to echo the content of the insert query just before executing it

$querypost = "INSERT into guest VALUES ('' ,'".$name."','".$email."','".$message."','".$date."','".$time."')";
echo "$querypost";
$res = mysql_query($querypost) or die ("Query failed".mysql_error());
printf ("Inserted records: %d\n", mysql_affected_rows());

[Bonesnap]

What is the very first value of the table? Is it an auto incrementing ID? Because you're trying to insert a string and it should be an integer. If it's an auto incrementing ID, enter NULL:

$querypost = "INSERT into guest VALUES (NULL, '".$name."','".$email."','".$message."','".$date."','".$time."')"; 

Or perhaps better, declare in the query which columns you're inserting into, and leave the ID column out completely. MySQL will take care of the auto incrementing ID (hence the "auto").

[vishu56]

Thanks a lot guys!!!!!!!!!!