PHP Classes

DXS XmlDB: Manipulate databases stored in XML files using SQL

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 105 All time: 9,729 This week: 455Up
Version License PHP version Categories
dxs-xmldb 1.0The PHP License5.3XML, PHP 5, Databases, Files and Folders
Description 

Author

Laurence Perales

This package can manipulate databases stored in XML files using SQL.

It can execute SQL statements to create, retrieve, update and delete database records.

The manipulated data records are stored in XML files.

The XML file is structured like a HTML table. If it is necessary to print the data, the XML file can be displayed and printed as HTML and styled using configurable CSS styles.

Innovation Award
PHP Programming Innovation award nominee
October 2018
Number 5		 XML is a format that is often used to store structured data.

This package uses XML files are storage containers for databases that can be accessed using SQL statements.

Since XML can also be rendered in Web browsers, the database files in XML format generated by this package can also be viewed in browser, using a given CSS code to customize their presentation.

Manuel Lemos
Picture of Laurence Perales
  Performance   Level  

Level 1 Star

 Innovation award
Innovation award
Nominee: 3x

 

Example

<?php
require_once 'dxs-xmldb/dxs.xmldb.table.class.php';
require_once 'dxs-xmldb/dxs.xmldb.dbms.class.php';

$XMLDB = new xmldb_dbms();
$XMLTB = new xmldb_table();

//$XMLDB->dropTable('test');
$XMLDB->executeQuery('DROP TABLE test');

//$cols = Array('user','pass');
//$XMLDB->createTable('test',$cols);
$XMLDB->executeQuery('CREATE TABLE test(user,pass)');

$rs = $XMLDB->executeQuery('SELECT ALL FROM test');
if( is_array($rs) ){
    echo '<pre>';print_r($rs);echo '</pre>';echo '<br />';
}else{
    echo 'ERROR : ';echo $XMLDB->gtMSG();echo '<br />';
}

//$XMLDB->executeQuery('INSER INTO test (admin,pass) values');

$XMLTB->loadXML('test.xml');
$XMLTB->InsertInto( Array( 'user' => 'lau' , 'pass' => 'test' ) );

$rs = $XMLDB->executeQuery('SELECT ALL FROM test');
if( is_array($rs) ){
    echo '<pre>';print_r($rs);echo '</pre>';echo '<br />';
}else{
    echo 'ERROR : ';echo $XMLDB->gtMSG();echo '<br />';
}
?>

Details

xmldb

PHP Library for use XML as DataBase Storage


  Files folder image Files (6)  
File Role Description
Files folder imagedxs-xmldb (3 files)
Accessible without login Plain text file README.md Doc. Documentation
Accessible without login Plain text file test.php Example Example script
Accessible without login Plain text file test.xml Data Auxiliary data

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloaddxs-xmldb-2018-10-11.zip 6KB
Downloaddxs-xmldb-2018-10-11.tar.gz 4KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:105
This week:0
All time:9,729
This week:455Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.