遍历数组,利用数组内的值查询数据库数据,将数据库查询出来的值重新组成一个数组

it2023-04-08  70

遍历数组,利用数组内的值查询数据库数据,将数据库查询出来的值重新组成一个数组。

foreach循环拿出来想要的单个值,在循环里面查询数据,

需要遍历的数组:

array(7) { [0]=> array(1) { [“user_id”]=> string(1) “9” } [1]=> array(1) { [“user_id”]=> string(2) “10” } [2]=> array(1) { [“user_id”]=> string(2) “11” } [3]=> array(1) { [“user_id”]=> string(2) “28” } [4]=> array(1) { [“user_id”]=> string(2) “42” } [5]=> array(1) { [“user_id”]=> string(2) “45” } [6]=> array(1) { [“user_id”]=> string(2) “55” } } 利用‘9’,10,查询数据库

查询语句:

string(130) "SELECT user_id, user_name, last_time FROM `newoa`.`xdd_users` WHERE shop_status = 5 AND last_time < 1600557299 AND operater_id = 9"

数据:

array(7) { [0]=> array(3) { ["user_id"]=> string(1) "1" ["user_name"]=> string(6) "响丁当" ["last_time"]=> string(10) "1574708053" } [1]=> array(3) { ["user_id"]=> string(3) "311" ["user_name"]=> string(10) "shiauthing" ["last_time"]=> string(10) "1582067358" } [2]=> array(3) { ["user_id"]=> string(3) "332" ["user_name"]=> string(4) "孙健" ["last_time"]=> string(10) "1562003534" } [3]=> array(3) { ["user_id"]=> string(3) "414" ["user_name"]=> string(6) "周莎莎" ["last_time"]=> string(10) "1596303254" } [4]=> array(3) { ["user_id"]=> string(3) "643" ["user_name"]=> string(6) "投资部" ["last_time"]=> string(1) "0" } [5]=> array(3) { ["user_id"]=> string(3) "695" ["user_name"]=> string(4) "范磊" ["last_time"]=> string(1) "0" } [6]=> array(3) { ["user_id"]=> string(3) "712" ["user_name"]=> string(6) "田正芳" ["last_time"]=> string(1) "0" } } $sql_peo = "SELECT role_id FROM " .$ecs->table('admin_user')."WHERE user_id =".$_SESSION['admin_id']; $sql_peo_value = $db->getAll($sql_peo); $sql_peo_0 = "SELECT user_id FROM " .$ecs->table('admin_user')."WHERE role_id =".$sql_peo_value[0]["role_id"]; //二维数组 $sql_peo_0_value = $db->getAll($sql_peo_0); $a = array(); foreach ($sql_peo_0_value AS $key => $value) { //利用$value,在数据库中查询出来数据,$sql是拼接的sql查询语句 $sql = "SELECT user_id, user_name, last_time FROM ".$ecs->table('users')." WHERE shop_status = 5 AND last_time < ".(gmtime()-2592000)." AND operater_id = ". $sql_peo_0_value[$key]['user_id']; //开始去mysql拿数据 $comentlist = $db->getAll($sql); //echo $comentlist; //var_dump($comentlist);exit(); $a = $a + $comentlist; } $comentlist = $a; //var_dump($comentlist);exit();

解决办法:

先把二维数组转成一维数组,然后 select from where id in 那个数组

最新回复(0)