XML


Create safe xml data. Removes dangerous characters for string.


$xml_safe = XML::safe($xml_unsafe);

Get XML file


$xml_file = XML::loadFile('path/to/file.xml');

DB


Create new database


DB::create('db_name');

Drop database


DB::drop('db_name');

Table


Table construct


$users = new Table('table_name');

Create new table


Table::create('table_name', array('field1', 'field2'));

Delete table


Table::drop('table_name');

Get table


$table = Table::get('table_name');

Get information about table


var_dump($users->info());

Get table fields


var_dump($users->fields());

Add new field


$users->addField('test');

Delete field


$users->deleteField('test');

Add new record


$users->insert(array('login'=>'admin', 'password'=>'pass'));

Select record(s) in table



$records = $users->select('[id=2]');

$records = $users->select(null, 'all');

$records = $users->select(null, 'all', null, array('login'));

$records = $users->select(null, 2, 1);


Delete current record in table


$users->delete(2);

Delete with xPath query record in xml file


$users->deleteWhere('[id=2]');

Update record with xPath query in XML file


$users->updateWhere('[id=2]', array('login'=>'Admin', 'password'=>'new pass'));

Update current record in table


$users->update(1, array('login'=>'Admin','password'=>'new pass'));

Get last record id


echo $users->lastId();

Get count of records


echo $users->count();