MyXML – Work with MySQL+XML (Database Abstractions)

With this PHP5 Class you are now able to:

1. Create an XML file from MySQL Query
2. Insert all XML Content into a MySQL table
3. Create/Insert work as Export/Import! So you have php-friendly way to backup data of a table
4. Create sitemap from a full MySQL table or just a query
5. Easy way to get class-failure errors
6. Easy way to display generated xml (with or without header) and save the data into .xml file
7. Full examples included

Examples

Creating XML from MySQL query:

$xml->SQLtoXML(mysql_query("SELECT * FROM your_table"));
$xml->show(3, 'your_file.xml');

Import a XML content into your MySQL table:

$xml->XMLtoSQL($xml_string, 'your_table');

Creating Sitemap:

$xml->table = 'my_table';
$xml->changefreq = 'changefreq_field';
$xml->lastmod = 'lastmod_field';
$xml->url = 'url_field';
$xml->Sitemap();

$xml->Show(3, 'sitemap.xml');

‘Catching errors’

if($count($xml->errors) > 0) {
echo 'Something went wrong!<br />';
print_r($xml->errors);
}

Rating will be really appreciated.
Questions? Suggestions? Please, don’t doubt to leave a comment!

Download MyXML – Work with MySQL+XML (Database Abstractions)