Reference - class DBE_Database

Methods

constructor Creates a new DB Engine database object
 

Tables

create Creates a new table
exists Checks if a table exists
verify Verifies a table (unique, numeric or non-numeric fields)
clear Clears a table
drop Deletes a table
 

Records

fetch Fetches records (accepts Where clauses, Sorts and Joints)
insert Inserts a new record (accepts auto-increment fields)
update Updates records (accepts Where clauses and Joints)
delete Deletes records (accepts Where clauses and Joints)
fastFetch Fetches records (faster with low ressources)
fastUpdate Updates records (faster with low ressources)
count Counts records
 

Locks

lock Locks tables
unlock Unlocks tables
 

Information

Tables Returns information on the tables
FieldNames Returns field names
 
 
 

Debug

DBE_Tables Returns HTML with tables information (for debug purpose)
DBE_Table Returns HTML with table content (for debug purpose)
DBE_Styles Return CSS for the DBE_Style class (for debug purpose)
 
 
 

Syntaxes

Where clauses Where clauses syntax (accepts Joints)
Sorts Sorts syntax (accepts Joints)
Joints Joints syntax
Updates Updates syntax
 
 
 

Constants

DBE_VERSION DB Engine version
DBE_CREATE Creates a new database (for constructor)
DBE_DEBUG Debug mode: show warnings (for constructor)
DBE_OVERWRITE Overwrites existing tables (for create method)
DBE_UNIQUE Requests a unique record result (for fastFetch method)
DBE_FS Field separator
DBE_RS Record separator
DBE_SUBDIR Scans sub-directories (for Table method)
 
 
 

Reserved names

DBE_FILEHANDLE constant name (internal use only)
DBE_FILELOCKED constant name (internal use only)
DBE_FIELDNAMES constant name (internal use only)
DBE_FIELDINDEXES constant name (internal use only)
DBE_RECORDSIZE constant name (internal use only)
DBE_LOGSIZE constant name (internal use only)
 
DBE_clean function name (internal use only)
DBE_cleanField function name (internal use only)
DBE_cleanFieldName function name (internal use only)
DBE_transpose function name (internal use only)
 
 
 

Usage

include ('dbengine.inc.php');
include ('dbengine.debug.inc.php');   // optionnal  

$iDBE = new DBE_Database('database/');

echo '<pre>';
print_r ($iDBE->Tables());
echo '</pre>';

echo DBE_Tables ($iDBE);