Copy codeThe Code is 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 (50) not null,
'Classid' INT NOT NULL
)";
$ SQL [] = "insert 'dd _ book_class '(classname, classid) values ('fiction', 0 )";
$ SQL [] = "insert 'dd _ book_class '(classname, classid) values ('literature, 0 )";
$ SQL [] = "insert 'dd _ book_class '(classname, classid) values ('you', 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 ('popularity', 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. 'signature <a href = "? Class = '. $ class_arr [$ I] [0].' "> '. $ class_arr [$ I]
[1]. '</a> <br> ';
Classtree ($ n + 1, $ class_arr [$ I] [0]);
}
}
}
Classtree (0, 0 );
?>