On 11/21/2008 07:55 AM, David Giragosian wrote: > On 11/21/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >> I have a PHP application that accesses data from MySQL. There is table >> called "rooms", and table called "beds". There is another table called >> "patients". Patients are being placed into beds, and beds are in the >> rooms. PHP application currently displays all information in textual mode >> via regular HTML tags. But I would like to have that information displayed >> in graphical mode instead of textual mode. >> >> Is there a way to display this information from the database graphically. >> Graphic would represent a room, and it would contain beds inside. You >> would be able to see visually which beds are occupied and which are free >> by looking at the graphics. >> >> User of the system wants pictures instead of text displayed via HTML >> tables as a list of entries. >> >> Anyone knows anything like this? >> Thanks, >> Dzenan >> > > > PHP has the GD library with a fairly extensive set of functions for creating > images <http://us2.php.net/gd>>. > > You can grab data from MySQL and then use the GD functions to create images > dynamically. It can be tedious, as you create the image pixel by pixel, but > the results are very good. > > David > > Or for reduced CPU overhead, just make some images for beds and rooms and use tables or positioned DIV tags to place them in the appropriate place based on the database information.
-Micah
