here are all my codes:
dbconnect.php
<?php
mysql_connect("localhost","nobody","ydobon")
or die("<h3>could not connect to MySQL</h3>\n");
mysql_select_db("guestbook")
or die("<h3>could not select database 'guestbook'</h3>\n");
?>
sign.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<h2>Sign my guestbook!</h2>
<form method="post" action="create_entry.php">
<b>Name:</b>
<input type="text" size="40" name="name">
<br>
<b>Location:</b>
<input type="text" size="40" name="location">
<br>
<b>Email:</b>
<input type="text" size="40" name="email">
<br>
<b>Home Page URL:</b>
<input type="text" size="40" name="url">
<br>
<b>Comments:</b>
<textarea name="comments" cols="40" rows="4"
wrap="virtualv"></textarea>
<br>
<input type="submit" name="submit" value="Sign!">
<input type="reset" name="reset" value="Start Over">
</form>
</BODY>
</HTML>
create_entry.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<?php
include("dbconnect.php");
if ($_REQUEST["submit"]=="Sign!")
{
$query="insert into guestbook(name,location,email,url,comments) values ('"
.$_REQUEST["name"]
."', '"
.$_REQUEST["location"]
."', '"
.$_REQUEST["email"]
."', '"
.$_REQUEST["url"]
."', '"
.$_REQUEST["comments"]
."') "
;
mysql_query($query);
?>
<h2>Thanks!!</h2>
<h2><a href="view.php">View my GuestBook!!</a></h2>
<?php
}
else
{
include("sign.php");
}
?>
</BODY>
</HTML>
view.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<?php include("dbconnect.php") ?>
<h2>View my GuestBook!!</h2>
<?php
$result = mysql_query("select * from guestbook")
or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
echo "Name:";
echo $row["name"];
echo "<br>\n";
echo "<b>Location:</b>";
echo $row["location"];
echo "<br>\n";
echo "<b>Email:</b>";
echo $row["email"];
echo "<br>\n";
echo "<b>URL:</b>";
echo $row["url"];
echo "<br>\n";
echo "<b>Comments:</b>";
echo $row["comments"];
echo "<br>\n";
echo "<br>\n";
echo "<br>\n";
}
mysql_free_result($result);
?>
<h2><a href="sign.php">Sign my GuestBook</a></h2>
</BODY>
</HTML>
everything works just fine until when it gets to view.php... dunno what the problem is...
Could you post the HTML Source of the output from
view.php.
Also, place the following above the page:
<?php
error_reporting(E_ALL);
display_errors(true);
?>
Or the equivalent in your PHP.ini.
That way any warnings, notices, etc. will be printed.
Reputation Points: 457
Solved Threads: 101
Nearly a Posting Virtuoso
Offline 1,250 posts
since Sep 2005
Unsolved 
