php实现简单的分页查询

---

一、链接数据库

<?php 
	$server = "localhost";
	$user = "root";
	$password = "root";
	$db = "shoping";
	function connect($servername,$username,$password,$dbname){
	    // 创建连接
	    $conn = mysqli_connect($servername, $username, $password, $dbname);
	    // $this->conn = $conn;
	    // 检测连接
	    if ($conn->connect_error) {
	        die("连接失败: " . $conn->connect_error);
	    }else{
	        // echo 'cg';
			return $conn;
	    }
	};
	
?>

二、编写查询语句

<?php
 header('Content-Type: text/html;charset=utf-8');
 header('Access-Control-Allow-Origin:*'); // *代表允许任何网址请求
//  echo json_encode($_POST);
 include('../mysql/linksql.php');
 $conn =  connect($server,$user,$password,$db );
 function selectFenYe($page,$count,$conn,$table,$id){
// SELECT * FROM 表名 LIMIT 20,10;
    $start = ($page-1)*$count;
    $sql = "SELECT * FROM $table WHERE user_id = $id LIMIT $start,$count;";
    $result = mysqli_query($conn,$sql);
        
    if ($result->num_rows > 0) {
        // 输出数据
        $class = [];
        while($row = $result->fetch_assoc()) {
            $class[] = $row;
        }
        return $class;
    } else {
        echo $sql;
    }
    $conn->close();
}
$x =  selectFenYe($_POST['page'],$_POST['count'],$conn,$_POST['table'],$_POST['user_id']);
echo json_encode($x);
?>