Performing queries

There are two methods that allow the passing of raw SQL statements and parameters, query() and raw(). Both expect the SQL statement as the first parameter and an array of values as the second.

Using query()

The query() method tracks the PDOStatment internally allowing you to continue using the DB methods.

// query(String $sql, Array $params) : DB

$db->query('SELECT * FROM `movies` WHERE `year`=? AND `rating`>?', [2020, 8]);
echo $db->getRowCount();

Using raw()

The raw() method returns the PDOStatement for you to manage.

// raw(String $sql, Array $params) : PDOStatement

$stmt = $db->raw('SELECT * FROM `movies` WHERE `year`=? AND `rating`>?', [2020, 8]);
foreach ($stmt->fetchAll() as $row) {
    echo $row->title;
}