本文整理汇总了PHP中Am_Query::escapeWithPlaceholders方法的典型用法代码示例。如果您正苦于以下问题:PHP Am_Query::escapeWithPlaceholders方法的具体用法?PHP Am_Query::escapeWithPlaceholders怎么用?PHP Am_Query::escapeWithPlaceholders使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Am_Query
的用法示例。
在下文中一共展示了Am_Query::escapeWithPlaceholders方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: _getWhere
public function _getWhere(Am_Query $q)
{
$a = $q->getAlias();
$f = '%' . $this->filter . '%';
return $q->escapeWithPlaceholders("({$a}.login LIKE ?) OR ({$a}.email LIKE ?) OR ({$a}.name_f LIKE ?) OR ({$a}.name_l LIKE ?)\n OR CONCAT({$a}.name_f, ' ', {$a}.name_l) LIKE ?\n OR ({$a}.remote_addr LIKE ?)\n OR ({$a}.user_id IN (SELECT user_id FROM ?_invoice WHERE public_id=? OR CAST(invoice_id as char(11))=?))\n OR ({$a}.user_id IN (SELECT user_id FROM ?_invoice_payment WHERE receipt_id=?))\n ", $f, $f, $f, $f, $f, $f, $this->filter, $this->filter, $this->filter);
}
示例2: _getWhere
public function _getWhere(Am_Query $q)
{
$a = $q->getAlias();
$f = '%' . $this->filter . '%';
return $q->escapeWithPlaceholders("({$a}.login LIKE ?) OR ({$a}.email LIKE ?) OR ({$a}.name_f LIKE ?) OR ({$a}.name_l LIKE ?) \n OR ({$a}.user_id = (SELECT user_id FROM ?_invoice WHERE public_id=? OR invoice_id=? LIMIT 1))\n OR ({$a}.user_id = (SELECT user_id FROM ?_invoice_payment WHERE receipt_id=? LIMIT 1))\n ", $f, $f, $f, $f, $this->filter, $this->filter, $this->filter);
}