Re: [PHP] Displaying information from table graphically]
Hardly any PHP lib's support WSOT? So it's J2EE strictly compatible? Ashley Sheridan wrote: On Sat, 2008-11-22 at 23:07 -0100, [EMAIL PROTECTED] wrote: http://en.wikipedia.org/wiki/Adobe_Flash#Programming_language Of late, the Flash libraries are being used with the XML capabilities of the browser to render rich content in the browser. This technology is known as Asynchronous Flash and XML, much like AJAX. This technology of Asynchronous Flash and XML has pushed for a more formal approach of this technology called Adobe Flex, which uses the Flash runtime to build Rich Internet Applications. --- This is probabily what I need for this project :) [EMAIL PROTECTED] wrote: So basically all the data between Flash and SQL queries goes thru temporary XML files correct? not so much temporary as you convert the data to xml packets and transport in that format, you use the xml as a way of keeping the data structured and transportable (see SOAP, XML-RPC); think of flash as a client side program and you're php application as a webservice that the client app sends and recieves data from and you'll get on a lot better. Yeah. XML web services are the way forward for exchanging data. You can have one service spit out XML that can be used by an AJAX request, Flash and basically anything else that can digest web services. Ash www.ashleysheridan.co.uk WSOT is worth a look if you're so inclined; hardly any php lib's have support for ws-* suite of services like ws-addressing, ws-security etc (native support in soap for sessions, security etc etc) -- 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
Re: [PHP] Displaying information from table graphically]
Yes however problem with using DIV's is that they are supported only from IE7, which is significant shortcoming I believe Maybe I missed soemthing... what was wrong with Stut's suggestion of using divs? Absolute divs within a relative div is great for treating a box as a canvas with image layers. Each layer being clickable in it's visible portion (unless obscured by an overlayed transparent image). Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
Now does it mean that I will have to create and incorporate webservices with my existing PHP web application? Does Flex support PHP in that respect? Sounds like J2EE strictly, but can I do it from PHP? On Sat, 2008-11-22 at 23:07 -0100, [EMAIL PROTECTED] wrote: http://en.wikipedia.org/wiki/Adobe_Flash#Programming_language Of late, the Flash libraries are being used with the XML capabilities of the browser to render rich content in the browser. This technology is known as Asynchronous Flash and XML, much like AJAX. This technology of Asynchronous Flash and XML has pushed for a more formal approach of this technology called Adobe Flex, which uses the Flash runtime to build Rich Internet Applications. --- This is probabily what I need for this project :) [EMAIL PROTECTED] wrote: So basically all the data between Flash and SQL queries goes thru temporary XML files correct? not so much temporary as you convert the data to xml packets and transport in that format, you use the xml as a way of keeping the data structured and transportable (see SOAP, XML-RPC); think of flash as a client side program and you're php application as a webservice that the client app sends and recieves data from and you'll get on a lot better. Yeah. XML web services are the way forward for exchanging data. You can have one service spit out XML that can be used by an AJAX request, Flash and basically anything else that can digest web services. Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
On Sun, 2008-11-23 at 10:20 -0100, [EMAIL PROTECTED] wrote: Yes however problem with using DIV's is that they are supported only from IE7, which is significant shortcoming I believe Maybe I missed soemthing... what was wrong with Stut's suggestion of using divs? Absolute divs within a relative div is great for treating a box as a canvas with image layers. Each layer being clickable in it's visible portion (unless obscured by an overlayed transparent image). Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP I'd hope div's were supported by IE6, because I've been using them and testing them in that browser for years! The only thing to be wary of is the box model for IE is different than that of every other browser and the W3C. I've got more details on my site about the box model and how to use conditional comments to have stylesheets just for IE. Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
Excellent, it's good to know that. I think someone earlier in the discussion mentioned that DIV's were supported from IE7. He probabily meant fully supported, I am not absolutely sure but anyway it's good to know there are other experiences with IE as well. How about IE5? Does anyone have any experience on how IE5 handles DIV's? On Sun, 2008-11-23 at 10:20 -0100, [EMAIL PROTECTED] wrote: Yes however problem with using DIV's is that they are supported only from IE7, which is significant shortcoming I believe Maybe I missed soemthing... what was wrong with Stut's suggestion of using divs? Absolute divs within a relative div is great for treating a box as a canvas with image layers. Each layer being clickable in it's visible portion (unless obscured by an overlayed transparent image). Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP I'd hope div's were supported by IE6, because I've been using them and testing them in that browser for years! The only thing to be wary of is the box model for IE is different than that of every other browser and the W3C. I've got more details on my site about the box model and how to use conditional comments to have stylesheets just for IE. Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
On Sun, 2008-11-23 at 11:21 -0100, [EMAIL PROTECTED] wrote: Excellent, it's good to know that. I think someone earlier in the discussion mentioned that DIV's were supported from IE7. He probabily meant fully supported, I am not absolutely sure but anyway it's good to know there are other experiences with IE as well. How about IE5? Does anyone have any experience on how IE5 handles DIV's? On Sun, 2008-11-23 at 10:20 -0100, [EMAIL PROTECTED] wrote: Yes however problem with using DIV's is that they are supported only from IE7, which is significant shortcoming I believe Maybe I missed soemthing... what was wrong with Stut's suggestion of using divs? Absolute divs within a relative div is great for treating a box as a canvas with image layers. Each layer being clickable in it's visible portion (unless obscured by an overlayed transparent image). Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP I'd hope div's were supported by IE6, because I've been using them and testing them in that browser for years! The only thing to be wary of is the box model for IE is different than that of every other browser and the W3C. I've got more details on my site about the box model and how to use conditional comments to have stylesheets just for IE. Ash www.ashleysheridan.co.uk IE 5 and IE5.5 handle div's the same way that IE6 does, albeit badly. One caveat that you may run into though, IE doesn't like the minimum height of a div to be smaller than the font size, so if you make sure yu set your font sizes for those graph divs to something like 1px, you should be OK. Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
Robert Cummings wrote: Maybe I missed soemthing... what was wrong with Stut's suggestion of using divs? Absolute divs within a relative div is great for treating a box as a canvas with image layers. Each layer being clickable in it's visible portion (unless obscured by an overlayed transparent image). Cheers, Rob. nothing at all was wrong with Stut's suggestion; however us web developers have been boxed in and indeed grown accustomed to using the wrong tools for the job through years of having to bastardise html, javascript and http to do what we want it to, rather that what it was designed for. (/hence ajax!/) In the above scenario you *can* use (x)html to complete the task and get something going, or you can use a tech like flash/flex which was developed primarily for tasks such as this. I'm no going to go into any more detail on this, I'm sure you understand what I mean. Regards! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
I absolutely agree. This type of scenario is exactly what they had in mind when they decided to develop Flex technology. And I have no time to experiment or take risk. I did some aditional reading on Flex in the mean time, and I found out that it is fully integratable with existing PHP web application (and other technologies as well such as JSP's, ColdFusion, and ASP's). It's just gonna serve as add-on, and make my application transition from web 1 to web 2 standard. The only catch is that Flex Builder (plug in for Eclipse) has a commercial licence, and Adobe sells it for 250 Euros for standard version (professional is about 600) Robert Cummings wrote: Maybe I missed soemthing... what was wrong with Stut's suggestion of using divs? Absolute divs within a relative div is great for treating a box as a canvas with image layers. Each layer being clickable in it's visible portion (unless obscured by an overlayed transparent image). Cheers, Rob. nothing at all was wrong with Stut's suggestion; however us web developers have been boxed in and indeed grown accustomed to using the wrong tools for the job through years of having to bastardise html, javascript and http to do what we want it to, rather that what it was designed for. (/hence ajax!/) In the above scenario you *can* use (x)html to complete the task and get something going, or you can use a tech like flash/flex which was developed primarily for tasks such as this. I'm no going to go into any more detail on this, I'm sure you understand what I mean. Regards! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
[EMAIL PROTECTED] wrote: I absolutely agree. This type of scenario is exactly what they had in mind when they decided to develop Flex technology. And I have no time to experiment or take risk. I did some aditional reading on Flex in the mean time, and I found out that it is fully integratable with existing PHP web application (and other technologies as well such as JSP's, ColdFusion, and ASP's). It's just gonna serve as add-on, and make my application transition from web 1 to web 2 standard. The only catch is that Flex Builder (plug in for Eclipse) has a commercial licence, and Adobe sells it for 250 Euros for standard version (professional is about 600) now adobe have done an interesting thing, the flex 3 builder trial is fully functional for 60 days, giving yuo more than enough time to get on and learn it + make some app's with it, thus letting you use the software to generate the revenue to pay for it. This is what I did and found that within 2 weeks I'd paid for it with time saved and additional work done. :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
[EMAIL PROTECTED] wrote: Since you already used it, and I have a doubt regarding wheter to use Zend or PDT with Eclipse, what is your opinion on that subject. Official Adobe Flex page recommends using Zend, but Zend is commercial too, and I generally preffer using open source, could I encounter some depenency problems down the road if I opt for PDT? It shouldn't but what is your personal experience with that? personally I have different eclipses for each thing, the flex eclipse builder full package for flex stuff, the pdt all in one with some extras like subversive, RSE etc for php, a uml one with amateras and uml2 tools etc, then a j2ee one. Sticking to the one IDE is great, but different versions and set-ups for each job. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
Since you already used it, and I have a doubt regarding wheter to use Zend or PDT with Eclipse, what is your opinion on that subject. Official Adobe Flex page recommends using Zend, but Zend is commercial too, and I generally preffer using open source, could I encounter some depenency problems down the road if I opt for PDT? It shouldn't but what is your personal experience with that? [EMAIL PROTECTED] wrote: I absolutely agree. This type of scenario is exactly what they had in mind when they decided to develop Flex technology. And I have no time to experiment or take risk. I did some aditional reading on Flex in the mean time, and I found out that it is fully integratable with existing PHP web application (and other technologies as well such as JSP's, ColdFusion, and ASP's). It's just gonna serve as add-on, and make my application transition from web 1 to web 2 standard. The only catch is that Flex Builder (plug in for Eclipse) has a commercial licence, and Adobe sells it for 250 Euros for standard version (professional is about 600) now adobe have done an interesting thing, the flex 3 builder trial is fully functional for 60 days, giving yuo more than enough time to get on and learn it + make some app's with it, thus letting you use the software to generate the revenue to pay for it. This is what I did and found that within 2 weeks I'd paid for it with time saved and additional work done. :) -- 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
Re: [PHP] Displaying information from table graphically
Please keep the discussion on-list. On 22 Nov 2008, at 13:40, [EMAIL PROTECTED] wrote: The second approach is I believe exactly what I need. I dont actually have to make sophisticated graphics at all. Just a simple graphical representation of a room and beds inside in different colors indicating whether they are occupied, free, or reserved. So I believe DIVs would be definitelly the right approach for the scope of this project. Now the question would be how DIV's are supported by IE and Mozzila Firefox (I could specify this as a restriction in terms of usage) You should be fine with any Firefox and IE7, but you may have issues with IE6. Best advice is to test everything thoroughly. I'll probably get lynched for saying this, but you could avoid most compatibility issues by using a table to put the images together instead of divs. Also what does the KISS principle mentioned below stands for please? KISS === Keep It Simple, Stupid http://en.wikipedia.org/wiki/KISS_principle -Stut -- http://stut.net/ On 21 Nov 2008, at 17:55, [EMAIL PROTECTED] 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. There's a couple of ways you can do this with differing qualities. 1) Use GD or ImageMagick to composite images together to represent the room. This would allow you to create the best looking images. You can either store images for rooms with 1, 2, 3, 4, ..., n beds and overlay markers to indicate occupied beds, or you could composite the whole thing. 2) Slice images up such that you can build a room using positioned divs. This would be a lot easier but you'd be limited in what type of textures and looks you can give the rooms. On the other hand this could turn out to be more flexible as you could arrange it to allow rooms of any dimensions with any number of beds. Personally I'd opt for 2 based on the KISS principle, but you could potentially run into browser compatibility issues depending on your target platforms. -Stut -- http://stut.net/ -- 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
Re: [PHP] Displaying information from table graphically
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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically
On Sat, 2008-11-22 at 14:22 -0100, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
[Fwd: Re: [PHP] Displaying information from table graphically]
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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
Re: [Fwd: Re: [PHP] Displaying information from table graphically]
On 22 Nov 2008, at 16:23, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
Re: [Fwd: Re: [PHP] Displaying information from table graphically]
For the love of $DEITY, please include the list when replying!! On 22 Nov 2008, at 17:26, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
[Fwd: Re: [Fwd: Re: [PHP] Displaying information from table graphically]]
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? On 22 Nov 2008, at 16:23, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
Re: [Fwd: Re: [PHP] Displaying information from table graphically]
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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
[Fwd: Re: [PHP] Displaying information from table graphically]
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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
Re: [Fwd: Re: [PHP] Displaying information from table graphically]
On Sat, 2008-11-22 at 19:47 -0100, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
Re: [Fwd: Re: [PHP] Displaying information from table graphically]
Ashley Sheridan wrote: On Sat, 2008-11-22 at 19:47 -0100, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
Re: [Fwd: Re: [PHP] Displaying information from table graphically]
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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
Re: [Fwd: Re: [PHP] Displaying information from table graphically]
[EMAIL PROTECTED] wrote: So basically all the data between Flash and SQL queries goes thru temporary XML files correct? not so much temporary as you convert the data to xml packets and transport in that format, you use the xml as a way of keeping the data structured and transportable (see SOAP, XML-RPC); think of flash as a client side program and you're php application as a webservice that the client app sends and recieves data from and you'll get on a lot better. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [Fwd: Re: [PHP] Displaying information from table graphically]
I see that. Is there some good tutorial on this topic? How to make Flash interact with SQL queries in PHP [EMAIL PROTECTED] wrote: So basically all the data between Flash and SQL queries goes thru temporary XML files correct? not so much temporary as you convert the data to xml packets and transport in that format, you use the xml as a way of keeping the data structured and transportable (see SOAP, XML-RPC); think of flash as a client side program and you're php application as a webservice that the client app sends and recieves data from and you'll get on a lot better. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
On Sat, 2008-11-22 at 23:07 -0100, [EMAIL PROTECTED] wrote: http://en.wikipedia.org/wiki/Adobe_Flash#Programming_language Of late, the Flash libraries are being used with the XML capabilities of the browser to render rich content in the browser. This technology is known as Asynchronous Flash and XML, much like AJAX. This technology of Asynchronous Flash and XML has pushed for a more formal approach of this technology called Adobe Flex, which uses the Flash runtime to build Rich Internet Applications. --- This is probabily what I need for this project :) [EMAIL PROTECTED] wrote: So basically all the data between Flash and SQL queries goes thru temporary XML files correct? not so much temporary as you convert the data to xml packets and transport in that format, you use the xml as a way of keeping the data structured and transportable (see SOAP, XML-RPC); think of flash as a client side program and you're php application as a webservice that the client app sends and recieves data from and you'll get on a lot better. Yeah. XML web services are the way forward for exchanging data. You can have one service spit out XML that can be used by an AJAX request, Flash and basically anything else that can digest web services. Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
Ashley Sheridan wrote: On Sat, 2008-11-22 at 23:07 -0100, [EMAIL PROTECTED] wrote: http://en.wikipedia.org/wiki/Adobe_Flash#Programming_language Of late, the Flash libraries are being used with the XML capabilities of the browser to render rich content in the browser. This technology is known as Asynchronous Flash and XML, much like AJAX. This technology of Asynchronous Flash and XML has pushed for a more formal approach of this technology called Adobe Flex, which uses the Flash runtime to build Rich Internet Applications. --- This is probabily what I need for this project :) [EMAIL PROTECTED] wrote: So basically all the data between Flash and SQL queries goes thru temporary XML files correct? not so much temporary as you convert the data to xml packets and transport in that format, you use the xml as a way of keeping the data structured and transportable (see SOAP, XML-RPC); think of flash as a client side program and you're php application as a webservice that the client app sends and recieves data from and you'll get on a lot better. Yeah. XML web services are the way forward for exchanging data. You can have one service spit out XML that can be used by an AJAX request, Flash and basically anything else that can digest web services. Ash www.ashleysheridan.co.uk WSOT is worth a look if you're so inclined; hardly any php lib's have support for ws-* suite of services like ws-addressing, ws-security etc (native support in soap for sessions, security etc etc) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
Nathan Rixham wrote: WSOT is worth a look... sorry my nickname for it.. i meant wso2 (wso2.org) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically]
Maybe I missed soemthing... what was wrong with Stut's suggestion of using divs? Absolute divs within a relative div is great for treating a box as a canvas with image layers. Each layer being clickable in it's visible portion (unless obscured by an overlayed transparent image). Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically
On 21 Nov 2008, at 17:55, [EMAIL PROTECTED] 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. There's a couple of ways you can do this with differing qualities. 1) Use GD or ImageMagick to composite images together to represent the room. This would allow you to create the best looking images. You can either store images for rooms with 1, 2, 3, 4, ..., n beds and overlay markers to indicate occupied beds, or you could composite the whole thing. 2) Slice images up such that you can build a room using positioned divs. This would be a lot easier but you'd be limited in what type of textures and looks you can give the rooms. On the other hand this could turn out to be more flexible as you could arrange it to allow rooms of any dimensions with any number of beds. Personally I'd opt for 2 based on the KISS principle, but you could potentially run into browser compatibility issues depending on your target platforms. -Stut -- http://stut.net/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically
[EMAIL PROTECTED] 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 general idea: in mysql you have marked beds with 0 not occupied and 1 occupied. then you have two images: bed_occupied_0.gif and bed_occupied_1.gif and, depending on record from mysql different image should be shown. same with number of beds in room. for example. there is 4 beds maximum per room. you have 5 images no_of_beds_0.gif (actually, this is a transparent 1x1 gif) images no_of_beds_1.gif images no_of_beds_2.gif images no_of_beds_3.gif images no_of_beds_4.gif $query = mysql_qurey(select no_of_beds from beds where room=123; $result = mysql_fetch_assoc($query); echo img src=images/no_of_beds_.$result['no_of_beds']..gif border=0 /; something like that. -afan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Displaying information from table graphically
On Fri, 2008-11-21 at 16:55 -0100, [EMAIL PROTECTED] 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
