PHP - More efficient way to store SQL result in array?

Question

Currently, I have coded this (in PHP).

<? $array = array("0");

$q1 =mysql_query("SELECT id FROM `stuff` ORDER BY `id` ASC");

while($q=mysql_fetch_object($q1)){
$array[] = $q->id;
} ?>

It doesn't take that long to load, but I was wondering, if there was a more efficient way than this? If there is, please share. It just doesn't feel efficient if there are 1000 rows.

If there isn't, please say so.

Note: the mysql extension is deprecated as of PHP 5.5. Use PDO or mysqli. PDO for example is offers an API to directly bind a result to an object (or change it according to the result of the query) — Rangad
– Rangad, Commented Jul 6, 2014 at 15:31
Question solved. I'll take your advice Rangad. But, if I do, then I will have to convert thousands of lines of code sigh, but I guess it will be for the long term benefit. — user2467929
– user2467929, Commented Jul 6, 2014 at 15:59

andrew · Accepted Answer · 2014-07-06 15:44:26Z

1

you can use mysqli_fetch_all rather than looping through each row:

$q1 ="SELECT id FROM `stuff` ORDER BY `id` ASC";
$result=mysqli_query($con,$q1);
$array=mysqli_fetch_all($result,MYSQLI_ASSOC);

answered Jul 6, 2014 at 15:44

andrew

9,6039 gold badges36 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

faintsignal Over a year ago

But this will return a two-dimensional array, each element an array with key 'id', while the OP is looking for a straightforward array of the values.

Collectives™ on Stack Overflow

PHP - More efficient way to store SQL result in array?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related