Want a PHP program to produce hierarchical tree of names using PHP and MySql?

Question

Actually I am running a site where new members can join with the reference of a existing member this is how a tree structure of members are formed.
So, I want a PHP program for my website to mangage and display names of my site members in a hierarchical tree structure.
So, I was looking for any complete php software (like phpbb ,SMF etc) where I can manage such structure of names in a web-based manager. And with a search option to search names and display that name with complete tree path for that member name.
Best would be a graphical hierarchical chart to disply members and their sub-members with the search option, of not at least like a windows directory structure with search option.

If you know any such PHP package to sute my purpose please tell. Or any other type of package (may not be for that job) which can be used to solve that specific purpose.

I would manually enter the whole members data, so i don't need a specific platform which will need my exixting data structure to fit. It can have it's own database.

Answer 1

An existing program (assuming it exists and is available on reasonable terms) won't do you much good, because you need something that works with your data structure...

Answer 2

Repying to dhvrm's comment. You should not use mysql_pconnect instead of mysql_connect. mysql_pconnect causes apache to create a new and constant connect to mysql the entire time the user is on your website. It will increase server and database load. You should connect to the database and release it as soon as you’re done. Plus, If you have limited mysql to only 50 connects this means only 50 people could use your website at once. Instead of 50 connections to the database at once.

Answer 3

I doubt you will find anything that specific that you could just plug in and go.

It sounds to me like you need each member to have a single association to whoever invited them and multiple associations to members they invite.

If you feel like writing your own implementation of this, read up on storing hierarchial data in a database: Have a look at how CakePHP does it here (http://manual.cakephp.org/chapter/models) search for HABTM.