php分页输出有关问题
程序员文章站
2022-06-07 11:45:34
...
php分页输出问题
这里是 search.php页的
*****************************
这里是searchshow.php 页的
?>
include("conn/conn.php");
include("search.php");
$search=$_POST[search];
$xuanze=$_POST[xuanze];
if($_POST[search]==""){
$search=$_GET[search];
$xuanze=$_GET[xuanze];
}
if(shoptype=="$xuanze"){
$sql1=mysql_query("select count(*) as total from tb_members where shoptype='$search' order by mid");
}elseif(user=="$xuanze"){
$sql1=mysql_query("select count(*) as total from tb_members where user='$search' order by mid");
}elseif(shopname=="$xuanze"){
$sql1=mysql_query("select count(*) as total from tb_members where shopname='$search' order by mid");
}
$minfo=mysql_fetch_array($sql1);//在这里出错
$total=$minfo[total];
$pagesize=5;
if($total $pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
if(shoptype=="$xuanze"){
$sql=mysql_query("select * from tb_members where shoptype='$search' order by mid limit ".($page-1)*$pagesize.",$pagesize");
}elseif(user=="$xuanze"){
$sql=mysql_query("select * from tb_members where user='$search' order by mid limit ".($page-1)*$pagesize.",$pagesize");
}
elseif(shopname=="$xuanze"){
$sql=mysql_query("select * from tb_members where shopname='$search' order by mid limit ".($page-1)*$pagesize.",$pagesize");
}
$info=mysql_fetch_array($sql);//在这里也出错
?>
这里是 search.php页的
*****************************
这里是searchshow.php 页的
?>
include("conn/conn.php");
include("search.php");
$search=$_POST[search];
$xuanze=$_POST[xuanze];
if($_POST[search]==""){
$search=$_GET[search];
$xuanze=$_GET[xuanze];
}
if(shoptype=="$xuanze"){
$sql1=mysql_query("select count(*) as total from tb_members where shoptype='$search' order by mid");
}elseif(user=="$xuanze"){
$sql1=mysql_query("select count(*) as total from tb_members where user='$search' order by mid");
}elseif(shopname=="$xuanze"){
$sql1=mysql_query("select count(*) as total from tb_members where shopname='$search' order by mid");
}
$minfo=mysql_fetch_array($sql1);//在这里出错
$total=$minfo[total];
$pagesize=5;
if($total $pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
if(shoptype=="$xuanze"){
$sql=mysql_query("select * from tb_members where shoptype='$search' order by mid limit ".($page-1)*$pagesize.",$pagesize");
}elseif(user=="$xuanze"){
$sql=mysql_query("select * from tb_members where user='$search' order by mid limit ".($page-1)*$pagesize.",$pagesize");
}
elseif(shopname=="$xuanze"){
$sql=mysql_query("select * from tb_members where shopname='$search' order by mid limit ".($page-1)*$pagesize.",$pagesize");
}
$info=mysql_fetch_array($sql);//在这里也出错
?>
帐号 | 联系人 | 店铺名称 | 类型 | 联系电话 | 联系地址 |
上一篇: yii pageTitle 怎么修改
下一篇: HTML中的DIV的相关代码,该如何解决
网友评论
文明上网理性发言,请遵守 新闻评论服务协议
我要评论