 |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
订阅该问题
悬赏分：20 - 2007年08月15日
我是刚才学PHP的，有很多不懂的地方，下面两个是分类的问题，昨晚做了一晚都找不出原因。代码是我把别人的copy过来再修改的，但始终改不成功。希望各位大哥帮下忙。谢谢！！！ ------------------------------------------------------------------------------------------------------- The first: --------------------- <? session_start(); echo "$vail_user 很高兴见到你"; echo "
"; ?> <? if (!$page) { $page=1; } $myconn=mysql_connect("localhost","root",""); mysql_select_db("customers",$myconn); $query="select count(*) as title from customer"; $result=mysql_query($query,$myconn); $message_count=mysql_result($result,0,"title"); $page_count=ceil($message_count/$page_size); $offset=($page-1)*$page_size; $strdo="select * from customer order by today desc limit $offset,$page_size"; $result=mysql_query($strdo,$myconn); while($row=mysql_fetch_array($result)) { echo "| ".$row['id']." | "; echo "".$row['username']." | "; echo "".$row['name']." | "; echo "".$row['sex']." | "; echo "".$row['code']." | "; echo "".$row['tel']." | "; echo "".$row['email']." | "; echo "".$row['address']." | "; echo "".$row['today']." | "; echo "
| "; if ($page<=1){ echo "第一页 | "; } else{ echo "第一页 | "; } if ($prev_page<1){ echo "上一页 | "; } else{ echo "上一页 | "; } if ($next_page>$page_count){ echo "下一页 | "; } else{ echo "下一页 | "; } if ($page>=$page_count){ echo "最后一页 |
\n"; } else{ echo "最后一页 |\n"; } } ?> ------------------------------------ The second: ---------------------- <? session_start(); echo "$vail_user 很高兴见到你"; echo ""; ?> <? mysql_connect("localhost","root","") or die("Cannot connect"); mysql_select_db("customers") or die("Cannot select"); $myquery = "SELECT * FROM customer ORDER BY today DESC"; $result = mysql_query($myquery); $number = mysql_num_rows($result); if($number>0) { $i=0; while($record= mysql_fetch_array($result)) { $data[$i]['userName'] = $record['username']; $data[$i]['name'] = $record['name']; $data[$i]['sex'] = $record['sex']; $date[$i]['code'] = $record['code']; $date[$i]['tel'] = $record['tel']; $date[$i]['email'] = $record['email']; $date[$i]['address'] = $record['address']; $date[$i]['today'] = $record['today']; $i++; } } mysql_close(); //echo "新增留言....\n"; $queryPage=$_GET['page']; $currentpage = $queryPage; if($queryPage != "") { $currentpage = $queryPage; } else { $currentpage = 1; } $i = count($data); $itemPerPage = 3; $start = ($currentpage-1)*$itemPerPage; $end = $start + $itemPerPage; if($end > $i) $end = $i; $totalPage = ceil($i/$itemPerPage); $pageString = ""; if($currentpage > 1) { $pageString .= ""."< 上页-"; } $pageString .= "[第"; for($i = 1; $i <=$totalPage; $i++) { if($i != $currentpage) { $pageString.= "".$i.""; }else { $pageString .= $i." "; } } $pageString .= "页]"; if($currentpage <= ($totalPage - 1)) { $pageString .= "-"."下页>"; } $pageString = "
".$pageString."
\n"; $ip=''; for($i=$start;$i<$end;$i++) { echo "
\n"; //echo "
\n"."2004年11月25日"." ";
/*
if($data[$i]['email'] != "") {
echo "";
}
echo "".$data[$i]['userName']."";
if($data[$i]['email'] !="") echo "";
echo "
\n";
echo "from:{$ip}
\n"; echo "".$data[$i]['message'].""; echo "
\n"; */ } echo "
\n"; echo $pageString; ?> ------------------------------------------------------------------