}
$db->where("id", array('1', '2', '3'), 'IN');
$db->get("users");
if ($db->count != 3) {
echo "Invalid users count on where() with in ";
exit;
}
$db->where("id", array('2', '3'), 'between');
$db->get("users");
if ($db->count != 2) {
echo "Invalid users count on where() with between";
exit;
}
///
$db->where("id", 2);
$db->orWhere("customerId", 11);
$r = $db->get("users");
if ($db->count != 2) {
echo "Invalid users count on orWhere()";
exit;
}
///
$db->where("lastName", NULL, '<=>');
$r = $db->get("users");
if ($db->count != 1) {
echo "Invalid users count on null where()";
exit;
}
///
$db->join("users u", "p.userId=u.id", "LEFT");
$db->where("u.login", 'user2');