require 'vendor/autoload.php';

$database = new Database('host', 'dbname', 'username', 'password'); # connect to database

# select all records from table
$database->select('tableName');
# apply where condition while selecting records from table where condtion can be string/array
$database->select('tableName', 'id = 5');
#multiple condition
$database->select('tableName', array(id => 5, age => 23));
#limit the records
$database->select('tableName', 'id = 5', $limit=5);
#insert the records
$database->insert('table',array(field1=>value1, field2=>value2))
#update the records
$database->update('table',array(field1=>value1, field2=>value2), 'condition_field = 2')
#delete the records
$database->delete('table', 'condition_field = 2')
$database->delete('table', array('condition_field => [1,2]))