Download MyXML - Work with MySQL+XML

With this PHP5 Class you are now able to: Create an XML file from MySQL Query Insert all XML Content into a MySQL table Create/Insert work as Export/Import! So you have php-friendly way to backup data of a table Create sitemap from a full MySQL table or just a query Easy way to get class-failure errors Easy way to display generated xml (with or without header) and save the data into

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); } 

Testimonials

It took just 5 mins to buy, download & upload the files on my server and get this gem of a script working.

You saved me HOURS and HOURS of work!

The examples were really helpful.

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