[Fwd: Re: Displaying information from table graphically]

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

 



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
>




-- 
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