Select, Insert, Update and Delete in CodeIgniter

Select, Insert, Update and Delete in CodeIgniter — a practical guide to CodeIgniter CRUD queries with clear examples you can reuse in real projects.

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

Short description

These four operations power most CRUD apps. Prefer Query Builder or Models for everyday work.

CRUD with Query Builder

$builder = $db->table('posts');

$builder->insert(['title' => 'Hello', 'body' => 'World']);
$builder->where('id', 1)->update(['title' => 'Updated']);
$row = $builder->where('id', 1)->get()->getRowArray();
$builder->where('id', 1)->delete();