Php promise classification (recursion) implementation code. For more information, see.
The code is as follows:
$ 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 );
?>