In PHP5, how do I create an associative array from a database query?

Question

I am creating a class for an application "backbone" and I need this function to query the db, and return a multidimensional to look like this:

$myArray = ("name"=>"John", "dob"=>"January 5, 1955");

Of course the data for the array is from a database query. but, "name" and "dob" would be the database column name and "John" and "January 5, 1955" would be the value of the column

Here is my code:

public function getFrame($id) {
    $getFrameQuery = "SELECT * FROM " . DB_FRAMETABLE . "WHERE `fhid`=" . $this->quote_smart($id);
    $getFrameRecord = $db->query_first($getFrameQuery);          
}

Any help is greatly appreciated!

Josh

jasonbar · Accepted Answer · 2010-03-01 20:18:12Z

2

What database wrapper are you using? They usually provide a way to retrieve a row into an associative array.

mysql_fetch_assoc(), for example

From your comment to the other answer, the wrapper you are using provides a ->fetch_array() method that returns the data structure you are looking for.

Looks like you would need to change your code to use something like

$result = $db->query($getFrameQuery);
$data = $db->fetch_array($result);

answered Mar 1, 2010 at 20:18

jasonbar

13.5k4 gold badges41 silver badges47 bronze badges

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

3 Comments

josh brown Over a year ago

thanks. What type of array did I use as an example for future reference?

jasonbar Over a year ago

@josh brown: An associative array. php.net/manual/en/language.types.array.php

bonez Over a year ago

you used an associative or hash array, key => value A multidimensional array could have been (key => "value1", "value2")

bonez · Accepted Answer · 2010-03-01 20:16:37Z

0

This isn't a multidimensional array. Just a regular associative array.

answered Mar 1, 2010 at 20:16

bonez

6951 gold badge16 silver badges39 bronze badges

4 Comments

josh brown Over a year ago

So the DB query returns a associative array?

josh brown Over a year ago

I am using this mysql class wrapper: ricocheting.com/scripts/php_mysql_wrapper.php

voodoo555 Over a year ago

Seems as if query_first() does return an associative array, the column names as keys. $getFrameRecord['name'] would get you "John"

bonez Over a year ago

$query = "select name from whatever"; $results = mysql_query($query) or die("Query failed: ".mysql_error()); while($row = mysql_fetch_assoc($results)){ echo $row['name']; }

Collectives™ on Stack Overflow

In PHP5, how do I create an associative array from a database query?

2 Answers 2

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related