Displaying relationships graphically 'on the fly'...

[scubak1w1]

Hello,

I have a series of database tables in PostgreSQL that I am getting data from and displaying in the web browser (via PHP, SQL, etc.)

How about giving some details of what I am looking to do with a simple set of examples? (if you will forgive the verbosity.)

• I have groups of employees assigned to just one training group - say 'truck drivers', 'shipping technicians', etc - a one to many
  
  
• I have a series of modules, assigned to again just one module group - say 'Vehicles', 'Drug Testing', 'Pallet Safety', etc - again a one to many
  
  
• The site admins use the existing functionality of the web site to, say, indicate that:
  1. employees listed in the training group 'truck drivers' need to do all of the modules listed under the 'vehicles' module group,
  2. ditto 'shipping technicians' for 'pallet safety', and
  3. all employees need to do the 'drug testing' modules

As mentioned this is all set up, both in the back end database and on the user interface; that is, I have already written the pages and associated code to populate the intermediate table that sets up these relationships - so these can be dragged out with SQL easily.

On one of the admin pages, I would love to be able to show the relationship of the records in the training group table to that in the module group table GRAPHICALLY 'on the fly' to better enable the admin user to see how they are related.

I envisage this as a sort of ERD, as it were (but rather than the database structural elements being the entities in the relationship diagram, I would want to show the varied training group <---> module group relationship as entities on the diagram.)

Any suggestions as to how? Some OS software out there that I can use PHP with?

I realise that the request is a bit esoteric, but wanted to get some input before I started investigating it further! :-)

Thanks in advance:
GREG...

[devsusen]

I prefer you should googled for your requirement. There are many on fly graphics generator classes/libraries available. Now you need to find out which one will suits you most. I had used pChart earlier.

[Tarantulus]

GDLIB is a good one for graphical output

[scubak1w1]

@devsusen
Thank you...

I was aware of a lot of them from Googling, but was seeking specifics on one that does ERD-like diagrams...

I will definitely check out your suggestion to see if it can be adapted, thank you!

Aside - I have found JPGraph useful for my on-the-fly charting needs from PHP, recommended

[scubak1w1]

@Tarantulus
I will go and check that out - see if someone has built (sic?) a library for the sort of thing I am looking to do... cheers!