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

Someone uses Phalcon with oracle database?

Dear,

I'm having a hard time to start using the framework. I was overcoming the difficulties but every step I take has a new wall ahead. I spent all afternoon trying to do a find in a model and nothing to return me data. The find method expects parameters of criteria which I step correctly but the table columns are not included in the query that looks like this: SELECT WHERE USERS.ID =: id AND LIKE USERS.NAME: NAME AND LIKE USERS.EMAIL: MAIL ORDER BY USERS.ID

Missing columns and the table name.

thank you!



21.5k
edited Apr '14

Can you put your code here?

I think the query should be:

SELECT * FROM USERS WHERE USERS.ID = :id AND USERS.NAME LIKE :NAME AND USERS.EMAIL LIKE :MAIL ORDER BY USERS.ID

To get that query is built that way, you should define a 'Users' model, then do

$users = Users::find(array(
    "conditions" => "name like :name: and email like :email:",
    "bind"       => array( "name" => "somename", "email" => "someemail"),
    "order" => "id"
));

https://docs.phalcon.io/en/latest/reference/models.html