-
1. Re: Create a Slideshow that pulls information from a database
The Feldkircher Apr 25, 2011 8:05 AM (in response to deisouss)Hi
Everything you want here, can be easily achieved thru the Flash URLLoader, PHP and MySQL.
You can communicate directly with a PHP resource to SELECT, UPDATE, REPLACE, DELETE database entries, and return an XML object from the same PHP resource.
Check out URLLoader, URLRequest and Parsing XML.
If you let me know what size your rotator will be, then I'll make a rough example to get ya started.
Also which version of Flash your using and if your familiar with Actionscript Classes.
Hope it helps
The Feldkircher
-
2. Re: Create a Slideshow that pulls information from a database
deisouss Apr 25, 2011 7:05 PM (in response to The Feldkircher)Thank you for reply and assistance.
I was doing some testing on my side regarding the size and if I do a single box rotaing ad, it will be 180 W x 220 H
If I do the banner style it will be 540 W x 220 H that will have 3 boxes similar to this:
Where the images will rotate right to left every 10 seconds and repeat once they have reach the last item.
The image holders will be 100 x 125
The fields that will change will be:
Name - Ex. Clear, 6" Polycarbonate Bud Vases, 12 Pack
Price - Ex. $26.28
Brand - Ex. Cambro: BV6CW-135
Image - URL http://www.deiequipment.com/core/media/media.nl?id=4239&c=562544&h=d2979ac8391cf36bfcb3
I am using Flash Professional CS5, I am not too familiar with the actionscripts yet, but I have done programming in the past so I can do research on how to work with those.
Once again, thank you for your help!
-
3. Re: Create a Slideshow that pulls information from a database
The Feldkircher Apr 26, 2011 2:58 AM (in response to deisouss)Hi
OK, I'll do the single version and you can alter it to the longer version if you wish.
Give me a day or so and I should have something for you.
ps. Can you give me a Product Link URL example.
The Feldkircher.
-
4. Re: Create a Slideshow that pulls information from a database
deisouss Apr 26, 2011 9:41 AM (in response to The Feldkircher)Thank you so much! I am really grateful for all your help
-
5. Re: Create a Slideshow that pulls information from a database
The Feldkircher Apr 27, 2011 3:18 AM (in response to deisouss)OK
You can see a demo here: http://demo.thefeldkircher.org/forum/rotator.swf
For some reason I can't explain yet, there should be a control panel at the bottom of the stage but it doesn't appear when online.
Works Perfect in the Flash IDE, I still have to work on some of the next/previous logic and a refresh function but its getting there.
Hope its somewhere close to what you need
The Feldkircher
-
6. Re: Create a Slideshow that pulls information from a database
deisouss Apr 27, 2011 6:22 AM (in response to The Feldkircher)That is exactly what I need! Thank you so much! That was fast, and you are good. It took me 2 days and a headache to do just the rotating banner with no text.
Please let me know once it's done and if there is anything I can do as a token of appreciation.
-
7. Re: Create a Slideshow that pulls information from a database
The Feldkircher Apr 27, 2011 9:32 AM (in response to deisouss)Hi
No Problem, I actually enjoy doing this type of stuff.....
Ok, I have a slightly different link but it now works has designed: http://demo.thefeldkircher.org/forum/
Previous/Next now work within the control Panel, refresh is not implemented yet. Not sure you need this anyway,
because everytime the page is refreshed the rotator will refresh.
Let me know what you think.
The Feldkircher.
-
8. Re: Create a Slideshow that pulls information from a database
deisouss Apr 27, 2011 1:04 PM (in response to The Feldkircher)It's perfect! it's just like you read my mind, I love the layout and everything. I don't need a refresh button, the navigation is more than enough... just perfect.
So just one question, when I need to update it I will just update the database with the new fields correct?
Thanks
-
9. Re: Create a Slideshow that pulls information from a database
The Feldkircher Apr 27, 2011 2:58 PM (in response to deisouss)Glad you like it.
Yes, exactly - simply add/edit/delete your product list then load/refresh the page the rotator is on and Bingo.
I'll put a zip file on my Blog sometime tomorrow, and you can download it from there with usage instructions.
So please mark this discussion has answered, Thanx.
The Feldkircher
-
10. Re: Create a Slideshow that pulls information from a database
deisouss Apr 27, 2011 5:39 PM (in response to The Feldkircher)Thank you for all your help


