Quick Queries

F-engines "quick queries" is a set of functions that allows traditional sql sintax abstraction and contributes with some benefit such as safer queries. This is because the values are escaped automatically by the system.

Unlike active record database pattern, these functions have no perceptible impact in application performance or memory usage.

Selecting Data

Retrieve all records from a table

$table = 'users';
$fields = '*';
$this->db->f_select(table,$fields);

Where clauses

$table = 'users';
$fields = 'users.idu, users.name ,users.lastname';
$where = array('users.active' => '1', 'name != "admin" ');
$extra = 'order by idu desc';

$this->db->f_select(table,$fields,$where,$extra);

LIKE clauses

$table = 'users';
$fields = 'users.idu, users.name ,users.lastname';
$where = array('users.active' => '1',"users.name like '%m%' ");
$extra = array('order by idu desc','limit 5');

$this->db->f_select(table,$fields,$where,$extra);

Joins

$table = 'users LEFT JOIN comments ON users.idu = comments.iduser';
$fields = 'users.idu, users.name ,users.lastname,comments.*';
$where = array('users.idu' => '1');

$this->db->f_select(table,$fields,$where);

Inserting Data

$data = array(
	'name' => $_POST["nombre"],
	'lastname' => $_POST["lastname"]
);

$this->db->f_insert('users',$data);

Updating Data

$data = array(
	'name' => $_POST["nombre"],
	'lastname' => $_POST["lastname"]
);				
$where = array('users.idu' => "1");

$this->db->f_update('users',$data,$where);

Deleting Data


$where = array(
	'users.idu' => "1"
);
//optional:
$limit = 1;


$this->db->f_delete('users',$where,$limit);