I don't know if anyone can help me with this. But can anyone tell me how can I map an XML script into mysql database? Lets say the web service provider has a XML script that returns the hotel classifications. Instead of running this script everytime I run a search query, I want it to save into the database and use the database table instead of the XML script. Can anyone help me with this?
You shouldn't work with XML from a webservice directly. Use a proxy class which automatically serialize and desearialize the XML for you into a "Hotel" object.
Put your XMl into a SimpleXMLElement object. You can find an example of how to do that via my answer here.