php+mysql，php连接mysql,查询与分页显示

来源：互联网发布：java socket 发送报文编辑：程序博客网时间：2024/06/06 14:10

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>php+mysql,分页</title>
</head>

<body>

<?
//链接数据库
$conn= mysql_connect("localhost:3336", "root", "myoa888") or die("Could not connect: " . mysql_error());
    //解决乱码问题：
    @mysql_query("SET character_set_connection=gb2312, character_set_results=gb2312, character_set_client=binary",$conn);
    //2.mysql_select_db()...选择数据表
    mysql_select_db('TD_OA',$conn);
mysql_query( "set names 'gb2312'");
?>
<?
//计算总页数
$pagesize=4; //设置每一页显示的记录数
$rs=mysql_query("select count(*) from flow_run_attach",$conn); //取得记录总数$rs
$myrow = mysql_fetch_array($rs);
$numrows=$myrow[0];

//计算总页数
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)//如果不能整除，页数加1
$pages++;

$pages;
//判断页数设置
if(isset($_GET["page"])){
$page=intval($_GET["page"]);
}
else{
  $page=1;
  }

//计算记录偏移量
   $offset=$pagesize*($page-1);
$sql="select * from flow_run_attach order by SEQ_ID asc limit $offset,$pagesize";
//echo $sql."<br>";
   $cursor=mysql_query($sql,$conn);
   $i=0;

?>
<table border="1" bordercolor="#0033FF" align="center" width="80%">
<tr>
    <td>序号</td>
        <td>SEQ_ID</td>
        <td>RUN_ID</td>
        <td>ATTACHEMENT_ID</td>
        <td>ATTACHEMENT_NAME</td>
    </tr>
    <?

while($myrow1 = mysql_fetch_array($cursor)){
   $SEQ_ID=$myrow1["SEQ_ID"];
   $RUN_ID=$myrow1["RUN_ID"];
   $ATTACHEMENT_ID=$myrow1["ATTACHMENT_ID"];
   $ATTACHEMENT_NAME=$myrow1["ATTACHMENT_NAME"];
?>
<tr>
    <td><?=++$i?></td>
        <td><?=$SEQ_ID?></td>
        <td><?=$RUN_ID?></td>
        <td><?=$ATTACHEMENT_ID?></td>
        <td><?=$ATTACHEMENT_NAME?></td>
    </tr>
<?
   }
?>
</table>
<div align="center">共有<?=$pages?>页 <?=$page?>/<?=$pages?>
<?
for($i=1;$i<$page;$i++){//
echo "<a href='index.php?page=".$i."'>[".$i ."]</a> ";
}
echo "[".$page."]";
for ($i=$page+1;$i<=$pages;$i++){echo "<a href='index.php?page=".$i."'>[".$i ."]</a>";}

$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;

if ($page>1)
{echo "<a href='index.php?page=".$first."'>首页</a> ";
echo "<a href='index.php?page=".$prev."'>上一页</a> ";}
if ($page < $pages)
{echo "<a href='index.php?page=".$next."'>下一页</a> ";
echo "<a href='index.php?page=".$last."'>尾页</a> ";
}
?>
</div>
</body>
</html>

1 0