BaseConnection.php

Saves our connection settings.

Initializes the database connection/settings.

Close the database connection.

Platform dependent way method for closing the connection.

Create a persistent database connection.

Returns the actual connection object. If both a 'read' and 'write' connection has been specified, you can pass either term in to get that connection. If you pass either alias in and only a single connection is present, it must return the sole connection.

Returns the name of the current database being used.

Set DB Prefix Set's the DB Prefix to something new without needing to reconnect

Returns the database prefix.

The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc)

Sets the Table Aliases to use. These are typically collected during use of the Builder, and set here so queries are built correctly.

Add a table alias to our list.

Executes the query against the database.

Orchestrates a query against the database. Queries must use Database\Statement objects to store the query and build it. This method works with the cache. Should automatically handle different connections for read/write queries if needed.

Performs a basic query against the database. No binding or caching is performed, nor are transactions handled. Simply takes a raw query string and returns the database-specific result id.

Disable Transactions This permits transactions to be disabled at run-time.

Enable/disable Transaction Strict Mode When strict mode is enabled, if you are running multiple groups of transactions, if one group fails all subsequent groups will be rolled back. If strict mode is disabled, each group is treated autonomously, meaning a failure of one group will not affect any others

Start Transaction

If set to true, exceptions are thrown during transactions.

Complete Transaction

Lets you retrieve the transaction flag to determine if it has failed

Begin Transaction

Commit Transaction

Rollback Transaction

Reset transaction status - to restart transactions after strict mode failure

Handle transaction status when a query fails

Begin Transaction

Commit Transaction

Rollback Transaction

Returns a non-shared new instance of the query builder for this connection.

Returns a new instance of the BaseBuilder class with a cleared FROM clause.

Creates a prepared statement with the database that can then be used to execute multiple statements against. Within the closure, you would build the query in any normal way, though the Query Builder is the expected manner. Example: $stmt = $db->prepare(function($db) { return $db->table('users') ->where('id', 1) ->get(); })

Returns the last query's statement object.

Returns a string representation of the last query's statement object.

Returns the time we started to connect to this database in seconds with microseconds. Used by the Debug Toolbar's timeline.

Returns the number of seconds with microseconds that it took to connect to the database. Used by the Debug Toolbar's timeline.

Protect Identifiers This function is used extensively by the Query Builder class, and by a couple functions in this class. It takes a column or table name (optionally with an alias) and inserts the table prefix onto it. Some logic is necessary in order to deal with column names that include the path. Consider a query like this: SELECT hostname.database.table.column AS c FROM hostname.database.table Or a query with aliasing: SELECT m.member_id, m.member_name FROM members AS m Since the column name can include up to four segments (host, DB, table, column) or also have an alias prefix, we need to do a bit of work to figure this out and insert the table prefix (if it exists) in the proper position, and escape only the correct identifiers.

Escape the SQL Identifier This function escapes single identifier.

Returns escaped table name with alias.

Escape the SQL Identifiers This function escapes column and table names

Prepends a database prefix if one exists in configuration

Returns the total number of rows affected by this query.

"Smart" Escape String Escapes data based on type. Sets boolean and null types

Escape String

Escape LIKE String Calls the individual driver for platform specific escaping for LIKE conditions

Platform independent string escape. Will likely be overridden in child classes.

This function enables you to call PHP database functions that are not natively included in CodeIgniter, in a platform independent manner.

Get the prefix of the function to access the DB.

Returns an array of table names

Determine if a particular table exists

Fetch Field Names

Determine if a particular field exists

Returns an object with field data

Returns an object with key data

Returns an object with foreign key data

Converts array of arrays generated by _foreignKeyData() to array of objects array[ {constraint_name} => stdClass[ 'constraint_name' => string, 'table_name' => string, 'column_name' => string[], 'foreign_table_name' => string, 'foreign_column_name' => string[], 'on_delete' => string, 'on_update' => string, 'match' => string ] ]

Disables foreign key checks temporarily.

Enables foreign key checks temporarily.

Allows the engine to be set into a mode where queries are not actually executed, but they are still generated, timed, etc. This is primarily used by the prepared query functionality.

Empties our data cache. Especially helpful during testing.

Determines if the statement is a write-type query or not.

Returns the last error code and message. Must return an array with keys 'code' and 'message':

Insert ID

Generates the SQL for listing tables in a platform-dependent manner.

Generates a platform-specific query string so that the column names can be fetched.

Platform-specific field data information.

Platform-specific index data.

Platform-specific foreign keys data.

Platform-specific SQL statement to disable foreign key checks. If this feature is not supported, return empty string.

Platform-specific SQL statement to enable foreign key checks. If this feature is not supported, return empty string.

Accessor for properties if they exist.

Checker for properties existence.