Home:ALL Converter>Serializing XML data to store in MySQL with PHP

Serializing XML data to store in MySQL with PHP

Ask Time:2012-06-14T11:28:53         Author:Adola

Json Formatter

I have a series of very complex XML files. I need to access these often, so reading .xml files is something of a hangup. I've been considering writing a series of massive SQL statements, but before I begin that massive task, I wanted to know about serializing whole XML files to store as blobs in MySQL.

My intentions: 
XML -> store_into_database()
database -> read_seralized_data($row)
echo -> un_serialize_data($row)

This would allow me to store .xml files that I parse from an onlinedatabse, and only have to do I/O operations once.

or is the the wrong way to do this?

Author:Adola,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/11026272/serializing-xml-data-to-store-in-mysql-with-php
yy