📄 bbs.php
字号:
<html>
<head>
<title>BBS</title>
</head>
<body bgcolor="#ccccff" link="#0000ff" vlink="#0000ff" alink="#0033ff">
<?php
print("<h1>Welcome to Photo Upload</h1>\n");
//connect to server, then test for failure
if(!($dbLink = mysql_connect("localhost", "jackie", "123456")))
{
print("Failed to connect to database!<br>\n");
print("Aborting!<br>\n");
exit();
}
//select database, then test for failure
if(!($dbResult = mysql_query("USE test", $dbLink)))
{
print("Can't use the test database!<BR>\n");
print("Aborting!<BR>\n");
exit();
}
/*
** recursive function that spits out all
** descendent messages
*/
function showMessages($parentID)
{
global $dbLink;
$dateToUse = Date("U");
print("<ul>\n");
$Query = "SELECT ID, Titil, Created " .
"FROM Message " .
"WHERE Parent=$parentID " .
"ORDER BY Created ";
if(!($dbResult = mysql_query($Query, $dbLink)))
{
//can't execute query
print("Couldn't query Message table!<br>\n");
print("MySQL Reports: " . mysql_error() . "<br>\n");
exit();
}
while($row = mysql_fetch_assoc($dbResult))
{
//show message Titil as a link to view the body
print("<li>({$row['Created']}) " .
"<a href=\"" .
"{$_SERVER['PHP_SELF']}?messageID={$row['ID']}" .
"\">" .
"{$row['Titil']}</a></li>\n");
//show children of this message
showMessages($row['ID']);
}
print("</ul>\n");
}
/*
** print out a form for adding a message with
** parent id given
*/
function postForm($parentID, $useTitil)
{
print("<form action=\"{$_SERVER['PHP_SELF']}\" " .
"method=\"post\">\n" .
"<input type=\"hidden\" name=\"inputParent\" " .
"value=\"$parentID\">\n" .
"<input type=\"hidden\" name=\"ACTION\" " .
"value=\"POST\">\n" .
"<table border=\"1\" cellspacing=\"0\" " .
"cellpadding=\"5\" width=\"400\">\n" .
"<tr>\n" .
"<td width=\"100\"><b>Titil</b></td>\n" .
"<td width=\"300\">" .
"<input type=\"text\" name=\"inputTitil\" " .
"size=\"35\" maxlength=\"64\" value=\"$useTitil\">" .
"</td>\n" .
"</tr>\n" .
"<tr>\n" .
"<td width=\"100\"><b>Poster</b></td>\n" .
"<td width=\"300\">" .
"<input type=\"text\" name=\"inputPoster\" " .
"size=\"35\" maxlength=\"64\">" .
"</td>\n" .
"</tr>\n" .
"<tr>\n" .
"<td colspan=\"2\" width=\"400\">" .
"<textarea name=\"inputBody\" " .
"cols=\"45\" rows=\"5\"></textarea>" .
"</td>\n" .
"</tr>\n" .
"<tr>\n" .
"<td colspan=\"2\" width=\"400\" align=\"middle\">" .
"<input type=\"submit\" value=\"Post\">" .
"</td>\n" .
"</tr>\n" .
"</table>\n" .
"</form>\n");
}
/*
** perform actions
*/
if(isset($_REQUEST['ACTION']))
{
if($_REQUEST['ACTION'] == "POST")
{
$Query = "INSERT INTO Message " .
"(Titil, Poster, Created, Parent, Body)" .
"VALUES(" .
"'" . addslashes($_REQUEST['inputTitil']) . "', " .
"'" . addslashes($_REQUEST['inputPoster']) . "', " .
"NOW(), {$_REQUEST['inputParent']}, " .
"'" . addslashes($_REQUEST['inputBody']) . "')";
if(!($dbResult = mysql_query($Query, $dbLink)))
{
//can't execute query
print("Couldn't insert into Message " .
"table!<br>\n");
print("MySQL Reports: " . mysql_error() .
"<br>\n");
exit();
}
}
}
/*
** Show Message or show list of messages
*/
if(isset($_REQUEST['messageID']) AND
($_REQUEST['messageID'] > 0))
{
$Query = "SELECT ID, Titil, Poster, Created, " .
"Parent, Body " .
"FROM Message " .
"WHERE ID={$_REQUEST['messageID']} ";
if(!($dbResult = mysql_query($Query, $dbLink)))
{
//can't execute query
print("Couldn't query Message table!<br>\n");
print("MySQL Reports: " . mysql_error() . "<br>\n");
exit();
}
if($row = mysql_fetch_assoc($dbResult))
{
print("<table border=\"1\" cellspacing=\"0\" " .
"cellpadding=\"5\" width=\"400\">\n" .
"<tr>" .
"<td width=\"100\"><b>Titil</b></td>" .
"<td width=\"300\">{$row['Titil']}</td>" .
"</tr>\n" .
"<tr>" .
"<td width=\"100\"><b>Poster</b></td>" .
"<td width=\"300\">{$row['Poster']}</td>" .
"</tr>\n" .
"<tr>" .
"<td width=\"100\"><b>Posted</b></td>" .
"<td width=\"300\">{$row['Created']}</td>" .
"</tr>\n" .
"<tr>" .
"<td colspan=\"2\" width=\"400\">" .
"{$row['Body']}" .
"</td>" .
"</tr>\n" .
"</table>\n");
postForm($row['ID'], "RE: {$row['Titil']}");
}
print("<a href=\"{$_SERVER['PHP_SELF']}\">" .
"List of Messages</a><br>\n");
print("<a href=\"index.php\">" .
"Home</a><br>\n");
}
else
{
print("<h2>List of Messages</h2>\n");
// get entire list
showMessages(0);
postForm(0, "");
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -