<?php //连接数据库 @mysql_connect('127.0.0.1','root','root'); //选择数据库 mysql_select_db('ajax'); //设置字符集 mysql_query('set names utf8'); //拼写sql语句 $sql="select count(id) as count from lianxi"; $str=mysql_query($sql); $results=mysql_fetch_assoc($str); $count=$results['count']; //设置每页数据条数 $number=3; //总页数 $page_count=ceil($count/$number); //默认页数 $page=isset($_GET['page'])?$_GET['page']:1; //判断页数合法性 if($page<=0){ $page=1; } if($page>$page_count){ $page=$page_count; } //从0开始 $state=($page-1)*$number; //查询数据 $sqll="select * from lianxi limit $state,$number"; //取结果 $result=mysql_query($sqll); ?> <meta charset="utf-8"/> <input type="text" id="sousuo"><input type="button" value="搜索" οnclick="check_ss();"> <div id="u_sousuo"> <div id="fenye"> <table border="1"> <th>序号</th> <th>名称</th> <th>状态</th> <th>操作</th> <?php while(@$arr=mysql_fetch_assoc($result)){ ?> <tr> <td><input type="checkbox" name="checkbox" id="<?php echo $arr['id']?>"><?php echo $arr['id']?></td> <td><?php echo $arr['name']?></td> <td><a href="javascript:void(0);" οnclick="check_sd(this,<?php echo $arr['id']?>);"><?php echo $arr['state']?"锁定":"未锁定";?></a></td> <td><a href="javascript:void(0);" οnclick="check_sc(this,<?php echo $arr['id']?>);">删除</a> </td> </tr> <?php } ?> <tr> <td colspan="7" align="center"> <input type="checkbox" id="quan" οnclick="check_quan();">全选/全不选 <input type="button" id="fan" οnclick="check_fan();" value="反选"> <input type="button" id="pl" οnclick="check_pl();" value="批量删除"> <a href="javascript:void(0);" οnclick="check_fenye(1);">首页</a> <a href="javascript:void(0);" οnclick="check_fenye(<?php echo $page+1?>);">下一页</a> <a href="javascript:void(0);" οnclick="check_fenye(<?php echo $page-1?>);">上一页</a> <a href="javascript:void(0);" οnclick="check_fenye(<?php echo $page=$page_count?>);">尾页</a> </td> </tr> </table> </div> </div> <style> ul li{ list-style: none; float: left; width: 150px; } </style> <div style="width:600px;float:left;"> <ul> <li><img src="upload/14697554706662.jpg" width="145" height="100" alt=""/></li> <li><img src="upload/14697554706662.jpg" width="145" height="100" alt=""/></li> <li><img src="upload/14697554706662.jpg" width="145" height="100" alt=""/></li> <li><input type='checkbox'></li> <li><input type='checkbox'></li> <li><input type='checkbox'></li> </ul> </div> <script> //锁定 function check_sd(obj,id){ var ajax=new XMLHttpRequest(); ajax.onreadystatechange=function(){ if(ajax.readyState==4 && ajax.status==200){ if(ajax.responseText==1){ if(obj.innerHTML=="锁定"){ obj.innerHTML="未锁定"; }else if(obj.innerHTML=="未锁定"){ obj.innerHTML="锁定"; } } } } ajax.open('get','exam_sd.php?id='+id,false); ajax.send(null); } //全选 function check_quan(){ var num=document.getElementsByName('checkbox'); var quan=document.getElementById('quan'); if(quan.checked){ for(var i=0;i<num.length;i++){ num[i].checked=true; } }else{ for(var i=0;i<num.length;i++){ num[i].checked=false; } } } //反选 function check_fan(){ var num=document.getElementsByName('checkbox'); for(var i=0;i<num.length;i++){ if(num[i].checked){ num[i].checked=false; }else{ num[i].checked=true; } } } //批量删除 function check_pl(){ var num=document.getElementsByName('checkbox'); var str=''; for(var i=0;i<num.length;i++){ if(num[i].checked){ str=str+num[i].id+','; } } var id=str.substr(0,str.length-1); var ajax=new XMLHttpRequest(); ajax.onreadystatechange=function(){ if(ajax.readyState==4 && ajax.status==200){ //alert(ajax.responseText);return false; if(ajax.responseText!=0){ for(var i= num.length-1;i>=0;i--){ if(num[i].checked){ num[i].parentNode.parentNode.parentNode.removeChild(num[i].parentNode.parentNode); } } }else{ alert('删除失败'); } } } ajax.open('post','exam_pl.php',true); ajax.setRequestHeader('Content-Type','application/x-www-form-urlencoded'); ajax.send('id='+id); } //删除 function check_sc(obj,id){ var ajax=new XMLHttpRequest(); ajax.onreadystatechange=function(){ if(ajax.readyState==4 && ajax.status==200){ //alert(ajax.responseText);return false; if(ajax.responseText!=0){ obj.parentNode.parentNode.parentNode.removeChild(obj.parentNode.parentNode); } } } ajax.open('get','exam_sc.php?id='+id,false); ajax.send(null); } //分页 function check_fenye(page){ var ajax=new XMLHttpRequest(); ajax.onreadystatechange=function(){ if(ajax.readyState==4 && ajax.status==200){ document.getElementById('fenye').innerHTML=ajax.responseText; } } ajax.open('get','exam_fenye.php?page='+page,true); ajax.send(null); } //搜索后分页 function check_ssfy(page){ //alert(page);return false; var sousuo=document.getElementById('sousuo').value; //alert(sousuo);return false; var ajax=new XMLHttpRequest(); ajax.onreadystatechange=function(){ if(ajax.readyState==4 && ajax.status==200){ //alert(ajax.responseText);return false; document.getElementById('u_sousuo').innerHTML=ajax.responseText; } } ajax.open('get','exam_ss.php?page='+page+'&sousuo='+sousuo,true); ajax.send(null); } //搜索 function check_ss(){ var sousuo=document.getElementById('sousuo').value; if(sousuo==""){ alert('搜索不能为空');return false; }else{ var ajax=new XMLHttpRequest(); ajax.onreadystatechange=function(){ if(ajax.readyState==4 && ajax.status==200){ //alert(ajax.responseText);return false; document.getElementById('u_sousuo').innerHTML=ajax.responseText; } } ajax.open('get','exam_ss.php?sousuo='+sousuo,false); ajax.send(null); } } </script>
全选,反选,搜索,分页,批量删除,删除
最新推荐文章于 2023-10-06 18:15:04 发布