$ 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 If ($ class_arr [$ I] [2] ==$ id ){
- Echo $ n. 'callback'. $ class_arr [$ I]
- [1].'
';
- Classtree ($ n + 1, $ class_arr [$ I] [0]);
- }
- }
- }
- Classtree (0, 0 );
- ?>
|