一个用postgreSQL数据库和php写的留言本的源码（一）

一个用postgreSQL数据库和php写的留言本的源码（一）
相关文章
•	一个用postgreSQL数据库和php写的留言本的源码（二）

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">

<HTML>

<HEAD>

<TITLE>Processing... please wait...</TITLE>

</HEAD>

<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#0000FF" ALINK="#0000FF">

<DIV ALIGN="Center">

<?

$conn = pg_Connect("localhost", "5432", "", "", "db");

if (!$conn) {

echo "An error occurred.n";

exit;

}

pg_Exec($conn,"INSERT INTO messageboard VALUES ($selectid,$selectparent,$selectthread,$selectlevel,'$selectdate','$selecttopic','$selectbody','$selectauthor','$selectemail');");

pg_Close($conn);

echo "<SCRIPT LANGUAGE="JavaScript1.1">n";

echo "<!-- Activate Cloaking Devicen";

echo "window.location="$selectpage"n";

echo "// Deactivate Cloaking  -->n";

echo "</SCRIPT>n";

?>

</DIV>

</BODY>

</HTML>

//以上是admin.php3文件



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">

<HTML>

<HEAD>

<TITLE>Message Board</TITLE>

</HEAD>

<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#0000FF" ALINK="#0000FF">

<DIV ALIGN="Center">

<TABLE BORDER="0" WIDTH="95%" CELLPADDING="2" CELLSPACING="0">

<TR ALIGN="Center" VALIGN="Middle">

<TD ALIGN="Left" VALIGN="Middle">

<FONT FACE="Arial" SIZE="4"><B>Message Board</B></FONT>

</TD>

</TR>

<TR ALIGN="Center" VALIGN="Middle">

<TD ALIGN="Center" VALIGN="Middle" BGCOLOR="#FF0000">

<TABLE BORDER="0" WIDTH="100%" CELLPADDING="2" CELLSPACING="0">

<TR ALIGN="Center" VALIGN="Middle">

<TD ALIGN="Center" VALIGN="Middle" BGCOLOR="#FFFFFF">

<TABLE BORDER="0" WIDTH="100%" CELLPADDING="0" CELLSPACING="0">

<?

$MAXTOPICS = 10;

$conn = pg_Connect("localhost", "5432", "", "", "db");

if (!$conn) {

echo "An error occurred.n";

exit;

}

$result = pg_Exec($conn,"SELECT * FROM messageboard ORDER BY thread DESC, id");

if (!$result) {

echo "An error occurred.n";

exit;

}

$num = pg_NumRows($result);

$i = 0;

$topiccount = 0;

if (isset($messageid)) {

$selectid = pg_Result($result,$i,0);

while ($selectid != $messageid) {

if ($topiccount < $MAXTOPICS) {

$selectid = pg_Result($result,$i,0);

$selectlevel = pg_Result($result,$i,3);

if ($selectlevel == 0) {

$topiccount++;

}

} else {

$previd = $pg_Result($result,$i - 1,0);

$topiccount = 0;

}

$i++;

}

} 

$topiccount = 0;

$endflag = false;

while ($i < $num) {

if ($topiccount < $MAXTOPICS) {

$selectid = pg_Result($result,$i,0);

$selectparent = pg_Result($result,$i,1);

$selectlevel = pg_Result($result,$i,3);

$selectdate = pg_Result($result,$i,4);

$selecttopic = pg_Result($result,$i,5);

$selectauthor = pg_Result($result,$i,7);

$selectemail = pg_Result($result,$i,8);

$printdate = date("F d, Y h:ia",mktime(substr($selectdate,8,2),substr($selectdate,10,2),0,substr($selectdate,4,2),substr($selectdate,6,2),substr($selectdate,0,4)));

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Middle" WIDTH="50%">n";

$j = 0;

while ($j < $selectlevel) {

echo "&nbsp;&nbsp;&nbsp;";

$j++;

}

echo "<FONT FACE="Arial" SIZE="2"><A HREF="message.php3?selectid=$selectid" onMouseover="window.status='$selecttopic'; return true" onMouseOut="window.status=''; return true">$selecttopic</A></FONT>n";

echo "</TD>n";

echo "<TD ALIGN="Left" VALIGN="Middle" WIDTH="15%">n";

if (empty($selectemail)) {

echo "<FONT FACE="Arial" SIZE="2">$selectauthor</FONT>n";

} else {

echo "<FONT FACE="Arial" SIZE="2"><A HREF="mailto:$selectemail" onMouseover="window.status='$selectauthor'; return true" onMouseOut="window.status=''; return true">$selectauthor</A></FONT>n";

}

echo "</TD>n";

echo "<TD ALIGN="Right" VALIGN="Middle" WIDTH="35%">n";

echo "<FONT FACE="Arial" SIZE="2">$printdate</FONT>n";

echo "</TD>n";

echo "</TR>n";

if ($selectlevel == 0) {

$topiccount++;

}

} else {

if ($endflag == false) {

$nextid = pg_Result($result,$i - 1,0);

$endflag = true;

}

}

$i++;

}

pg_FreeResult($result);

echo "</TABLE>n";

echo "</TD>n";

echo "</TR>n";

echo "</TABLE>n";

echo "</TD>n";

echo "</TR>n";

echo "</TABLE>n";

echo "<TABLE BORDER="0" WIDTH="95%" CELLPADDING="2" CELLSPACING="0">n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

if (!empty($previd)) {

echo "<FONT FACE="Arial" SIZE="2"><A HREF="board.php3?messageid=$previd" onMouseover="window.status='Previous'; return true" onMouseOut="window.status=''; return true">Previous</A></FONT>n";

} else {

echo "<FONT FACE="Arial" SIZE="2">Previous</FONT>n";

}

echo "</TD>n";

echo "<TD ALIGN="Right" VALIGN="Middle">n";

if (!empty($nextid)) {

echo "<FONT FACE="Arial" SIZE="2"><A HREF="board.php3?messageid=$nextid" onMouseover="window.status='Next'; return true" onMouseOut="window.status=''; return true">Next</A></FONT>n";

} else {

echo "<FONT FACE="Arial" SIZE="2">Next</FONT>n";

}

echo "</TD>n";

echo "</TR>n";

echo "</TABLE>n";

echo "<BR><BR>n";

echo "<TABLE BORDER="0" WIDTH="95%" CELLPADDING="2" CELLSPACING="0">n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<FONT FACE="Arial"><B>Start a new thread</B></FONT>n";

echo "</TD>n";

echo "</TR>n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Center" VALIGN="Middle" BGCOLOR="#FF0000">n";

echo "<TABLE BORDER="0" WIDTH="100%" CELLPADDING="2" CELLSPACING="0">n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Center" VALIGN="Middle" BGCOLOR="#FFFFFF">n";

echo "<TABLE BORDER="0" WIDTH="100%" CELLPADDING="0" CELLSPACING="0">n";

$result = pg_Exec($conn,"SELECT * FROM messageboard ORDER BY id");

if (!$result) {

echo "An error occurred.n";

exit;

}

$num = pg_NumRows($result);

$i = $num - 1;

$selectid = pg_Result($result,$i,0);

$selectid = $selectid + 1;

pg_FreeResult($result);

$result = pg_Exec($conn,"SELECT * FROM messageboard ORDER BY thread");

if (!$result) {

echo "An error occurred.n";

exit;

}

$num = pg_NumRows($result);

$i = $num - 1;

$selectthread = pg_Result($result,$i,2);

$selectthread = $selectthread + 1;

$selectdate = date("YmdHi");

echo "<FORM ACTION="admin.php3" METHOD="Post">n";

echo "<INPUT TYPE="Hidden" NAME="selectpage" VALUE="board.php3">n";

echo "<INPUT TYPE="Hidden" NAME="selectid" VALUE="$selectid">n";

echo "<INPUT TYPE="Hidden" NAME="selectparent" VALUE="0">n";

echo "<INPUT TYPE="Hidden" NAME="selectthread" VALUE="$selectthread">n";

echo "<INPUT TYPE="Hidden" NAME="selectlevel" VALUE="0">n";

echo "<INPUT TYPE="Hidden" NAME="selectdate" VALUE="$selectdate">n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<FONT FACE="Arial" SIZE="2"><B>Name:</B>&nbsp;</FONT>n";

echo "</TD>n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<INPUT TYPE="Text" NAME="selectauthor" SIZE="30" MAXLENGTH="30" VALUE="">n";

echo "</TD>n";

echo "</TR>n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<FONT FACE="Arial" SIZE="2"><B>Email:</B>&nbsp;</FONT>n";

echo "</TD>n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<INPUT TYPE="Text" NAME="selectemail" SIZE="55" MAXLENGTH="100" VALUE="">n";

echo "</TD>n";

echo "</TR>n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<FONT FACE="Arial" SIZE="2"><B>Topic:</B>&nbsp;</FONT>n";

echo "</TD>n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<INPUT TYPE="Text" NAME="selecttopic" SIZE="55" MAXLENGTH="100" VALUE="">n";

echo "</TD>n";

echo "</TR>n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Top">n";

echo "<FONT FACE="Arial" SIZE="2"><B>Text:</B>&nbsp;</FONT>n";

echo "</TD>n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<TEXTAREA NAME="selectbody" COLS="55" ROWS="10" WRAP="Virtual"></TEXTAREA>n";

echo "</TD>n";

echo "</TR>n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "&nbsp;n";

echo "</TD>n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "&nbsp;n";

echo "</TD>n";

echo "</TR>n";

echo "<TR ALIGN="Center" VALIGN="Middle">n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "&nbsp;n";

echo "</TD>n";

echo "<TD ALIGN="Left" VALIGN="Middle">n";

echo "<INPUT TYPE="Submit" VALUE="Post">&nbsp;<INPUT TYPE="Reset" VALUE="Clear Fields">n";

echo "</TD>n";

echo "</TR>n";

echo "</FORM>n";

pg_FreeResult($result);

pg_Close($conn);

?>

</TABLE>

</TD>

</TR>

</TABLE>

</TD>

</TR>

</TABLE>

<BR><BR>

</DIV>

</BODY>

</HTML>





//以上是board.php3文件