How to create associative array with Id and Value?

Question

I have a table that contains id and weight. I want to put both in an associative array.

Right now I've managed to put only the weight in an array:

$weight= array();
$stmt = $dbc->query("SELECT * FROM tbl_weight");
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
 $weight[] = $row['weight'];
}

I want to also put the id and make it an associative array.

For example for id = 1 and weight = 50, I want to be able to do something like:

$weight = array("1"=>"50");

How can I do this?

Machavity · Accepted Answer · 2015-05-15 03:05:44Z

3

Just set your key when you append the value. As long as id is unique you shouldn't have any problems

$weight= array();
$stmt = $dbc->query("SELECT * FROM tbl_weight");
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $weight[$row['id']] = $row['weight'];
}

answered May 15, 2015 at 3:05

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

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

3 Comments

wobsoriano Over a year ago

Hello, thanks for this. I have another question if you don't mind. Supposed this is the output of the query i.imgur.com/EsSSWFv.png, how can I pair up those id's with the same value? For example in the picture 1 and 3, 2 and 4, 5 and 6? And also 7 and 9, id must not be used twice..

AbraCadaver Over a year ago

Also, just SELECT id, weight not * unless you later need the other columns.

user557846 Over a year ago

@FewFlyBy if you have a new question, please post a new question - thanks

Adam Link · Accepted Answer · 2015-05-15 03:22:57Z

1

You'll want to do

$weight[$row['id']] = $row['weight'];

edited May 15, 2015 at 3:22

answered May 15, 2015 at 3:06

Adam Link

2,7914 gold badges33 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to create associative array with Id and Value?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related