我将使用一个数组来包含where …的各个部分，当发生匹配时，将结果语句添加到数组中。评估完之后，进行内爆，以“ AND”分隔并连接到$
query上。
$arrWhere = array();$assWhere = array();if($variable1 != "") { $arrWhere[] = "variable1 = :variable1"; $assWhere[":variable1"] = $variable1;}if($variable2 != "") { $arrWhere[] = "variable2 = :variable2"; $assWhere[":variable2"] = $variable2;}if($variable3 != "") { $arrWhere[] = "variable3 = :variable3"; $assWhere[":variable3"] = $variable3;}$query="SELECt * FROM table WHERe " . implode ( " AND " , $arrWhere );$query -> execute($assWhere);
