jQuery+PHP+MySQL简单无限级联实现-白红宇

jQuery+PHP+MySQL简单无限级联实现

阅读量：6874 次

发布时间：2019-06-26

本文共 4479 字，大约阅读时间需要 14 分钟。

本文简单实现jQuery无限级联效果。

主要包含3个文件：index.html（主页），wuxianjilian.php（数据处理），wuxianjilian.sql（MySQL数据文件）

1. index.html

1  2  3     无限级联 4     
      5     
      6      7  8  9 
     
10 42 43 
     44 45 
     
46 47 59 60 61

2. wuxianjilian.php

1 
     '.$row['text'].'';20     }21 22     if(!empty($html)) $html = '';23     24     //输出下拉菜单25     echo json_encode($html);26 //End_php

3. wuxianjilian.sql

1 wuxianjilian.sql 2 /* 3 Navicat MySQL Data Transfer 4  5 Source Server         : localhost 6 Source Server Version : 50516 7 Source Host           : localhost:3306 8 Source Database       : test 9 10 Target Server Type    : MYSQL11 Target Server Version : 5051612 File Encoding         : 6500113 14 Date: 2012-10-24 20:59:0915 */16 17 SET FOREIGN_KEY_CHECKS=0;18 -- ----------------------------19 -- Table structure for `wuxianjilian`20 -- ----------------------------21 DROP TABLE IF EXISTS `wuxianjilian`;22 CREATE TABLE `wuxianjilian` (23   `id` int(11) NOT NULL AUTO_INCREMENT,24   `pid` int(11) DEFAULT NULL,25   `text` varchar(32) DEFAULT NULL,26   PRIMARY KEY (`id`)27 ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;28 29 -- ----------------------------30 -- Records of wuxianjilian31 -- ----------------------------32 INSERT INTO `wuxianjilian` VALUES ('1', '0', 'A0');33 INSERT INTO `wuxianjilian` VALUES ('2', '0', 'B0');34 INSERT INTO `wuxianjilian` VALUES ('3', '1', 'C1');35 INSERT INTO `wuxianjilian` VALUES ('4', '1', 'D1');36 INSERT INTO `wuxianjilian` VALUES ('5', '1', 'E1');37 INSERT INTO `wuxianjilian` VALUES ('6', '2', 'F2');38 INSERT INTO `wuxianjilian` VALUES ('7', '2', 'G2');39 INSERT INTO `wuxianjilian` VALUES ('8', '3', 'H3');40 INSERT INTO `wuxianjilian` VALUES ('9', '3', 'I3');41 INSERT INTO `wuxianjilian` VALUES ('10', '3', 'J3');42 INSERT INTO `wuxianjilian` VALUES ('11', '3', 'K3');43 INSERT INTO `wuxianjilian` VALUES ('12', '4', 'L4');44 INSERT INTO `wuxianjilian` VALUES ('13', '4', 'M4');45 INSERT INTO `wuxianjilian` VALUES ('14', '8', 'N8');46 INSERT INTO `wuxianjilian` VALUES ('15', '9', 'N9');47 INSERT INTO `wuxianjilian` VALUES ('16', '14', 'O14');48 INSERT INTO `wuxianjilian` VALUES ('17', '14', 'P14');49 INSERT INTO `wuxianjilian` VALUES ('18', '14', 'Q14');50 INSERT INTO `wuxianjilian` VALUES ('19', '17', 'R17');51 INSERT INTO `wuxianjilian` VALUES ('20', '17', 'S18');52 INSERT INTO `wuxianjilian` VALUES ('21', '20', 'T20');

1 /* 2 Navicat MySQL Data Transfer 3  4 Source Server         : localhost 5 Source Server Version : 50516 6 Source Host           : localhost:3306 7 Source Database       : test 8  9 Target Server Type    : MYSQL10 Target Server Version : 5051611 File Encoding         : 6500112 13 Date: 2012-10-24 20:59:0914 */15 16 SET FOREIGN_KEY_CHECKS=0;17 -- ----------------------------18 -- Table structure for `wuxianjilian`19 -- ----------------------------20 DROP TABLE IF EXISTS `wuxianjilian`;21 CREATE TABLE `wuxianjilian` (22   `id` int(11) NOT NULL AUTO_INCREMENT,23   `pid` int(11) DEFAULT NULL,24   `text` varchar(32) DEFAULT NULL,25   PRIMARY KEY (`id`)26 ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;27 28 -- ----------------------------29 -- Records of wuxianjilian30 -- ----------------------------31 INSERT INTO `wuxianjilian` VALUES ('1', '0', 'A0');32 INSERT INTO `wuxianjilian` VALUES ('2', '0', 'B0');33 INSERT INTO `wuxianjilian` VALUES ('3', '1', 'C1');34 INSERT INTO `wuxianjilian` VALUES ('4', '1', 'D1');35 INSERT INTO `wuxianjilian` VALUES ('5', '1', 'E1');36 INSERT INTO `wuxianjilian` VALUES ('6', '2', 'F2');37 INSERT INTO `wuxianjilian` VALUES ('7', '2', 'G2');38 INSERT INTO `wuxianjilian` VALUES ('8', '3', 'H3');39 INSERT INTO `wuxianjilian` VALUES ('9', '3', 'I3');40 INSERT INTO `wuxianjilian` VALUES ('10', '3', 'J3');41 INSERT INTO `wuxianjilian` VALUES ('11', '3', 'K3');42 INSERT INTO `wuxianjilian` VALUES ('12', '4', 'L4');43 INSERT INTO `wuxianjilian` VALUES ('13', '4', 'M4');44 INSERT INTO `wuxianjilian` VALUES ('14', '8', 'N8');45 INSERT INTO `wuxianjilian` VALUES ('15', '9', 'N9');46 INSERT INTO `wuxianjilian` VALUES ('16', '14', 'O14');47 INSERT INTO `wuxianjilian` VALUES ('17', '14', 'P14');48 INSERT INTO `wuxianjilian` VALUES ('18', '14', 'Q14');49 INSERT INTO `wuxianjilian` VALUES ('19', '17', 'R17');50 INSERT INTO `wuxianjilian` VALUES ('20', '17', 'S18');51 INSERT INTO `wuxianjilian` VALUES ('21', '20', 'T20');

效果图：

　　　　　图（1）仅下拉框

　　　　　　图（2）层级提示+下拉框

　　　　　　　　　　　　　　图（3）存储数据点击响应

简单贴几张图，不过还是亲自测试效果好点，请点击演示地址测试。

演示地址：

下载地址：

转载地址：http://ujofl.baihongyu.com/

你可能感兴趣的文章

指针与句柄的区别

查看>>

C#委托-总结实例