Listing posts
<?php
import_request_variables("pg", "form_");
$db = mysql_connect("localhost:/export/mysql/mysql.sock");
mysql_select_db("forum", $db);
$sql = "SELECT poster, postdate, subject, body"
. " FROM Posts";
$rows = mysql_query($sql, $db);
if(!$rows) {
$error = "SQL error: " . mysql_error();
} elseif(mysql_num_rows($rows) == 0) {
$error = "There are not yet any posts.";
} else {
$error = FALSE;
}
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Postings</title>
</head>
<body>
<?php
if($error) {
echo "<h1>Error accessing post information</h1>\n";
echo "<p>$error</p>\n";
} else {
echo "<h1>Postings</h1>\n";
$row = 0;
while($row < mysql_num_rows($rows)) {
$post_poster = mysql_result($rows, $row, 0);
$post_date = mysql_result($rows, $row, 1);
$post_subject = mysql_result($rows, $row, 2);
$post_body = mysql_result($rows, $row, 3);
echo "<h2>$post_subject</h2>\n";
echo "<p>From: <tt>$post_poster</tt></p>\n";
echo "<p>Date: $post_date</p>\n";
echo "<p>$post_body</p>\n";
$row = $row + 1;
}
}
?>
</body>
</html>