PHP Classes

DXS XmlDB: Manipulate databases stored in XML files using SQL

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

Author

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  
Name: Laurence Perales is available for providing paid consulting. Contact Laurence Perales .
Classes: 3 packages by
Country: Peru Peru
Age: 32
All time rank: 428514 in Peru Peru
Week rank: 411 Up3 in Peru Peru Up
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  
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

  Files folder image Files  /  dxs-xmldb  
File Role Description
  Plain text file dxs.xmldb.class.php Class Class source
  Plain text file dxs.xmldb.dbms.class.php Class Class source
  Plain text file dxs.xmldb.table.class.php Class Class source

 Version Control Unique User Downloads Download Rankings  
 100%
Total:105
This week:1
All time:9,696
This week:560Up