售后app 库存分类（foreach循环遇到的问题 ）（group by）

、

如图，数据库中如果按照category来分类只有几种类型，如何实现左一效果呢

思路：先输出分类category 再查找包含category的数据循环出来作为它的数组

  $material_mdl = app::get('wsapi')->model('sap_material');
        $sql = 'SELECT *  FROM tfsh_wsapi_sap_material group by category';
        $materials = $material_mdl->db->select($sql);
        foreach ($materials as &$val) {
            $val['items'] = $material_mdl->getList("*",array('category' => $val['category']));
        }
        if ($materials) {
            $this->success($materials, '成功');
        } else {
            $this->error(array(), '失败');
        }

$sql = 'SELECT * FROM tfsh_wsapi_sap_material group by category';

 

总结：努力学习，多练习

$arr=array(
["a1","A1"],
["a2","A2"],
["a3","A3"],
);

然后用foreach循环：

 

$tem=array();
foreach($arr as $v){
 $tem[$v[0]]=$v[1];
}