php如何实现多行多列的分页功能?高分急救!! 急!,php如何实现多行多列的分页功能?由于刚学习,不懂,求高人帮助,急救!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是不是用TABLE了..然后要避免<tr></tr>???????????? <?php/* * Created on 2010-4-17 * * Order by Kove Wong */ $link=@mysql_connect("localhost","kenriyphp","126468") or die("you could notconnect mysql"); //连接的数据库名称 @mysql_select_db("ecskenriy") or die("could not select database!"); $Page_size=20; $result=mysql_query('select * from ecs_goods'); $count = mysql_num_rows($result); $page_count = ceil($count/$Page_size); $init=1; $page_len=7; $max_p=$page_count; $pages=$page_count; //判断当前页码 if(empty($_GET['page'])||$_GET['page']<0){ $page=1; }else { $page=$_GET['page'];} $offset=$Page_size*($page-1); $sql="select * from ecs_goods limit $offset,$Page_size"; $result=mysql_query($sql,$link); $i=0; while ($row=mysql_fetch_array($result)) { if($i%5==0) echo "<TBODY><TR>"; ?> <?php //for ($i;$i<3;$i++) { // echo("<td bgcolor='#E0EEE0' height='25px'>花衣燕子</td>"); // } ?> <TD class=innertablestyle vAlign=top width="20%" height="100%"> <DIV class=div_style10><A href="productshow.php?prodid=<?php echo $row[goods_id] ?>" target=_blank><IMG class=small_pic title="<?php echo $row[goods_name];?>" height=60 src="/<?php echo $row[goods_thumb] ?>" width=80 border=0> </A></DIV> <DIV class=div_style10><A href="productshow.php?prodid=<?php echo $row[goods_id] ?>" target=_blank> <?php echo $row[goods_name];?> <br/> <?php if($row[shop_price]) { echo "$".$row[shop_price]; }?> </A></DIV></TD> <?php $i++; //} //if($i%2==0) echo "</tr>"; //if($i%2==0){ echo "</tr><tr>";} //echo("</tr>"); }?> </TR></TBODY></TABLE><?php//First |Front 1Next |Last $page_len = ($page_len%2)?$page_len:$pagelen+1;//页码个数 $pageoffset = ($page_len-1)/2;//页码个数左右偏移量 $key='<div class="page">'; $key.="<span>$page/$pages</span> "; //第几页,共几页 if($page!=1){ $key.="<a href=\"".$_SERVER['PHP_SELF']."?page=1\">First</a> "; //First $key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">Front</a>"; //Front}else { $key.="First | ";//First $key.="Front"; //Front} if($pages>$page_len){ //如果当前页小于等于左偏移 if($page<=$pageoffset){ $init=1; $max_p = $page_len; }else{//如果当前页大于左偏移 //如果当前页码右偏移超出最大分页数 if($page+$pageoffset>=$pages+1){ $init = $pages-$page_len+1; }else{ //左右偏移都存在时的计算 $init = $page-$pageoffset; $max_p = $page+$pageoffset; } } } for($i=$init;$i<=$max_p;$i++){ if($i==$page){ $key.=' <span>'.$i.'</span>'; } else { $key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>"; } } if($page!=$pages){ $key.=" | <a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">Next</a> ";//Next $key.="<a href=\"".$_SERVER['PHP_SELF']."?page={$pages}\">Last</a>"; //Last }else { $key.="Next ";//Next $key.=" | Last"; //Last } $key.='</div>';?><div align="center"><?php echo $key?></div> php使用DynamicWrapper调用dll返回string为空 刚学PHP 这题目如何编写 信息安全体系结构与模型 短息接口 寻PHP高手 关于功能安排 curl数据提交 在nginx中出错 怎么样做英文的页面 内建函数要记太难了,PHP难点是什么? 江湖救急!!!为什么不能返回表单数据? (在线等)怎么建立一个表格的时候,就让这个表格隐藏呢? include的路径问题,如何表示上N级目录
/*
* Created on 2010-4-17
*
* Order by Kove Wong
*/
$link=@mysql_connect("localhost","kenriyphp","126468") or die("you could notconnect mysql");
//连接的数据库名称
@mysql_select_db("ecskenriy") or die("could not select database!");
$Page_size=20; $result=mysql_query('select * from ecs_goods');
$count = mysql_num_rows($result);
$page_count = ceil($count/$Page_size);
$init=1;
$page_len=7;
$max_p=$page_count;
$pages=$page_count; //判断当前页码
if(empty($_GET['page'])||$_GET['page']<0){
$page=1;
}else {
$page=$_GET['page'];
} $offset=$Page_size*($page-1);
$sql="select * from ecs_goods limit $offset,$Page_size";
$result=mysql_query($sql,$link);
$i=0;
while ($row=mysql_fetch_array($result)) {
if($i%5==0) echo "<TBODY><TR>"; ?> <?php //for ($i;$i<3;$i++) {
// echo("<td bgcolor='#E0EEE0' height='25px'>花衣燕子</td>");
// }
?>
<TD class=innertablestyle vAlign=top width="20%" height="100%">
<DIV class=div_style10><A
href="productshow.php?prodid=<?php echo $row[goods_id] ?>"
target=_blank><IMG class=small_pic
title="<?php echo $row[goods_name];?>" height=60
src="/<?php echo $row[goods_thumb] ?>"
width=80 border=0> </A></DIV>
<DIV class=div_style10><A
href="productshow.php?prodid=<?php echo $row[goods_id] ?>"
target=_blank>
<?php echo $row[goods_name];?> <br/>
<?php
if($row[shop_price])
{
echo "$".$row[shop_price];
}?> </A></DIV></TD>
<?php
$i++;
//}
//if($i%2==0) echo "</tr>";
//if($i%2==0){ echo "</tr><tr>";}
//echo("</tr>");
}?>
</TR></TBODY></TABLE>
<?php
//First |Front 1Next |Last $page_len = ($page_len%2)?$page_len:$pagelen+1;//页码个数
$pageoffset = ($page_len-1)/2;//页码个数左右偏移量 $key='<div class="page">';
$key.="<span>$page/$pages</span> "; //第几页,共几页
if($page!=1){
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=1\">First</a> "; //First
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">Front</a>"; //Front
}else {
$key.="First | ";//First
$key.="Front"; //Front
} if($pages>$page_len){
//如果当前页小于等于左偏移
if($page<=$pageoffset){
$init=1;
$max_p = $page_len;
}else{//如果当前页大于左偏移
//如果当前页码右偏移超出最大分页数
if($page+$pageoffset>=$pages+1){
$init = $pages-$page_len+1;
}else{
//左右偏移都存在时的计算
$init = $page-$pageoffset;
$max_p = $page+$pageoffset;
}
}
}
for($i=$init;$i<=$max_p;$i++){
if($i==$page){
$key.=' <span>'.$i.'</span>';
} else {
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>";
}
} if($page!=$pages){
$key.=" | <a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">Next</a> ";//Next
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page={$pages}\">Last</a>"; //Last
}else {
$key.="Next ";//Next
$key.=" | Last"; //Last
}
$key.='</div>';
?>
<div align="center"><?php echo $key?></div>