iis升级到7.0,类似/search.php?province=贵州这样都不能用了 iis从6升级到了7.0,类似iis升级到7.0,类似/search.php?province=贵州这样的查询 都无法列出数据了,有什么解决办法啊. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 一般是url编码问题。urldecodeurldecode试一下,我这的服务器都正常,所以没办法给出调试后的代码… = = 我的查询语句是这样的,我该如何写呀...$searchsql = "SELECT id,username,nickname,grade,sex,birthday,love,kind,area1,area2,area3,area4,heigh,edu,job,pay,photo_s,ifphoto,ifsfz,ifedu,iflove,ifpay FROM ".__TBL_MAIN__." WHERE ";$tempsql = '';if (!empty($keyword)){ $keyword = trimm($keyword); $tmpkeyword = trimm($keyword); $tempsql .= " (username LIKE '%".$keyword."%' OR nickname LIKE '%".$keyword."%') AND ";}if (!empty($kind))$tempsql .= " kind='$kind' AND ";if (!empty($grade))$tempsql .= " grade='$grade' AND ";if (!empty($sex))$tempsql .= " sex='$sex' AND ";if ($photo == 1)$tempsql .= " photo_s<>'' AND ";if (!empty($birthday1))$tempsql .= " ( YEAR(NOW()) - YEAR(birthday) >= '$birthday1' ) AND ";if (!empty($birthday2))$tempsql .= " ( YEAR(NOW()) - YEAR(birthday) <= '$birthday2' ) AND ";if (!empty($province))$tempsql .= " area1 = '$province' AND ";if (!empty($city))$tempsql .= " area2 = '$city' AND ";if ($px == 1){ $sqlpx= " ORDER BY id DESC ";} elseif ($px == 2){ $sqlpx= " ORDER BY logintime DESC ";} else { $sqlpx= " ORDER BY refresh_time DESC,grade DESC ";}$searchsql .= $tempsql." flag = 1 ".$sqlpx." LIMIT 500";$rt=$db->query($searchsql);$total = $db->num_rows($rt);if($total>0){require_once YZLOVE.'include/classx.php';$pagesize = 10;if ($p<1)$p=1;$mypage=new uobarpage($total,$pagesize);$pagelist = $mypage->pagebar(1);$pagelistinfo = $mypage->limit2();mysql_data_seek($rt,($p-1)*$pagesize);for($i=1;$i<=$pagesize;$i++) {$rows = $db->fetch_array($rt);if(!$rows) break;$tmpx = 0;if ($rows['ifphoto'] == 1)$tmpx = $tmpx+1;if ($rows['ifsfz'] == 1)$tmpx = $tmpx+1;if ($rows['ifedu'] == 1)$tmpx = $tmpx+1;if ($rows['iflove'] == 1)$tmpx = $tmpx+1;if ($rows['ifpay'] == 1)$tmpx = $tmpx+1;if ($i % 4 == 1){$tablebg='#ffffff';} else {$tablebg='#ffffff';}if ($i % 2 == 1 || $i==1){?> $keyword = trimm($keyword); ↑$keyword从哪取的?应该是$_GET变量吧? 网络安全师的前景怎么样 求一个DIV层随上下滚动条滚动的JS,只要能浮动的就行 循环SQL批量更新 PHP安装配置问题 请问,这种情况该如何能够实现? session_id赋值出现莫名其妙的难题,急!!!! php gd 如何取出包含双引号的字符专递到javascript的input box!! 微信调试问题 正则能匹配(1,2,3)和(3,4,5)吗 请大家帮忙看这个个php程序,有没有什么问题 想做个注册后绑定手机激活的功能
urldecode
urldecode
试一下,我这的服务器都正常,所以没办法给出调试后的代码… = =
$tempsql = '';
if (!empty($keyword)){
$keyword = trimm($keyword);
$tmpkeyword = trimm($keyword);
$tempsql .= " (username LIKE '%".$keyword."%' OR nickname LIKE '%".$keyword."%') AND ";
}
if (!empty($kind))$tempsql .= " kind='$kind' AND ";
if (!empty($grade))$tempsql .= " grade='$grade' AND ";
if (!empty($sex))$tempsql .= " sex='$sex' AND ";
if ($photo == 1)$tempsql .= " photo_s<>'' AND ";
if (!empty($birthday1))$tempsql .= " ( YEAR(NOW()) - YEAR(birthday) >= '$birthday1' ) AND ";
if (!empty($birthday2))$tempsql .= " ( YEAR(NOW()) - YEAR(birthday) <= '$birthday2' ) AND ";
if (!empty($province))$tempsql .= " area1 = '$province' AND ";
if (!empty($city))$tempsql .= " area2 = '$city' AND ";if ($px == 1){
$sqlpx= " ORDER BY id DESC ";
} elseif ($px == 2){
$sqlpx= " ORDER BY logintime DESC ";
} else {
$sqlpx= " ORDER BY refresh_time DESC,grade DESC ";
}
$searchsql .= $tempsql." flag = 1 ".$sqlpx." LIMIT 500";
$rt=$db->query($searchsql);
$total = $db->num_rows($rt);
if($total>0){
require_once YZLOVE.'include/classx.php';
$pagesize = 10;
if ($p<1)$p=1;
$mypage=new uobarpage($total,$pagesize);
$pagelist = $mypage->pagebar(1);
$pagelistinfo = $mypage->limit2();
mysql_data_seek($rt,($p-1)*$pagesize);
for($i=1;$i<=$pagesize;$i++) {
$rows = $db->fetch_array($rt);
if(!$rows) break;
$tmpx = 0;
if ($rows['ifphoto'] == 1)$tmpx = $tmpx+1;
if ($rows['ifsfz'] == 1)$tmpx = $tmpx+1;
if ($rows['ifedu'] == 1)$tmpx = $tmpx+1;
if ($rows['iflove'] == 1)$tmpx = $tmpx+1;
if ($rows['ifpay'] == 1)$tmpx = $tmpx+1;
if ($i % 4 == 1){$tablebg='#ffffff';} else {$tablebg='#ffffff';}
if ($i % 2 == 1 || $i==1){
?>
↑
$keyword从哪取的?应该是$_GET变量吧?