find and findbycolumnname returning null

Question

find and findbycolumnname returning null

assadnazar Sep '17

Created Sep '17	Last Reply Sep '17	Replies 4	Views 784	Votes 0

assadnazar 5.9k

Sep '17

Hey helpers, My db model:

<?php
namespace Ocapp\Models;

use \Phalcon\Mvc\Model;

class UserHistories extends Model
{

    /**
     *
     * @var integer
     * @Primary
     * @Identity
     * @Column(type="integer", length=11, nullable=false)
     */
    public $id;

    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $vendorId;

    /**
     *
     * @var integer
     * @Column(type="integer", length=11, nullable=false)
     */
    public $userId;

    /**
     *
     * @var string
     * @Column(type="string", nullable=false)
     */
    public $use_time;

    /**
     * Initialize method for model.
     */
    public function initialize()
    {
        $this->belongsTo('userId', __NAMESPACE__ . '\Users', 'id', [
            'alias' => 'user'
        ]);

        $this->belongsTo('vendorId', __NAMESPACE__ . '\Users', 'id', [
            'alias' => 'vendor'
        ]); 
    }

}

when i use

$userHistories = UserHistories::findFirst('userId=30');

it returns the resultset

but it returns null with find() and findByUserid().

Wojciech Ślawski
145.0k

Accepted
answer

edited Sep '17
Sep '17

There is no chance that find returns null. Find returns RESULTSET class, even empty, it returns set of rows. You have id null beacause it's not your model yet., You need to do getFirst()->id.

You are trying to do:

Model::find()->id;

Which is wrong and will never work, beacause you have Resultset class. You need to do:

Model::find()->getFirst()->id;

Or if you need one record just:

Model::findFirst()->id;

Wojciech Ślawski · Answer 1 · 2017-09-25T13:23:46-07:00

No, it doesn't return resultset, it returns UserHistories class. If you use find() it should return resultset, even empty, same wiht findByUserId. Not sure, maybe find method doesn't accept condition as first argument?

Dylan Anderson · Answer 2 · 2017-09-25T13:44:01-07:00

Does find() return the correct record?

In my experience, you don't specify the column with findFirst, just the value. The column is automatically determined to be the primary key:

$userHistories = UserHistories::findFirst(30);

assadnazar · Answer 3 · 2017-09-25T23:08:50-07:00

No find() also returning null. BTW, my phalcon version is 3.2.1 if it is of any help.

Does find() return the correct record?

In my experience, you don't specify the column with findFirst, just the value. The column is automatically determined to be the primary key:
$userHistories = UserHistories::findFirst(30);

assadnazar · Answer 4 · 2017-09-26T01:17:18-07:00

i just get the following notice if i try to get the value of id (the primary key)

Notice: Undefined property: Phalcon\Mvc\Model\Resultset\Simple::$id in D:\xampp\htdocs\ocapp\app\modules\frontend\controllers\UsersController.php on line 288 NULL

if i use findFirst(1), then i get

string(1) "1"

It has taken my whole day but no clue till now.

No, it doesn't return resultset, it returns UserHistories class. If you use find() it should return resultset, even empty, same wiht findByUserId. Not sure, maybe find method doesn't accept condition as first argument?

Wojciech Ślawski · Answer 5 · 2017-09-26T11:20:56-07:00

Wojciech Ślawski
145.0k

edited Sep '17
Sep '17

I guess your issue after my last post is solved so i will mark it as answer.

assadnazar · Answer 6 · 2017-09-26T13:41:12-07:00

yes, it has been resolved. just came back to mark it resolved but you already had done it...

Anyways, thanks.

I guess your issue after my last post is solved so i will mark it as answer.