PHP Classes
elePHPant
Icontem

File: test.php

Recommend this page to a friend!
  Classes of Laurence  >  DXS XmlDB  >  test.php  >  Download  
File: test.php
Role: Example script
Content type: text/plain
Description: Example script
Class: DXS XmlDB
Manipulate databases stored in XML files using SQL
Author: By
Last change:
Date: 8 months ago
Size: 907 bytes
 

Contents

Class file image Download
<?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 />';
}
?>