NO3µÚÈýµÛ¹úÁôÑÔ²¾ÖÆ×÷¹ý³Ì

//ÏÔʾËuÓеÄÁoÑÔ

$conn=mysql_connect("hostname","username","password"); $db=mysql_select_db("dbname",$conn); $numcolumns=8;//ÿҳÏÔʾµÄ¼Í¼Êý

$query="select *from guestbook"; $result=mysql_query($query); $allnums=mysql_num_rows($result);//¼ÆËaËuÓеļͼÊý $numpage=ceil($allnums/$numcolumns);//ÁoÑÔ²¾×ܹ²ÓÐ$numpageÒ³

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

if($next>=$allnums)

{ $next=$allnums; $numcolumns=$next-$prev; }//´¦Ài×iºoÒ»Ò³µÄ$prev,$next

$query="select *from guestbook order by time desc limit $prev,$next ";

$result=mysql_query($query); //ÕaÀiÊÇÁoÑÔ²¾µÄÒ³Ãae½o

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

{ $row=mysql_fetch_array($result);

//ÏÔʾËuÓеÄÁoÑÔÒ³Ãae

----------

-°ßÖñ»Ø¸´: -¸u¾Ý»Ø¸´È˵ÄidºÅ $id=$row['id']; $queryback="select *from gback where id=$id"; $resultback=mysql_query($queryback); $rowback=mysql_fetch_array($resultback); //°ßÖñ»Ø¸´Ò³Ãae echo $rowback['noteback'];//»Ø¹ËÄÚÈÝ echo $rowback['timeback'];//»Ø¸´Ê±¼a }//ecd for

-----------

´¦Ài»Ø¸´ÐÅÏ¢
$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="ÇeÉÔºo....¿´¿´ËuÓеÄÁoÑÔ"; } else { $message="¶Ô²»Æð,Ö»ÓаßÖñ²Å¿ÉÒԻظ´£¡"; }

echo $message; ¡¡µÛ¹uÒoΪÓÐÄa¶ø¾«²Ê
Èç¹ua¯ÀÀÆ÷³¤Ê±¼aûÓÐÏiÓ¦,Çeµa»÷ÕaÀiµÄÁ¬½Ó

´¦ÀiÁoÑÔÐÅÏ¢:

$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);
×¢:no3µÛ¹uÁoÑÔ²¾
¹¦ÄܽeÉÜ:Äܹ»ÊµÏÖ°ßÖñ»Ø¸´,°ßÖñÈÏÖ¤
Ìصa:½a¹¹¼oµ¥,¿ÉÀ(C)³a¹¦ÄÜ
ȱµa:ËٶȱȽÏÂý
Õa¸oÁoÑÔ²¾¿ÉÒÔÔÚHttp://phpempire.net¿´µ½ÔËÐеÄÇe¿o,Èç¹uÄu¶ÔÓÚÕa¸oÁoÑÔ²¾µÄijÐ(C)¹ý³ÌÓеaÔθøÎÒ¢email°É!

¡¾±¾ÎÄ°aeȨ¹e×÷ÕßÓe°ÂË÷Íø¹²Í¬ÓµÓУ¬ÈçÐeתÔØ£¬Çe×¢Ã÷×÷Õß¼°³o´¦¡¿