二级联动下拉框（适用与产品分类）

页面一：index.php
```php

<script src="http://libs.baidu.com/jquery/1.9.1/jquery.min.js"></script>
<script>
    $(document).ready(function () {
        $("#cat1").change(function () {
            var catgoryid = $(this).val();
            if (catgoryid != "") {
                $("#category2").load("category2.php?catgory2=" + catgoryid);
            }
        });
    });
</script>

<?php
require_once("../config/database.php");//数据库文件自己设置
?>
<form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
    产品分类：
<?php
$sql = "select * from category WHERE pid=0";/*找出最大类，sql语句自己设置*/
$query = mysql_query($sql);
    while ($row = mysql_fetch_array($query)) {
        $categoryone[] = $row;
    }
    ?>

<select id="cat1" name="pid1">
        <option value=''>请选择一级分类</option>
        <?php
 foreach ($categoryone as $k => $v) {
            $pid1 = $v['id'];
            ?>
<option
value='<?php echo $pid1 ?>'><?php echo $v['name'] ?></option>
            <?php
}
        ?>
</select>

<span id="category2">
<select id="cat2" name="pid2">
             <option value="">请选择二级分类</option>
         </select>
    </span>
    <input class="btn" type="submit" value="提交" name="submit"/>

</form>
<?php
if (isset($_POST["submit"])) {
    echo "第一大类id为：" . $_POST["pid1"];
    echo "<br>";
    echo "第二大类id为：" . $_POST["pid2"];
}
?>
```
页面二：category.php
```php
<?php
require_once ("../config/database.php");
$sql="select * from category where pid=".$_GET['catgory2'];/*使用无限极分类，父类pid=传过来的id*/
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
    $categorytwo[]=$row;
}
?>
<select id="cat2" name="pid2" onchange="selectArea()">
    <option value="">请选择二级分类</option>
    <?php
 foreach($categorytwo as $k=>$v){
        ?>
<option value='<?php echo $v['id']?>'><?php echo $v['name']?></option>
        <?php
}
    ?>
</select>
```
数据表，，表，，表，，，不是数据库
```sql
CREATE TABLE `category` (
  `id` int(5) NOT NULL,
  `name` varchar(20) COLLATE utf8_bin NOT NULL,
  `pid` int(5) NOT NULL,
  `path` varchar(20) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
INSERT INTO `category` (`id`, `name`, `pid`, `path`) VALUES
(1, '手机', 0, ''),
(2, '平板&穿戴', 0, ''),
(3, '笔记本电脑', 0, ''),
(4, '智能家居', 0, ''),
(5, '专属配件', 0, ''),
(6, '通用配件', 0, ''),
(7, '应用市场', 0, ''),
(8, '叮咚', 1, '1,8'),
(9, '叮咚新品', 1, '1,9'),
(10, '新品系列', 1, '1,10'),
(11, '平板电脑', 2, '2,11'),
(12, '手环', 2, '2,12'),
(13, '手表', 2, '2,13'),
(14, 'Matebook', 3, '3,14'),
(15, '拓展坞', 3, '3,15'),
(16, '触控笔', 3, '3,16'),
(17, '子母路由', 4, '4,17'),
(18, '电视盒子', 4, '4,18'),
(19, '路由器', 4, '4,19'),
(20, '保护盒', 5, '5,20'),
(21, '保护套', 5, '5,21'),
(22, '贴膜', 5, '5,22'),
(23, '耳机', 6, '6,23'),
(24, '音箱', 6, '6,24'),
(25, '移动电源', 6, '6,25'),
(26, '手机游戏', 7, ''),
(27, '手机应用', 7, ''),
(28, '新品2', 10, '');
```

二级联动下拉框（适用与产品分类）

添加新评论

最新文章

最新回复

标签

归档

友情链接