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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ashley Sheridan wrote:
On Sat, 2008-11-22 at 19:47 -0100, dzenan.causevic@xxxxxxxxxx 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@xxxxxxxxxx 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@xxxxxxxxxx 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@xxxxxxxxxx
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@xxxxxxxxxx
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@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



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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux