dzenan.causevic@xxxxxxxxxx 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
general idea:
in mysql you have marked beds with 0 not occupied and 1 occupied.
then you have two images: bed_occupied_0.gif and bed_occupied_1.gif and,
depending on record from mysql different image should be shown.
same with number of beds in room.
for example. there is 4 beds maximum per room.
you have 5
images no_of_beds_0.gif (actually, this is a transparent 1x1 gif)
images no_of_beds_1.gif
images no_of_beds_2.gif
images no_of_beds_3.gif
images no_of_beds_4.gif
$query = mysql_qurey("select no_of_beds from beds where room=123";
$result = mysql_fetch_assoc($query);
echo "<img src="images/no_of_beds_".$result['no_of_beds'].".gif"
border=0 />";
something like that.
-afan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
