Get data from sql in one array

Question

I am trying to get the data from database in one single array but I was unsuccessful doing that. What I have tried is -

$q = mysql_query("SELECT*FROM meaning ORDER BY RAND() LIMIT 7");
$gt = mysql_fetch_array($q);
var_dump($gt);

This query fetches only one row. What I want is that this query should fetch random 7 rows and come back in one array as data like -

array(4) { [0]=> row_0
           [1]=> row_1
           [2]=> row_2
           [3]=> row_3
           [4]=> row_4
           [5]=> row_5
           [6]=> row_6
         }

First, mysql_ is deprecated, please switch to mysqli_ or PDO. ^^ Secondly, you can, but you have to create a loop. From the function mysql_fetch_array. So do a while or for loop while using it to get all the rows. — Jon
– Jon, Commented Dec 29, 2013 at 7:43
@AwladLiton That won't help, instead of returning a numerically indexed array for each row, it will return an associative one. — Jon
– Jon, Commented Dec 29, 2013 at 7:45
Actually, if you use mysqli_fetch_array the returned array has characteristics numeric and associative arrays. Not certain if mysql_fetch_array does, though — David Wilkins
– David Wilkins, Commented Dec 29, 2013 at 7:48

Barmar · Accepted Answer · 2013-12-29 07:47:05Z

8

There is no function in the mysql extension that does what you want. All the mysql_fetch_XXX functions read just one row at a time. To get everything, you have to use a loop:

$gt = array();
while ($row = mysql_fetch_assoc($q)) {
    $gt[] = $row;
}
var_dump($gt);

If you convert to the PDO extension, it has the method PDO::fetchAll that does what you want.

answered Dec 29, 2013 at 7:47

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Comment

BlitZ Over a year ago

Yeah, exactly my thoughts. ++

Krish R · Accepted Answer · 2013-12-29 07:55:58Z

0

Hope this may helps you,

 $q = mysql_query("SELECT * FROM meaning ORDER BY RAND() LIMIT 7");
 while($gt = mysql_fetch_assoc($q)){
   $myarray[] =  $gt;
 }   
 var_dump($myarray);

edited Dec 29, 2013 at 7:55

answered Dec 29, 2013 at 7:42

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

1 Comment

Jon Over a year ago

How do you figure this helps? You are just assigning a row to a defined index in an array.

AyB · Accepted Answer · 2013-12-29 07:57:11Z

0

Try this:

$q = mysql_query("SELECT * FROM meaning ORDER BY RAND() LIMIT 7");
$i = 0;
$myarray[]='';

while($gt = mysql_fetch_assoc($q))
{
  $myarray[$i] = $gt;
  $i++;
}

var_dump($myarray);

answered Dec 29, 2013 at 7:57

AyB

11.6k4 gold badges34 silver badges49 bronze badges

Comments

RaviRokkam · Accepted Answer · 2013-12-29 08:00:18Z

0

mysql_fetch_array returns the first row in a MySQL Resource in the form of an associative array. Fetches a result row as an associative array, a numeric array, or both.
You need to use loop to get all the records.

$q = mysql_query("SELECT * FROM meaning ORDER BY RAND() LIMIT 7");

while ($row = mysql_fetch_array($q)) {
    echo $row["title"]."<br />";
}

answered Dec 29, 2013 at 8:00

RaviRokkam

7899 silver badges16 bronze badges

Collectives™ on Stack Overflow

Get data from sql in one array

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related