如何在不使用循环的情况下根据数组元素从数据库中获取数据 - How to fetch data from DB according to array element without using loop

How to fetch data from DB according to array element without using loop

我在一个数组中有多个id，我想打印cat_name。这是我在CI中的代码...

$business_cat   = $this->input->post('cat_id');
$business_sub_cat= $this->input->post('sub_cat_id');
$msg="<td><b>Business Catagories :</b></td><td>".implode(", ", $business_cat)."</td>
                        </tr><tr>   
                            <td><b>Business Subcatagories :</b></td><td>".implode(", ", $business_sub_cat)."</td>";

但是我想打印cat_name而不是id，但是当我使用foreach loop黑白时

它打印错误。任何人都可以帮助我。提前感谢xxx

试试这个...//标记这只是演示代码

$business_cat   = $this->input->post('cat_id');
$cat_name = array();
foreach($business_cat  as $key=>$cat_id )
{
    $cat_name[] = "demo cat name ". $key;//take name from database using $cat_id.... 
}
$cat_name_str = implode(", ", $cat_name);
$business_sub_cat = $this->input->post('sub_cat_id');
$sub_cat = array();
foreach($business_sub_cat  as $key=>$sub_cat_id )
{
    $sub_cat[] = "demo sub cat name ". $key;//take name from database using $sub_cat_id.... 
}
$sub_name_str = implode(", ", $sub_cat);
$msg = "<td><b>Business Catagories :</b></td><td>$cat_name_str</td></tr><tr><td><b>Business Subcatagories :</b></td><td>$sub_name_str</td>";