Has anyone developed a php script that autogenerates an organisational chart page from a back-end MySQL database?
Any pointers, even algorithms , would be of great help.
Has anyone developed a php script that autogenerates an organisational chart page from a back-end MySQL database?
Any pointers, even algorithms , would be of great help.
I seek the same thing. Do U find a solution?
Me too!
I have an SQL database with lots of employee info. Also employee jpg headshots. The headshots are separate jpg files. The file names are just a field in the employee database. I need a tool that will convert that database into a visual set of headshots in a traditional orgchart layout. It would run on my intranet. It should paint org charts on the fly. Start with a view of the CEO and his direct reports. Names and titles are immediately above their pics. Click on a subordinate's headshot pic, and see a new page with him/her at the top, and a new set of subordinates. And so on. The whole thing could work if I would only have to add a field to my database for each employee called "reports to" with the name of that employee's manager. The whole thing would be smart enough to figure out the current org structure just from that field. Can't have some separate interface to maintain it, just want it to display based on my SQL database. You guys know where to get this, call me asap. --Jeff VEtterick, VP Mktg, AFS 405-782-1490
I need something similar too Anyone have any luck?
I think i have the solution for you guys. I built an org chart that works off a SQL database. It automatically creates the chart, its a system I develop for my company after 2 years of other solutions, that always took to much time to deal with.
Email me at webmaster@flir.com for details,
Thanks,
Brad
Hello,
I'm new to this board, and I am interested in a script that generates an org chart. I tried using a sub select query in getting the reporting structure, but that doesn't eem to work. ANy ideas would be greatly appreciated.
Thanks
You can check this link
https://github.com/phpdev-expert/Org-chart
Re-opened a nearly 20-year-old thread?