Jeg har først oprettet databasen, og indsat data:
CREATE TABLE IF NOT EXISTS menu (
id int(10) unsigned NOT NULL auto_increment,
parid int(10) unsigned ,
text char(255) ,
PRIMARY KEY (id)
);
INSERT INTO menu VALUES("1", "0", "Item 0.0");
INSERT INTO menu VALUES("2", "0", "Item 0.1");
INSERT INTO menu VALUES("3", "0", "Item 0.2");
INSERT INTO menu VALUES("4", "0", "Item 0.3");
INSERT INTO menu VALUES("5", "0", "Item 0.4");
INSERT INTO menu VALUES("6", "2", "Item 2.0");
INSERT INTO menu VALUES("7", "2", "Item 2.1");
INSERT INTO menu VALUES("8", "2", "Item 2.2");
INSERT INTO menu VALUES("9", "2", "Item 2.3");
INSERT INTO menu VALUES("10", "7", "Item 2.1.0");
INSERT INTO menu VALUES("11", "7", "Item 2.1.1");
INSERT INTO menu VALUES("12", "7", "Item 2.1.2");
INSERT INTO menu VALUES("13", "11", "Item 2.1.1.0");
INSERT INTO menu VALUES("14", "11", "Item 2.1.1.1");
INSERT INTO menu VALUES("15", "11", "Item 2.1.1.2");
INSERT INTO menu VALUES("16", "11", "Item 2.1.1.3");
INSERT INTO menu VALUES("17", "11", "Item 2.1.1.4");
INSERT INTO menu VALUES("18", "11", "Item 2.1.1.5");
INSERT INTO menu VALUES("19", "15", "Item 2.1.1.2.0");
INSERT INTO menu VALUES("20", "15", "Item 2.1.1.2.1");
INSERT INTO menu VALUES("21", "15", "Item 2.1.1.2.2");
INSERT INTO menu VALUES("22", "15", "Item 2.1.1.2.3");
INSERT INTO menu VALUES("23", "17", "Item 2.1.1.4.0");
INSERT INTO menu VALUES("24", "17", "Item 2.1.1.4.1");
INSERT INTO menu VALUES("25", "17", "Item 2.1.1.4.2");
INSERT INTO menu VALUES("26", "4", "Item 0.3.0");
INSERT INTO menu VALUES("27", "4", "Item 0.3.1");
INSERT INTO menu VALUES("28", "4", "Item 0.3.2");
INSERT INTO menu VALUES("29", "4", "Item 0.3.3");
INSERT INTO menu VALUES("30", "4", "Item 0.3.4");
INSERT INTO menu VALUES("31", "28", "Item 0.3.2.0");
INSERT INTO menu VALUES("32", "28", "Item 0.3.2.1");
INSERT INTO menu VALUES("33", "28", "Item 0.3.2.2");
Derefter har jeg oprettet filen ListTreeMenu.class.php:
<?php
class ListTreeMenu {
private $tableName;
private $htmlId;
private function getHTML($aMenu, $nLevel=0) {
$aRet = array();
$aRet[] = $nLevel==0 ? "<ul id='".$this->htmlId."'>" : "<ul>";
for ($i=0,$j=count($aMenu[$nLevel]); $i<$j; $i++) {
$nId = $aMenu[$nLevel][$i]->id;
$sTxt = $aMenu[$nLevel][$i]->text;
if (is_array($aMenu[$nId])) {
$aRet[] = "<li><a href='#' onclick='showSub(this);return false'>".$sTxt."</a>";
$aRet[] = $this->getHTML($aMenu, $nId)."</li>";
}
else $aRet[] = "<li><a href='page.php?id=".$nId."'>".$sTxt."</a></li>";
}
print $bla;
return implode("", $aRet)."</ul>";
}
public function dump() {
$sql = "SELECT `id`, `parid`, `text` FROM ".$this->tableName;
$res = mysql_query($sql) or die (mysql_error());
while ($row=mysql_fetch_object($res)) {
if (!is_array($aMenu[$row->parid])) $aMenu[$row->parid] = array();
$aMenu[$row->parid][] = $row;
}
print $this->getHTML($aMenu);
}
public function __construct($sTableName, $sHtmlId) {
$this->tableName = $sTableName;
$this->htmlId = $sHtmlId;
}
}
?>
Til sidst har jeg oprettet index.php:
<?php
include("ListTreeMenu.class.php");
include("includes/config.php")
$conn = mysql_connect("$server", "$user", "$password");
mysql_select_db("$database");
$menu = new ListTreeMenu("menu", "minMenu");
?>
<div class="dropdown">
<?php $menu->dump() ?>
</div>
Men alligevel får jeg følgende fejl:
Parse error: syntax error, unexpected T_VARIABLE in /hsphere/local/home/internet/emilc.eu/test/index.php on line 5
Ny bruger
Nybegynder
Opret
Preview
