<?php
//获取筛选条件
$keywords = isset($_GET[‘keywords‘]) ? $_GET[‘keywords‘] : ‘‘;
//页码
$page = isset($_GET[‘page‘]) ? $_GET[‘page‘] : 1;
//每页显示的条数
$pnum = 2;
$sqlnum = ($page - 1) * $pnum . ‘,‘ . $pnum;
$conn = new mysqli(‘localhost‘, ‘root‘, ‘root‘, ‘qiye‘);
$sql = "select * from product where descs like ‘%$keywords%‘ limit $sqlnum";
$res = $conn->query($sql);
$list = $res->fetch_all(MYSQLI_ASSOC);
// var_dump($list);
//总条数
$sql = "select * from product where descs like ‘%$keywords%‘";
$zongnum = $conn->query($sql);
$zongnum = $zongnum->num_rows;
//总页码数
$zpage = ceil($zongnum / $pnum);
// ceil 向上取整
$conn->close();
?>
<?php
for ($i = 1; $i <= $zpage; $i++) {
?>
<a href="product.php?page=<?php echo $i ?>&keywords=<?php echo $keywords ?>"><?php echo $i ?></a>
<?php
}
?>
更新数据
<?php
$id=$_GET[‘id‘];
$conn= new mysqli(‘localhost‘, ‘root‘, ‘root‘, ‘qiye‘);
$sql="select * from product where id = $id";
$res=$conn->query($sql);
$info=$res->fetch_assoc();
if ($_POST) {
$descs = $_POST[‘descs‘];
$uname = $_POST[‘img‘];
$conn = new mysqli(‘localhost‘, ‘root‘, ‘root‘, ‘qiye‘);
$sql = "update product set descs=‘$descs‘,img=‘$uname‘ where id = $id ";
$res = $conn->query($sql);
if($conn->error){
die($conn->error);
}
if($res){
header(‘location:product.php‘);
}else{
echo $res;
}
}
?>
上级页面编辑按钮
<a href="editproduct.php?id=<?php echo $val[‘id‘]?>" class="layui-btn">编辑</a>
<form class="layui-form layui-card-body" action="" method="post" enctype="multipart/form-data">
<button type="button" class="layui-btn" id="test1">
<i class="layui-icon"></i>上传图片
</button>
<img src="<?php echo $info[‘img‘]?>" id="imgs">
<input type="hidden" name ="img" id=‘imgg‘ value="<?php echo $info[‘img‘]?>">
<div class="layui-form-item layui-form-text">
<label class="layui-form-label">文本域</label>
<div class="layui-input-block">
<textarea name="descs" placeholder="请输入内容" class="layui-textarea"><?php echo $info[‘descs‘]?></textarea>
</div>
</div>
<div class="layui-form-item">
<div class="layui-input-block">
<button class="layui-btn layui-btn-blue" lay-submit lay-filter="formDemo">立即提交</button>
<button type="reset" class="layui-btn layui-btn-primary">重置</button>
</div>
</div>
</form>