How to store entire mysql_fetch_array results into an array? PHP

Question

I have one SQL query and the results are retrieved using;

$result = mysql_query($query);

And the results are printed using;

while($row = mysql_fetch_array($result)){
    echo $row['column']."<br>";
}

I want to store entire $row['column'] into an array. For that, the above code can be replaced by;

$my_array[] = "";
while($row = mysql_fetch_array($result)){
    echo $row['column']."<br>";
    $my_array[] = $row['column'];
}

But here, the while loop is executed. Is there any other efficient / better method, avoiding loops?

Why don't you just read the desired column only and you have it in the array? All you need to do is select your desired column in the query. — itsols
– itsols, Commented Dec 10, 2015 at 4:52
@itsols is this problem related to a select query? well, I dont think so — Alfred
– Alfred, Commented Dec 10, 2015 at 4:54
Of course your question is clear. Why -1, even I don't know. I think there are a few people who can't negotiate between their thoughts and the mouse they use. I wish there is a system to reveal who does these down-votes. It wasn't me. — itsols
– itsols, Commented Dec 10, 2015 at 4:55
My question to you is why not just do a query like select column from table? This way, you already have it in an array. Of course it's going to be an associate array. — itsols
– itsols, Commented Dec 10, 2015 at 4:56

Hanky Panky · Accepted Answer · 2015-12-10 05:09:51Z

4

Store your desired value in your array right there in the first loop.

while($row = mysql_fetch_array($result)){
    echo $row['column']."<br>";
    $my_array[] = $row['column'];
}

Now you don't need 2 loops. $my_array is available to you to use anywhere you like

But here, the while loop is executed again

No, absolutely incorrect. This can be done in just 1 loop call and loop is not executed again.

But here, the while loop is executed. Is there any other efficient / better method, avoiding loops?

Nope there is none using mysql_* but yes using mysqli or pdo you can fetch all rows in an array using just one call without any loops.

How can I do that using mysqli_* can u include that in your answer

$link = mysqli_connect("localhost", "user", "password", "database");
$query = "SELECT column FROM yourTable";
$result = mysqli_query($link,$query);
$my_array = mysqli_fetch_all($result,MYSQLI_ASSOC);

edited Dec 10, 2015 at 5:09

answered Dec 10, 2015 at 4:46

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

5 Comments

itsols Over a year ago

Shouldn't you include the element number to hold the value in $my_array?

Alfred Over a year ago

No, I have only one loop, i just avoided the echo part.

Alfred Over a year ago

@Hanky웃Panky Can I avoid that loop? Thats what i am asking

Hanky Panky Over a year ago

Nope you can't with mysql_*. See my last line of the edited answer

Alfred Over a year ago

How can I do that using mysqli_* can u include that in your answer? I mean, the code

Collectives™ on Stack Overflow

How to store entire mysql_fetch_array results into an array? PHP

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related