<?php
$perNumber=6; //每页显示的记录数
$page=$_GET['page']; //获得当前的页面值
$count=mysql_query("select count(*) from pic where zhuangtai=0"); //获得记录总数
$rs=mysql_fetch_array($count);
$totalNumber=$rs[0];
$totalPage=ceil($totalNumber/$perNumber); //计算出总页数
if (!isset($page)){
$page=1;
} //如果没有值,则赋值1
$startCount=($page-1)*$perNumber; //分页开始,根据此方法计算出开始的记录
$sql="select id,title,bookpic,zhuangtai from pic where zhuangtai=0 limit $startCount,$perNumber";
$result=mysql_query($sql);
while ($row=mysql_fetch_object($result))
{
?>
<table width="229" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="219" align="left" class="hj"><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"><img src="<?php echo "$row->bookpic";?>" width="212" height="137" /></td>
</tr>
</table></td>
<td width="10" align="left" class="hj"> </td>
</tr>
<tr>
<td align="center" class="hj"><?php echo "$row->title";?></td>
<td align="left" class="hj"> </td>
</tr>
</table>
<?php
}
?>
<p>
<div class="jogger"><span class="disabled">
< </span><span class="current"><?php echo "总共".$totalPage."页,";?>|<a href="anli.php?page=1">首页</a>|
<?php
if ($page!=1) { //页数不等于1
?>
<a href="anli.php?page=<?php echo $page-1;?>">上一页</a>
<?php }?>
<?php
if ($page<$totalPage) { //如果page小于总页数,显示下一页链接
?>
<a href="anli.php?page=<?php echo $page+1;?>">"下一页</a>
<?php
}
?>
循环出来是一个TALBE 一个图片,怎样让它循环出来 是2排 ,一排3个图片 这样排列的!!!
<table><tr>
<?php
$i=0;
while ($row=mysql_fetch_object($result)){
$i++;
?>
<td>
<table width="229" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="219" align="left" class="hj"><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"><img src="<?php echo "$row->bookpic";?>" width="212" height="137" /></td>
</tr>
</table></td>
<td width="10" align="left" class="hj"> </td>
</tr>
<tr>
<td align="center" class="hj"><?php echo "$row->title";?></td>
<td align="left" class="hj"> </td>
</tr>
</table></td>
<?php
if($i%3==0)echo "</tr><tr>";
}
?>
</tr>
</table>