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.

Answer 1

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();