原生的搜索分页
来源:互联网 发布:网络点播系统 编辑:程序博客网 时间:2024/06/07 21:46
<?phpheader('content-type:text/html;charset=utf-8');//连接数据库$link=mysqli_connect('127.0.0.1','root','root','exam');//设置字符集mysqli_query($link,'set names utf8');$search=isset($_GET['search'])?$_GET['search']:""; //查询数据总条数$sql1="select count(*) num from rikao_15 where c_mingcheng like '%$search%'";$res1=mysqli_query($link,$sql1);$arr1=mysqli_fetch_assoc($res1);//获得数据总条数$size=$arr1['num'];//设置每页条数$length=3;//计算总页数$pages=ceil($size/$length);//传递页数$page=isset($_GET['page'])?$_GET['page']:1;//上一页,下一页$last=$page-1<1?1:$page-1;$next=$page+1>$pages?$pages:$page+1;//偏移量 $offset=($page-1)*$length;//写sql语句 $sql="select * from rikao_15 where c_mingcheng like '%$search%' limit $offset,$length " ;//执行 $res=mysqli_query($link,$sql); ?><center><div id='div1'><input type="search" name="search" value="<?php echo $search?>"><button onclick="page(1)">搜索</button><table border=1><tr><td>全选<input type="checkbox" name="quanxuan" onclick="quanxuan()"></td><td>自动序号</td><td>序列</td><td>名称</td><td>图片</td><td>作者</td><td>描述</td><td>权限</td><td>特定信息</td><td>操作</td></tr><?phpwhile($arr=mysqli_fetch_assoc($res)){?><tr><td><input type="checkbox" name="box"value="<?php echo $arr['id']?>"></td><td><?php echo $arr['id']?></td><td><?php echo $arr['id']?></td><td><?php echo $arr['c_mingcheng']?></td><td><img src="<?php echo $arr['c_filename']?>" alt="" width=150/></td><td><?php echo $arr['c_author']?></td><td><?php echo $arr['c_desc']?></td><td><?php if($arr['c_quanxuan']==1){ echo '是';}else{echo '否';} ?></td><td><?php echo $arr['c_infor']?></td><td><a href="javascript:del(<?php echo $arr['id']?>)">删除</a> <?php if($arr['c_quanxuan']==1){?><a href="upload.php?id=<?php echo $arr['c_filename']?>">下载</a><?php }else{ ?><a href="javascript:fun1()">下载</a> <?php} ?></td></tr><?php}?><tr><td>全选<input type="checkbox" name="xuan" onclick="xuan()" ></td><td colspan=9><button onclick="Quan()">全选</button><button onclick="Fan()">反选</button><button onclick="Bu()">全不选</button><button onclick="Pi()">批量删除</button><button onclick="Tian()">添加</button></td></tr></table><a href="javascript:page(1)">首页</a><a href="javascript:page(<?php echo $last?>)">上一页</a><a href="javascript:page(<?php echo $next?>) ">下一页</a><a href="javascript:page(<?php echo $pages?>)">尾页</a> <?php echo $page?>/<?php echo $pages?> 总共<?php echo $size?>条数据 </div></center><script type="text/javascript">function page(page){ var search = document.getElementsByName('search')[0].value; var ajax = new XMLHttpRequest(); ajax.open('get','ajax.php?page='+page+'&search='+search); ajax.send(); ajax.onreadystatechange = function(){ if(ajax.readyState==4 &&ajax.status == 200){ document.getElementById('div1').innerHTML=ajax.responseText;}}}function del(id){ //var search = document.getElementsByName('search')[0].value; var ajax = new XMLHttpRequest(); ajax.open('get','del.php?id='+id); ajax.send(); ajax.onreadystatechange = function(){ if(ajax.readyState==4 &&ajax.status == 200){ //alert(ajax.responseText); if(ajax.responseText==1){ alert('删除成功'); location.href='ajax.php'; }else{ alert('删除失败'); location.href='ajax.php'; } }}}/*function del(id){ //var search = document.getElementsByName('search')[0].value; var ajax = new XMLHttpRequest(); ajax.open('get','del.php?id='+id); ajax.send(); ajax.onreadystatechange = function(){ if(ajax.readyState==4 &&ajax.status == 200){ //document.getElementById('div1').innerHTML=; //alert(ajax.responseText);}}}*///上全选function quanxuan(){var quanxuan=document.getElementsByName('quanxuan')[0]var box=document.getElementsByName('box') for(var i=0;i<box.length;i++){ if(quanxuan.checked==true){ box[i].checked=true;}else{ box[i].checked=false;}}}//下全选function xuan(){var xuan=document.getElementsByName('xuan')[0]var box=document.getElementsByName('box') for(var i=0;i<box.length;i++){ if(xuan.checked==true){ box[i].checked=true;}else{ box[i].checked=false;}}}//全选按钮function Quan(){var box=document.getElementsByName('box') for(var i=0;i<box.length;i++){ box[i].checked=true;}}//全不选function Bu(){var box=document.getElementsByName('box') for(var i=0;i<box.length;i++){ box[i].checked=false;}}//反选function Fan(){var box=document.getElementsByName('box') for(var i=0;i<box.length;i++){ box[i].checked=!box[i].checked;}}//添加function Tian(){location.href='rikao.php';}//批量删除function Pi(){ var str=""; var box=document.getElementsByName('box') for(var i=0;i<box.length;i++){ if(box[i].checked==true){ str=str+','+box[i].value;}} str=str.substr(1); var ajax = new XMLHttpRequest(); ajax.open('get','del.php?id='+str); ajax.send(); ajax.onreadystatechange = function(){ if(ajax.readyState==4 &&ajax.status == 200){ //alert(ajax.responseText); if(ajax.responseText==1){ alert('删除成功'); location.href='ajax.php'; }else{ alert('删除失败'); location.href='ajax.php'; } }} }function fun1(){ alert('该下载只支持会员');}</script>
0 0
- 原生的搜索分页
- 原生分页后搜索
- laravel原生分页并带参数的搜索分页
- YII2原生SQL分页支持排序搜索
- laravel的搜索分页
- 原生javascript实现的分页插件pagenav
- php最原生的SQL语句分页
- 好用的分页器(原生)
- 关于oracle的原生sql排序分页
- django分页(原生分页)
- laravel的搜索后分页
- laravel简单的搜索分页
- PHP原生分页
- PHP 原生分页
- php原生分页
- php 原生分页
- js原生 实现分页
- 原生JQUERY html5 分页
- 新手:linux环境配置以及linux下的pycharm安装
- c++命名空间
- javaweb三大框架知识点总结
- Android framwork service添加(manager 远程调service,service jni调native code)
- 在html文档中添加 iconfont 图标
- 原生的搜索分页
- Win10用不了virtualbox
- Day37、函数重载、缺省参数、哑元参数、内联函数inline、内存分配、引用
- 密码学:生日攻击
- Selector
- C++中实现字符串分割方法
- ShareData
- 正则表达式
- Yii 异常处理、事务回滚