Table of Contents

Caching
- Caching Driver
Cli
- BaseCommand
- BaseCommand::call()
- BaseCommand::getPad()
- BaseCommand::showError()
- BaseCommand::showHelp()
- CLI Generators
- CLI Library
- CLIRequest Class
- Command Line Usage
- Custom CLI Commands
- Running via the Command Line
Concepts
- Application Structure
- Autoloading Files
- CodeIgniter4 Overview
- Factories
- Models, Views, and Controllers
- Security Guidelines
- Services
- Working With HTTP Requests
Cookie
- Cookie Helper
- delete_cookie()
- get_cookie()
- has_cookie()
- set_cookie()
Cookies
- Cookie
- Cookie::__construct()
- Cookie::fromHeaderString()
- Cookie::getId()
- Cookie::setDefaults()
- Cookie::toArray()
- Cookie::toHeaderString()
- Cookie::withDomain()
- Cookie::withExpired()
- Cookie::withExpires()
- Cookie::withHTTPOnly()
- Cookie::withName()
- Cookie::withNeverExpiring()
- Cookie::withPath()
- Cookie::withPrefix()
- Cookie::withRaw()
- Cookie::withSameSite()
- Cookie::withSecure()
- Cookie::withValue()
- Cookies
- CookieStore
- CookieStore::fromCookieHeaders()
CURLRequest
- CURLRequest Class
Database
- BaseBuilder
- BaseBuilder::countAll()
- BaseBuilder::countAllResults()
- BaseBuilder::db()
- BaseBuilder::decrement()
- BaseBuilder::delete()
- BaseBuilder::distinct()
- BaseBuilder::emptyTable()
- BaseBuilder::from()
- BaseBuilder::get()
- BaseBuilder::getCompiledDelete()
- BaseBuilder::getCompiledInsert()
- BaseBuilder::getCompiledSelect()
- BaseBuilder::getCompiledUpdate()
- BaseBuilder::getWhere()
- BaseBuilder::groupBy()
- BaseBuilder::groupEnd()
- BaseBuilder::groupStart()
- BaseBuilder::having()
- BaseBuilder::havingGroupEnd()
- BaseBuilder::havingGroupStart()
- BaseBuilder::havingIn()
- BaseBuilder::havingLike()
- BaseBuilder::havingNotIn()
- BaseBuilder::increment()
- BaseBuilder::insert()
- BaseBuilder::insertBatch()
- BaseBuilder::join()
- BaseBuilder::like()
- BaseBuilder::limit()
- BaseBuilder::notGroupStart()
- BaseBuilder::notHavingGroupStart()
- BaseBuilder::notHavingLike()
- BaseBuilder::notLike()
- BaseBuilder::offset()
- BaseBuilder::orderBy()
- BaseBuilder::orGroupStart()
- BaseBuilder::orHaving()
- BaseBuilder::orHavingGroupStart()
- BaseBuilder::orHavingIn()
- BaseBuilder::orHavingLike()
- BaseBuilder::orHavingNotIn()
- BaseBuilder::orLike()
- BaseBuilder::orNotGroupStart()
- BaseBuilder::orNotHavingGroupStart()
- BaseBuilder::orNotHavingLike()
- BaseBuilder::orNotLike()
- BaseBuilder::orWhere()
- BaseBuilder::orWhereIn()
- BaseBuilder::orWhereNotIn()
- BaseBuilder::replace()
- BaseBuilder::resetQuery()
- BaseBuilder::select()
- BaseBuilder::selectAvg()
- BaseBuilder::selectCount()
- BaseBuilder::selectMax()
- BaseBuilder::selectMin()
- BaseBuilder::selectSum()
- BaseBuilder::set()
- BaseBuilder::setInsertBatch()
- BaseBuilder::setUpdateBatch()
- BaseBuilder::truncate()
- BaseBuilder::update()
- BaseBuilder::updateBatch()
- BaseBuilder::where()
- BaseBuilder::whereIn()
- BaseBuilder::whereNotIn()
- BaseResult
- BaseResult::dataSeek()
- BaseResult::freeResult()
- BaseResult::getCustomResultObject()
- BaseResult::getCustomRowObject()
- BaseResult::getFieldCount()
- BaseResult::getFieldData()
- BaseResult::getFieldNames()
- BaseResult::getFirstRow()
- BaseResult::getLastRow()
- BaseResult::getNextRow()
- BaseResult::getNumRows()
- BaseResult::getPreviousRow()
- BaseResult::getResult()
- BaseResult::getResultArray()
- BaseResult::getResultObject()
- BaseResult::getRow()
- BaseResult::getRowArray()
- BaseResult::getRowObject()
- BaseResult::getUnbufferedRow()
- BaseResult::setRow()
- Connecting to your Database
- Custom Function Calls
- Database Configuration
- Database Events
- Database Metadata
- Database Quick Start: Example Code
- Generating Query Results
- Queries
- Query Builder Class
- Query Helper Methods
- Transactions
- Utilities
- Working With Databases
Date
- Date Helper
- now()
- timezone_select()
Dbmgmt
- Database Forge Class
- Database Migrations
- Database Seeding
- Forge
- Forge::addColumn()
- Forge::addField()
- Forge::addForeignKey()
- Forge::addKey()
- Forge::addPrimaryKey()
- Forge::addUniqueKey()
- Forge::createDatabase()
- Forge::createTable()
- Forge::dropColumn()
- Forge::dropDatabase()
- Forge::dropTable()
- Forge::modifyColumn()
- Forge::renameTable()
- Managing Databases
- MigrationRunner
- MigrationRunner::findMigrations()
- MigrationRunner::force()
- MigrationRunner::latest()
- MigrationRunner::regress()
- MigrationRunner::setGroup()
- MigrationRunner::setNamespace()
Email
- Email
- Email Class
- Email::attach()
- Email::clear()
- Email::printDebugger()
- Email::send()
- Email::setAltMessage()
- Email::setAttachmentCID()
- Email::setBCC()
- Email::setCC()
- Email::setFrom()
- Email::setMessage()
- Email::setReplyTo()
- Email::setSubject()
- Email::setTo()
Encryption Service
- EncrypterInterface
- EncrypterInterface::decrypt()
- EncrypterInterface::encrypt()
- Encryption
- Encryption Service
- Encryption::createKey()
- Encryption::initialize()
Extending
- Authentication
- Contributing to CodeIgniter
- Creating Core System Classes
- Events
- Extending CodeIgniter
- Extending the Controller
- Replacing Common Functions
Filesystem
- delete_files()
- directory_map()
- directory_mirror()
- Filesystem Helper
- get_dir_file_info()
- get_file_info()
- get_filenames()
- octal_permissions()
- same_file()
- set_realpath()
- symbolic_permissions()
- write_file()
Form
- Form Helper
- form_button()
- form_checkbox()
- form_close()
- form_dropdown()
- form_fieldset()
- form_fieldset_close()
- form_hidden()
- form_input()
- form_label()
- form_multiselect()
- form_open()
- form_open_multipart()
- form_password()
- form_radio()
- form_reset()
- form_submit()
- form_textarea()
- form_upload()
- set_checkbox()
- set_radio()
- set_select()
- set_value()
Functions
- app_timezone()
- cache()
- cookie()
- cookies()
- csrf_field()
- csrf_hash()
- csrf_header()
- csrf_meta()
- csrf_token()
- env()
- esc()
- force_https()
- function_usable()
- helper()
- is_cli()
- is_really_writable()
- lang()
- log_message()
- model()
- old()
- redirect()
- remove_invisible_characters()
- route_to()
- service()
- session()
- single_service()
- slash_item()
- stringify_attributes()
- timer()
- view()
- view_cell()
Global Constants
- APPPATH
- DAY
- DECADE
- FCPATH
- HOUR
- MINUTE
- MONTH
- ROOTPATH
- SECOND
- SYSTEMPATH
- WEEK
- WRITEPATH
- YEAR
Honeypot
- Honeypot Class
HTML
- audio()
- doctype()
- embed()
- HTML Helper
- img()
- img_data()
- link_tag()
- object()
- ol()
- param()
- script_tag()
- source()
- track()
- ul()
- video()
Image Manipulation
- Image Manipulation Class
Incoming
- Content Negotiation
- Controller Filters
- Controllers
- Controllers and Routing
- HTTP Messages
- HTTP Method Spoofing
- IncomingRequest
- IncomingRequest Class
- IncomingRequest::getGet()
- IncomingRequest::getGetPost()
- IncomingRequest::getPath()
- IncomingRequest::getPost()
- IncomingRequest::getPostGet()
- IncomingRequest::getUserAgent()
- IncomingRequest::getVar()
- IncomingRequest::isAJAX()
- IncomingRequest::isCLI()
- IncomingRequest::isSecure()
- IncomingRequest::setPath()
- Message
- Message::appendBody()
- Message::appendHeader()
- Message::getBody()
- Message::getHeaderLine()
- Message::getProtocolVersion()
- Message::hasHeader()
- Message::header()
- Message::headers()
- Message::populateHeaders()
- Message::prependHeader()
- Message::removeHeader()
- Message::setBody()
- Message::setHeader()
- Message::setProtocolVersion()
- Request
- Request Class
- Request::fetchGlobal()
- Request::getEnv()
- Request::getIPAddress()
- Request::getMethod()
- Request::getServer()
- Request::isValidIP()
- Request::setGlobal()
- Request::setMethod()
- RESTful Resource Handling
- URI Routing
Inflector
- camelize()
- counted()
- dasherize()
- humanize()
- Inflector Helper
- is_pluralizable()
- ordinal()
- ordinalize()
- pascalize()
- plural()
- singular()
- underscore()
Intro
- Credits
- PSR Compliance
- Server Requirements
- Welcome to CodeIgniter4
Models
- Modeling Data
- setValidationMessage()
- setValidationMessages()
- setValidationRule()
- setValidationRules()
- Using CodeIgniter’s Model
- Using Entity Classes
Number
- Number Helper
- number_to_amount()
- number_to_currency()
- number_to_roman()
- number_to_size()
Outgoing
- Alternate PHP Syntax for View Files
- API Response Trait
- Building Responses
- HTML Table Class
- HTTP Responses
- Localization
- Parser
- Parser::render()
- Parser::renderString()
- Parser::setData()
- Parser::setDelimiters()
- Parser::setVar()
- Response
- Response::deleteCookie()
- Response::getCookie()
- Response::getCookies()
- Response::getReasonPhrase()
- Response::getStatusCode()
- Response::hasCookie()
- Response::noCache()
- Response::setCache()
- Response::setContentType()
- Response::setCookie()
- Response::setDate()
- Response::setLastModified()
- Response::setStatusCode()
- Table
- Table::addRow()
- Table::clear()
- Table::generate()
- Table::makeColumns()
- Table::setCaption()
- Table::setEmpty()
- Table::setFooting()
- Table::setHeading()
- Table::setTemplate()
- View Cells
- View Layouts
- View Parser
- Views
Pagination
- Pagination
Publisher
- Publisher
Security
- encode_php_tags()
- sanitize_filename()
- Security
- Security Helper
- strip_image_tags()
Session
- Session Library
Test
- fake()
- Test Helper
Testing
- Benchmarking
- Debugging Your Application
- Generating Test Data
- getFilterCaller()
- getFiltersForRoute()
- HTTP Feature Testing
- Mocking System Classes
- Testing
- Testing
- Testing Controllers
- Testing Responses
- Testing Your Database
Text
- alternator()
- ascii_to_entities()
- character_limiter()
- convert_accented_characters()
- ellipsize()
- entities_to_ascii()
- excerpt()
- highlight_code()
- highlight_phrase()
- increment_string()
- quotes_to_entities()
- random_string()
- reduce_double_slashes()
- reduce_multiples()
- strip_quotes()
- strip_slashes()
- Text Helper
- word_censor()
- word_limiter()
- word_wrap()
Throttler
- Throttler
Times and Dates
- Times and Dates
Typography
- autoTypography()
- formatCharacters()
- nl2brExceptPre()
- Typography
URL
- anchor()
- anchor_popup()
- auto_link()
- base_url()
- current_url()
- index_page()
- mailto()
- mb_url_title()
- prep_url()
- previous_url()
- safe_mailto()
- site_url()
- uri_string()
- URL Helper
- url_is()
- url_title()
- url_to()
User Agent
- User Agent Class
- UserAgent
- UserAgent::getAgentString()
- UserAgent::getBrowser()
- UserAgent::getMobile()
- UserAgent::getPlatform()
- UserAgent::getReferrer()
- UserAgent::getRobot()
- UserAgent::getVersion()
- UserAgent::isBrowser()
- UserAgent::isMobile()
- UserAgent::isReferral()
- UserAgent::isRobot()
- UserAgent::parse()
User guide: General
- AJAX Requests
- Code Modules
- CodeIgniter URLs
- Configuration
- Error Handling
- General Topics
- Global Functions and Constants
- Handling Multiple Environments
- Helper Functions
- Logging Information
- Managing your Applications
- Web Page Caching
User guide: Installation
- CodeIgniter Repositories
- Composer Installation
- Installation
- Manual Installation
- Running Your App
- Troubleshooting
- Upgrading From a Previous Version
User guide: Tutorial
- Build Your First Application
- Conclusion
- Create news items
- News section
- Static pages
Validation
- Validation
Working with Files
- Working with Files
Working with Uploaded Files
- Working with Uploaded Files
Working with URIs
- Working with URIs
XML
- XML Helper
- xml_convert()

Working With Databases

CodeIgniter comes with a full-featured and very fast abstracted database class that supports both traditional structures and Query Builder patterns. The database functions offer clear, simple syntax.

© 2014–2020 British Columbia Institute of Technology
Licensed under the MIT License.
https://codeigniter.com/user_guide/database/index.html