A client of mine wants me to build him a new personal website which has all of the articles he’s written. I’ve created the database already and I asked his previous host for a dump of his old database. (He’s got like 140 articles and I really don’t want to insert them manually). They sent me an XML file. I’m at a loss though, as I don’t know how to insert that data into his new MySQL database.
Can anyone provide any instructions on how to do this? Keep in mind I don’t know too much about XML. I think I understand the jest of it: Create a loop in PHP which extracts each piece of data from the XML, sets it equal to a variable, then inserts those variables as normal into the database. Problem is, I don’t know how to interact with XML using PHP. Are there any tutorials, programs, or scripts out there that can help me out or do this?