Query Builder in CodeIgniter

Query Builder in CodeIgniter — a practical guide to CodeIgniter query builder with clear examples you can reuse in real projects.

CodeIgniter Tutorial Series (31/74). Prefer one article? Read the complete CodeIgniter tutorial.

Short description

Query Builder helps prevent SQL mistakes and supports chaining for select/where/join/order.

Query Builder select

$db = ConfigDatabase::connect();
$posts = $db->table('posts')
    ->select('id, title, created_at')
    ->where('is_published', 1)
    ->orderBy('id', 'DESC')
    ->get()
    ->getResultArray();