分页原理及搜索时带着条件的方法

来源：互联网发布：python获取日期字符串编辑：程序博客网时间：2024/05/21 07:14
<meta charset="utf-8"><?php session_start();//链接数据库@mysql_connect('localhost','root','123456');mysql_select_db('test');//获得搜索的要求 写$where $where='';$id=0; function getWhere() {    //两种方式获取where条件   /*if(!empty($_POST)) //用post方式获取，跳转页面用get传送，接收{$where="where id > '{$_POST['id']}'";$id=$_POST['id'];}if(!empty($_GET['id'])){    $where="where id > '{$_GET['id']}' ";    $id=$_GET['id'];}*/ //用SESSION存储，页面跳转，值不会失去if(!empty($_POST['id'])){    $_SESSION['id']=$_POST['id'];}if(!empty($_SESSION['id'])){    $where="where id > '{$_SESSION['id']}'";} }//获取where $id;echo $where=getWhere();//$num为每页显示的内容function page($table,$num,$where='',$id){if(isset($_REQUEST['page'])){    $page=$_REQUEST['page'];}else{    $page=1;}//获取所有的数据条数$sqlGetNum="select * from $table $where";//记得加上where条件$result=mysql_query($sqlGetNum);$allNums=mysql_num_rows($result);if($page==0){    $page=1;}else if($page>ceil($allNums/$num)){    $page=ceil($allNums/$num);}//echo ceil($allNums/$num);$sta=($page-1)*$num;$sql="select * from $table $where limit $sta,$num";$res=mysql_query($sql);//echo $sql;$rows=[];while($res1=mysql_fetch_assoc($res)){    $rows[]=$res1;  }foreach($rows as $row){echo $row['name']."------<br>";}if(!empty($id)){echo "<a href='test2.php?page=".($page-1)."&id=".$id."'>上一页</a>  &nbsp;&nbsp;&nbsp;<a href='test2.php?page=".($page+1)."&id=".$id."'>下一页</a>";}else{echo "<a href='test2.php?page=".($page-1)."'>上一页</a>  &nbsp;&nbsp;&nbsp;<a href='test2.php?page=".($page+1)."'>下一页</a>";}}page('users',3,$where,$id);?><form action="" method="post" >id大于<input name="id" type="text"><input type="submit" value="搜索"></form>
0 0