Updated: 06/12/2008

Combine XML, Files and SQLite with PHP 5

This example shows you how to do it if you have no MySql DBMS at hand and a not to extensive amount of data to expect. The XML file (holds all basic data we want to make available in the administration by choice), the text file will handle all the chosen data and the SQLite will contain all data submitted from users - as an extra we want to trigger the most important actions as data inserts and changes in text files with error_log(). PHP has everything you need: SimpleXML and XPath to handle the XML data, the fopen-flock-fwrite-fclose functions to handle text files and the SQLite statements and features to handle database content. A configuration class concerns about the connections, a debugger class writes the log messages and a exception class of one's own secures that text files are always in fine read and write condition or checks if the submitted data has been manipulated. The function sqlite_escape_string prevents from submitting harmful code in the SQLite database.

• Categories
  • PHP →
  • Scripts and Programs →
  • XML and PHP
• Tags
  • and php,
  • class xml php,
  • function php,
  • mysql and php,
  • mysql example,
  • mysql php,
  • php basic,
  • php class,
  • php database class,
  • php example,
  • php mysql,
  • php mysql example,
  • php mysql xml,
  • php text database,
  • php to xml,
  • php xml,
  • php xml class,
  • php xml database,
  • php xml mysql,
  • sqlite,
  • text database php,
  • xml and php,
  • xml database example,
  • xml in php,
  • xml mysql php,
  • xml php,
  • xml php class,
  • xml php mysql,
  • xml to php,
  • xpath
  • ...
• Platforms
  • Windows
• Licenses
  • Freeware
• Author
  • Claudio Biesele