Sqloo is a proprietary library that means Structured Query Language Object Oriented. The purpose of Sqloo is to use PHP to interface with various Database servers, primarily MySQL, in the following ways:
- Develop and maintain a complex database table schemas
- To make developing complex queries easy and more readable
- Enhance rapid application development by allowing a DB framework via the PHP language
And some other things:
Your first example here:
$sqloo = Common::getSqloo();
$query = $sqloo->newQuery();
$user_ref = $query->table( "vo_user" );
$query->column = array(
"display_name" => $user_ref->display_name,
"email" => $user_ref->email,
);
$unescaped_array = array( "current_user_id"=>1);
$query->where[] = $user_ref->id." = :current_user_id";
$query->run( $unescaped_array );
$results = $query->fetchRow();
print_r($results);