这是我的php代码,有没有大牛能告知一下,非常感谢
$pagesize=2;
$pageoff = ($page-1)*$pagesize;
if($page <=1){
$page = $page+1;
}
//1.连接数据库
$conn = mysqli_connect($host,$username,$password,$db);
mysqli_set_charset($conn,'utf8');
if(!$conn){
echo "数据库连接失败";
exit;
}
//4.获取数据sql语句
$sql = "select * from htxt LIMIT {$pageoff}, {$pagesize}";
$sql_count = "select count(*) as count from htxt";
//5.发送sql语句
$res = mysqli_query($conn,$sql);
while($row = mysqli_fetch_assoc($res)) {
$rows[] = $row;
}
$temr = mysqli_query($conn,$sql_count);
if($temr){
$row_count = mysqli_fetch_assoc($temr);
$count = $row_count['count'];
}
$total = ceil($count / $pagesize);
if($page >= $total){
$page = $total-1;
}
<a href=" >">上一页</a >;
<a href="welcome.php?p=<?php echo ($page+1);?>">下一页</a >;
$pagesize=2;
$pageoff = ($page-1)*$pagesize;
if($page <=1){
$page = $page+1;
}
//1.连接数据库
$conn = mysqli_connect($host,$username,$password,$db);
mysqli_set_charset($conn,'utf8');
if(!$conn){
echo "数据库连接失败";
exit;
}
//4.获取数据sql语句
$sql = "select * from htxt LIMIT {$pageoff}, {$pagesize}";
$sql_count = "select count(*) as count from htxt";
//5.发送sql语句
$res = mysqli_query($conn,$sql);
while($row = mysqli_fetch_assoc($res)) {
$rows[] = $row;
}
$temr = mysqli_query($conn,$sql_count);
if($temr){
$row_count = mysqli_fetch_assoc($temr);
$count = $row_count['count'];
}
$total = ceil($count / $pagesize);
if($page >= $total){
$page = $total-1;
}
<a href=" >">上一页</a >;
<a href="welcome.php?p=<?php echo ($page+1);?>">下一页</a >;
这是上一页的代码,没问题,为什么点击上一页会报错sql语句错误呢?
sql语句哪里错误了
<a href=" welcome.php?p=<?php echo ($page-1);?>">上一页</a >;
那么程序在查询时如何知道你这是上一页呢?
你最前面要有:
$page=$_GET['p'];