CODEWITHSUNDEEP
cakephpcakephp-3.x
Der Admin81
Der Admin81

Reputation: 455

Check if record exists in CakePHP3.5

The Following Code returns only a error :Record not found in table "users"

if($this->Users->get($uid)->isEmpty()) {
            //do something
        }

Because the Table is empty, i want to customize this if the table is empty, and call a new page in browser

Upvotes: 7

Views: 3210

Answers (1)

ndm
ndm

Reputation: 60453

Table::get() will immediately evaluate the query and return an entity, or throw an exception if the record with the given primary key doesn't exist, ie it doesn't return a query, you cannot call isEmpty() on the result.

If you are using Table::get() you can catch the RecordNotFoundException:

try {
    $user = $this->Users->get($uid);
    // ...
} catch (\Cake\Datasource\Exception\RecordNotFoundException $exeption) {
    // record doesn't exist
}

If you wanted to use isEmpty(), you'd need to use a regular query:

$query = $this->Users->findById($uid);
if ($query->isEmpty()) {
    // record doesn't exist
}

If you don't actually need the result, you can use Table::exists():

$exists = $this->Users->exists(['id' => $uid]);
if ($exists !== true) {
    // record doesn't exist
}

or a COUNT query:

$count = $this->Users->findById($uid)->count();
if ($count !== 1) {
    // record doesn't exist
}

See also

Upvotes: 12

Related Questions