Database: Using PDO
<?php
// Get PDO instance from default connection
$pdo = DB::connection()->getPdo();
// ... or from specific connection
$pdo = DB::connection('mysql')->getPdo();
// Do a query, and fetch records
$sql = "select * from users";
$stmt = $pdo->query($sql);
while ($rec = $stmt->fetch(PDO::FETCH_ASSOC)) {
print_r($rec);
}
// Get one record
$stmt = $pdo->query("select * from users limit 1");
$rec = $stmt->fetch();
print_r($rec[0]);
?>