I'm trying to write a simple PHP guestbook after following a few tutorials online. I am able to write to the database without any issues; however, when I try to parse through the existing comments and "echo" them back to the page, I am not seeing anything being displayed.
Is there an obvious reason for this?
(The code in question starts under "Existing Comments:")
<?php
require_once('includes/config.inc.php');
define('DB_GUEST','guestbook_db');
// Connect
$mysqli = @new mysqli(DB_HOSTNAME,DB_USERNAME,DB_PASSWORD,DB_GUEST);
// Check connection
if (mysqli_connect_errno()) {
printf("Unable to connect to database: %s", mysqli_connect_error());
exit();
}
// POST
if($_SERVER['REQUEST_METHOD'] == 'POST') {
$now = time();
$name=($_POST['name']);
$message =($_POST['message']);
$sql = "insert into comments (name,message,timestamp) values ('$name','$message','$now')";
$result = $mysqli->query($sql) or die($mysqli->error.__LINE__);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Guest Book</title>
</head>
<body>
<h3>Post A Comment:</h3>
<form action="index.php" method="post">
<strong>Name:</strong><br/> <input type="text" name="name" /><br/>
<strong>Comment:</strong><br/> <textarea name="message" rows="5" cols="25">
<textarea><br/>
<input type="submit" value="Go">
</form>
<h3>Exisiting Comments:</h3>
<?php
$sql1 = "select * from guestbook_db.comments";
$allPostsQuery = $mysqli->query($sql1) or die($mysqli->error.__LINE__);
if(!mysql_fetch_rows($allPostsQuery)) {
echo "No comments were found!";
} else {
while($row = mysql_fetch_assoc($allPostsQuery)) {
echo "<b>Name:</b> {$comment[1]} <br/>";
echo "<b>Message:</b> {$comment[2]} <br/>";
echo "<b>Posted at:</b> " .date("Y-d-m H:i:s",$comment[3]). " <br/><hr/>";
}
}
?>
</body>
</html>
