PHP爆破数组以生成mysql IN条件 [英] PHP implode array to generate mysql IN criteria
本文介绍了PHP爆破数组以生成mysql IN条件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我具有如下功能:
public function foo ($cities = array('anaheim', 'baker', 'colfax') )
{
$db = global instance of Zend_Db_Adapter_Pdo_Mysql...
$query = 'SELECT name FROM user WHERE city IN ('.implode(',',$cities).')';
$result = $db->fetchAll( $query );
}
这很好,直到有人将$ cities作为空数组传递为止.
This works out fine until someone passes $cities as an empty array.
为防止发生此错误,我一直在逻辑上使查询中断,如下所示:
To prevent this error I have been logic-breaking the query like so:
$query = 'SELECT name FROM user';
if (!empty($cities))
{
$query .= ' WHERE city IN ('.implode(',',$cities).')';
}
但这不是很优雅.我觉得应该有一个更好的方法来按列表进行过滤,但是我不确定该如何做.有什么建议吗?
but this isn't very elegant. I feel like there should be a better way to filter by a list, but I am not sure how. Any advice?
推荐答案
至少使用quote
方法...
if ($cities) {
$query .= sprintf('WHERE city IN (%s)', implode(',', array_map(array($db, 'quote'), $cities)));
}
或者,理想情况下,使用Zend_Db_Select ...构造查询.
or, ideally, construct the query with Zend_Db_Select...
$select = $db->select()->from('user', 'name');
if ($cities) {
foreach ($cities as $city) {
$select->orWhere('city = ?', $city);
}
}
这篇关于PHP爆破数组以生成mysql IN条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文