$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<>
- if ($class _arr[$i][2]== $id) {
- echo $n. ' ┠ '. $class _arr[$i]
- [1]. '
';
- Classtree ($n +1, $class _arr[$i][0]);
- }
- }
- }
- Classtree (0,0);
- ?>
Copy Code |