客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
|
数据库代码： mysql> desc category; +------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | pid | int(11) | NO | | NULL | | | catename | varchar(20) | NO | | NULL | | | createtime | varchar(10) | NO | | NULL | | +------------+-------------+------+-----+---------+----------------+ 4 rows in set (0.01 sec) mysql> select * from category; +----+-----+--------------+------------+ | id | pid | catename | createtime | +----+-----+--------------+------------+ | 1 | 0 | beijing | 1493778388 | | 2 | 0 | shanghai | 1493778388 | | 3 | 1 | chaoyang | 1493778476 | | 4 | 1 | haidian | 1493778476 | | 5 | 3 | wangjing | 1493778533 | | 6 | 3 | jiuxianqiao | 1493778533 | | 7 | 4 | zhongguancun | 1493778575 | | 8 | 2 | xunhui | 1493778633 | | 9 | 2 | changning | 1493778633 | | 10 | 8 | jiaotong | 1493778685 | +----+-----+--------------+------------+ 10 rows in set (0.00 sec)
代码： conn.php: <?php
$conn = mysql_connect('localhost', 'root', 'root');
if($conn) {
mysql_select_db("yii", $conn);
} else {
die('database is connect false.');
}
index.php: <?php
include_once('conn.php');
function get_str($id = 0) {
global $str;
$sql = "select * from category where pid= $id";
$result = mysql_query($sql);
if($result && mysql_affected_rows()){
$str .= PHP_EOL . '<ul>' . PHP_EOL;
while ($row = mysql_fetch_array($result)) {
$str .= "<li>" . $row['id'] . "--" . $row['catename'] . "</li>" . PHP_EOL;
get_str($row['id']);
}
$str .= '</ul>' . PHP_EOL;
}
return $str;
}
function get_array($id=0){
$sql = "select * from category where pid= $id";
$result = mysql_query($sql);
$arr = array();
if($result && mysql_affected_rows()){
while($rows=mysql_fetch_assoc($result)){
$rows['list'] = get_array($rows['id']);
$arr[] = $rows;
}
return $arr;
}
}
echo get_str(0);
echo "<hr/>";
$list = get_array(0);
echo '<pre>';
print_r($list);
echo '</pre>';
结果： get_str:
get_array: Array
(
[0] => Array
(
[id] => 1
[pid] => 0
[catename] => beijing
[createtime] => 1493778388
[list] => Array
(
[0] => Array
(
[id] => 3
[pid] => 1
[catename] => chaoyang
[createtime] => 1493778476
[list] => Array
(
[0] => Array
(
[id] => 5
[pid] => 3
[catename] => wangjing
[createtime] => 1493778533
[list] =>
)
[1] => Array
(
[id] => 6
[pid] => 3
[catename] => jiuxianqiao
[createtime] => 1493778533
[list] =>
)
)
)
[1] => Array
(
[id] => 4
[pid] => 1
[catename] => haidian
[createtime] => 1493778476
[list] => Array
(
[0] => Array
(
[id] => 7
[pid] => 4
[catename] => zhongguancun
[createtime] => 1493778575
[list] =>
)
)
)
)
)
[1] => Array
(
[id] => 2
[pid] => 0
[catename] => shanghai
[createtime] => 1493778388
[list] => Array
(
[0] => Array
(
[id] => 8
[pid] => 2
[catename] => xunhui
[createtime] => 1493778633
[list] => Array
(
[0] => Array
(
[id] => 10
[pid] => 8
[catename] => jiaotong
[createtime] => 1493778685
[list] =>
)
)
)
[1] => Array
(
[id] => 9
[pid] => 2
[catename] => changning
[createtime] => 1493778633
[list] =>
)
)
)
)
|
2022-08-17
2022-11-06
2022-07-29
2022-08-18
2022-08-13
tanmuhittin/laravel-google-translate: Translate translation files to other langu
bradtraversy/iweather: Ionic 3 mobile weather app
joaomh/curso-de-matlab
魔兽世界怀旧服已经开启两个多月了，但作为一个猎人玩家，抓到“断牙”，已经成为了一
rugk/mastodon-simplified-federation: Simplifies following and interacting with r
Vesta v1.0.0-5 was discovered to contain a cross-site scripting (XSS) vulnerabil
方法一： onLoad: function () { this.setData({ height: wx.getSystemInfoSync().win
andlabs/ui: Platform-native GUI library for Go.
Tangshitao/Dense-Scene-Matching: Learning Camera Localization via Dense Scene Ma
相信不少果粉在对自己的设备进行某些操作时，都会碰到Respring，但这个 Respring 到底
请发表评论