PHP / MySQL two rows in one array

Question

Hy I have some problems with php and mysql -> I can't find a good solution for it.

This is my DB:

user_id | meta_key | meta_value
1       | name     | Freddy
1       | phone    | 123
1       | adress   | Elm Street 1428
1       | city     | Springwood

I'm getting datas this way:

$userdata = array (userdata);
$get_user_data = mysql_query("SELECT `meta_value` FROM `table` WHERE `user_id` = $user_id", $link);

while($row=mysql_fetch_array($get_user_data)){
array_push($userdata, $row["meta_value"]);}

What i don't like is: I can only get data this way -> $userdata[1];

How can i get my data that there is a connection between the two rows?

$userdata['name']; (Freddy)

Note: The mysql_* functions are deprecated, they will be removed from PHP in future versions and your code will stop working then. You should not write new code using them, use mysqli_* or PDO instead. — Gerald Schneider
– Gerald Schneider, Commented Jan 9, 2015 at 8:30
how would this code look like if i use mysqli? Can i just use mysqli_query and mysqli_fetch_array insted of? — user3563887
– user3563887, Commented Jan 9, 2015 at 11:54

Gerald Schneider · Accepted Answer · 2015-01-09 08:36:05Z

1

If you want the meta_key as index in your array, just add the data like this:

// add meta_key to the query
$get_user_data = mysql_query("SELECT `meta_value`,`meta_key` FROM `table` WHERE `user_id` = $user_id", $link);

// use _assoc instead of _array, we don't need the numerical indexes.
while($row=mysql_fetch_assoc($get_user_data)){
  $userdata[$row['meta_key']] = $row['meta_value'];
}

This will result in:

Array(
  'name' => 'Freddy',
  // ...
)

edited Jan 9, 2015 at 8:36

answered Jan 9, 2015 at 8:28

Gerald Schneider

17.8k10 gold badges64 silver badges79 bronze badges

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

Comments

Peter · Accepted Answer · 2015-01-09 08:28:38Z

0

Use:

while ($row=mysql_fetch_array($get_user_data, MYSQL_ASSOC)) {
    ....
}

or:

while ($row=mysql_fetch_assoc($get_user_data)) {
    ...
}

answered Jan 9, 2015 at 8:28

Peter

9,1868 gold badges69 silver badges100 bronze badges

2 Comments

Gerald Schneider Over a year ago

this is unnessecary, mysql_fetch_array() returns by default an array with numerical and associative indexes.

Peter Over a year ago

@GeraldSchneider Indeed, but by using an associative array the numeric values are left out.

Kiren S · Accepted Answer · 2015-01-09 08:29:31Z

0

mysql_fetch_array($get_user_data, MYSQL_ASSOC)

answered Jan 9, 2015 at 8:29

Kiren S

3,1178 gold badges43 silver badges73 bronze badges

1 Comment

Gerald Schneider Over a year ago

this is unnessecary, mysql_fetch_array() returns by default an array with numerical and associative indexes.

Collectives™ on Stack Overflow

PHP / MySQL two rows in one array

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related