i have array given below
Array (
[0] => Array (
[user_id] => 2
)
[1] => Array (
[user_id] => 4
)
)
i need to select these user id to fetch data from database and display in html table i tried this
foreach($prevUser as $key => $value){
print_r($value);
}
and receive this not the values
Array ( [user_id] => 2 ) Array ( [user_id] => 4 )
how to get user id
You can get the user like below and fire queries using two ways first is.
foreach($prevUser as $key => $value){
$user_id = $value['user_id'];
//write your query here like "select * from user where id = $user_id";
print_r($value);
}
the second and proper way is
$userIds = [];
foreach($prevUser as $key => $value){
$userIds[] = $value['user_id'];
}
// stores all user_id on single array and then fire query like below
//write your query here like "select * from user where id IN $userIds";
I prefer to used second way instead of first way. I hope this is help full for you
You can use $user_ids = array_column($prevUser, 'user_id');
$user_ids is an array of user_id like this [2, 4], then you can traverse it with foreach like this,
foreach($user_ids as $user_id)
{
echo $user_id;
}
<?php
$array = Array(
0 => Array(
user_id => 2
),
1 => Array(
user_id => 4
)
);
foreach ($array as $key => $value) {
$user_id = $value['user_id'];
echo $user_id;
echo "<br>";
}
?>
echo echo $value['user_id'];instead ofprint_r($value);