脚本宝典收集整理的这篇文章主要介绍了PDO PHP在BetweenPlaceholders中添加“AND”，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。
$cdatahome = fetchCategory(array("status"=>"1","home"=>"1"));
function fetchCategory(array $condITions){
$db = Core::getInstance();
$sql = "SELECT id,title From ruj_category WHERE ";
$params = array();
foreach ($conditions as $column => $value) {
if (PReg_match('/^[a-z-.]+$/',$column)) {
$sql .= "$column = ?";
$params[] = $value;
}
}
$sql .= " order by title asc";
$res = $db->dbh->prepare($sql);
$res->execute(array_values($params));
$res = $res->fetchAll(PDO::FETCH_ASSOC);
return $res;
$cdatahome = fetchCategory(array("status"=>"1","home"=>"1"));
function fetchCategory(array $conditions){
$db = Core::getInstance();
$sql = "SELECT id,title From ruj_category WHERE ";
$params = array();
$i = 0;
foreach ($conditions as $column => $value) {
if (preg_match('/^[a-z-.]+$/',$column)) {
if($i != 0){
$sql .= ' AND ';
}
$sql .= "$column = ?";
$params[] = $value;
$i++;
}
}
$sql .= " order by title asc";
$res = $db->dbh->prepare($sql);
$res->execute(array_values($params));
$res = $res->fetchAll(PDO::FETCH_ASSOC);
return $res;
以上是脚本宝典为你收集整理的PDO PHP在BetweenPlaceholders中添加“AND”全部内容，希望文章能够帮你解决PDO PHP在BetweenPlaceholders中添加“AND”所遇到的问题。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。