Php tree structure operation code (1/4)

/*************************************** ************************
* Tree structure operation class (ideal for writing stored procedures)
*
**************************************** ************************/

Class treenode {
Var $ f_id = 'id ';
Var $ f_pid = 'pid ';
Var $ f_lft = 'lft ';
Var $ f_rgt = 'rgt ';
Var $ f_s = 'sequence ';
Var $ f_level = 'lev ';
Var $ f_child_num = 'child _ num ';
Var $ table;
Var $ db;
/**
* Constructor
* @ Param string $ table name
* @ Param object $ dbhanle adodb database tutorial operation handle
*/
Function treenode ($ table, $ dbhandle ){
$ This-> db = $ dbhandle;
$ This-> table = $ table;
// $ This-> db-> debug = true;
        }
/**
* Add a subnode
* @ Param array $ data node data
* @ Return bool
*/
Function addchild ($ data ){
$ Pid = $ data [$ this-> f_pid];
$ SQL = "select max ({$ this-> f_s}) from {$ this-> table} where {$ this-> f_pid} = $ pid ";
$ Data [$ this-> f_s] = $ this-> db-> getone ($ SQL) + 1; // Obtain the serial number of the node to be inserted.
$ SQL = "select * from {$ this-> table} where {$ this-> f_id} =-1 ";
$ Rs = $ this-> db-> execute ($ SQL );
$ SQL = $ this-> db-> getinsertsql ($ rs, $ data );
$ This-> db-> execute ($ SQL); // Insert node data
If (! $ This-> db-> affected_rows ()){
Return false;
                }
               
$ This-> buildtree (); // the left and right node values are rebuilt.
$ This-> updatelevel (1); // Generate a node-level value
Return true;
        }
/**
* Modify node data
* @ Param int $ id node id
* @ Param array $ data node data
* @ Return bool
*/

Homepage 1 2 3 4 Last page