mysql导入组织树脚本_使用函数递归实现基于PHP和MySQL的动态树型菜单

INSERT INTO menu VALUES ( '1', '0', '人事管理', '');

INSERT INTO menu VALUES ( '2', '0', '通讯交流', '');

INSERT INTO menu VALUES ( '3', '1', '档案管理', '');

INSERT INTO menu VALUES ( '4', '1', '考勤管理', 'http://localhost/personal/attendance.php' );

INSERT INTO menu VALUES ( '5', '2', '通讯录', '');

INSERT INTO menu VALUES ( '6', '2', '网络会议', '');

INSERT INTO menu VALUES ( '7', '3', '新增档案', 'http://localhost/personal/add_achive.php' );

INSERT INTO menu VALUES ( '8', '3', '查询档案', 'http://localhost/personal/search_archive.php' );

INSERT INTO menu VALUES ( '9', '3', '删除档案', 'http://localhost/personal/delete_archive.php' );

INSERT INTO menu VALUES ( '10', '5', '新增通讯记录','http://localhost/communication/add_address.php' );

INSERT INTO menu VALUES ( '11', '5', '查询通讯记录', http://localhost/communication/search_address.php' );

INSERT INTO menu VALUES ( '12', '5', '删除通讯记录', http://localhost/communication/delete_address.php' );

INSERT INTO menu VALUES ( '13', '6', '召开会议', 'http://localhost/communication/convence_meeting.php' );

INSERT INTO menu VALUES ( '14', '6', '会议查询', 'http://localhost/communication/search_meeting.php' );