Binding parameters to QueryBuilder

Question

Binding parameters to QueryBuilder

Hugo Durães Apr '13

Created Apr '13	Last Reply Apr '13	Replies 3	Views 4012	Votes 4

Hugo Durães 31.7k

Apr '13

Hi,

I'm trying to bind some parameters with Phalcon\Mvc\Model\Query\Builder::where method.

This is my code:

$builder = $this->modelsManager->createBuilder()
    ->addFrom('\Namespace\Model', 'm')
    ->where('m.id=:id:', array('id' => $id));

But it produces the following error:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':id' at line 1

What am I doing wrong?

4

Phalcon
98.9k

Accepted
answer

Apr '13

Hi, I added a fix for this in 1.1.0, can you recompile again please?

Ivan Vorontsov · Answer 1 · 2013-04-30T05:23:27-07:00

Unfortunately 'where' has no second parameter. To bind values use:

$builder = $this->modelsManager->createBuilder()
    ->addFrom('\Namespace\Model', 'm')
    ->where('m.id=:id:')
    ->getQuery()
    ->execute(array('id' => $id))

Hugo Durães · Answer 2 · 2013-04-30T05:57:10-07:00

Sorry, I forgot to mention that I'm using Phalcon 1.1.0.

In Phalcon 1.1.0 there are two more parameters on where method: https://docs.phalcon.io/en/1.1.0/api/Phalcon_Mvc_Model_Query_Builder.html

Ivan Vorontsov · Answer 3 · 2013-04-30T06:07:12-07:00

It seems that implementation is missing https://github.com/phalcon/cphalcon/blob/1.1.0/ext/mvc/model/query/builder.c#L529 while andWhere (and other) has this implementation

Hugo Durães · Answer 4 · 2013-04-30T06:30:05-07:00

Hugo Durães
31.7k

Apr '13

Problem solved! :) Thank you @Phalcon