空间管理您的位置: Linux宝库 » IT World Never Sleep » 日志

Construct Oracle Like query using PHP Zend Framework bindParam

上一篇 / 下一篇 2008-06-24 23:03:12 / 个人分类：PHP

When first time I approached to the Zend Framework using the bindParam, I thought it is very tedious, but as I use it more, it became my second nature and I actually I like it.

To construct the Oracle Like query as following

select first_name,email from accounts where email like '%:bindString'

using the bindParam, we need to re-construct the sql string as

$sql = "select first_name,email from accounts where email like '%' || :bindString"

the trick is to use the concatenate ' || ' to concatenate the '%' in the string.

Construct Oracle Like query using PHP Zend Framework bindParam

相关阅读:

用户菜单

标题搜索

我的存档

数据统计

RSS订阅