本文整理汇总了PHP中ADODB_mysqli::quote方法的典型用法代码示例。如果您正苦于以下问题:PHP ADODB_mysqli::quote方法的具体用法?PHP ADODB_mysqli::quote怎么用?PHP ADODB_mysqli::quote使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ADODB_mysqli
的用法示例。
在下文中一共展示了ADODB_mysqli::quote方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: loadByFilter
public function loadByFilter($filterArgs = array(), $ufilterArgs = array())
{
$sql = array();
$args = array();
foreach ($filterArgs as $key => $value) {
if ($property = $this->findDbKeyByProperty($key)) {
if (is_array($value)) {
if (count($value)) {
foreach ($value as $vvalue) {
$args[] = $this->db->quote($vvalue);
}
$sql[] = "`{$property}` IN (" . implode(",", array_fill(0, count($value), "?")) . ")";
}
} else {
$sql[] = "`{$property}` = ?";
$args[] = $value;
}
}
}
foreach ($ufilterArgs as $key => $value) {
if ($property = $this->findDbKeyByProperty($key)) {
if (is_array($value)) {
if (count($value)) {
foreach ($value as $vvalue) {
$args[] = $this->db->quote($vvalue);
}
$sql[] = "`{$key}` NOT IN (" . implode(",", array_fill(0, count($value), "?")) . ")";
}
} else {
$sql[] = "`{$key}` != ?";
$args[] = $value;
}
}
}
$sqlString = "SELECT * FROM {$this->dbTableName}";
if (count($sql)) {
$sqlString .= " WHERE " . implode(" AND ", $sql);
}
//TODO: Return array of objects
//die("TODO");
return $this->db->GetAll($sqlString, $args);
}