Introduction
Providing necessary functions for using database
Usually you don't need to use this DB_pdo class. Try to use Model class instead.
How to use
You can load DB_pdo class through Application::getClass method.
$database = $this->getClass('DB_pdo');
// Select query
$result = $database->select('table_name')->execute()->all();
Methods
📄️ DB_pdo::select
Set select query
📄️ DB_pdo::count
Set select count query
📄️ DB_pdo::insert
Set insert query
📄️ DB_pdo::update
Set update query
📄️ DB_pdo::delete
Set delete query
📄️ DB_pdo::truncate
Set truncate query
📄️ DB_pdo::createTable
Set create table query
📄️ DB_pdo::createIndex
Set create index query
📄️ DB_pdo::alterAddColumn
Set create alter add column query
📄️ DB_pdo::alterRenameTo
Set create alter rename to query
📄️ DB_pdo::dropTable
Set create drop table query
📄️ DB_pdo::dropIndex
Set create drop index query
📄️ DB_pdo::pragma
Set pragma query
📄️ DB_pdo::setGroup
Set group query
📄️ DB_pdo::setItem
Set query item values
📄️ DB_pdo::setLimit
Set limit value
📄️ DB_pdo::setOrder
Set order value
📄️ DB_pdo::setQuery
Set query string directly
📄️ DB_pdo::setWhere
Set where condition
📄️ DB_pdo::setHaving
Set having condition
📄️ DB_pdo::setJoin
Set join table
📄️ DB_pdo::setOn
Set on query for joined table
📄️ DB_pdo::disabledRegularUseQuery
Disable automatic append query flag
📄️ DB_pdo::unsetRegularUseQuery
Disable automatic append query for a current query flag
📄️ DB_pdo::unsetRegularUseQueryForTable
Disable automatic append query of the table for a current query flag
📄️ DB_pdo::setInitQueryFlag
Enable reset query flag
📄️ DB_pdo::unsetInitQueryFlag
Disable reset query flag
📄️ DB_pdo::execute
Execute built query
📄️ DB_pdo::compile
Compile built query (not execute)
📄️ DB_pdo::all
Get all the result of executed select query
📄️ DB_pdo::one
Shift the result of executed select query
📄️ DB_pdo::id
Get the specific column's list of executed select query
📄️ DB_pdo::simpleArray
Get the specific column's key and value array of executed select query
📄️ DB_pdo::getAffectedRow
Get affected row number of executed update query
📄️ DB_pdo::getLastIndexId
Get the last inserted id of executed insert query
📄️ DB_pdo::getLastQuery
Get the last executed query for debugging
📄️ DB_pdo::getLastQueryDebug
Get the last executed query and parameter separately for debugging
📄️ DB_pdo::getReturnCode
Get return code of the last executed query
📄️ DB_pdo::masterServer
Connect to master server
📄️ DB_pdo::slaveServer
Connect to slave server