我将使用一个mysql查询来创建一个多维数组,以便嵌套结果(类别和子类别)。
查询
SELECT `categories`.`cat_title`, `subcategories`.`sub_cat_id`, `subcategories`.`sub_cat_title`
FROM (`categories`)
LEFT JOIN `subcategories`
ON `subcategories`.`cat_id` = `categories`.`cat_id`
ORDER BY `categories`.`cat_title
创建多维数组
$array = array();
foreach ($query->result_array() as $row): //query result as a pure array
$array[$row['cat_title']][] = $row['sub_cat_title'];
endforeach;
return $array;
以上返回类别及其相应的子类别。
Array (
[Art] => Array ( [0] => Graphic Design [1] => Painting )
[Literature] => Array ( [0] => Science Fiction [1] => Poetry [2] => Fiction )
[Science] => Array ( [0] => Environmental )
)
是否可以用查询数据,如子类别ID sub_cat_id
, 替换数组键?例如:
[Literature] => Array ( [8] => Science Fiction [94] => Poetry [5] => Fiction )
cat_title
将始终被设置,而我正在检查类别是否存在子类别,如果存在则显示它们。 - CyberJunkie