Codeigniter 4 V 4.5.1 $this->db problem

Just $db->table, without $this

PHP Code:

public function get_all_items(){
        $db      = \Config\Database::connect();
        $builder = $db->table('items');
        $query = $builder->select('*')
                 ->get();

                return $query->getResult();
    }
    

    public function fetch_single_item($item_id){
        $db      = \Config\Database::connect();
        $builder = $db->table('items');
        $query = $builder->select('*')
                ->where('item_id', $item_id)
                ->get();

              return $query->getRow();
    } 


That will work

I enjoy web design   d-templates.com

Thanks, but I need to have the same instance in all the methods of the class, both to avoid having to declare it in each method and because when I make transactions I often call other methods from the method that manages the transaction so the connection must be the same

Then we can get benefit of protected

Code:

    protected $table = 'items';
    protected $primaryKey = 'item_id';
    protected $allowedFields = ['field1', 'field2', 'field3'];

Then:

PHP Code:

public function get_all_items()
    {
        return $this->findAll(); 
    }

    
    public function fetch_single_item($item_id)
    {
        return $this->where('item_id', $item_id)
                    ->first(); 
    } 


Is this what you are looking for?

I enjoy web design   d-templates.com