Monstra XMLDB API
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();