We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. ORM

How can I call mysql function in PHQL ?

Hi everyone in my raw sql , I have one query like that SELECT * FROM places WHERE calculate_distance(lat,lng,10.8088715,106.6921842) <= 105.61305999756

Then I change PHQL SELECT * FROM ABC\Models\Places WHERE calculate_distance(lat,lng,10.8088715,106.6921842) <= 105.61305999756

But it can not run. How can I call funciton "calculate_distance" in my PHQL



10.4k
edited Aug '17

From within your model:

$this->getDi()->getShared("db")->query("SELECT * FROM persons WHERE age > 21 AS old_enough_to_drink");

or statically:

\Phalcon\Di::getDefault()->getShared("db")->query("SELECT * FROM persons WHERE age > 21 AS old_enough_to_drink");



799
in reply to ChangePlaces
edited Aug '17

From within your model:

$this->getDi()->getShared("db")->query("SELECT * FROM persons WHERE age > 21 AS old_enough_to_drink");

or statically:

\Phalcon\Di::getDefault()->getShared("db")->query("SELECT * FROM persons WHERE age > 21 AS old_enough_to_drink");

Thanks ChangePlaces

But I still not understand what you mean

Now I have one function (like store procdure https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html) .It has name "caculate_distance) . I want to use it built in my PHQL and I don't know how to call it.

SELECT * FROM ABC\Models\Places WHERE calculate_distance(lat,lng,10.8088715,106.6921842) <= 105.61305999756



145.0k

Add mysql dialect extension - for example https://forum.phalcon.io/discussion/15381/subquerys#C45579.