Create associative array from another array with foreach

Question

I would like to create an associative array from another array using a foreach loop. The first array only hold a set of id to retrieve data from mysql. Then, I would like to add more elements to the array.

//Array holding all the user_id
$user_id = array("0"=> 111, "1"=>222, "2"=>333);

//The user_id is used to return the data from another table
$sql = "SELECT first_name, last_name, age 
FROM user WHERE user_id = ?";

$statement = $DB->link->prepare($sql);

$user_data = array();
foreach($user_id as $user)
{
    $statement->bind_param("s", $user);
    $statement->execute();

    if($rs = $statement->get_result())
    {
        while($row = $rs->fetch_assoc())
        {   
            //Is it possible to do something like this?
            $user_data[$user]['id'] = $user;
            $user_data[$user]['first_name'] = $row['first_name'];
            $user_data[$user]['last_name'] = $row['last_name'];
            $user_data[$user]['age'] = $row['age'];
        }
    }   
}

How can I get the array to look like this array here?

$first_array = array(
    array(
        "user_id" => 111,
        "first_name"=>"Ben",
        "last_name"=>"White",
        "age"=>"43"),
    array(
        "user_id" => 222,
        "first_name"=>"Sarah",
        "Benning"=>"37",
        "age"=>"13"
    )
);

Have you tried running this code? What was the problem with it? — Mureinik
– Mureinik, Commented Oct 15, 2014 at 9:49

Sergiu Pirlici · Accepted Answer · 2014-10-15 10:03:11Z

1

It's not a good practice to make database queries in a foreach loop.

You can use the following instead:

//Array holding all the user_id
$user_id = array("0"=> 111, "1"=>222, "2"=>333);
//The user_id is used to return the data from another table
$sql = "SELECT user_id, first_name, last_name, age 
FROM user WHERE user_id in (".implode(',', $user_id).")";

$statement = $DB->link->prepare($sql);

$statement->execute();

if($rs = $statement->get_result())
{
    while($row = $rs->fetch_assoc())
    {   
        //Is it possible to do something like this?
        $first_array[] = $row;
    }
}

If you want the field user_id to be id then you can change $sql var:

$sql = "SELECT user_id as id, first_name, last_name, age 
    FROM user WHERE user_id in (".implode(',', $user_id).")";

edited Oct 15, 2014 at 10:03

answered Oct 15, 2014 at 9:56

Sergiu Pirlici

1502 silver badges13 bronze badges

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

Comments

Davide Orazio Montersino · Accepted Answer · 2014-10-15 09:50:46Z

0

I think an array_push might do the trick:

$first_array = array();    
while($row = $rs->fetch_assoc())
    {   
        $user_data['id'] = $user;
        $user_data['first_name'] = $row['first_name'];
        $user_data['last_name'] = $row['last_name'];
        $user_data['age'] = $row['age'];
        array_push($first_array, $user_data);
    }

answered Oct 15, 2014 at 9:50

Davide Orazio Montersino

5065 silver badges19 bronze badges

Comments

S.Thiongane · Accepted Answer · 2014-10-15 10:58:22Z

0

The code in your post seems correct, but $user_data will look like this :

$user_data = array(
    "111" => array(
        "id" => 111,
        "first_name"=>"Ben",
        "last_name"=>"White",
        "age"=>"43"),
    "222" => array(
        "id" => 222,
        "first_name"=>"Sarah",
        "Benning"=>"37",
        "age"=>"13"),
    "333" => array( ... )
);

answered Oct 15, 2014 at 10:58

S.Thiongane

6,9153 gold badges39 silver badges53 bronze badges

Collectives™ on Stack Overflow

Create associative array from another array with foreach

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related