RE: [PHP-DB] Generate Menu based on database structure
Thanks for the link. I've got a working JavaScript menu system; I wanted a PHP script that runs once/day to generate the tree structure in the JavaScript config file. That way each time I added a page to the database, it would be automatically added to the menu system. I'm still interested in the menu class to store each record as an object of the class if anyone can point me to any sites or offer any hints. Cheers, Gav -Original Message- From: Leo G. Divinagracia III [mailto:[EMAIL PROTECTED] Sent: Friday, 15 October 2004 11:29 AM Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Generate Menu based on database structure graeme wrote: Hi, Rather than writing a recursive function I'd suggest that you create a menu class and store each record as an object of the class. why reinvent the wheel: http://www.destroydrop.com/javascripts/tree/ -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Generate Menu based on database structure
graeme wrote: Hi, Rather than writing a recursive function I'd suggest that you create a menu class and store each record as an object of the class. why reinvent the wheel: http://www.destroydrop.com/javascripts/tree/ -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Generate Menu based on database structure
Ok, sounds good. Any hints? I've not touched this stuff before.. Will using classes allow multiple objects to be running at the same time making the script faster? Cheers, Gav -Original Message- From: graeme [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 October 2004 7:05 PM To: Gavin Amm Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Generate Menu based on database structure Hi, Rather than writing a recursive function I'd suggest that you create a menu class and store each record as an object of the class. The menu class will have variables of id, parent, title, children, and tree. The children will be initialised to 0 and tree will be initialised to 1. You will need to write a function to find any menu object given the menu's ID, should be easy if you store each object in an array (keyed on the ID) 1) Read in a record and create a menu object 2) Get the parent object, using the parent variable and the find method 3) Increment the children variable in the parent menu object by one 4) Set the tree variable in the new menu object to the tree object in the parent object plus the value in the children object. Now add method to display the menu items and your problem should be solved. Gavin Amm wrote: Hi guys, I need to generate a menu based on the content structure of my database. The data is structured using an 'id' 'parent' relationship, for eg: id parent title 1 0 Home Page 6 1 My Page 2 9 6 My Page 3 15 9 My Page 4 21 6 My Page 5 22 9 My Page 6 23 22 My Page 7 24 22 My Page 8 25 1 My Page 9 28 25 My Page 10 I need to create a recursive loop that will create the menu. The text in the brackets is what I'm trying to achieve, the rest is just for aesthetics ease of reading. (The children of the row id=1 are the top of the menu tree, ie they will be the menu categories at the top of the web page to display the menu when the mouse hovers over it.) (Each menu item, being a menu, will have a href to it's id number.) My Page 2 (Menu_1) My Page 3 (Menu_1_1) My Page 4 (Menu_1_1_1) My Page 6 (Menu_1_1_2) My Page 7 (Menu_1_1_2_1) My Page 8 (Menu_1_1_2_2) My Page 5 (Menu_1_2) My Page 9 (Menu_2) My Page 10 (Menu_2_1) I just can't for the life of me get the numbering to work correctly in the recursion. I seem to get things like (1_1_2_1_2_3_1_2_3_4) which I can see the pattern in, but it's obviously not what I'm after.. Appreciate your help. Thanks, Gav. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Generate Menu based on database structure
Hi, Rather than writing a recursive function I'd suggest that you create a menu class and store each record as an object of the class. The menu class will have variables of id, parent, title, children, and tree. The children will be initialised to 0 and tree will be initialised to 1. You will need to write a function to find any menu object given the menu's ID, should be easy if you store each object in an array (keyed on the ID) 1) Read in a record and create a menu object 2) Get the parent object, using the parent variable and the find method 3) Increment the children variable in the parent menu object by one 4) Set the tree variable in the new menu object to the tree object in the parent object plus the value in the children object. Now add method to display the menu items and your problem should be solved. Gavin Amm wrote: Hi guys, I need to generate a menu based on the content structure of my database. The data is structured using an 'id' 'parent' relationship, for eg: id parent title 1 0 Home Page 6 1 My Page 2 9 6 My Page 3 15 9 My Page 4 21 6 My Page 5 22 9 My Page 6 23 22 My Page 7 24 22 My Page 8 25 1 My Page 9 28 25 My Page 10 I need to create a recursive loop that will create the menu. The text in the brackets is what I'm trying to achieve, the rest is just for aesthetics ease of reading. (The children of the row id=1 are the top of the menu tree, ie they will be the menu categories at the top of the web page to display the menu when the mouse hovers over it.) (Each menu item, being a menu, will have a href to it's id number.) My Page 2 (Menu_1) My Page 3 (Menu_1_1) My Page 4 (Menu_1_1_1) My Page 6 (Menu_1_1_2) My Page 7 (Menu_1_1_2_1) My Page 8 (Menu_1_1_2_2) My Page 5 (Menu_1_2) My Page 9 (Menu_2) My Page 10 (Menu_2_1) I just can't for the life of me get the numbering to work correctly in the recursion. I seem to get things like (1_1_2_1_2_3_1_2_3_4) which I can see the pattern in, but it's obviously not what I'm after.. Appreciate your help. Thanks, Gav. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
