Re: [Fwd: Re: [PHP] Displaying information from table graphically]

Ashley Sheridan wrote:

On Sat, 2008-11-22 at 19:47 -0100, dzenan.causevic@wise-t.com wrote:

Since I am not an expert in FLASH, I need to make sure I understand what you suggested below.

From what I understand I can pass the data from SQL query to Flash via

some sort of flash parameters (flashvars), but I am not sure what XML file serves here for? All I need is to somehow trigger SQL updates from within the FLASH file.

On Sat, 2008-11-22 at 15:20 -0100, dzenan.causevic@wise-t.com wrote:

At least that eliminates GD as an option for this particular purpose. Yes exactly something Flash like that allows interaction as well. But how to exchange data between flash multimedia file and MySQL queries. This is a serious issue, this is not trivial. I know there must be some way, but I also dont know if it's worth it. That's why I need to do this research in order to determine what kind of work this particular project would involve. Your help is invaluable in that respect. Thanks goes to all of you zillion times :)

On Sat, 2008-11-22 at 14:22 -0100, dzenan.causevic@wise-t.com wrote:

I mean composite in a figurative way, but they have to be overlapping individual images in order to be individually clickable. Does GD

allow

that? Can I create multiple images on the top of each other in GD? And how would imagemap work in this respect?

On Sat, 2008-11-22 at 12:51 -0100, dzenan.causevic@wise-t.com

wrote:

Okay I would probabily define few functions such as room(), bed(), bed_status() etc. that I could use for any room and then it would

be

just a matter of passing right arguments to those funtions. However would those beds within the room composite graphic be individually clickable? So the composite graphic must be interactive in nature.

User

must be able to click on individual beds inside the room in order

to

change its status. Would GD approach allow this kind of

interaction?

On Sat, 2008-11-22 at 12:14 -0100, dzenan.causevic@wise-t.com

wrote:

It's not kind of a school/college project that I am too lazy to

do.

It's

just a matter of having 800 rooms and about 2,500 beds so I

believe

it's

gonna take forever defining all of those graphics via GD

functions.

That's why I think I need to go with some rapid approach. I never used

GD's

so

I dont even know how complex it is generating graphics this way.

And

also

those graphics dont need to be sophisticated. Just simple

graphic

representations of rooms and beds in few different colors

indicating

wheter bed is free, occupied, or reserved. GD just seems too powerful and too time consuming for this

task. I

probabily need some rapid approach with limited graphic

capabilities.

Does such exist that's my question at this point of time

On Fri, 2008-11-21 at 16:55 -0100, dzenan.causevic@wise-t.com

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

This sounds a lot like a school/college/uni project that

you're

too

lazy

to research... Correct me if I'm wrong. The other guys who have answered are all spot on when they

say

you

need

to look at the GD library. Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

GD is fine for what you need to do, and it shouldn't be

difficult

to

create what you need to do. There isn't any pre-built rooms()

function

in it, but just build that yourself and use basic math to create

the

graphics you need. Ash www.ashleysheridan.co.uk

The only way you could achieve clickable parts of a composite image

like

that is either to not have it as a composite and use many images,

or

use

an imagemap. Ash www.ashleysheridan.co.uk

I don't think you can do that in anything. GD outputs an image, which can be made up of layers, but there is no provision in the browser to allow you to select an image below another one even if you can see it because the top-most image is transparent. I think what you're really looking for is something Flash based? Ash www.ashleysheridan.co.uk

I assume that to get this data you are querying based on some sort of ID? Why not pass that to you Flash file (with flashvars or something similar) and then have your Flash call an external XML document. The XML document does not have to exist, but it can be a PHP file which displays as an XML in much the same way you use PHP to output HTML (just make sure to set the correct headers). Then you can get all the information you need from within Flash. Ash www.ashleysheridan.co.uk

I suggested the XML because flashvars isn't really suited to large amounts of data, whereas XML is. Ash www.ashleysheridan.co.uk

or just go for flex and pull xml(custom, xml-rpc,soa, whatever) directly from your php scripts