<?
print("<HTML>\n");
print("<HEAD>\n");
print("<TITLE>Leon's BBS</TITLE>\n");
print("</HEAD>\n");
print("<BODY BGCOLOR=\"#FFFFFF\">\n");
print("<H1>Leon's BBS</H1>\n");
// connect to server
$mysql_link = mysql_connect("localhost", "httpd", "");
// select the 'store' database
mysql_select_db("leon", $mysql_link);
/*
** recursive function that spits out all
** descendent messages
*/
function showMessages($parentID)
{
global $mysql_link;
$dateToUse = Date("U");
print("<UL>\n");
$Query = "SELECT ID, Title, Created, Parent ";
$Query .= "FROM bbsMessage ";
$Query .= "WHERE Parent=$parentID "; php学习之家
$Query .= "ORDER BY Created ";
$mysql_result = mysql_query($Query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
$messageID = $row[0];
$messageTitle = $row[1];
$messageCreated = $row[2];
$messageParent = $row[3];
//show message title as a link to view the body
print("<LI>($messageCreated) <A HREF=\"");
print("16-8.php3?messageID=$messageID\">");
print("$messageTitle</A><BR>\n");
//show children of this message
showMessages($messageID);
$RowCount++;
}
print("</UL>\n");
}
/*
** print out a form for adding a message with
** parent id given
*/
function postForm($parentID, $useTitle)
{
print("<FORM ACTION=\"16-8.php3\" METHOD=\"post\">\n");
print("<INPUT TYPE=\"hidden\" NAME=\"inputParent\" ");
print("VALUE=\"$parentID\">\n");
print("<INPUT TYPE=\"hidden\" NAME=\"ACTION\" ");
print("VALUE=\"POST\">\n");
print("<TABLE BORDER=\"1\" CELLSPACING=\"0\" ");
print("CELLPADDING=\"5\" WIDTH=\"400\">\n");
print("<TR>\n");
print("<TD WIDTH=\"100\"><B>Title</B></TD>\n");
print("<TD WIDTH=\"300\">");
print("<INPUT TYPE=\"text\" NAME=\"inputTitle\" ");
print("SIZE=\"35\" MAXLENGTH=\"64\" VALUE=\"$useTitle\">");
print("</TD>\n");
print("</TR>\n");
print("<TR>\n");
print("<TD WIDTH=\"100\"><B>Poster</B></TD>\n");
print("<TD WIDTH=\"300\">");
print("<INPUT TYPE=\"text\" NAME=\"inputPoster\" ");
print("SIZE=\"35\" MAXLENGTH=\"64\">");
print("</TD>\n");
print("</TR>\n");
print("<TR>\n");
print("<TD COLSPAN=\"2\" WIDTH=\"400\">");
print("<TEXTAREA NAME=\"inputBody\" ");
print("COLS=\"45\" ROWS=\"5\"></TEXTAREA>");
print("</TD>\n");
print("</TR>\n");
print("<TR>\n");
print("<TD COLSPAN=\"2\" WIDTH=\"400\" ALIGN=\"middle\">");
print("<INPUT TYPE=\"submit\" VALUE=\"Post\">");
print("</TD>\n");
print("</TR>\n");
print("</TABLE>\n");
print("</FORM>\n");
}
/*
** perform actions
*/
if($ACTION != "")
{
if($ACTION == "POST")
{
$inputTitle = ereg_replace("'", "''", $inputTitle);
$inputBody = ereg_replace("'", "''", $inputBody);
$Query = "INSERT INTO bbsMessage ";
$Query .= "VALUES(0, '$inputTitle', ";
$Query .= "'$inputPoster', ";
$Query .= "now(), $inputParent, ";
$Query .= "'$inputBody')";
mysql_query($Query, $mysql_link);
}
}
/*
** Show Message or show list of messages
*/
if($messageID > 0)
{
$Query = "SELECT * FROM bbsMessage ";
$Query = $Query . "WHERE ID=$messageID ";
$mysql_result = mysql_query($Query, $mysql_link);
if($row = mysql_fetch_row($mysql_result))
{
$messageTitle = $row[1];
$messagePoster = $row[2];
$messageCreated = $row[3];
$messageParent = $row[4];
$messageBody = $row[5];
print("<TABLE BORDER=\"1\" CELLSPACING=\"0\" ");
print("CELLPADDING=\"5\" WIDTH=\"400\">\n");
print("<TR>");
print("<TD WIDTH=\"100\"><B>Title</B></TD>");
print("<TD WIDTH=\"300\">$messageTitle</TD>");
print("</TR>\n");
print("<TR>");
print("<TD WIDTH=\"100\"><B>Poster</B></TD>"); php学习之家
print("<TD WIDTH=\"300\">$messagePoster</TD>");
print("</TR>\n");
print("<TR>");
print("<TD WIDTH=\"100\"><B>Posted</B></TD>");
print("<TD WIDTH=\"300\">$messageCreated</TD>");
print("</TR>\n");
print("<TR>");
print("<TD COLSPAN=\"2\" WIDTH=\"400\">");
print("$messageBody");
print("</TD>");
print("</TR>\n");
print("</TABLE>\n");
postForm($messageID, "RE: $messageTitle");
}
print("<A HREF=\"16-8.php3\">List of Messages</A><BR>\n");
}
else
{
print("<H2>List of Messages</H2>\n"); 本文来自 www.444p.com
// get entire list
showMessages(0);
postForm(0, "");
}
print("</BODY>\n");
print("</HTML>\n");
?>
print("<HTML>\n");
print("<HEAD>\n");
print("<TITLE>Leon's BBS</TITLE>\n");
print("</HEAD>\n");
print("<BODY BGCOLOR=\"#FFFFFF\">\n");
print("<H1>Leon's BBS</H1>\n");
// connect to server
$mysql_link = mysql_connect("localhost", "httpd", "");
// select the 'store' database
mysql_select_db("leon", $mysql_link);
/*
** recursive function that spits out all
** descendent messages
*/
function showMessages($parentID)
{
global $mysql_link;
$dateToUse = Date("U");
print("<UL>\n");
$Query = "SELECT ID, Title, Created, Parent ";
$Query .= "FROM bbsMessage ";
$Query .= "WHERE Parent=$parentID "; php学习之家
$Query .= "ORDER BY Created ";
$mysql_result = mysql_query($Query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
$messageID = $row[0];
$messageTitle = $row[1];
$messageCreated = $row[2];
$messageParent = $row[3];
//show message title as a link to view the body
print("<LI>($messageCreated) <A HREF=\"");
print("16-8.php3?messageID=$messageID\">");
print("$messageTitle</A><BR>\n");
//show children of this message
showMessages($messageID);
$RowCount++;
}
print("</UL>\n");
}
/*
** print out a form for adding a message with
** parent id given
*/
function postForm($parentID, $useTitle)
{
print("<FORM ACTION=\"16-8.php3\" METHOD=\"post\">\n");
print("<INPUT TYPE=\"hidden\" NAME=\"inputParent\" ");
print("VALUE=\"$parentID\">\n");
print("<INPUT TYPE=\"hidden\" NAME=\"ACTION\" ");
print("VALUE=\"POST\">\n");
print("<TABLE BORDER=\"1\" CELLSPACING=\"0\" ");
print("CELLPADDING=\"5\" WIDTH=\"400\">\n");
print("<TR>\n");
print("<TD WIDTH=\"100\"><B>Title</B></TD>\n");
print("<TD WIDTH=\"300\">");
print("<INPUT TYPE=\"text\" NAME=\"inputTitle\" ");
print("SIZE=\"35\" MAXLENGTH=\"64\" VALUE=\"$useTitle\">");
print("</TD>\n");
print("</TR>\n");
本文来自 www.444p.com
print("<TR>\n");
print("<TD WIDTH=\"100\"><B>Poster</B></TD>\n");
print("<TD WIDTH=\"300\">");
print("<INPUT TYPE=\"text\" NAME=\"inputPoster\" ");
print("SIZE=\"35\" MAXLENGTH=\"64\">");
print("</TD>\n");
print("</TR>\n");
print("<TR>\n");
print("<TD COLSPAN=\"2\" WIDTH=\"400\">");
print("<TEXTAREA NAME=\"inputBody\" ");
print("COLS=\"45\" ROWS=\"5\"></TEXTAREA>");
print("</TD>\n");
print("</TR>\n");
print("<TR>\n");
print("<TD COLSPAN=\"2\" WIDTH=\"400\" ALIGN=\"middle\">");
本文来自 www.444p.com
print("<INPUT TYPE=\"submit\" VALUE=\"Post\">");
print("</TD>\n");
print("</TR>\n");
print("</TABLE>\n");
print("</FORM>\n");
}
/*
** perform actions
*/
if($ACTION != "")
{
if($ACTION == "POST")
{
$inputTitle = ereg_replace("'", "''", $inputTitle);
$inputBody = ereg_replace("'", "''", $inputBody);
$Query = "INSERT INTO bbsMessage ";
$Query .= "VALUES(0, '$inputTitle', ";
$Query .= "'$inputPoster', ";
$Query .= "now(), $inputParent, ";
$Query .= "'$inputBody')";
mysql_query($Query, $mysql_link);
}
}
/*
** Show Message or show list of messages
php学习之家
*/
if($messageID > 0)
{
$Query = "SELECT * FROM bbsMessage ";
$Query = $Query . "WHERE ID=$messageID ";
$mysql_result = mysql_query($Query, $mysql_link);
if($row = mysql_fetch_row($mysql_result))
{
$messageTitle = $row[1];
$messagePoster = $row[2];
$messageCreated = $row[3];
$messageParent = $row[4];
$messageBody = $row[5];
print("<TABLE BORDER=\"1\" CELLSPACING=\"0\" ");
print("CELLPADDING=\"5\" WIDTH=\"400\">\n");
print("<TR>");
print("<TD WIDTH=\"100\"><B>Title</B></TD>");
print("<TD WIDTH=\"300\">$messageTitle</TD>");
print("</TR>\n");
print("<TR>");
print("<TD WIDTH=\"100\"><B>Poster</B></TD>"); php学习之家
print("<TD WIDTH=\"300\">$messagePoster</TD>");
print("</TR>\n");
print("<TR>");
print("<TD WIDTH=\"100\"><B>Posted</B></TD>");
print("<TD WIDTH=\"300\">$messageCreated</TD>");
print("</TR>\n");
print("<TR>");
print("<TD COLSPAN=\"2\" WIDTH=\"400\">");
print("$messageBody");
print("</TD>");
print("</TR>\n");
print("</TABLE>\n");
postForm($messageID, "RE: $messageTitle");
}
print("<A HREF=\"16-8.php3\">List of Messages</A><BR>\n");
}
else
{
print("<H2>List of Messages</H2>\n"); 本文来自 www.444p.com
// get entire list
showMessages(0);
postForm(0, "");
}
print("</BODY>\n");
print("</HTML>\n");
?>
