Introduction
Basic Concepts
Understanding Routing
Intercepting Requests
Module Fundamentals
Database Operations
Templates
Helpers
Form Handling
Form Validation
Working With Files
Image Manipulation
Working With Dates & Times
Language Control
Authorization & Authentication
Database Interaction Methods
The db module contains one file: modules/db/Db.php.
Inside lives a single, no-BS PHP class packed with every database method you’ll ever need for database interaction.
Use it exactly like any other module:
$this->db->get();
$this->db->insert($data);
$this->db->query($sql);
No magic. No hidden layers. Just Native PHP doing what it does best.
All The Methods
Everything you need is right here. Click any method for full popup docs. Or just open the file and read the source.
Data Retrieval
- get()
- get_where()
- get_where_custom()
- get_one_where()
- get_many_where()
- get_where_in()
- get_max()
Data Manipulation
- insert()
- insert_batch()
- update()
- update_where()
- delete()
<?php
echo 'hello';
?>
Analysis & Management
- count()
- count_where()
- count_rows()
- describe_table()
- table_exists()
- get_all_tables()
- resequence_ids()
Raw / Custom Queries
- query()
- query_bind()
Seriously: ignore this page and open modules/db/Db.php.
The source code is the only documentation that you'll ever need!