PHP无限级分类

傷城~ 2023-01-10 14:55 124阅读 0赞

## 1.PHP无限级分类之建库准备 ##

建表sql如下：

CREATE TABLE IF NOT EXISTS `deepcate` (
    `id` int(4) NOT NULL,
    `pid` int(11) NOT NULL,
    `catename` varchar(30) NOT NULL,
    `cateorder` int(11) unsigned NOT NULL DEFAULT '0',
    `createtime` int(10) NOT NULL
    ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='分类表';
    
    INSERT INTO `deepcate` (`id`, `pid`, `catename`, `cateorder`, `createtime`) VALUES 
    (1, 0, '新闻', 0, 0),
    (2, 0, '图片', 0, 0),
    (3, 1, '国内新闻', 0, 0),
    (4, 1, '国际新闻', 0, 0),
    (5, 3, '北京新闻', 0, 0),
    (6, 4, '美国新闻', 0, 0),
    (7, 2, '美女图片', 0, 0),
    (8, 2, '风景图片', 0, 0),
    (9, 7, '欧美明星', 0, 0),
    (10, 9, '英国电影', 0, 0);

## 2.PHP无限级分类之配置连接文件 ##

conn.php：

<?php
    $db_host = "localhost";
    $db_user = "root";
    $db_password = "123456";
    $db_name = "test";
    $link = mysqli_connect($db_host, $db_user, $db_password, $db_name) or die(mysqli_error());
    mysqli_select_db($link, $db_name) or die(mysqli_error());
    mysqli_query($link,"set names utf8;") or die("编码设置错误");
    ?>

## 3.PHP无限级分类之列表分类样式 ##

<?php
    include ("conn.php");
    
    function getList($pid=0, &$result = array(), $space = 0)
    { 
        Global $link;
        //print_r($link);
        $space = $space + 2;
        $sql = "SELECT * FROM deepcate WHERE pid = $pid";
        if (!empty($link)) { 
            $res = mysqli_query($link, $sql);
        }
        // 执行SQL语句
        while($row = mysqli_fetch_array($res)) { 
            $row['catename'] = str_repeat(' ', $space).'|--|'.$row['catename'];
            $result[] = $row;
            getList($row['id'], $result, $space);
        }
        return $result;
    }
    
    $rs = getList();
    //print_r($rs);
    echo "<select name='cate'>";
    foreach ($rs as $kye=>$value) { 
        echo "<option>{ $value['catename']}</option>";
    }
    echo "</select>";
    ?>

执行效果：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3VzZXJuYW1lNjY2_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3VzZXJuYW1lNjY2_size_16_color_FFFFFF_t_70]: /images/20221119/ec9313f687ac4716afcac5c3502452e1.png