php - CODEIGNITER 调用成员函数 num rows on boolean

Question

我对 codeigniter 有疑问。当我尝试在这里登录时，结果是:

fatal error :在第 19 行调用 D:\xampp\htdocs\procurementSys\application\models\login_model.php 中 bool 值的成员函数 num_rows()

相关文件代码如下:

  <?php


  class Login_model extends CI_Model {

//this function checks whether the username and the password is in the database or not
public function check_login($username, $password){

    $this->db->select('username, password, status');
    $array = array('username' => $username, 'password' => sha1($password),'status' => 'active');
    $this->db->where($array);
    $query = $this->db->get('user');

    if($query->num_rows() == 1) // if the affected number of rows is one
    {
        return true;
    }
    else
    {
        return false;
    }
}

//this function returns the status of the user to be used in authentication
public function user_login_data($username, $password){

    $this->db->select('status');
    $array = array('username' => $username, 'password' => sha1($password));
    $this->db->where($array);
    $query = $this->db->get('user');

    if($query->num_rows() == 1) // if the affected number of rows is one
    {
         $row = $query->row();
         return $row->status;
    }
  //        else
  //        {
  //            return false;
  //        }
}


public function user_role($username){ // this function gets the user's role from the database
     $this->db->select('role');
     $this->db->where('username', $username);
     $query = $this->db->get('user');
     $row = $query->row(0);

     return $row->role;
}

public function department($username){ // this function gets the user's department from the database
     $this->db->select('department');
     $this->db->where('username', $username);
     $query = $this->db->get('user');
     $row = $query->row(0); // returns the first row with an array of objects that is stored in the row variable

     return $row->department;
}

public function get_user_id($username){ // this function gets the user's department from the database
     $this->db->select('userID');
     $this->db->where('username', $username);
     $query = $this->db->get('user');
     $row = $query->row(0); // returns the first row with an array of objects that is stored in the row variable

     return $row->userID ;
}

public function fullname($username){
     $this->db->select('firstName, secondName');
     $this->db->where('username', $username);
     $query = $this->db->get('user');
     $row = $query->row(0);
     return $row;

  //            foreach($query->result() as $row) // returns the query as an array of objects
  //           {
  //                $data[] = $row; // equates the array of objects to an array variable
  //           }
  //        
  //           return $data;
   // }
}

 }

 ?>

我一直在寻找解决方案并找到了这篇文章 (Call to a member function num_rows() on boolean)。它给了我一个想法，但没有真正的帮助。谢谢

Answer 1

我在启用 MySQL 严格模式时遇到了这个错误。当我禁用严格模式时，错误消失了。

检查此模式是否已启用

SHOW VARIABLES LIKE 'sql_mode';

禁用它

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';