Flash & PHP

[qokepow]

I have a dynamic photo gallery running on PHP and MySQL, and want to know If i can dynamically load all the images into flash. I know this is possible, but so far everything I've found on the subject of "PHP and Flash" has been pretty vague and not of much use. Does any have any help or any good resources about such a topic?

[sneakyimp]

you're going to need a more specific question than that to get any answers here. what, in particular, are you having problems with?

[etully]

Your question has very little to do with Flash. The key question is: What does the HTML look like that sets up the Flash movie to play? If the HTML has some sort of place where it lists the names of the files that should be in the photo gallery, then all you have to do is use PHP to build that list dynamically instead of writing static HTML that calls the same images every time. Can you show us a sample of the <embed> command that includes the Flash movie? That's likely where the images are defined. Though it's possible that the images are defined in an external config file... in which case you'd simply have to make that file dynamically built.

[sneakyimp]

It's also possible that the flash file will query the server directly, in which case you'll need a php script to return a list of files. This might be more reliable as the flash<-->html variable communication doesn't work so well with javascript.

[qokepow]

Ok, I have a php/mysql backend for the user to upload and categorise their images. A thumbnail is automatically created and the following details are stored in the database:

id, title, description, filename, thumbnail_filename, category, tags

I already have the the php working for the gallery, with, for example a user clicking on "portrait", php returns the images from a statement such as

SELECT * FROM gallery WHERE category = portrait

The images are then echo'd out as list items, eg:

<li><?=$title?><br />
<img src="<?=$filename?>" />
</li>

This is all working fine, but I want to have these images in a flash file. I understand I need to echo these variables into Flash, but what's the best way of doing this. and how do I loop through each result and display each picture in Flash?