postm.php-sends query to post.php
Code: Select all
<form method="post" action="post.php">
<h3>Type in your name:</h3><br />
<input type="text" name="username" /><br />
<h3>Type in your message:<br /></h3>
<textarea name="message"></textarea>
<br />
<input type="submit" value="Submit" name="submit" /><input type="reset" value="Reset" />Code: Select all
<?php
$message = $HTTP_POST_VARSї"message"];
$username = "<b>" . $HTTP_POST_VARSї"username"] . "</b> on ";
$username .= date("g:i a, n/j/Y");
$conn = mysql_connect("localhost", "", "");
mysql_select_db("guestbook", $conn);
$query = "INSERT INTO posts (poster, message) VALUES ('$username', '$message')";
$result = mysql_query($query,$conn)or die("query failed");
?>Code: Select all
<?php
$conn = mysql_connect("localhost", "", "");
mysql_select_db("guestbook", $conn);
$query = "SELECT * FROM posts ORDER BY id DESC";
$result = mysql_query($query,$conn)or die("query failed");
?><p align="center">
<?php
while($r=mysql_fetch_array($result))
{
$postnum = $rї"ID"];
$user = $rї"poster"];
$message = $rї"message"];
echo"<table border="3" width="40%"><tr><th>Post#</th><td>$postnum</td>
<th>Posted by:</th><td>$user</td></tr><tr>
<td colspan="4">$message</td></tr></table><br />";
}
?>