$sql = "SELECT * FROM table ORDER by id";
$rows = db_array($sql); //db opened automatically based on $CONFIG, errors handled automatically
foreach ($rows as $k => $row) {
    printf ("%s (%s)\n", $row["Field1"], $row["Field2"]);
}

$link = mysqli_connect("localhost", "my_user", "my_password", "world"); //connect
if (mysqli_connect_errno()) { //check connection
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
$query = "SELECT * FROM table ORDER by id";
if ($result = mysqli_query($link, $query)) {
    while ($row = mysqli_fetch_assoc($result)) { //fetch associative array
        printf ("%s (%s)\n", $row["Field1"], $row["Field2"]);
    }
    mysqli_free_result($result); //free result set
}
mysqli_close($link); //close connection

$CONFIG = array(
    'DB'    => array(
                'DBNAME'    => 'your_database_name',
                'USER'      => 'your_database_user',
                'PWD'       => 'password',
                'HOST'      => 'localhost', //localhost or other host
                'PORT'      => '', //if empty default MySQL port used
                ),
);

#get one field value
$users_ctr = db_value('select count(*) from users');

#get one field value with condition
$where = array(
    'id' => 1,
);
$email = db_value('user', $where, 'email');

#get count of rows value with condition
$where = array(
    'status' => 0,
);
$active_users_ctr = db_value('user', $where, 'count(*)');

#get one table row
$id=1;
$row = db_row("users", array('id' => $id));
$row = db_row("select * from users where id=".dbqi($id));

#get one table row with condition and order by
$row = db_row("users", array('status' => 0), 'id desc');

#get all table records
$rows = db_array('select * from users');
$rows = db_array('users', array());

#get all table records with condition
$status=0;
$rows = db_array('select * from users where status='.dbqi($status));
$rows = db_array('users', array('status' => 0));
$rows = db_array('select * from users where email='.dbq('[email protected]'));
$rows = db_array('users', array('email' => '[email protected]'));

#get all table records with condition, order by 'id desc' and limit 2
$rows = db_array("users", array('status' => 0), 'id desc', 2);

#get first column all values
$ids = db_col("select id from users");

#get named column all values with condition and order
$emails = db_col("users", array('status' => 0), 'email', 'id desc');

#raw select query execution
$res = db_query("select * from users");
$rows = $res->fetch_all();
$res->free();

#raw non-select query execution
db_exec("update users set status=0");

#insert a row
$vars=array(
    'nick'   => 'Jon',
    'email'  => '[email protected]',
);
$new_id=db_insert('users', $vars);

#replace a row (by primary or unique key)
$vars=array(
    'nick'   => 'John',
    'email'  => '[email protected]',
);
$new_id=db_insert('users', $vars, array('replace'=>true));

#insert with options - ignore and no_identity
$vars=array(
    'users_id'   => 1,
    'options_id'  => 23,
);
db_insert('users_options', $vars, array('ignore'=>true, 'no_identity'=>true));

#multi-rows insert
$vars=array(
    array(
        'nick'   => 'John',
        'email'  => '[email protected]',
    ),
    array(
        'nick'   => 'Bill',
        'email'  => '[email protected]',
    ),
    array(
        'nick'   => 'Robert',
        'email'  => '[email protected]',
    ),
);
db_insert('users', $vars);

#update record by primary key
$id=1;
$vars=array(
    'nick'   => 'Jon',
    'email'  => '[email protected]',
);
db_update('users', $vars, $id);

#update record by column key
$email=1;
$vars=array(
    'nick'   => 'Jon',
    'upd_time'   => '~!now()', #will set upd_time=now()
);
db_update('users', $vars, $email, 'email');

#update record by column key with additonal set/where
$email='[email protected]';
$vars=array(
    'nick'   => 'Jon',
);
db_update('users', $vars, $email, 'email', ', upd_time=now()', ' and status=0');

#update record by where
$vars=array(
    'nick'   => 'John',
    'upd_time'   => '~!now()', #will set upd_time=now()
);
$where=array(
    'email'  => '[email protected]',
    'status' => 0,
)
db_update('users', $vars, $where);

#check if record exists for particular field/value
$is_exists=db_is_record_exists('users', '[email protected]', 'email');

#check if record exists for particular field/value and NOT with other id
$is_exists=db_is_record_exists('users', '[email protected]', 'email', 1);  #will check: where email='[email protected]' and id<>1

#check if record exists for particular field/value and NOT with other field/value
$is_exists=db_is_record_exists('users', '[email protected]', 'email', 'John', 'nick');  #will check: where email='[email protected]' and nick<>'John'

$db = new DB(); //if no params passed, db connection settings read from global $CONFIG as described above

//or pass connection settings explicitly
$dbconfig=array(
    'DBNAME'    => 'your_database_name',
    'USER'      => 'your_database_user',
    'PWD'       => 'password',
    'HOST'      => 'localhost', //localhost or other host
    'PORT'      => '', //if empty default MySQL port used
)
$db = new DB($dbconfig);

$db->connect(); //actually no need, will be done automatically with first query

//methods are similar as with procedural API
$db->value($sql);
$db->value($table_name, $where[, $field_name]);
$db->value($table_name, $where, 'count(*)');

$db->row($sql);
$db->row($table_name, $where [, $orderby]);

$db->array($sql);
$db->array($table_name, $where [[, $orderby], $limit]);

$db->col($sql);
$db->col($table_name, $where [, $field_name [, $orderby]]);

$db->query($sql);
$db->exec($sql);

$db->insert($table_name, $data [, $options]);

$db->update($table_name, $data, $id);
$db->update($table_name, $data, $id, $id_column_name [[, $more_set], $more_where]);
$db->update($table_name, $data, $where);

$db->delete($table_name, $id [[, $id_column_name = 'id'], $more_where='']);

$db->is_record_exists($table_name, $value, $field [, $not_value [, $not_field]]);

$db->get_identity();
$db->quote($value);