-------------------------------Forum--------------------------
Data Sheet
CREATE TABLE guest (ID int not NULL auto_increment,primary key (ID), title varchar (), email varchar (homepage), varchar ( (), name varchar (+), text text,relay int,r_time date)
CREATE TABLE relay (ID int NOT NULL auto_increment,primary key (ID), title int,email varchar (+), name varchar (+), text text)
-------------------------index.php--------------------------
Website Complete Brochure
$db =mysql_connect ("localhost", "* * *", "* * *");
mysql_select_db ("* * *", $db);
@ $result = mysql_query ("SELECT * from guest ORDER BY id Desc", $db);
$i = 0;
while ($myrow = Mysql_fetch_row ($result)) {
$guestbook [$i][0] = $myrow [0];
$guestbook [$i][1] = $myrow [1];
$guestbook [$i][2] = $myrow [2];
$guestbook [$i][3] = $myrow [4];
$guestbook [$i][4]= $myrow [6];
$guestbook [$i][5]= $myrow [7];
$i + +;
}//Read into array
Mysql_close ($DB);
echo "-----------------------------total [";
if ($q! = "") {
$page = $q;
} else {
$page = 0;
}
$i =count ($guestbook);
$msgnum = 20; 20 pens per page
$start = $page * $MSGNUM;
$end = $start + $msgnum;
if ($end > $i) $end = $i;
$totalpage = $i/$msgnum;
for ($i =0; $i < $totalpage; $i + +) {
if ($i! = $page) {
echo "$i";
} else {
echo "$i";
}
}
echo "] Page-----------------------------
"; printf ("Add a Theme
");
echo "
";
echo "
";echo "
"; Echo"
Theme | "; echo "
Email | "; echo "
What is said | "; echo "
Reply | "; echo "
Last reply time | "; echo "
";for ($i = $start; $i < $end; $i + +) {$id = $guestbook [$i][0];echo "
"; Echo"
"; echo "", Echo $guestbook [$i][1]; echo ""; echo " | "; echo "
"; echo ""; echo $guestbook [$i][2];echo ""; echo " | "; echo "
"; echo $guestbook [$i][3]; echo " | "; echo "
"; echo $guestbook [$i][4]; echo " | "; echo "
"; echo $guestbook [$i][5]; echo " | "; echo "
";}echo "
";
echo "
";
printf ("Add theme");
?>
------------------------------444.php--------------------------------
$db =mysql_connect ("localhost", "* * *", "* * *");
mysql_select_db ("* * *", $db);
@ $result = mysql_query ("SELECT * from Guest where", $db);
echo "
";$myrow = Mysql_fetch_row ($result);echo "
"; Echo"
Theme: "; echo $myrow [1]; echo " | "; echo "
";$msg =base64_decode ($myrow [5]);$msg = Ereg_replace ("", "" ", $msg); whitespace handling$msg =nl2br ($msg); Line Break processingif ($myrow [3]!= "") {$myrow [3]=] $myrow [3] ";}Else{$myrow [3]=] I haven't settled on the internet yet;}echo "
"; echo "
"; Echo $msg, echo " | "; Echo"
";echo "
"; echo "
Homepage: "; Echo $myrow [3]; echo " |
";echo "
"; Echo"
"; echo "Reply List"; echo " | "; echo "
";$num = $myrow [6];@ $result 1 = mysql_query ("SELECT * from relay where title= ' $id ' ORDER by id DESC", $db);$i = 0;while ($myrow 1 = mysql_fetch_row ($result 1)) {$guestbook [$i][0] = $myrow 1[1];$guestbook [$i][1] = $myrow 1[2];$guestbook [$i][2] = $myrow 1[3];$guestbook [$i][3]= $myrow 1[4];$i + +;}Mysql_close ($DB);if ($q! = "") {$page = $q;} else {$page = 0;}$i =count ($guestbook);$msgnum = 5; 5 pens per page$start = $page * $MSGNUM;$end = $start + $msgnum;if ($end > $i) $end = $i;$totalpage = $i/$msgnum;for ($i = $start; $i < $end; $i + +) {$t = $guestbook [$i][0];echo "
"; Echo"
"; echo "Re:"; echo $myrow [1]; echo " | "; echo "
";echo "
"; echo "
"; echo $guestbook [$i][2]; echo " | "; echo "
";echo "
"; echo "
E-mail: "; echo ""; echo $guestbook [$i][1];echo ""; echo " | "; echo "
";$msg =base64_decode ($guestbook [$i][3]);$msg = Ereg_replace ("", "" ", $msg);$msg =nl2br ($msg);echo "
"; echo "
"; Echo $msg; echo " | "; echo "
";}echo "
"; echo "
"; echo "
"; echo "-------------------------------total [";
for ($i =0; $i < $totalpage; $i + +) {
if ($i! = $page) {
echo "$i";
} else {
echo $i;
}
} echo "] page---------------------------------"; echo "
";
echo "Reply"; echo "
";
echo "Browse Theme";
?>
--------------------------------333.php-----------------------------
if (! $t) {
if ($text = = "" & $email = = "& $name = =" ") {echo" * required "; echo" return ";}
else {if (eregi ("^[_.0-9a-z-]+@" ([0-9a-z][0-9a-z-]+.) +[a-z]{2,3}$ ", $email)) {
$text = Base64_encode ($text); Verify that the email address is legitimate
$db =mysql_connect ("localhost", "* * *", "* * *");
$time =date ("y-m-d");
mysql_select_db ("* * *", $db);
$sql = "INSERT into relay values (' ', ' $title ', ' $email ', ' $name ', ' $text ')";
$result = mysql_query ($sql);
$num = $num +1;
$sql = "Update guest set relay= ' $num ', r_time= ' $time ' where";
$result =mysql_query ($sql);
Mysql_close ();
echo " ";
}
else {echo "email address is invalid"; echo "return";}
} }
Else
{?> ?>
-----------------------------------www.php--------------------------
if ($title! = "" & $email! = "" & $name! = "") {
if (eregi ("^[_.0-9a-z-]+@" ([0-9a-z][0-9a-z-]+.) +[a-z]{2,3}$ ", $email)) {
$text = Base64_encode ($text); Verify that the email address is legitimate
$db =mysql_connect ("localhost", "* * *", "* * *");
$time =date ("y-m-d");
mysql_select_db ("* * *", $db);
$sql = "INSERT into guest values (' ', ' $title ', ' $email ', ' $homepage ', ' $name ', ' $text ', ', ' $time ')";
$result = mysql_query ($sql); Mysql_close ();
echo " ";
}
Else
{echo "email address is invalid"; echo "return";} }
else {echo "* required"; echo "return";}
Mysql_close ($DB)
printf ("message successfully returned");
?>
--------------------------------111.php---------------------------
"The copyright of this article is owned by the author and house Orso near net, if need to reprint, please specify the author and source"
The above describes the 1000 Ultraman Wars 1000 Monsters movie A paging forum, including 1000 Ultraman Wars 1000 monster movie Aspects, I hope to be interested in PHP tutorial friends helpful.