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

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

 



After reading the article I first thought imagemaps would be the best
solution, however then I realized that although I can click on individual
images inside the composite image, I can not change just that individual
element. I would have to reload the whole new composite image containing
appropriate combination of individual elements.

Other words if I want to change the status of one bed from free to
occupied, I have to reload new composite image with corresponding bed
status settings. So for example a room with 2 beds where each bed can have
one of three possible statuses (free, occupied, reserved), would need to
have total of 3^2 = 9 images defining all possible room arrangements. And
that's not too bad, but if a room has 5 beds then the total number of
images would be 3^5=243 and that's where things starting getting out of
hand. If room has 10 beds (which is quite possible) those figures grow to
extreme values, so I would have to store thousands, or tens of thousands
images to be able to define every possible room arrangement.

So imagemaps are quite nice and simple to use HTML features, but for this
particular project I believe they would not be practical.

> For the love of $DEITY, please include the list when replying!!
>
> On 22 Nov 2008, at 17:26, dzenan.causevic@xxxxxxxxxx wrote:
>
>> But imagemaps are constructed using DIV's and that would not be
>> supported
>> by IE6 correct? Is there another way to build imagemaps beside DIV's
>> that
>> would be supported at least since IE5?
>
> Imagemaps have absolutely nothing to do with divs. I suggest you read
> this: http://www.elated.com/articles/creating-image-maps/
>
> -Stut
>
> --
> http://stut.net/
>
>>> On 22 Nov 2008, at 16:23, 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 :)
>>>
>>> Since you would be using coordinates to composite the images,
>>> building
>>> an imagemap at the same time should be really simple. However, I'd
>>> still go with constructing the images in divs or a table due to the
>>> relative simplicity.
>>>
>>> -Stut
>>>
>>> --
>>> http://stut.net/
>>>
>>>>> 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
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> 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