Php cat is a mysql nested model category software for managing hierarchical data.Call your hierarcial categories with seo url. .manage unlimited categories,produce seo url,you can delete category and their sub categories at one time.
New in 0.0.3 alpha 2
seo class.inc query_link problem fixed. New in 0.0.3 alpha php_cat Changes:
sql file changed.
example_admin.php and other examples files completely changed.
added some error warnings for unexpected situations.
New Php5 exception error functions added.
seo.actions and actions.class joined in one class.
seo.class.inc update link increase problem fixed.Query_link method changed.
added parent_id for getting top categories .. (deleted TP value from sql (has been deprecated!))
Download It From SourgeForge.net
in admin file i get problem with
it must be like and i get only the first node (root)
sorry, i am not active in this project and i will not improve this class.. i guess you can fix it.. this is the original aritcle –>
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
HI admin,
I have been working with php mysql application and dealing with this nested set model. I have to store the ‘n’ level tree and nested seem model seems excellent for retrival of node. But traversal of node, adding,deleting,updating operation seem very expensive where there will be thousands of records in the database table.
Is there any way, i can improve the performace of this nested hierarchy ?
thanks
sachin pethani
hi,
you can try mysql stored procedures for each sql code, i guess just mysql 5.0 support this feature.
some info about stored procedures.
http://database-programming.suite101.com/article.cfm/mysql_stored_procedures_and_functions
you have to edit sql codes in action.class.php, every function has a original sql code in /* code blocks */