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

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

 



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


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