NO3 Third Empire Book making process _php tutorial

Show all the messages

$conn =mysql_connect ("hostname", "username", "password"); $db =mysql_select_db ("dbname", $conn); $numcolumns =8;//The number of records displayed per page

$query = "Select *from Guestbook"; $result =mysql_query ($query); $allnums =mysql_num_rows ($result);//calculation of all records $numpage =ceil ($allnums/$numcolumns);//Guestbook Total $numpage pages

$prev = ($pagenum-1) * $NUMCOLUMNS; $next = $prev + $numcolumns;

if ($next >= $allnums)

{$next = $allnums; $numcolumns = $next-$prev;} Handle the last page of $prev, $next

$query = "Select *from Guestbook ORDER BY time DESC limit $prev, $next";

$result =mysql_query ($query); Here is the guestbook page to

for ($i =1; $i <= $numcolumns; $i + +)

{$row =mysql_fetch_array ($result);

Show all the message pages

----------

-Owner reply:-According to the reply person's id number $id = $row [' id ']; $queryback = "Select *from gback where id= $id"; $resultback =mysql_query ($queryback); $rowback =mysql_fetch_array ($resultback); Owner reply page echo $rowback [' Noteback '];//review content echo $rowback [' Timeback '];//reply time}//ecd for

-----------

Handling Reply messages
$conn =mysql_connect ("hostname", "username", "password"); $db =mysql_select_db ("dbname", $conn); $query = "SELECT * from Phpempire"; $result =mysql_query ($query); $row =mysql_fetch_array ($result);

if ($password = = $row [' Password '])

{$timeback =date ("y-m-d-h:i:s"); $query = "INSERT into gback values (' $noteback ', ' $timeback ', ' $id ')"; $result =mysql_ Query ($query);

$message = "Please wait ...." Look at all the messages "; } else {$message = "Sorry, only the owner can reply!" "; }

Echo $message; The Empire is wonderful because of you.
If the browser is not responding for a long time, please click here for the connection


Processing message information:

$conn =mysql_connect ("hostname", "username", "password"); $db =mysql_select_db ("dbname", $conn); $time =date ("y-m-d-h:i:s"); $ip = $REMOTE _addr; $query = "Select *from Guestbook"; $result =mysql_query ($query); $id =mysql_num_rows ($result); $id + +; $query = "INSERT into guestbook values (' $username ', ' $city ', ' $email ', ' $homepage ', ' $note ', ' $ip ', ' $time ', $id)"; $result =mysql_query ($query);
Note: NO3 Empire Guestbook
Function: Can realize the owner of the reply, the owner certification
Features: simple structure, expandable function
Cons: Slow speed
This guestbook can see the running situation in Http://phpempire.net, if you are a bit dizzy for some of the process of this guestbook send me email!


"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"

http://www.bkjia.com/PHPjc/316568.html www.bkjia.com true http://www.bkjia.com/PHPjc/316568.html techarticle //Show All Messages $conn =mysql_connect (hostname,username,password), $db =mysql_select_db (dbname, $conn); $numcolumns =8;/ /number of records displayed per page $query =select *from Guestbook; $...

