5. Select Query

After any select/get function calls amount or returned rows is stored in $count variable

$users = $db->get(‘users’); //contains an Array of all users $users = $db->get(‘users’, 10); //contains an Array 10 users

or select with custom columns set. Functions also could be used

$cols = Array (“id”, “name”, “email”); $users = $db->get (“users”, null, $cols); if ($db->count > 0)

foreach ($users as $user) {
print_r ($user);

}

or select just one row

$db->where (“id”, 1); $user = $db->getOne (“users”); echo $user[‘id’];

$stats = $db->getOne (“users”, “sum(id), count(*) as cnt”); echo “total ”.$stats[‘cnt’]. “users found”;

or select one column value or function result

$count = $db->getValue (“users”, “count(*)”); echo “{$count} users found”;

select one column value or function result from multiple rows:

$logins = $db->getValue (“users”, “login”, null); // select login from users $logins = $db->getValue (“users”, “login”, 5); // select login from users limit 5 foreach ($logins as $login)

echo $login;