Find entity by id column, \Phalcon\Mvc\Model::findFirst() gives incorrect result

php model phalcon
avasin picture avasin · Dec 18, 2012 · Viewed 8.5k times · Source

Currently i have table with posts, each posts has an id.

For a moment, only one posts exists, with id id = 92.

if i execute following code, i will get not false, but post with id=92:

$post = NewsPost::findFirst(['id' => 1]);
var_dump($post->id); // gives 92

Seems to be very strange logic.. What method could be used to retrieve post by id, and that will return false/throw exception if there is no such entity?

Answer

Nikolaos Dimopoulos picture Nikolaos Dimopoulos · Dec 18, 2012

Try this:

$post = NewsPost::findFirst("id = 1");

or

$post = NewsPost::find(
    array(
        "conditions" => "id = ?0",
        "bind"       => array(0 => 1)
    )
);

Related questions

How should a model be structured in MVC?

I am just getting a grasp on the MVC framework and I often wonder how much code should go in the model. I tend to have a data access class that has methods like this: public function CheckUsername($connection, $username) { …

Read More
CodeIgniter PHP Model Access "Unable to locate the model you have specified"

I have been trying to load some models for this website I am building. However, for an unknown reason, it will bring the following error : An Error Was Encountered Unable to locate the model you have specified: logon_model Now , …

Read More
Eloquent ORM laravel 5 Get Array of ids

I'm using Eloquent ORM laravel 5.1, i want to return an array of ids greater than 0, My model called test. I have tried : $test=test::select('id')->where('id' ,'>' ,0)->get()->toarray(); It …

Read More