本帖最后由 gdljw 于 2013-09-13 17:13:20 编辑
php 二级菜单
下边这段二级下拉菜单连动下拉，是读取数据库修改产品页时的代码，第一级下拉能读取一级分类数据，但第二级二拉只能再选过一次，要怎改为也可以自动获取二级分类呢？
修改产品
产品类型:

回复讨论(解决方案) - -- 表的结构 `product`-- create table `product` ( `p_id` int(15) not null auto_increment, `p_name` varchar(100) not null, `p_cccid` varchar(100) not null, `p_ccid` varchar(15) not null, `p_cid` varchar(100) not null, `p_imgurl` varchar(100) not null, `p_content` varchar(1000) not null, `p_number` varchar(15) not null, `p_sortid` varchar(15) not null, `p_scroll` varchar(15) not null default '0', `p_sortidd` varchar(15) not null, primary key (`p_id`)) engine=myisam default charset=utf8 auto_increment=31 ;-- -- 导出表中的数据 `product`-- insert into `product` values (4, '4', '22', '38', '24', 'upload/1287706504.jpg', '你死我活 ', 'pl6389999999999', '0022', '0', '22');insert into `product` values (6, '6', '19', '36', '23', 'upload/1287706041.bmp', '', 'pl3999555555', '0021', '0', '21');insert into `product` values (7, '7', '17', '35', '24', 'upload/1287706041.bmp', '', 'pl3999', '0020', '0', '20');insert into `product` values (8, '8', '', '38', '24', 'upload/20101023124900.jpg', '现在的的很好用 ', 'tcss36666', '0019', '0', '19');insert into `product` values (10, '10', '21', '38', '24', 'upload/20101023125120.jpg', '现在的的很好用 ', 'pl336699', '0018', '1', '18');insert into `product` values (11, '11', '18', '36', '23', 'upload/20101027201020.jpg', '', '23331', '0017', '1', '17');insert into `product` values (12, '11', '22', '38', '24', 'upload/20101027204003.jpg', '', '54645', '0016', '1', '16');insert into `product` values (13, 'sdfasdfds', '16', '35', '24', 'upload/20101027204346.jpg', 'sdfsd ', 'asdfasdfsd', '0015', '0', '15');insert into `product` values (14, 'sefas', '16', '35', '24', 'upload/20101027204531.jpg', 'sdafsd ', 'sdfa', '0014', '0', '14');insert into `product` values (17, 'sdfds', '22', '38', '24', 'upload/20101027210346.jpg', '', '23331', '0013', '0', '13');insert into `product` values (18, 'sdfds', '19', '36', '23', 'upload/20101027211354.gif', '', 'asdfasdfsd', '0012', '0', '12');insert into `product` values (22, 'sdafsd', '21', '38', '24', 'upload/20101027220734.png', 'sdfds ', 'sdfds', '0008', '0', '8');insert into `product` values (19, 'sdfasdfds', '16', '35', '24', 'upload/20101027213407.gif', 'dfgasd ', 'asdfasdfsd', '0011', '0', '11');insert into `product` values (20, 'sdfds', '19', '36', '23', 'upload/20101027213430.gif', 'fdgdf ', 'sdf', '0010', '0', '10');insert into `product` values (21, 'sdfasdfds', '22', '38', '24', 'upload/20101027213538.gif', '', 'dfg', '0009', '0', '9');insert into `product` values (23, 'sdfsd', '18', '36', '23', 'upload/20101027220752.png', 'sdfds ', 'sdfsd', '0007', '0', '7');insert into `product` values (24, '电刷', '23', '38', '24', 'upload/20101102132745.jpg', '', 'pl8888', '0006', '1', '6');insert into `product` values (25, 'sdfasdfds', '19', '36', '23', 'upload/20101102133302.jpg', '', 'pl8888', '0005', '1', '5');insert into `product` values (26, '12233', '23', '38', '24', 'upload/20101105132946.png', 'fadsfdsfds ', 'dsfdsdsfdsf', '0004', '0', '4');insert into `product` values (28, 'fsda', '23', '38', '24', 'upload/20101107155144.png', '', 'sdfds', '0003', '0', '3');insert into `product` values (29, 'aaaaaaa', '16', '35', '24', 'upload/20101109103038.gif', '', '888888888', '0002', '0', '2');insert into `product` values (30, 'aaaaaaa', '19', '36', '23', 'upload/20101109113914.gif', '', '888888888', '0001', '0', '1');-- ---------------------------------------------------------- -- 表的结构 `public`-- -- 表的结构 `p_ccclass`-- create table `p_ccclass` ( `ccc_id` int(15) not null auto_increment, `classname` varchar(100) not null, `sortid` varchar(100) not null, `cid_ccid_cccid` varchar(100) not null, primary key (`ccc_id`)) engine=myisam default charset=utf8 auto_increment=32 ;-- -- 导出表中的数据 `p_ccclass`-- insert into `p_ccclass` values (13, '贴片电容', '001', '34');insert into `p_ccclass` values (14, '钽电容', '003', '34');insert into `p_ccclass` values (15, '钻头', '001', '35');insert into `p_ccclass` values (16, '钻线', '003', '35');insert into `p_ccclass` values (12, '电解电容', '002', '34');insert into `p_ccclass` values (17, '钻靠', '002', '35');insert into `p_ccclass` values (18, 'soc8950', '', '36');insert into `p_ccclass` values (19, 'tp4471', '', '36');insert into `p_ccclass` values (20, 'tl317', '', '36');insert into `p_ccclass` values (21, '机芯', '003', '38');insert into `p_ccclass` values (22, '线圈', '002', '38');insert into `p_ccclass` values (23, '电刷', '001', '38');insert into `p_ccclass` values (30, '手动电p', '', '52');insert into `p_ccclass` values (31, '电动电p', '', '52');-- ---------------------------------------------------------- -- 表的结构 `p_cclass`-- create table `p_cclass` ( `cc_id` int(15) not null auto_increment, `classname` varchar(100) not null, `sortid` varchar(100) not null, `cid_ccid` varchar(100) not null, primary key (`cc_id`)) engine=myisam default charset=utf8 auto_increment=53 ;-- -- 导出表中的数据 `p_cclass`-- insert into `p_cclass` values (36, 'ic', '002', '23');insert into `p_cclass` values (38, '电动机', '002', '24');insert into `p_cclass` values (52, '电p', '', '23');insert into `p_cclass` values (35, '电钻配件', '001', '24');-- ---------------------------------------------------------- -- 表的结构 `p_class`-- create table `p_class` ( `c_id` int(15) not null auto_increment, `classname` varchar(100) not null, `sortid` varchar(15) not null, primary key (`c_id`)) engine=myisam default charset=utf8 auto_increment=26 ;-- -- 导出表中的数据 `p_class`-- insert into `p_class` values (23, '电子产品', '001');insert into `p_class` values (24, '电动工具', '002');
再修改数据的时候你要根据产品的那个分类父id读取该父id的子类
然后循环
js触发onchange事件，然后ajax查询二级分类，js插入数据
用ajax将二级分类数据取回来插入
还未解决，有代码参考一下吗
还未解决，有代码参考一下吗
参考
上边那段功能已实现了，只是需要修改产品时读取到相关的二级分类，现在修改产品是读不到相关对应的二级分类出来，
上边那段功能已实现了，只是需要修改产品时读取到相关的二级分类，现在修改产品是读不到相关对应的二级分类出来，
没看到我在2#说的话？？
在修改数据的时候你要根据产品的那个分类父id读取该父id的子类