PHP Populating an Array from a MySql Query

Question

I am looking to create an array of data to be pass to another function that is populated from a database query and am not sure how to do this.

$dataArray[0][1];

$qry = mysql_query("SELECT Id, name FROM users");

while($res = mysql_fetch_array($qry)) {
    $dataArray[$res['Id']][$res['name']]
}

Thanks in advance.

I spent about thirty seconds trying to understand how this code shows PHP polluting an array. — Richard Simões
– Richard Simões, Commented Nov 20, 2009 at 8:09

RageZ · Accepted Answer · 2009-11-20 08:08:08Z

6

This would look better

$dataArray = array();

$qry = mysql_query("SELECT Id, name FROM users");

while($res = mysql_fetch_array($qry)) {
    $dataArray[$res['Id']] = $res['name'];
}

you can take a look at the PHP manual how to declare and manipulate arrays.

answered Nov 20, 2009 at 8:08

RageZ

27.3k12 gold badges72 silver badges76 bronze badges

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

Comments

Surendra Narayan Roy · Accepted Answer · 2015-09-18 06:58:11Z

3

The below code sniper is very handy...

$select=" WRITE YOUR SELECT QUERY "; $queryResult= mysql_query($select);

//DECLARE YOUR ARRAY WHERE YOU WILL KEEP YOUR RECORD SETS
$data_array=array();

//STORE ALL THE RECORD SETS IN THAT ARRAY 
while ($row = mysql_fetch_array($queryResult, MYSQL_ASSOC)) 
{
    array_push($data_array,$row);
}


mysql_free_result($queryResult);


//TEST TO SEE THE RESULT OF THE ARRAY 
echo '<pre>';
print_r($data_array);
echo '</pre>';

Thanks

answered Sep 18, 2015 at 6:58

Surendra Narayan Roy

493 bronze badges

1 Comment

Wachaga Mwaura Over a year ago

This is excellent. The minimalist and most efficient answer in my honest opinion.

Collectives™ on Stack Overflow

PHP Populating an Array from a MySql Query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related