<!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>
PDO的分页效果
最新推荐文章于 2022-08-18 16:27:34 发布