fetch_array acts as fetch_first

[Former user]

When called fetch_array it will only fetch first row because after that it sets _executed to false

the deal is to do

$db->query($sql)->execute(); while( $row = $db->query($sql)->fetch_array() ) {

}

[Vivek N]

If you check the line 492 you can see that fetch_array is an alias to fetch_first https://bitbucket.org/getvivekv/php-mysqli-class/src/33f9f77845f30ac93a242380ea756bb2a6c056cf/class.database.php?at=master#cl-492