codeigniter4 countAllResults() empty string

Question

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

try this $query->countAllResults() to this $querys ->countAllResults() — Abdulla Nilam
– Abdulla Nilam, Commented Aug 23, 2021 at 4:49

Krina Mangukiya · Accepted Answer · 2021-08-24 11:54:47Z

1

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';
    }
}

edited Aug 24, 2021 at 11:54

answered Aug 24, 2021 at 10:40

Krina Mangukiya

4263 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

codeigniter4 countAllResults() empty string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related