Phpskriptet ser ut så här:
<?php
// PHP Guestbook using mySQL database
echo "<h1>Guestbook</h1><hr></hr>";
//connect to the database
$connect = mysql_connect("server","username","password") or die ("Error connecting to db");
//select talbe
mysql_select_db("15productions_se") or die ("Error selecing db");
//use query to get ALL data
$queryget = mysql_query("SELECT * FROM guestbook ORDER BY id ASC") or die("Error with query");
$querygetrownum = mysql_num_rows($queryget);
if ($querygetromnum==0)
echo "No posts have been made yet. Please be the first!";
while ($row = mysql_fetch_assoc($queryget))
{
//get row data and store in vars
$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 = "#elelel"
//process
echo "
<table 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 "<h1>";
if ($_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 = mysql_query("INSERT INTO GUESTBOOK VALUES ('','$name','$email','$message','$date','$time')");
echo "Please wait... <meta http-equiv='refresh' content='2'>";
}
else
echo "Please fill our all fields!";
}
echo "
<form action='index.php' method='POST'>
<table width='100%>
<tr>
<td width='18%' valign='top'>
Your name:
</td>
<td>
<input type='text' name='name' maxtlenght='25'>
</td>
</tr>
<tr>
<td valign='top'>
Your email:
</td>
<td>
<input type='text' name='email' maxtlenght='35'>
</td>
</tr>
<tr>
<td valign='top'>
Your message:
</td>
<td>
<textarea cols='20' rows='2' name='message' maxlenght='250'>
<p>
<input type='submit' name='submit' value='Post'>
</td>
</tr>
</table>
</form>
";
?>
