IF condition codeigniter - Check whether data exists in the database(model)

Question

I have the following method to obtain data in codeigniter.

// Obter Fase
public function obter_fase($id)
{
    $this->db->from($this->tbl_empresa_fase);
    $this->db->select("tbl_empresa_fase.*, IF(tbl_empresa_fase.crud = 'C', 'R', 'C') as crud", FALSE);
    if (is_array($id))
    {
        $this->db->where_in('campanha_id',$id);
    }
    else
    {
        $this->db->where('campanha_id',$id);
    }
    $this->db->order_by('campanha_id');
    $query = $this->db->get();
    $item = $query->result_array();
    return $item;
}

It works, but if the ID being searched does not exist in the database, an error is returned and with the above method, this is expected.

For this reason, I want to know if there is possibility to create a condition that checks if the ID sought exists in the database.

If yes, returns the result_array, if not, returns return [].

Answer 1

You can simply check the variable $item before returning the function value

//retornando com um if
if ($item) {
     return $item;
} else {
     return [];
}

//retornando com um ternário
return empty($item) ? [] : $item;

From what I saw in the error message select is empty inside the IN(), then this same check can be performed before the query

// Obter Fase
public function obter_fase($id)
{
    if(empty($id) && is_numeric($id)) return []; // aqui verifica se o id passado é um número e se há valor
    $this->db->from($this->tbl_empresa_fase);
    $this->db->select("tbl_empresa_fase.*, IF(tbl_empresa_fase.crud = 'C', 'R', 'C') as crud", FALSE);
    if (is_array($id)) {
        $this->db->where_in('campanha_id',$id);
    } else {
        $this->db->where('campanha_id',$id);
    }
    $this->db->order_by('campanha_id');
    $query = $this->db->get();
    $item = $query->result_array();
    return empty($item) ? [] : $item;
}