Call to a member function num_rows() on boolean

Question

Call to a member function num_rows() on boolean in C:\xampp\htdocs\c\application\models\usermodel.php on line 138

public function new_pass(){

    $email = $this->input->post('email');
    $pass1 = $this->input->post('pass1');
    $pass2 = $this->input->post('pass2');

    $result = $this->db->where('email', $email)->update('user',[
        'pass1' => $pass1,
        'pass2' => $pass2,
    ]);

    if ($result->num_rows() == 1) {
        return TRUE;
    }else{
        return FALSE;
    }
}

echo "
"; print_r($result == TRUE); return; remove these line from your code — shafiq.rst, Aug 22 '15 at 11:36
possible duplicate of [Call to a member function on a non-object](http://stackoverflow.com/questions/54566/call-to-a-member-function-on-a-non-object) — Ormoz, Aug 22 '15 at 11:39
possible duplicate of [mysql\_fetch\_array() expects parameter 1 to be resource (or mysqli\_result), boolean given](http://stackoverflow.com/questions/2973202/mysql-fetch-array-expects-parameter-1-to-be-resource-or-mysqli-result-boole) — andrewsi, Aug 23 '15 at 00:37

score 4 · Accepted Answer · edited Jun 17 '21 at 05:48

For insert and update query we use $this->db->affected_rows()

Also change your query too

public function new_pass(){

    $email = $this->input->post('email');
    $pass1 = $this->input->post('pass1');
    $pass2 = $this->input->post('pass2');
    $this->db->set('pass1',$pass1);
    $this->db->set('pass2',$pass2);
    $result = $this->db->where('email', $email);
    $this->db->update('user');

    $afftectedRows = $this->db->affected_rows();
     if ($afftectedRows == 1) {
        return TRUE;
    }else{
        return FALSE;
    }
}

Call to a member function num_rows() on boolean

1 Answers1

Linked