A platform combines multiple tutorials, projects, documentations, questions and answers for developers
  • Home (current)
  • Documentations
  • About
  • Login
  1. Home
  2. Documentations
  3. CodeIgniter 4
  4. Modeling Data

Modeling Data

CodeIgniter comes with rich tools for modeling and working with your database tables and records.

  • Using CodeIgniter's Model
  • Using Entity Classes

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

User guide: General
AJAX Requests
User guide: Tutorial
Build Your First Application
Conclusion
Create news items
News section
Static pages
Code Modules
User guide: Installation
CodeIgniter Repositories
CodeIgniter URLs
Composer Installation
Configuration
Error Handling
General Topics
Global Functions and Constants
Handling Multiple Environments
Helper Functions
Installation
Logging Information
Managing your Applications
Manual Installation
Running Your App
Troubleshooting
Upgrading From a Previous Version
Web Page Caching
Functions
app_timezone()
cache()
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()
Extending
Authentication
Contributing to CodeIgniter
Creating Core System Classes
Events
Extending CodeIgniter
Extending the Controller
Replacing Common Functions
Outgoing
API Response Trait
Alternate PHP Syntax for View Files
Building Responses
HTML Table Class
HTTP Responses
Localization
Parser
Parser::render()
Parser::renderString()
Parser::setData()
Parser::setDelimiters()
Parser::setVar()
Response
Response::deleteCookie()
Response::getCookies()
Response::getReason()
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
Text
Text Helper
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()
word_censor()
word_limiter()
word_wrap()
URL
URL Helper
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_title()
Concepts
Application Structure
Autoloading Files
CodeIgniter4 Overview
Models, Views, and Controllers
Security Guidelines
Services
Working With HTTP Requests
Global Constants
APPPATH
DAY
DECADE
FCPATH
HOUR
MINUTE
MONTH
ROOTPATH
SECOND
SYSTEMPATH
WEEK
WRITEPATH
YEAR
Array
Array Helper
dot_array_search()
HTML
HTML Helper
audio()
doctype()
embed()
img()
link_tag()
object()
ol()
param()
script_tag()
source()
track()
ul()
video()
Typography
Typography
autoTypography()
formatCharacters()
nl2brExceptPre()
Database
BaseBuilder
BaseBuilder::countAll()
BaseBuilder::countAllResults()
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::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::orderBy()
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::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
Cli
BaseCommand
BaseCommand::call()
BaseCommand::getPad()
BaseCommand::showError()
BaseCommand::showHelp()
CLI Library
CLIRequest Class
Command Line Usage
Custom CLI Commands
Running via the Command Line
Testing
Benchmarking
Debugging Your Application
Generating Test Data
HTTP Feature Testing
Testing
Testing
Testing Controllers
Testing Your Database
Caching
Caching Driver
Inflector
Inflector Helper
camelize()
counted()
dasherize()
humanize()
is_pluralizable()
ordinal()
ordinalize()
pascalize()
plural()
singular()
underscore()
Incoming
Content Negotiation
Controller Filters
Controllers
Controllers and Routing
HTTP Messages
HTTP Method Spoofing
IncomingRequest
IncomingRequest Class
IncomingRequest::getCookie()
IncomingRequest::getGet()
IncomingRequest::getGetPost()
IncomingRequest::getPost()
IncomingRequest::getPostGet()
IncomingRequest::getUserAgent()
IncomingRequest::getVar()
IncomingRequest::isAJAX()
IncomingRequest::isCLI()
IncomingRequest::isSecure()
Message
Message::appendBody()
Message::appendHeader()
Message::getBody()
Message::getHeader()
Message::getHeaderLine()
Message::getHeaders()
Message::getProtocolVersion()
Message::hasHeader()
Message::populateHeaders()
Message::prependHeader()
Message::removeHeader()
Message::setBody()
Message::setHeader()
Message::setProtocolVersion()
RESTful Resource Handling
Request
Request Class
Request::fetchGlobal()
Request::getEnv()
Request::getIPAddress()
Request::getMethod()
Request::getServer()
Request::isValidIP()
Request::setGlobal()
Request::setMethod()
URI Routing
Cookie
Cookie Helper
delete_cookie()
get_cookie()
set_cookie()
Intro
Credits
PSR Compliance
Server Requirements
Welcome to CodeIgniter4
CURLRequest
CURLRequest Class
Dbmgmt
Database Forge Class
Database Migrations
Database Seeding
Forge
Forge::addColumn()
Forge::addField()
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()
Date
Date Helper
now()
timezone_select()
Dates and Times
Dates and Times
Filesystem
Filesystem Helper
delete_files()
directory_map()
get_dir_file_info()
get_file_info()
get_filenames()
octal_permissions()
set_realpath()
symbolic_permissions()
write_file()
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()
Security
Security Class
Security Helper
encode_php_tags()
sanitize_filename()
strip_image_tags()
Encryption Service
EncrypterInterface
EncrypterInterface::decrypt()
EncrypterInterface::encrypt()
Encryption
Encryption Service
Encryption::createKey()
Encryption::initialize()
Test
Test Helper
fake()
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()
Honeypot
Honeypot Class
Image Manipulation
Image Manipulation Class
Models
Modeling Data
Using CodeIgniter’s Model
Working With Entities
setValidationMessage()
setValidationMessages()
setValidationRule()
setValidationRules()
Number
Number Helper
number_to_amount()
number_to_currency()
number_to_roman()
number_to_size()
Pagination
Pagination
Session
Session Library
Throttler
Throttler
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()
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()
Copyright ©2025 TypeError Powered By AnyPost, page cost 109ms.
Privacy Policy