CodeIgniter return尝试获取非对象的属性

Question

I've made an application in CodeIgniter this working in locally and now I want to try in on a hosting: hostinger. If you want see, check this. Now the problem's that when the I perform the installation of the library I get the error on the bottom from the code below:

public function get_admin_role_id()
{
    $result = intval($this->db->get_where('ea_roles', array('slug' => DB_SLUG_ADMIN))->row()->id);
    print_r($result);
    return $result;
}

A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: models/admins_model.php

Line Number: 372

Now this code should be returned the id roles of admin that is setted to default to 1. Now the installation is also involved in creating the structure of the tables and logging in phpMyAdmin seems that the database is still empty, perhaps this could be the cause of the problem? Can someone help me understand what's going on?

Complete admin model

Answer 1

It is not a good practice to use like this. We cannot ensure that the query will always produce a result it depends on database table. if $this->db->get_where returns no results then it cannot invoke the row() method and access the field idso it will raise an error.

So always do like this

public function get_admin_role_id()
{
   $result = $this->db->get_where('ea_roles', array('slug' => DB_SLUG_ADMIN));
   if($result->num_rows()==0){
     echo "Result not found!";
   } 
   else{
    $row = $result->row();
    $id = intval($row->id);
  }
}

Please make sure that this query have some result.

select * from ea_roles where slug='your_slug';