Newbie help with guestbook

mrmodest · July 2, 2012

Alright, I am trying to learn some PHP so I have been following a tutorial on how to make a simple guestbook page for my website. The problem is, the post button I coded into the page is not appearing and the area that I want displaying the current posts is appearing in the message text area where you actually are supposed to write posts. Everything is working properly with the database though which is a feat on my part. I must have a problem with a quotation somewhere but I have been looking for hours for my error. It is not a lot of code but I am not well experienced with this language. Everything looks correct until the message area underneath the other 2 text areas.

<?php
error_reporting (E_ALL ^ E_NOTICE);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xht
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Guestbook - Index</title>
</head>
<body>
<?php
		  
mysql_connect("xxx","xxx", "xxx") OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db("xxx");

		  
		  echo "<h2>Post to the Guestbook</h2>";
		  
		  if ($_POST['postbtn']){
		  $name = striptags($_POST['name']);
		  $email = striptags($_POST['email']);
		  $message = striptags($_POST['message']);
		  
			if ($name && $email && $message){

				$time = date("h:i A");
				$date = date("F d, Y");
				$ip = $_SERVER['REMOTE_ADDR'];

				// add to the database
				mysql_query("INSERT INTO guestbook VALUES (
					'', '$name', '$email', '$message', '$time', '$date', '$ip'
				)");

				echo "Post submitted!";

			}
			else
				echo "All information is required for posting.";
		  }
		  
		  echo "<form action='./guestbook.php' method='post'>
		  <table>
		  <tr>
		  <td>Name:</td>
		  <td><input type='text' name='name' style='width: 200px;' /></td>
		  </tr>
		  <tr>
		  <td>Email:</td>
		  <td><input type='text' name='email' style='width: 200px;' /></td>
		  </tr>
		  <tr>
		  <td>Message:</td>
		  <td><textarea name='message' style='width: 200px; height: 100px;' /></td>
		  </tr>
		  <tr>
		  <td></td>
		  <td><input type='submit' name='postbtn' value='Post' /></td>
		  </tr>
		  </table>
		  </form>";
		  
		  // DISPLAY
		  echo "<h2>Current Posts</h2>";
		  $query = mysql_query("SELECT * FROM guestbook ORDER BY id DESC"); // get most recent post
		  $numrows = mysql_num_rows($query); // how much data has been found
		  
		  if ($numrows > 0) { // if there are posts in the database
		  
		    echo "</ hr>"; // top horizontal line

			while ( $row = mysql_fetch_assoc($query) ) {

				$id = $row['id']; // get id out of the row variable for particular query
				$name = $row['name'];
				$email = $row['email'];
				$message = $row['message'];
				$time = $row['time'];
				$date = $row['date'];
				$ip = $row['ip'];

				$message = nl2br($message); // for breaking if new line

				echo "<div>
					By <b>$name</b> at <b>$time</b> on <b>$date</b><hr /> 
					$message
				</div> <hr />";
			}
		  }
		  else
		  echo "No posts were found.";
		  
		  mysql_close();
?>
</body>
</html>

Barand · July 2, 2012

<textarea> needs a </textarea> closing tag

<td><textarea name='message' style='width: 200px; height: 100px;' >TEXT GOES HERE</textarea></td>

Sign In

Newbie help with guestbook

Recommended Posts

mrmodest

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information