DByte\DB::query PHP Method

query() static public method

Prepare and send a query returning the PDOStatement
static public query ( string $query, array $params = NULL ) : object | null
$query string query string
$params array query parameters
return object | null
    static function query($query, $params = NULL)
    {
        $statement = static::$c->prepare(DB::$q[] = strtr($query, '`', DB::$i));
        $statement->execute($params);
        return $statement;
    }

Usage Example

Beispiel #1
0
var_dump($result);
$user = array('username' => 'John', 'email' => '*****@*****.**', 'created' => time());
$result = DB::insert('users', $user);
var_dump($result);
$user = array('username' => 'Bobb', 'email' => '*****@*****.**', 'created' => time());
$result = DB::insert('users', $user);
var_dump($result);
$user = array('username' => 'Troll', 'email' => '*****@*****.**', 'created' => time());
$result = DB::insert('users', $user);
var_dump($result);
// Oops! We got Bob's info wrong! Lets fix it!
$user = array('username' => 'Bob', 'email' => '*****@*****.**');
$result = DB::update('users', $user, 3);
var_dump($result);
// Our moderators say that the "Troll" user needs to be deleted!
$result = DB::query('DELETE FROM users WHERE username = ?', array('Troll'));
var_dump($result);
/*
 * Select Queries
 */
// Count all the users
$result = DB::column('SELECT COUNT(*) FROM `users`');
var_dump('Total users: ' . $result);
br();
// Get user number 2 (John)
$result = DB::row('SELECT * FROM `users` WHERE id = ?', array(3));
var_dump($result);
br();
// Fetch all the users!
$result = DB::fetch('SELECT * FROM `users`');
var_dump($result);