跪求上php神级选手!! 求解PDO操作mysql完整分页代码 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 。兄弟,下次百度去吧。帮你百度的。pdo分页<?php$page = $_GET['page'];$dsn = "mysql:host=localhost;dbname=bbv1";$db = new PDO($dsn,'root',''); //pdo链接$num = 10; //每页显示的文章数目$pagea=($page-1)*$num;foreach ($db->query("SELECT * from article Limit $pagea,$num") as $row) { echo "<hr>"; print_r("<a href=delete.php?id=".$row[0].">删除</a>"); print_r($row[1]); print_r($row[2]); print_r($row[3]); }$rs = $db->query("select COUNT(*) from article"); //取得数据总数$count = $rs->fetchColumn();$pagenum = ceil($count/$num);?><hr><a href="insert.php">添加文章</a><br>文章总数:<?php echo"$count" ?><br>文章总页:<?php echo"$pagenum"?><hr><?phpFor($i=1;$i<=$pagenum;$i++){ $show=($i!=$page)?"<a href='index.php?page=".$i."'>$i</a>":"<b>$i</b>"; Echo $show." ";}$db=null;?> http://book.2cto.com/201309/31542.html http://blog.csdn.net/sinat_22319877/article/details/47445533 <ul class="pagination"> <li><a href="invqueryico.php?pageid=1<?echo "&invcode=$invcode&invname=$invname&invstd=$invstd&tuhao=$tuhao&shiyongpinpai=$shiyongpinpai&shiyongchexing=$shiyongchexing&chanpinsucheng=$chanpinsucheng&oejianhao=$oejianhao";?>">← 首页</a></li> <? if (ceil($zsl/$pagesl)-$pageid>=10) { if ($pageid+1>=9) { $pagestart=$pageid-4; $pageend=$pageid+5; } else { $pagestart=1; $pageend=10; } } if (ceil($zsl/$pagesl)-$pageid<=9) { if ($pageid+1<=9) { if (ceil($zsl/$pagesl)<=9) { $pagestart=1; } else { $pagestart=ceil($zsl/$pagesl)-9; } $pageend=ceil($zsl/$pagesl); } else { $pagestart=ceil($zsl/$pagesl)-9; $pageend=ceil($zsl/$pagesl); } } for ($i=$pagestart;$i<=$pageend;$i++) { echo "<li><a href=invqueryico.php?pageid=".$i."&invcode=$invcode&invname=$invname&invstd=$invstd&tuhao=$tuhao&shiyongpinpai=$shiyongpinpai&shiyongchexing=$shiyongchexing&chanpinsucheng=$chanpinsucheng&oejianhao=$oejianhao>".$i."</a></li>"; } ?> <li><a href="invqueryico.php?pageid=<? echo ceil($zsl/$pagesl);?><?echo "&invcode=$invcode&invname=$invname&invstd=$invstd&tuhao=$tuhao&shiyongpinpai=$shiyongpinpai&shiyongchexing=$shiyongchexing&chanpinsucheng=$chanpinsucheng&oejianhao=$oejianhao";?>">末页 → </a></li><br> </ul>新手写的,有点复杂,但是使用很正常 其中zsl是记录总数量,pageid是页参数,pagesl是一个每页数,全局的 请问下XAMPP的配置问题! 缓存的原理,不太明白,求高手详解 两个域名访问同一个地址,为什么不能同步退出 mysql 插入gzcompress后的数据总是 ‘x’,为什么 这是什么错误? 问个问题:smarty 高版本中关联数组的访问是不是已经可以使用下标访问了? PHP 读取MYSQL数据.替换 有人了解 wooki 的吗 ? 【年终感悟】不知不觉已经坚持了4年多了,菜鸟坚持做一件事,也能够有所小成。 PHP能不能把js文件写入数据库,前台用js文件,直接读取数据库 解决问题你是神!!! 微信公众号,新增永久素材(图文)总失败
帮你百度的。
pdo分页
<?php
$page = $_GET['page'];
$dsn = "mysql:host=localhost;dbname=bbv1";
$db = new PDO($dsn,'root',''); //pdo链接
$num = 10; //每页显示的文章数目
$pagea=($page-1)*$num;
foreach ($db->query("SELECT * from article Limit $pagea,$num") as $row)
{
echo "<hr>";
print_r("<a href=delete.php?id=".$row[0].">删除</a>");
print_r($row[1]);
print_r($row[2]);
print_r($row[3]);
}
$rs = $db->query("select COUNT(*) from article"); //取得数据总数
$count = $rs->fetchColumn();
$pagenum = ceil($count/$num);
?>
<hr>
<a href="insert.php">添加文章</a>
<br>
文章总数:<?php echo"$count" ?>
<br>
文章总页:<?php echo"$pagenum"?>
<hr>
<?php
For($i=1;$i<=$pagenum;$i++){
$show=($i!=$page)?"<a href='index.php?page=".$i."'>$i</a>":"<b>$i</b>";
Echo $show." ";
}
$db=null;
?>
<ul class="pagination">
<li><a href="invqueryico.php?pageid=1<?echo "&invcode=$invcode&invname=$invname&invstd=$invstd&tuhao=$tuhao&shiyongpinpai=$shiyongpinpai&shiyongchexing=$shiyongchexing&chanpinsucheng=$chanpinsucheng&oejianhao=$oejianhao";?>">← 首页</a></li>
<?
if (ceil($zsl/$pagesl)-$pageid>=10)
{
if ($pageid+1>=9)
{
$pagestart=$pageid-4;
$pageend=$pageid+5;
}
else
{
$pagestart=1;
$pageend=10;
}
}
if (ceil($zsl/$pagesl)-$pageid<=9)
{
if ($pageid+1<=9)
{
if (ceil($zsl/$pagesl)<=9)
{
$pagestart=1;
}
else
{
$pagestart=ceil($zsl/$pagesl)-9;
}
$pageend=ceil($zsl/$pagesl);
}
else
{
$pagestart=ceil($zsl/$pagesl)-9;
$pageend=ceil($zsl/$pagesl);
}
}
for ($i=$pagestart;$i<=$pageend;$i++)
{
echo "<li><a href=invqueryico.php?pageid=".$i."&invcode=$invcode&invname=$invname&invstd=$invstd&tuhao=$tuhao&shiyongpinpai=$shiyongpinpai&shiyongchexing=$shiyongchexing&chanpinsucheng=$chanpinsucheng&oejianhao=$oejianhao>".$i."</a></li>";
}
?>
<li><a href="invqueryico.php?pageid=<? echo ceil($zsl/$pagesl);?><?echo "&invcode=$invcode&invname=$invname&invstd=$invstd&tuhao=$tuhao&shiyongpinpai=$shiyongpinpai&shiyongchexing=$shiyongchexing&chanpinsucheng=$chanpinsucheng&oejianhao=$oejianhao";?>">末页 → </a></li><br>
</ul>
新手写的,有点复杂,但是使用很正常