472,364 Members | 2,205 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,364 software developers and data experts.

Displaying relationships graphically 'on the fly'...


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:
Feb 25 '09 #1
4 1634
136 100+
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.
Feb 25 '09 #2
114 100+
GDLIB is a good one for graphical output
Feb 26 '09 #3
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
Feb 27 '09 #4
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!
Feb 27 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Mat | last post by:
Hi, I need to display a thumbnail of a large image that is contained in a database. I cannot upload a thumbnail into the database for various reasons. I have a function that resizes images before...
by: JL | last post by:
I have the following problem. I have a form created on the fly via a perl script that maintains a MySQL table. Any field that has spaces does not display properly. Only the text up to the first...
by: Mal | last post by:
Hi, As I gain knowledge through a lot of trial, error, and usenet posts.. I have a potentially odd question. I am using a commercial access application. It is a front-end / back...
by: David Lozzi | last post by:
Hello, I'm wondering whats the best method to use for displaying several photos' thumbnails. One method I know is to dynamically resize the photo at the time the page is loaded. What does this...
by: FrankEBailey | last post by:
I've been reading up on Modified Preorder Tree Traversal and it's definitely ideal for the kind of tree structures I need to model for my company's multi-level sales hierarchy. I've implemented the...
by: salad | last post by:
I'm curious about your opinion on setting relationships. When I designed my first app in Access I'd go to Tools/Relationships and set the relationships. Over time I'd go into the window and see...
by: ted | last post by:
I have an old link that was widely distributed. I would now like to put a link on that old page that will go to a new page without displaying anything.
by: =?Utf-8?B?QWRyaWFu?= | last post by:
I am writing a court booking system for 4 courts. The problem is I don't know how to render the table. I want each court as a column and I want time down the left hand side. Each court has a...
by: Roger | last post by:
I've moved all my tables to sql server2005 and I've created the appropriate relationships now I create links to two such tables that have a relationship into ms- acess97 but when I add the two...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.