Copy Code code as follows:
<?php
$conn =mysql_connect ("localhost", "root", "myoa888");
mysql_select_db ("lost63", $conn) or Die ("Select DB Error");
$sql []=] Create TABLE ' lost63 '. ' Dd_book_class ' (
' ID ' INT not NULL auto_increment PRIMARY KEY,
' ClassName ' VARCHAR not NULL,
' ClassID ' INT not NULL
)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' novel ', 0)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' literary ', 0)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' Youth ', 0)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' Inspirational/successful ', 0)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' children ', 0)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' suspense ', 1)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' Romance ', 1)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' Workplace ', 1)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' Literature ', 2)";
$sql []= "Insert ' Dd_book_class ' (classname,classid) VALUES (' Popular science ', 5)";
Print_r ($sql);
/*-Insert test data-* *
foreach ($sql as $value) {
mysql_query ($value) or Die ("Insert data Error");
}
$class _arr=array ();
$recordset =mysql_query ("select * from ' Dd_book_class '");
while ($row =mysql_fetch_array ($recordset)) {
$class _arr[]=array ($row [' id '], $row [' classname '], $row [' ClassID ']);
}
function Classtree ($n, $id) {
Global $class _arr;
$n = Str_pad (', $n, '-', str_pad_right);
$n = Str_replace ("-", "", $n);
For ($i =0 $i <count ($class _arr); $i + +) {
if ($class _arr[$i][2]== $id) {
echo $n. ' ┠<a href= ' class= '. $class _arr[$i][0]. ' " > $class _arr[$i]
[1]. ' </a><br> ';
Classtree ($n +1, $class _arr[$i][0]);
}
}
}
Classtree (0,0);
?>