Any way to dynamically create flow chart or UML with PHP/MySQL?

Question

I've got a process tracking system built with PHP/MySQL and I'd like to provide a graphical representation of the entire process -- a map, more or less. Each step, tasks, assigned users, and dependencies are stored in MySQL tables and so I have no problem outputting the data in any number of ways, but I'm not sure how I could go about displaying that in a graphical manner. Processes can be edited by privileged users so I can't just create a process map once and save it -- it needs to be dynamic.

I thought about simply outputting tables or divs but my problem is how to make it responsive to mobile browsers, so I figure a JPG/PNG would be simpler and more platform-independent. I've seen plenty of LAMP based charting tools but nothing that will create workflows. The closest I found was yUML (http://yuml.me/) which looks like it would be easy to implement based on a quick review of the syntax, but I'm not running Rails and don't know anything about how to do so.

I also looked into screenshot services (Grabzit, Thumbshots, Websnapr, etc.) but the problem there is that this is a secure site so those services wouldn't be able to gain access.

I'm not looking for anything flashy which is why I thought UML might be a good fit -- I just need to be able to dynamically create process maps based on MySQL data.

Thanks to anyone who can point me in the right direction!

Question heading :- Any way to dynamically create flow chart or UML .................. Description say: - I'm not looking for anything flashy which is why I thought UML might be a good fit ..............................Are you looking for mysql.com/products/workbench/design — zod
– zod, Commented Sep 27, 2013 at 18:10
No, what I'm looking for is a way to describe the processes (workflows) that the end users have created. The data for those processes are stored in MySQL but I can query any number of ways to provide the data in a meaningful manner to whatever sort of flowchart API is out there. — Sean Cunningham
– Sean Cunningham, Commented Sep 27, 2013 at 18:18

Community · Accepted Answer · 2017-05-23 10:29:21Z

4

I don't know of a flow chart API, but there are any number of general purpose chart API's.

Google charts has examples for org chart (among many other chart types).

There are many threads on this kind of thing on SO already:

JavaScript Chart Library
Graph visualization library in JavaScript etc

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Sep 27, 2013 at 18:25

AllInOne

1,4502 gold badges14 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sean Cunningham Over a year ago

Thanks, that's given me some good places to look -- particularly the Dracula Graph Library (graphdracula.net).

quantme · Accepted Answer · 2020-07-08 15:35:51Z

0

I bet one of the best solutions is D3.js.

D3.js is a JavaScript library for producing dynamic, interactive data visualizations in web browsers. It makes use of Scalable Vector Graphics, HTML5, and Cascading Style Sheets standards.

—Wikipedia

You can find many examples here to fit what you are looking for, especially its very well documented API reference. Also has an incredible wiki (in many languages), greatest tutorials and some plugins.

answered Jul 8, 2020 at 15:35

quantme

3,6554 gold badges38 silver badges50 bronze badges

Collectives™ on Stack Overflow

Any way to dynamically create flow chart or UML with PHP/MySQL?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related