PHP Sql Query Class

Update: This is outdated, please use prepared statements / PHP Data Objects (PDO).
http://code.google.com/p/class-query/ Class Query makes it easy to run a query. Simply chain the query parameters with ->run(); as the last parameter.
// Basic select
$q = new Query;
$q
    ->select()
    ->from('`user`')
    ->run();
 
// -> SELECT * FROM `user`
// Select using page
$q = new Query;
$q
    ->select()
    ->from('`user`')
    ->limit(20)
    ->page(3)
    ->run();
 
// -> SELECT * FROM `user` LIMIT 60,20
Query using more advanced parameters:
require 'class-query.php';
 
$user_id = 123456;
$q = new Query;
$q
    ->select(
        array(
            '`user`.`user_id`',
            '`user`.`name`',
            '`user`.`email`'
        )
    )
    ->from('`user`')
    ->where_equal_to(
        array(
            '`user_id`'=>$user_id
        )
    )
    ->limit(1)
    ->run();
if ($q) {
    $user = $q->get_selected();
    echo
        'Hello '.$user['name'].',
'.
        'Your email is currently set to '.$user['name'].' '.
        'and your user id is '.$user['user_id'].'.
'.
        '';
} else {
    echo 'Sorry, user '.$user_id.' not found.';
}
Class Query http://code.google.com/p/class-query/
This post is available on GitHub.
Posted .

Comments

Leave a Reply