在search.php接到eng.php提交的表单后,开始查询数据并且分页处理。pageft($total, 10);为分页类中的函数,但是当点击下一页时候,提示没定义的“$_POST['name']”,也就是点下一页后eng.php提交的数据不存在了。请高手指点呀!search.php 页面$str=$_POST['name'];
$num=explode(' ',$str);
$char=$num;
//根据多个关键字构建动态SQL语句
$sql="select * from (";
for($i=0;$i<count($char);$i++){
if($i==0)
$sql.="select * from p_engbase left join p_engcontent on p_engbase.id=p_engcontent.nid where shenhe='1' and title like '%char[0]%' or author like '%$char[0]%' or keyword like '%$char[0]%' or content like '%$char[0]%' or region like '%$char[0]%' or school like '%$char[0]%'";
else
$sql.=" union select * from p_engbase left join p_engcontent on p_engbase.id=p_engcontent.nid where where shenhe='1' and title like '%$char[$i]%' or author like '%$char[$i]%' or keyword like '%$char[$i]%' or content like '%$char[$i]%' or region like '%$char[$i]%' or school like '%$char[$i]%'";
}
$sql.=")T order by date_time DESC";
$result=$db->query($sql);
$total=$db->num_rows($result);
pageft($total, 10);
if($firstcount<0)$firstcount=0;
$query=$db->query($sql." limit $firstcount,$displaypg");
while($row=@$db->fetch_array($query)){
$sm_e[]=array("title"=>$row['title'],
"id"=>$row['id'],
"date_time"=>$row['date_time']);
}
$num=explode(' ',$str);
$char=$num;
//根据多个关键字构建动态SQL语句
$sql="select * from (";
for($i=0;$i<count($char);$i++){
if($i==0)
$sql.="select * from p_engbase left join p_engcontent on p_engbase.id=p_engcontent.nid where shenhe='1' and title like '%char[0]%' or author like '%$char[0]%' or keyword like '%$char[0]%' or content like '%$char[0]%' or region like '%$char[0]%' or school like '%$char[0]%'";
else
$sql.=" union select * from p_engbase left join p_engcontent on p_engbase.id=p_engcontent.nid where where shenhe='1' and title like '%$char[$i]%' or author like '%$char[$i]%' or keyword like '%$char[$i]%' or content like '%$char[$i]%' or region like '%$char[$i]%' or school like '%$char[$i]%'";
}
$sql.=")T order by date_time DESC";
$result=$db->query($sql);
$total=$db->num_rows($result);
pageft($total, 10);
if($firstcount<0)$firstcount=0;
$query=$db->query($sql." limit $firstcount,$displaypg");
while($row=@$db->fetch_array($query)){
$sm_e[]=array("title"=>$row['title'],
"id"=>$row['id'],
"date_time"=>$row['date_time']);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货