Call to a member function where() on array php

Question

        $customers = \dibi::select('*')->from('accounts')->fetchAll();
    if($username){
        $customers = $customers->where("username", $username);
    }

I have got problem with this code. Error is:

Call to a member function where() on array.

If you're trying to add the username to the query, then you have to do that before you fetchAll(). — aynber, Feb 02 '18 at 19:33
`fetchAll()` returns an array of all the results, not an object. You can't use methods of your class to filter it. — Barmar, Feb 02 '18 at 20:17

score 1 · Accepted Answer · answered Feb 06 '18 at 07:12

fetchAll return ISelection. You dont call Where on ISelection

if($username){
  $customers = \dibi::select('*')->from('accounts')->where("username", $username)->fetchAll();
}

or

$customersTable = \dibi::select('*')->from('accounts');

if($username){
  $customersTable = \dibi::select('*')->from('accounts')->where("username", $username);
}

$customers = $customersTable->fetchAll();

Call to a member function where() on array php

1 Answers1