Question

0

190

Vistas

codeigniter4 countAllResults() empty string

in version 4.0.4 of codeigniter it does not give me an error but in version 4.1.3 it gives me an error

public function verificar($email, $cedula)
{
    $query = $this->db->table('veterinario AS v');
    $query->select('v.*');
    $query->where('v.email', $email);
    $query->where('v.cedula', $cedula);
    $querys = $query->get()->getResult();

    var_dump($querys);

    if (!empty($querys)) {
        if ($query->countAllResults() == 1) {
            echo 'encontrado';
        } else {
            echo 'noencontrado';
        }
    } else {
        echo 'noencontrado';
    }
}

example

until the var_dump I check and if it brings me the data from the database but when entering the if it tells me that empty string or it goes straight to the not found

8 months ago · Santiago Trujillo

1 Respuestas

Responde la pregunta

0

Responde la pregunta

Encuentra empleos remotos

Accepted Answer · 2022-06-01T14:36:24.826Z

You could use the helper function count.

Replace the countAllResults with the count function like $query->countAllResults() == 1 into count($querys) == 1.

It returns the number of rows returned by the query. You can use it like this:

public function verificar($email, $cedula)
{
    $query = $this->db->table('veterinario AS v');
    $query->select('v.*');
    $query->where('v.email', $email);
    $query->where('v.cedula', $cedula);
    $querys = $query->get()->getResult();

    var_dump($querys);

    if (!empty($querys)) {
        if (count($querys) == 1) {
            echo 'encontrado';
        } else {
            echo 'noencontrado';
        }
    } else {
        echo 'noencontrado';
    }
}