CSci 115: Computing and the Internet
Home Syllabus Assignments Tests

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>