mysqli and arrays

[Manixat]

Hello freaks.

 

Im new to OOP and I'm just starting to practice using this mysqli object. What I want to do is fetch a bunch of results and store them in an array and what I've done is this

 

 

 
$result = $db->query("SELECT * FROM `stuff`");
while($row = $result->fetch_assoc()){
$stuff[] = $row;
}

 

and I can't help but wonder if there is a more efficient way of doing this, for example without looping ?

Edited March 2, 2013 by Manixat

[Barand]

mysqli_result::fetch_all

[Manixat]

I went through that and couldn't figure out how it works, but now I can't figure out how could I not figure it out the first time. Thanks!

[AyKay47]

Something important to note, only use fetch_all() in this particular case (e.g. when you only need to store the values into an array).

In most other cases, fetch_all() is a complete waste of resources.