How to use like token？

Question

How to use like token？

sharklet Jun '13

Created Jun '13	Last Reply Jun '13	Replies 1	Views 449	Votes 1

sharklet 12.8k

Jun '13

this->modelsManager->createBuilder() ->from(array('g' => 'Goods')) ->join('Enterprises','g.enterprise_id = e.id','e') ->where('g.category_id = :id:',array('id' => $category_id)) ->andWhere("e.full_name like '%:keyword:%'",array('keyword' => $keyword)) ->getQuery() ->execute();

Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens' 。。。。

1

Phalcon · Answer 1 · 2013-06-03T07:50:15-07:00

This way:

$this->modelsManager->createBuilder()
    ->from(array('g' => 'Goods'))
    ->join('Enterprises','g.enterprise_id = e.id','e')
    ->where('g.category_id = :id:',array('id' => $category_id))
    ->andWhere("e.full_name like :keyword:",array('keyword' => '%'. $keyword. '%'))
    ->getQuery()
    ->execute();

sharklet · Answer 2 · 2013-06-03T17:53:19-07:00

sharklet
12.8k

Jun '13

thanks.