Question
XML/SPRY & MySQL...Need help please!
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?
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?
AdChoices