Zend_db fill in multiple placeholders
Jan 11, 2011 zend-framework
This post is more than 18 months old. Since technology changes too rapidly, this content may be out of date (but that's not always the case). Please remember to verify any technical or programming information with the current release.
I’ve been using
Zend_db to create a query which does a simple search on three columns of a table. Fortunately, I found out that the
where() statement handles single parameters intelligently when there are multiple placeholders. In the case that there are many placeholders but only one parameter, that parameter will be added to each of the placeholders the same.
For example, see this statement:
$select->where( 'email like ? OR first_name like ? OR last_name like ?', array('%' . $q . '%') );