这个不需要用session来制作,用mysql的语句就可以了
比如每页显示20条记录
$page=($page-1)*20;
$sql="select * from ji_zcfg order by id desc limit $page,20";
$qu=mysql_db_query($db_dbname, $sql);
while($list=mysql_fetch_array($qu))
你可以get $page变量来决定查询第几页
limit的语法如下
limit 开始,结束
limit 0,5的话,只读取符合要求的头5个数据,
limit 5,5的话,只读取符合要求的第5个开始的5条信息
比如每页显示20条记录
$page=($page-1)*20;
$sql="select * from ji_zcfg order by id desc limit $page,20";
$qu=mysql_db_query($db_dbname, $sql);
while($list=mysql_fetch_array($qu))
你可以get $page变量来决定查询第几页
limit的语法如下
limit 开始,结束
limit 0,5的话,只读取符合要求的头5个数据,
limit 5,5的话,只读取符合要求的第5个开始的5条信息
第一页是 limit 0,5
第二页是 limit 5,5
这要取决于你翻页的交互方式。若是表单方式则可以保存于表单的隐藏对象里
若是url方式,则可以保存在url参数中当然若session可用的话,保存在session中是最方便的
http://localhost/abc.php?action=XXXX&mod=XXXX这里的action和mod你都可以用$_GET['action']和$_GET['mod']来取得,
做搜索的时候只要每页都把url后加上这些条件并取得就能每页都得到条件了。
session_start(); include_once("../../../inc/easytpl.inc");
include_once("global.inc");
include_once("../../../inc/user.inc");
include "qiyedaquan_city_search.php";
include "NNTop.php";
include "NTop.php";
$Server=Get_Mysql_Server(); $PageSize=12;
$where.="";
if($Product!="")
{
$where.="rele_cali=\"$Product\" and ";
session_register("Product");
}
if($City!="")
{
$where.="city=\"".$City."\" and ";
session_register("City");
}
print $Product;
print $City;
$StrSql="select * from comm_introduce where $where 1";
$Result=mysql_query($StrSql,$Server) or die("搜索错误".$StrSql);
$Num=mysql_num_rows($Result);
$TotalPages=ceil($Num/$PageSize);
if($CurPage<1) $CurPage=1;
if($CurPage>$TotalPages) $CurPage=$TotalPages;
if($CurPage>1) mysql_data_seek($Result,($CurPage-1)*$PageSize);
//---------------------- 搜 索 开 始 -------------------------------------------------------
if($Row=mysql_fetch_object($Result))
{
$j=0;
while($Row&&$j<$PageSize)
{
$tpl=new EasyTemplate("qiyedaquan_list.htm");
for($i=0;$i<3;$i++)
{
if($Row)
{
$tpl->assign("Image[$i]","<A href=\"shichangdongtai_qiyedaquan_2.php?ID=$Row->id\"><IMG src=\"$Row->photo_dir\" width=\"120\" height=\"60\" border=\"0\"></A>");
$tpl->assign("name[$i]","<A href=\"shichangdongtai_qiyedaquan_2.php?ID=$Row->id\"><B>$Row->calibre</B></A>");
if($user=="Admin")
{
$tpl->assign("Del","<font size=\"2\"><a href=\"shichangdongtai_qiyedaquan.php\">删 除</a></font>");
}else
{
$tpl->assign("Del","");
}
$Row=mysql_fetch_object($Result);
}
else
{
$tpl->assign("Image[$i]"," ");
$tpl->assign("name[$i]"," ");
}
}
$j+=3;
$PrintOut.=$tpl->easy_parse();
}
}else $PrintOut="<font color=#6699cc>目前还没有你所需的品牌信息</font>"; //---------------------- 搜 索 结 束 ------------------------------------------------------- $Page=preg_replace("/>$CurPage /","><font color=#FF0000>$CurPage</font> ",$Page);
if($CurPage<=1)
{
$Prev=$CurPage;
}else{
$Prev=$CurPage-1;
}
if($CurPage>=$TotalPages)
{
$Next=$CurPage;
}else{
$Next=$CurPage+1;
} $tpl=new EasyTemplate("shichangdongtai_qiyedaquan_c.htm");
$tpl->assign("NNTop",$NNTop);
$tpl->assign("NTop",$NTop);
$tpl->assign("keyword1",$keyword);
$tpl->assign("qiyedaquan_city_search",getsearch($Product,$City));
$tpl->assign("qiyedaquan_list",$PrintOut);
$tpl->assign("TP",$TotalPages);
$tpl->assign("CP",$CurPage);
$tpl->assign("LP","city_search.php?CurPage=$TotalPages");
$tpl->assign("Prev","city_search.php?CurPage=$Prev");
$tpl->assign("Next","city_search.php?CurPage=$Next");
$tpl->easy_print();// if(session_is_registered("Product")) session_unregister("Product");
// if(session_is_registered("City")) session_unregister("City");
//我不知道该在那里释放注册的变量?>
你要用session保存$StrSql或$where