Model database Query

Hi, I'm using this code codeigniter 3.I try ci4 this code but not working.How work this code ci4?

Code:

public function give($from,$where=array()){
    $giveme = $this->db->from($from)->where($where)->get()->row_array();
    return $giveme;
}

It would be something like this:

PHP Code:

public function give($from,$where=array())
{
    $db = \Config\Database::connect();
    $builder = $db->table($from);
    
    $giveme = $builder->from($from)->where($where)->get()->getResultArray();

    return $giveme;
} 


Did not have the time to test it, but give it a go.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

If you use CI4 model, simply set the protected variables for $table, $returnType etc. then create function in the model:

PHP Code:

public function give( $where=[] ) 
{
   return $this->where( $where )->findAll();
} 


Dirk B.
Abatrans Software
No SEO spam - see forum guidelines