<?php
$key = isset($_GET[‘key‘]) ? $_GET[‘key‘] : ‘‘;
$page = isset($_GET[‘page‘]) ? $_GET[‘page‘] : 1;
$pnum = 3;
$sqlnum = ($page - 1) * $pnum . ‘,‘ . $pnum;
//查询数据
$conn = new mysqli(‘localhost‘, ‘root‘, ‘root‘, ‘qiye‘);
$sql = "select * from product where title like ‘%$key%‘ limit $sqlnum";
$res = $conn->query($sql);
// var_dump($res);
$list = $res->fetch_all(MYSQLI_ASSOC);
// 总条数
$sql = "select * from product where title like ‘%$key%‘";
$zongnum = $conn->query($sql);
$zongnum = $zongnum->num_rows;
//总页码
$zpage = ceil($zongnum / $pnum); //向上取整
var_dump($zongnum);
//
$conn->close();
?>
