我為 collection-category 創(chuàng)建了一個 API。但是我在將數(shù)組轉(zhuǎn)換為數(shù)組時遇到了問題。我已經(jīng)嘗試取消設(shè)置舊數(shù)組并附加到新數(shù)組中，但我沒有得到正確的數(shù)組。我的收藏表是這樣的，CREATE TABLE `crm_collection` ( `collection_id` int(11) NOT NULL AUTO_INCREMENT, `heading` varchar(255) DEFAULT NULL, `collection_image` varchar(255) DEFAULT NULL, `status` enum('Active','In-active') DEFAULT NULL, `group_id` int(11) DEFAULT NULL, PRIMARY KEY (`collection_id`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1; insert into `crm_collection`(`collection_id`,`heading`,`collection_image`,`status`,`group_id`) values (33,'test3','30d79a495652f762bbe365df59dbef3b.jpeg','Active',1),(34,'test4','7cc28028d0684d9bb58e285434002758.jpeg','In-active',3);我的收藏類別表如下所示，CREATE TABLE `crm_category_collection` ( `category_collection_id` int(11) NOT NULL AUTO_INCREMENT, `text` varchar(255) DEFAULT NULL, `category_image` varchar(255) DEFAULT NULL, `status` enum('Active','In-active') DEFAULT NULL, `collection_id` int(11) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, PRIMARY KEY (`category_collection_id`)) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;這是我的 API 代碼。$table_collection = "crm_collection"; $table_collection_id = 'tl.collection_id'; $default_sort_column_collection = 'tl.collection_id'; $default_sort_order_collection = 'desc'; $condition_collection = "1=1"; $main_table_collection = array("$table_collection tl", array("tl.collection_id", "tl.heading", "tl.collection_image", "tl.group_id")); $join_tables_collection = array( array("left", "tbl_menu tm", "tm.id = tl.group_id", array("tm.menu_name as group_name","tm.id as group_id")), array("left", "crm_category_collection cc", "cc.collection_id = tl.collection_id", array("cc.text","cc.category_image","cc.category_id")), );
1 回答
慕桂英546537
TA貢獻(xiàn)1848條經(jīng)驗(yàn) 獲得超10個贊
這里的代碼描述了邏輯應(yīng)該如何在您的結(jié)果集上運(yùn)行以獲得所需的格式，其中一些虛擬數(shù)組數(shù)據(jù)與您的查詢結(jié)果匹配。
$test = array( array( "collection_id" => 33, 'heading' => 'test3', 'category_id' => 3, 'text' => 'dfsfdsfd1' ),
array( "collection_id" => 33, 'heading' => 'test3', 'category_id' => 4, 'text' => 'dfsfdsfd2' ),
array( "collection_id" => 34, 'heading' => 'test4', 'category_id' => 5, 'text' => 'dfsfdsfd3' ),
array( "collection_id" => 34, 'heading' => 'test4', 'category_id' => 6, 'text' => 'dfsfdsfd4' )
);
$res= array();
foreach ($test as $key => $value) {
if( !isset($res[$value['collection_id']]) ){
$res[$value['collection_id']] = array();
$res[$value['collection_id']]['collection_id'] = $value['collection_id'];
$res[$value['collection_id']]['heading'] = $value['heading'];
}
$colarr = isset($res[$value['collection_id']]['category']) && is_array($res[$value['collection_id']]['category']) ? $res[$value['collection_id']]['category'] : array();
$colarr[] = array( 'category_id' => $value['category_id'], 'text' => $value['text'] );
$res[$value['collection_id']]['category'] = $colarr;
}
$output = array();
$output['collection-category'] = array_values($res);
echo json_encode($output);
你可以在你的代碼中試試這個。
- 1 回答
- 0 關(guān)注
- 133 瀏覽
添加回答
舉報
0/150
提交
取消