web前端|js教程
jQuery,PHP,MySQL,无限级联
web前端-js教程
本文简单实现jQuery无限级联效果,分享给大家供大家参考,具体内容如下
效果图:
微信交友平台源码,vscode撤销操作,ubuntu libsx,tomcat 后端配置,sqlite qt写入中文,织梦网页视频插件,移动前端ui框架下载,爬虫 B站视频评论,php 部署服务,成都外包seo 排名,java课程网站模板下载,html网页如何在手机里全屏,mac自带视频模板lzw
office完整源码,ubuntu自动重装网卡,如何用dos运行tomcat,爬虫族蛇类,php 开发的游戏,seo价格seo教程lzw
图1 仅下拉框
qq源码网,vscode补全双大括号,ubuntu 麒麟13,tomcat指定应用路径,爬虫黄勇,php 打开网址,沈阳seo优化排名哪家好,个人信息在线提交网站源码,家装门窗自适应企业官网源码模板lzw
图2 层级提示+下拉框
图3 存储数据点击响应
主要包含3个文件:index.html(主页),wuxianjilian.php(数据处理),wuxianjilian.sql(MySQL数据文件)
1. index.html
$(document).ready(function(){ var getData = function(obj){ $.ajax({url:wuxianjilian.php,type:POST,data:{"pid":obj.val()},dataType:json,async:false,success:function(data){ if($(".selection").length){$(".selection:gt("+$(obj).index()+")").remove(); //移除后面所有子级下拉菜单$(".selection:last").after(data);//添加子级下拉菜单 }else {$("#jilianContainer").append(data);//初始加载情况 } //所有下拉响应 $(".selection").unbind().change(function(){getData($(this)); });},error:function(msg){ alert(error);} }); } //Init getData($(this)); });
$(document).ready(function(){ $("#save").click(function(){ var data = []; $(".selection").each(function(){data.push($.trim($(this).val())); }) alert(data.join(,)); });});
2. wuxianjilian.php
<?php header("Content-type: text/html; charset=utf-8"); //数据库连接操作 $conn = mysql_connect("localhost","Zjmainstay","") or die("Can not connect to database.Fatal error handle by ". __FILE__); mysql_select_db("test",$conn);//数据库名为 test mysql_query("SET NAMES utf8",$conn); //获取父级id $pid = (int)$_POST[pid]; //查询子级 $sql = "SELECT id,text FROM `wuxianjilian` WHERE pid={$pid}"; $result = mysql_query($sql,$conn); //组装子级下拉菜单 $html = \; while($row = mysql_fetch_assoc($result)){ $html .= \.$row[ ext].\; } if(!empty($html)) $html = 请选择 . $html . \; //输出下拉菜单 echo json_encode($html);//End_php
3. wuxianjilian.sql
wuxianjilian.sql/*Navicat MySQL Data TransferSource Server: localhostSource Server Version : 50516Source Host: localhost:3306Source Database : testTarget Server Type : MYSQLTarget Server Version : 50516File Encoding: 65001Date: -10-24 20:59:09*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `wuxianjilian`-- ----------------------------DROP TABLE IF EXISTS `wuxianjilian`;CREATE TABLE `wuxianjilian` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) DEFAULT NULL, `text` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;-- ------------------------------ Records of wuxianjilian-- ----------------------------INSERT INTO `wuxianjilian` VALUES (1, , A0);INSERT INTO `wuxianjilian` VALUES (2, , B0);INSERT INTO `wuxianjilian` VALUES (3, 1, C1);INSERT INTO `wuxianjilian` VALUES (4, 1, D1);INSERT INTO `wuxianjilian` VALUES (5, 1, E1);INSERT INTO `wuxianjilian` VALUES (6, 2, F2);INSERT INTO `wuxianjilian` VALUES (7, 2, G2);INSERT INTO `wuxianjilian` VALUES (8, 3, H3);INSERT INTO `wuxianjilian` VALUES (9, 3, I3);INSERT INTO `wuxianjilian` VALUES (10, 3, J3);INSERT INTO `wuxianjilian` VALUES (11, 3, K3);INSERT INTO `wuxianjilian` VALUES (12, 4, L4);INSERT INTO `wuxianjilian` VALUES (13, 4, M4);INSERT INTO `wuxianjilian` VALUES (14, 8, N8);INSERT INTO `wuxianjilian` VALUES (15, 9, N9);INSERT INTO `wuxianjilian` VALUES (16, 14, O14);INSERT INTO `wuxianjilian` VALUES (17, 14, P14);INSERT INTO `wuxianjilian` VALUES (18, 14, Q14);INSERT INTO `wuxianjilian` VALUES (19, 17, R17);INSERT INTO `wuxianjilian` VALUES (20, 17, S18);INSERT INTO `wuxianjilian` VALUES (21, 20, T20);