请问在PHP中如何实现多参数数据库查询 $query = "select * from book where IndexID=xxx ".($price == "" ? "" : "and price=XXX").($publish == "" ? "" : "and publish=XXX"); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 设$ar = array("IndexID=XXX","PRICE=XXX","PUBLISH=XXX");则$sql = "SELECT* FROM dbo.BOOK WHERE ".join(" and ",$ar); $searchIfArray = array_diff($_GET , array('','0','列表','userList')); $searchIf = ''; foreach($searchIfArray as $key => $value) { if($key!='page' && $key!='SID') $searchIf = "{$key}='$value', "; } if($searchIf!='') $searchIf = " WHERE ".substr($searchIf , 0 ,-2); $searchTotalSQL = "SELECT count(*) FROM `".TABLE_USERS."`".$searchIf; 不好意思有点儿错误。应该如下:$query = "select * from book where IndexID=xxx ".($price == "" ? "" : "and price=$price").($publish == "" ? "" : "and publish=$publish"); 最笨的方法$sql="SELECT* FROM dbo.BOOK where IndexID=XXX";if(PRICE!="") $sql=$sql." and PRICE=XXX";if(PUBLISH!="") $sql=$sql." and PUBLISH=XXX"; 求助!帮用PHP正则表达示取出代码 php的一个数据库查询问题哦。高手请进 fckeditor 相关技术提问! 新手 关于一个 字符串拚接的问题 急 马上给分 谢谢!!! php版本问题?请教 有谁会配置Apache2+PHP5+pgsql+phpPgAdmin??? 关于ftp上传的问题,请各位大侠不吝赐教 极度讨厌,写了百多字后提交…… 有个问题,为什么我在iis中,配置了php,php文件可以正常运行 关于多表查询的问题 检查N次了,没有找到错误,下面的话什么意思? 检索问题,大家帮我看看,问题出在哪?
$ar = array("IndexID=XXX","PRICE=XXX","PUBLISH=XXX");
则
$sql = "SELECT* FROM dbo.BOOK WHERE ".join(" and ",$ar);
$searchIf = '';
foreach($searchIfArray as $key => $value)
{
if($key!='page' && $key!='SID')
$searchIf = "{$key}='$value', ";
}
if($searchIf!='')
$searchIf = " WHERE ".substr($searchIf , 0 ,-2);
$searchTotalSQL = "SELECT count(*) FROM `".TABLE_USERS."`".$searchIf;
$query = "select * from book where IndexID=xxx ".($price == "" ? "" : "and price=$price").($publish == "" ? "" : "and publish=$publish");
if(PRICE!="") $sql=$sql." and PRICE=XXX";
if(PUBLISH!="") $sql=$sql." and PUBLISH=XXX";