WorldWideScripts.net Delivering the best Add-Ons in more than 37 languages.

中文(简体), English, हिन्दी/हिंदी, Español/Castellano, العربية, Русский язык, Français, 中文 (台灣), বাংলা, Bahasa Indonesia, اردو, Português, Deutsch, Bahasa Melayu (بهاس ملايو‎), 日本語 (にほんご), فارسی, Italiano, తెలుగు, Türkçe, ગુજરાતી, Język polski/polszczyzna, Tiếng Việt, ಕನ್ನಡ, Українська мова, ไทย
PHP Scripts / Database Abstractions

MyXML - Work with MySQL+XML

— Add-On to WorldWideScripts.net

Subscribe to our feed to stay up to date!

New! Follow us as you want it!


MyXML - Work with MySQL+XML - CodeCanyon Item for Sale

Ads

Ad: Bluehost hosting
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!

Download
Other components in this categoryAll components of this author
CommentsFrequently asked questions and answers

Properties

Created:
25 October 11

Last Update:
N/A

Files Included:
JavaScript JS, HTML, XML, CSS, PHP, SQL

Software Version:
PHP 5.x

Keywords

eCommerce, eCommerce, All Items, class, data, domdocument, easy, export, import, manage, mysql, parse, php5, save, sql, xml