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

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

 



So basically all the data between Flash and SQL queries goes thru
temporary XML files correct?

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



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