PDO的分页效果

来源：互联网发布：人才外包知乎编辑：程序博客网时间：2024/05/17 23:21
<!DOCTYPE html><html><head lang="en">    <meta charset="UTF-8">    <title></title>    <style>        #div1{border: 1px solid black; width: 400px;}        .pp{  margin-left: 100px;  }        .pp2{  margin-left: 250px;  }        .pp3{  letter-spacing: 8px;  }        .pp4{  letter-spacing: 1.2em;  }        table,table td,table th{border: 1px solid black;border-collapse: collapse;width:800px;margin: 0 auto;}    </style></head><body><?php//$link=@mysql_connect("localhost:3306","root","")or die("不能连接数据库".mysql_error());//mysql_select_db("users", $link)or die("不能连接数据库users".mysql_error());//mysql_query("set names 'utf8'",$link);//$page=1;//if(isset($_GET["pageid"])) $page=$_GET["pageid"];//$sql="select * from t_user LIMIT ".(($page-1)*6).", 6";//$id=mysql_query($sql,$link);//while($info=mysql_fetch_array($id)){//    array_push($userslist,array($info[0],$info[1],$info[2],$info[3],$info[4],$info[5]));//}try{    $url="mysql:host=localhost;dbname=users";    $user="root";    $password="";    $dbh=new PDO($url,$user,$password);    $userslist=array();    $dbh->query("set names 'utf8'");//    $sql="select * from t_user where uname like '张%'";//    $data=$dbh->query($sql);//    $getdata=$data->fetchAll();//    foreach($getdata as $info){//        array_push($userslist,array($info[0],$info[1],//            $info[2],$info[3],$info[4],$info[5]));//    }    $page=1;    if(isset($_GET["pageid"])) $page=$_GET["pageid"];    $sql=$dbh->prepare("select * from t_user limit ".(($page-1)*6).",6");    $sql->execute();    $data=$sql->fetchAll();//    for($i=0;$i<count($data);$i++){//        foreach($data[$i] as $key=>$value){//            echo $key."=".$value."\t";//        }//    }//    var_dump($getdata);    foreach($data as $info){        array_push($userslist,array($info[0],$info[1],            $info[2],$info[3],$info[4],$info[5]));}    $tzcount=0;    $sql1="select * from t_user";    $data1=$dbh->query($sql1);    $getdata1=$data1->fetchAll();//    var_dump($getdata1);    //计算帖子的总共条数    for($n=0;$n<count($getdata1);$n++){        $tzcount++;    }    $maxpage=ceil($tzcount/6);}catch (PDOException $ex){    echo $ex->getLine();    echo $ex->getMessage();}//$tzcount=0;//$sql="select count(*)  from t_user";//$data=mysql_query($sql,$link);//if($count=mysql_fetch_array($data)){//    $tzcount=$count[0];//}//$maxpage=ceil($tzcount/6);?><table>    <caption>联系人信息</caption>    <tr>        <th>序号</th><th>姓名</th><th>性别</th><th>电话</th><th>QQ</th><th>说明</th>    </tr>    <?php    for($i=0;$i<count($userslist);$i++){    echo "<tr><td>".$userslist[$i][0]."</td><td>".$userslist[$i][1]."</td><td>".$userslist[$i][2]."</td><td>".$userslist[$i][3]."</td><td>".$userslist[$i][4]."</td><td>".$userslist[$i][5]."</td></tr>";    }?>    <tr>        <td colspan="6">            <a style="text-decoration: none;" href="info.php?pageid=1">首页</a>            <?php if($page<=1){                echo "上一页";            }else{                $prepage=$page-1;                echo "<a style=\"text-decoration: none;\" href=\"info.php?pageid=$prepage\">上一页</a>";            }            ?>            <?php if($page>=$maxpage){                echo "下一页";            }else{                $prepage=$page+1;                echo "<a style=\"text-decoration: none;\" href=\"info.php?pageid=$prepage\">下一页</a>";            }?>        </td>    </tr></table><button id="button">添加新朋友</button><div id="div1" style="display: none;">    <p class="pp pp3">姓 名:<input type="text"name="uname" id="name"/></p>    <p class="pp pp3">性 别: <input type="radio"value="男" checked="checked" name="sex" >男<input type="radio"name="sex" value="女"/>女      </p>    <p class="pp">       电话号码: <input type="text"name="phone" id="phone"/>    </p>    <p class="pp pp4">  QQ:<input type="text"name="qq" id="qq"/>    </p>    <p class="pp pp3">       说 明:<input type="text"name="desc" id="desc"/>    </p>    <p class="pp pp2">        <input type="button" value="提交" id="submit"/>    </p></div><ul>PHP操作说明：    <li>点击"添加新朋友"按钮，显示或者弹出添加朋友的界面，录入信息，点击保存后将新的数据添加到表格中保存</li>    <li>表格和表单效果自己处理</li>    <li>使用ajax处理而不是刷新整个页面</li></ul><script src="js/jquery-1.9.1.min.js"></script><script>    $(function(){        jQuery("#button").click(function(){            jQuery("#div1").show();        });        jQuery("#submit").click(function(){            jQuery.ajax({                type: "POST",                url: "one.php",                dataType:"text",                data: "name="+$("#name").val()+"&id="+$("table tr").length+"&sex="+$("input:radio:checked").val()+"&phone="+$("#phone").val()+"&qq="+$("#qq").val()+"&desc="+$("#desc").val(),                success: function(data){                        $("input[type='text']").val(null);                }            });        });    });</script></body></html>
0 0