 |
ต้องการดึงข้อมูลจากฐานข้อมูล มาเป็น <ul> <li> หลายระดับจะต้องเขียนโค้ดไงค่ะ ผู้รู้ช่วยหน่อยนะค่ะ |
| |
 |
|
|
 |
 |
|
ฐานข้อมูลค่ะ
CREATE TABLE `stinky_menu` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`title` varchar(120) NOT NULL DEFAULT '',
`active` tinyint(1) NOT NULL DEFAULT '0',
`nest_under` int(5) NOT NULL DEFAULT '0',
`description` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`img` varchar(255) NOT NULL,
UNIQUE KEY `id` (`id`),
KEY `nest_under` (`nest_under`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `stinky_menu`
--
INSERT INTO `stinky_menu` VALUES (8, 'Sub Menu Item 3', 1, 1, 'Games d0t com!', 'http://games.com', 'merge.gif');
INSERT INTO `stinky_menu` VALUES (6, 'Menu Item 2', 1, 0, 'SHORT URL within website', 'short_url', 'merge.gif');
INSERT INTO `stinky_menu` VALUES (1, 'Menu Item 1', 1, 0, 'I am mean d0t com', 'http://i-am-mean.com', 'merge.gif');
INSERT INTO `stinky_menu` VALUES (2, 'Sub Menu Item 1', 1, 1, 'Google . com', 'HTTP://google.com', 'merge.gif');
INSERT INTO `stinky_menu` VALUES (7, 'Sub Menu Item 2', 1, 3, 'Yahoo!!!!', 'http://yahoo.com', 'merge.gif');
INSERT INTO `stinky_menu` VALUES (3, 'Sub Menu Item 1.1', 1, 2, 'I LOVE CARS!', 'cars', 'merge.gif');
INSERT INTO `stinky_menu` VALUES (4, 'Sub Sub Menu Item 1.3', 1, 3, 'Weber Dev', 'http://weberdev.com', 'merge.gif');
INSERT INTO `stinky_menu` VALUES (5, 'Sub Sub Menu Item 1.2', 1, 6, 'Blacksnday d0t com', 'http://blacksnday.com', 'merge.gif');
อยากให้ดึงข้อมูลออกมาแล้วแสดงผลตามโค้ด นี้ค่ะ ต้องใช้ ul li นะค่ะ ขอบคุณค่ะ
<ul>
<li>Menu Item 1
<ul>
<li>Sub Menu Item 1
<ul>
<li> Sub Menu Item 1.1</li>
<li> Sub Menu Item 2 </li>
<li> Sub Sub Menu Item 1.3 </li>
</ul>
<li>Sub Menu Item 3</li>
</ul>
</li>
<li>Menu Item 2
<ul>
<li>Sub Sub Menu Item 1.2</li>
</ul>
</li>
</ul>
เมล์มาก็ได้นะค่ะ [email protected]
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2009-11-15 13:42:49 |
By :
nan |
View :
1712 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
<?php
mysql_connect('localhost', 'root', '12345');
mysql_select_db('test');
$r = mysql_query('SELECT * FROM stinky_menu');
$M = array();
$T = array();
while($row = mysql_fetch_assoc($r)){
$M[$row['id']] = $row;
if (empty($T[$row['nest_under']])){
$T[$row['nest_under']]=array();
}
$T[$row['nest_under']][] = $row['id'];
}
function render_tree($id=0,$prefix=''){
global $M,$T;
if (!empty($T[$id])){
echo "\n".$prefix."<ul>\n";
}
foreach((array)$T[$id] as $tid){
echo $prefix."<li>";
echo $M[$tid]['title'];
render_tree($tid, $prefix."\t");
echo "</li>\n";
}
if (!empty($T[$id])){
echo $prefix."</ul>\n";
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="th" xml:lang="th">
<head>
<title>test</title>
</head>
<body>
<?php render_tree(0);?>
</body>
</html>
|
| |
|
|
| |
| Date :
2009-11-15 14:15:47 |
By :
num |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณ คุณ num มากนะค่ะ
|
| |
|
|
| |
| Date :
2009-11-16 10:30:29 |
By :
nan |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
