codeigniter fatal error, trying to read database

Question

Fatal error: Call to a member function result() on a non-object in C:\wamp\www\system\application\models\users_model.php on line 8

   <?php

    class Users_model extends Model {

      function get_records()
      {
        $query = $this->db->get('users');
        return $query->result();
      }

    }
    ?>

Answer 1

The above error is occuring because the value of $query is NULL or a non-object. This is likely because get('users') failed to return a proper query.

Make sure your database has a table users and that your database library is initialized and configured correctly.

Answer 2

I agree with Aren.

You should implement some sort of failure checking to gracefully handle this error.

$result = $this->Users_model->get_records();
if ($result == null)
  echo "error message";
else
{
  // do your normal page handling
}