Sqlbuilder + Codeigniter v.4.1.1

Question

I have a model called Usuariomodel that only works the find and findAll option, but in my test step a Where so the method does not connect at the base: below follows the function call and the result:

Model:

class UsuarioModel extends Model
{
    protected $table = 'usuarios';
    protected $primaryKey = 'id';
    protected $allowedFields = ['nome', 'login', 'senha', 'tipoUsuario'];
    
    protected $returnType     = 'array';
    protected $useSoftDeletes = true;
    
    protected $useTimestamps = true;
    protected $createdField  = 'created_at';
    protected $updatedField  = 'updated_at';
    protected $deletedField  = 'deleted_at';
    
        
    public function get($id = null)
    {
        if($id <> null)
        {
            return $this->find($id);                    
        }           
        $exibe = $this->find();
        var_dump($exibe);
        exit();     
        
    }   
    
    public function pesquisar($busca = null)
    {
        
        $exibe = $this->where('id', 1);         
        var_dump($exibe);
        exit();
    }       
}

Controller:

class Usuario extends Controller
{

    public function __construct()
    {
        $this->model = new UsuarioModel();
    }   
    
    public function index()
    {   
        $busca = $this->request->getVar('busca');       
        if(!empty($busca))
        {           
            $this->data =   [
                'table' => $this->model->pesquisar($busca)
            ];
        }
        else
        {
            $this->data = [
                'table' => $this->model->get()
            ];
        }

        
        echo view('template/header');
        echo view('usuario/index', $this->data);
        echo view('template/footer');
    }
}

Answer 1

You don’t have to do what you want to do in the model can directly use the methods that the model has that is much more logical and easier for maintenance, although it lacked to call the method at the end of the builder within your custom method, example:

//dentro do método
public function pesquisar($id)
{
    return $this->where('id', $id)->first();
}
$blog = new Blog();
$result = $blog->pesquisar(1);

or

//fora do método
public function pesquisar($id)
{
    return $this->where('id', $id);
}
$blog = new Blog();
$result = $blog->pesquisar(1)->first();

the same thing is done like this:

$blog = new Blog();
$result = $blog->where('id', 2)->first();

if the search is done directly on your primary key, then:

$blog = new Blog();
$result = $blog->find(2);