在foreach PHP PDO内循环选择查询 - Loop select query inside foreach PHP PDO

Loop select query inside foreach PHP PDO

本文关键字：循环选择查询 PDO foreach PHP | 更新日期: 2023-09-27

我有数组输出，我想使用输出从数据库中获得另一个输出，这是我的查询:

$access_array = array(2,3,4);
foreach($access_array as $val){
        $index_erp = "id,name,alias,images";    
        $where_erp = "WHERE glb_pmstr_app_id = '2' and id = '".$val."'";
        $RES_SQL = $this->SQL_Query->__Select($index_erp,$tbl_app_feature,null,$where_erp,null,null,SQL_FETCHALL); 
}

和我应该从$RES_SQL的结果得到3行，但我只是从数据库得到1行。

如何解决这个问题?

$access_array = array(2,3,4);
$output = array();
foreach($access_array as $val){
    $index_erp = "id,name,alias,images";    
    $where_erp = "WHERE glb_pmstr_app_id = '2' and id = '".$val."'";
    $RES_SQL = $this->SQL_Query->__Select($index_erp,$tbl_app_feature,null,$where_erp,null,null,SQL_FETCHALL);
    $ouput[] =  $RES_SQL;
}

这就是你想做的吗?