杏林同學(xué)錄(七)_PHP教程
Jul 21, 2016 pm 04:04 PM
留言簿部分:
???班級(jí)成員留言簿: 顯示留言:class/notebook/index.php
session_start(); // 開始session
if(!session_is_registered("userregister")||($userregister==""))//檢查是否注冊(cè),如userregister未注冊(cè)或session為空值,重新注冊(cè).
{
echo "請(qǐng)重新注冊(cè)
";
exit;
}
?>
include ("../config.php");
$result = mysql_query("SELECT * FROM notebook",$db);
$row=mysql_num_rows($result);//查看查詢結(jié)果有多少行
$max=$row; //帖子總數(shù)
//設(shè)每頁顯示10篇,可自行設(shè)定,$p總頁數(shù),$page第幾頁,$low 從第幾行開始讀,$x 讀取幾行
if (!$page){ $page=1;}//$page默認(rèn)值為1
$p=ceil($max/10);//頁數(shù)為$max/10的最大整數(shù)
$low=10*($page-1);
if($page==$p&&($max%10)<>0){$x=($max%10);} else {$x=10;}//如果是最后一頁,且不是10的整倍數(shù),讀取$max除以10的余數(shù),否則取10
if($max==0){$x=0;}//如果沒有帖子,$x取0
$result = mysql_query("select * from notebook ORDER BY time DESC limit $low,$x",$db);//按照帖子的時(shí)間降序查詢
?>
![]() | ?? ?????? ![]() ![]() ???? |
?? ?????? ??????
?????????>???for ($i=0;$i???$user=mysql_result($result,$i,'user') ; ???$time=mysql_result($result,$i,'time'); ???$ip=mysql_result($result,$i,'ip'); ???$title=mysql_result($result,$i,'title'); ???$nnote=mysql_result($result,$i,'nnote'); ???$yresult = mysql_query("SELECT * FROM user where user='$user'",$db);//讀取成員資料庫 ???$name=mysql_result($yresult,0,'name'); ???$signature=mysql_result($yresult,0,'signature');//唸個(gè)人簽章 ???$email=mysql_result($yresult,0,'email'); ???$face=mysql_result($yresult,0,'face'); ???$face='../image/face/icon'.$face; echo " | ||||
?![]() | 」; 留言人:$name | ";發(fā)表於:$time | ";![]() | ";
![]() | ?? 標(biāo)題:$title | ";
留言內(nèi)容:$nnote -------- -- -------------- $signature |