Turn MySQL results into an array, the proper way!


/ Published in: PHP
Save to your folder(s)

Here is the correct way to turn your mysql results into an array. Forget the other nonsense of useless code. Why type out this long code: "for($i = 0; $array[$i] = mysqli_fetch_assoc($result); $i++) ;" when you can accomplish the same thing with much less code.


Copy this code and paste it in your HTML
  1. while($rows[] = mysqli_fetch_assoc($result));
  2. array_pop($rows); // pop the last row off, which is an empty row

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.