This content has been marked as final. Show 2 replies
Is there any way to set something like this up so once they input names into the database that it will automatically update?
the very PHP file which contains the Export XML behaviour can usually be used as XML data source for whatever 3rd party application, as it´s supposed to instantly output all recordsets resulting from a query like "SELECT * from customer_table" as array of XML root/child elements -- means that everytime your Flash file requests (aka loads) this PHP file, the database table will get queried anew.
I´m a little confused about some things:
I used the export XML from ADDT on the insert and it kind of worked
what do you mean with "on the insert" ?
but it asked me where to save the file and that wont work for the client
the PHP file will of course have to be stored somewhere on the server in order to connect to the database and to retrieve the records, so what exactly doesn´t work for your client ?
Adobe Community Expert, Dreamweaver
Thank you for replying to my cry for help. As with another issue I had recently, I ended up figuring it out after I posted my initial thread.
What happened is that I had an insert form for the client to use to input in new data to the db. I placed the export as XML SB on that same page, so when it went to insert into the db, it then exported a file as well. This is what didnt work as it asked me where to save the file. The client wont have access to the hosting account so they can save it to the correct place.
So what I did was made a page with a recordset then applied the export as XML server behavior. Then in my flash file I used this page as the source for the XML information and viola! It worked. So simple but I would have never thought of it on my own...I found a tutorial on creativecow.com that did something similar and that showed me what to do.
Again, many thanks for your help.