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.