Welcome Guest, Not a member yet? Register   Sign In
Query - Call to undefined method CodeIgniter\Database\MySQLi\Connection::where()
#2

(10-04-2018, 01:22 AM)happyape Wrote: I get this error "Call to undefined method CodeIgniter\Database\MySQLi\Connection::where()" when I try this in my model class

PHP Code:
$this->db->table($table);
 
       $this->db->where($where);
 
       $this->db->update($save_data); 

however it works fine when

PHP Code:
$this->db->table($table)->where($where)->update($save_data); 

The first approach above worked fine in CI 3. So I suppose in CI 4 I just to have chain or save $db = $this->db;

This works like says the documentation:

Model.php
PHP Code:
public function updateData (int $id 1) {
    
$this->db->table($this->table)->where('id'$id)->update(
        [
            
'title' => 'New title',
        ]
    );
}

public function 
anotherUpdateData (int $id 1) {
    
$builder $this->db->table($this->table);
    
$builder->where('id'$id);
    
$builder->update(
        [
            
'title' => 'New title 2',
        ]
    );

Reply


Messages In This Thread
RE: Query - Call to undefined method CodeIgniter\Database\MySQLi\Connection::where() - by unodepiera - 10-04-2018, 04:40 AM



Theme © iAndrew 2016 - Forum software by © MyBB