André Luiz André Luiz - 1 year ago 311
MySQL Question

Phalcon PhP - how to execute query inside a controller with parameters

I would like to know how can I execute a query, inside a phalcon controller, using parameters.

My SQL Query:

SELECT a.*, getApplicationData( as json_data
FROM application a
INNER JOIN application_data d on d.application_id =
WHERE a.form_id=1
AND d.firstname LIKE '%:searchQuery:%' ;

Here is how I'm trying to execute (I found it in Phalcon's doc, but the example was not inside a controller).

$applications = $this->db->query(

I know that since you have the ORM I shouldn't be querying the DB like this, but for the feature I'm working on it has to be like this, this query is dymanic.

My question is how to pass the parameter for the
in the query.

Thanks in advance for any help.

Answer Source

You almost got it right. You only had to add the percents (%) in the bind array.

$sqlQuery = 'SELECT * FROM events WHERE title LIKE :searchQuery';
$applications = $this->db->query(
    array('searchQuery'=> '%' . $searchQuery . '%')

Also notice how I binded the :searchQuery in the $sqlQuery. It only uses single : instead of surrounding the parameter. This is because Raw queries use directly the DB connection in our case it is PDO.

More examples can be found here:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download