XML/SPRY & MySQL...Need help please!

Report · Feb 08, 2009

I don't really even know how to title this new message but I know what I would like to do. I am designing a dynamic photo gallery and would like use the Spry/AJAX framework to display my photos on a php web page.

The photos would be uploaded to a MySQL database on the backend thru an insert form. I understand that Spry Datasets have to be associated to an XML file located on the server. I know how to format the XML file manually however I do not know how to update the XML file on the fly. I would like to be able to upload photos to a remote folder on ther server using PHP/MySQL via an 'insert new record' form or an 'update record' form. Once the new photos have been uploaded (or Updated), how can I tell the MySQL database to update the XML file that is associated with Spry table that displays the photos on the frontend?

Report · Feb 08, 2009

zuffster wrote:
> how can I tell the MySQL database to update the XML file
> that is associated with Spry table that displays the photos on the frontend?

You don't. All that you need to do is to generate the XML dynamically by
querying the database. The following page in the Spry samples shows you
how to do it:

http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS4",
"PHP Solutions" & "PHP Object-Oriented Solutions"
http://foundationphp.com/