Menu
Community /Pin to ProfileBookmark
@NogDogApr 17.2011 — #Not entirely sure what you want/need to do, but there's a good chance you'll want to make use of either the [url=http://php.net/simplexml]SimpleXML[/url] or [url=http://php.net/dom]DOM[/url] extension.@NogDogApr 17.2011 — #If you just need to read and parse the XML, probably SimpleXML. If you actually want to manipulate the data and change/overwrite the file, you'll need to use DOM. @NogDogApr 18.2011 — #If I understand, then I don't see any need to change the XML file/data, just use the applicable names as needed when referring to the XML fields or the DB fields. A crude version might have something like:
XML and PHP help
Hi all,
This is my first post ?, and I am new to PHP!
I am looking for some information on how to edit an xml file, and then take the new file and update my mysql database.
My mysql database has different headers than the xml has, so that is why I need to edit the xml file.
Would this be possible?
Thanks in advance!
Sign in
to post a comment12 Comments(s) ↴
0
@NogDogApr 17.2011 — #Not entirely sure what you want/need to do, but there's a good chance you'll want to make use of either the 0
@NogDogApr 17.2011 — #0
@NogDogApr 18.2011 — #If I understand, then I don't see any need to change the XML file/data, just use the applicable names as needed when referring to the XML fields or the DB fields. A crude version might have something like:[code=php]
$xml = simplexml_load_file($file);
foreach($xml->item as $item) {
$name = mysql_real_escape_string($item->name); // field names happen to match
$price = (float) $item->unit_price; // fields happen to be different
$qty = (int) $item->quantity; // different again
$sql = "
INSERT INTO table_name (name, price, qty)
VALUES ('$name', $price, $qty)
";
mysql_query($sql);
}
[/code]