- model(...) KoclikoDisplay\Models\ContentOwnerModel#128 (46)
- Properties (46)
- Methods (88)
- public pager -> nullmodel('ContentOwnerModel')->pager
- protected db -> CodeIgniter\Database\MySQLi\Connection#102 (45)
- Properties (45)
- Methods (78)
- protected DSN -> string (0) ""
- protected port -> integer 3306
- protected hostname -> string (20) "solisculv32.mysql.db"
- protected username -> string (11) "solisculv32"
- protected password -> string (18) "tybzodpebsu5cexWiq"
- protected database -> string (11) "solisculv32"
- public DBDriver -> string (6) "MySQLi"
- protected subdriver -> null
- protected DBPrefix -> string (0) ""
- protected pConnect -> boolean false
- protected DBDebug -> boolean true
- protected charset -> string (7) "utf8mb4"
- protected DBCollat -> string (18) "utf8mb4_general_ci"
- protected swapPre -> string (0) ""
- protected encrypt -> boolean false
- protected compress -> boolean false
- protected strictOn -> boolean false
- protected failover -> array (0)
- protected lastQuery -> CodeIgniter\Database\Query#130 (10)
- Properties (10)
- Methods (19)
- toString
- protected originalQueryString -> string (100) "SELECT * FROM `content_owner` WHERE `owner_name` = :owner_name: AND `owner_i...
SELECT * FROM `content_owner` WHERE `owner_name` = :owner_name: AND `owner_id` = :owner_id: LIMIT 1
- protected swappedQueryString -> uninitialized
- protected finalQueryString -> string (91) "SELECT * FROM `content_owner` WHERE `owner_name` = 'Actuality' AND `owner_id...
SELECT * FROM `content_owner` WHERE `owner_name` = 'Actuality' AND `owner_id` = 18 LIMIT 1
- protected binds -> array (2)
- Table (2)
- Contents (2)
0 1 owner_name Actuality true owner_id 18 true - owner_name => array (2)
- 0 => string (9) "Actuality"
- 1 => boolean true
- owner_id => array (2)
- 0 => integer 18
- 1 => boolean true
- protected bindMarker -> string (1) "?"
- protected startTime -> double 1773430017.03
- protected endTime -> double 1773430017.0311
- protected errorCode -> null
- protected errorString -> null
- public db -> CodeIgniter\Database\MySQLi\Connection#102 Recursion
- public __construct(CodeIgniter\Database\ConnectionInterface $db)
Defined in .../system/Database/Query.php:98
- public setQuery(string $sql, $binds = null, bool $setEscape = true): $this Sets the raw query string to use for this statement.
/** * Sets the raw query string to use for this statement. * * @param mixed $binds * * @return $this */ Defined in .../system/Database/Query.php:110
- public setBinds(array $binds, bool $setEscape = true): $this Will store the variables to bind into the query later.
/** * Will store the variables to bind into the query later. * * @return $this */ Defined in .../system/Database/Query.php:141
- public getQuery(): string Returns the final, processed query string after binding, etal has been perfor...
/** * Returns the final, processed query string after binding, etal * has been performed. */ Defined in .../system/Database/Query.php:160
- public setDuration(float $start, ?float $end = null): $this Records the execution time of the statement using microtime(true) for it's st...
/** * Records the execution time of the statement using microtime(true) * for it's start and end values. If no end value is present, will * use the current time to determine total duration. * * @return $this */ Defined in .../system/Database/Query.php:176
- public getStartTime(bool $returnRaw = false, int $decimals = 6): float|string Returns the start time in seconds with microseconds.
/** * Returns the start time in seconds with microseconds. * * @return float|string */ Defined in .../system/Database/Query.php:194
- public getDuration(int $decimals = 6): string Returns the duration of this query during execution, or null if the query has...
/** * Returns the duration of this query during execution, or null if * the query has not been executed yet. * * @param int $decimals The accuracy of the returned time. */ Defined in .../system/Database/Query.php:209
- public setError(int $code, string $error): $this Stores the error description that happened for this query.
/** * Stores the error description that happened for this query. * * @return $this */ Defined in .../system/Database/Query.php:219
- public hasError(): bool Reports whether this statement created an error not.
/** * Reports whether this statement created an error not. */ Defined in .../system/Database/Query.php:230
- public getErrorCode(): int Returns the error code created while executing this statement.
/** * Returns the error code created while executing this statement. */ Defined in .../system/Database/Query.php:238
- public getErrorMessage(): string Returns the error message created while executing this statement.
/** * Returns the error message created while executing this statement. */ Defined in .../system/Database/Query.php:246
- public isWriteType(): bool Determines if the statement is a write-type query or not.
/** * Determines if the statement is a write-type query or not. */ Defined in .../system/Database/Query.php:254
- public swapPrefix(string $orig, string $swap): $this Swaps out one table prefix for a new one.
/** * Swaps out one table prefix for a new one. * * @return $this */ Defined in .../system/Database/Query.php:264
- public getOriginalQuery(): string Returns the original SQL that was passed into the system.
/** * Returns the original SQL that was passed into the system. */ Defined in .../system/Database/Query.php:281
- protected compileBinds() Escapes and inserts any binds into the finalQueryString property.
/** * Escapes and inserts any binds into the finalQueryString property. * * @see https://regex101.com/r/EUEhay/5 */ Defined in .../system/Database/Query.php:291
- protected matchNamedBinds(string $sql, array $binds): string Match bindings
/** * Match bindings */ Defined in .../system/Database/Query.php:319
- protected matchSimpleBinds(string $sql, array $binds, int $bindCount, int $ml): string Match bindings
/** * Match bindings */ Defined in .../system/Database/Query.php:343
- public debugToolbarDisplay(): string Returns string to display in debug toolbar
/** * Returns string to display in debug toolbar */ Defined in .../system/Database/Query.php:373
- public __toString(): string Return text representation of the query
/** * Return text representation of the query */ Defined in .../system/Database/Query.php:427
- lastQuery string (91) "SELECT * FROM `content_owner` WHERE `owner_name` = 'Actuality' AND `owner_id...
SELECT * FROM `content_owner` WHERE `owner_name` = 'Actuality' AND `owner_id` = 18 LIMIT 1
- public connID -> mysqli#113 (18)
- Properties (18)
- Methods (43)
- Static methods (1)
- public readonly affected_rows -> integer 1
- public readonly client_info -> string (14) "mysqlnd 8.3.23"
- public readonly client_version -> integer 80323
- public readonly connect_errno -> integer 0
- public readonly connect_error -> null
- public readonly errno -> integer 0
- public readonly error -> string (0) ""
- public readonly error_list -> array (0)
- public readonly field_count -> integer 5
- public readonly host_info -> string (31) "solisculv32.mysql.db via TCP/IP"
- public readonly info -> null
- public readonly insert_id -> integer 0
- public readonly server_info -> string (7) "8.4.7-7"
- public readonly server_version -> integer 80407
- public readonly sqlstate -> string (5) "00000"
- public readonly protocol_version -> integer 10
- public readonly thread_id -> integer 225484
- public readonly warning_count -> integer 0
- public autocommit(bool $enable)
- public character_set_name()
- public close()
- public dump_debug_info()
- public debug(string $options)
- public get_charset()
- public execute_query(string $query, ?array $params = null): mysqli_result|bool
- public get_client_info()
- public get_connection_stats()
- public get_server_info()
- public get_warnings()
- public init()
- public kill(int $process_id)
- public multi_query(string $query)
- public more_results()
- public next_result()
- public ping()
- public prepare(string $query)
- public reap_async_query()
- public real_query(string $query)
- public savepoint(string $name)
- public select_db(string $database)
- public set_charset(string $charset)
- public options(int $option, $value)
- public set_opt(int $option, $value)
- public stat()
- public stmt_init()
- public store_result(int $mode = 0)
- public thread_safe()
- public use_result()
- public refresh(int $flags)
- public resultID -> mysqli_result#131 (5)
- Properties (5)
- Methods (16)
- Iterator
- public current_field -> uninitialized
- public field_count -> uninitialized
- public lengths -> uninitialized
- public num_rows -> uninitialized
- public type -> uninitialized
- public close()
- public free()
- public data_seek(int $offset)
- public fetch_field()
- public fetch_fields()
- public fetch_all(int $mode = 2)
- public fetch_array(int $mode = 3)
- public fetch_assoc()
- public fetch_row()
- public fetch_column(int $column = 0): string|int|float|false|null
- public field_seek(int $index)
- public free_result()
- public getIterator(): Iterator
- mysqli_result Iterator Contents uninitialized Blacklisted
- public protectIdentifiers -> boolean true
- protected reservedIdentifiers -> array (1)
- 0 => string (1) "*"
- public escapeChar -> string (1) "`"
- public likeEscapeStr -> string (13) " ESCAPE '%s' "
- public likeEscapeChar -> string (1) "!"
- protected pregEscapeChar -> array (4)
- 1 => string (1) "`"
- 0 => string (1) "`"
- 3 => string (1) "`"
- 2 => string (1) "`"
- public dataCache -> array (0)
- protected connectTime -> double 1773430016.9987
- protected connectDuration -> double 0.0024290084838867
- protected pretend -> boolean false
- public transEnabled -> boolean true
- public transStrict -> boolean true
- protected transDepth -> integer 0
- protected transStatus -> boolean true
- protected transFailure -> boolean false
- protected transException -> boolean false
- protected aliasedTables -> array (0)
- protected queryClass -> string (26) "CodeIgniter\Database\Query"
- protected dateFormat -> array (5)
- date => string (5) "Y-m-d"
- datetime => string (11) "Y-m-d H:i:s"
- datetime-ms => string (13) "Y-m-d H:i:s.v"
- datetime-us => string (13) "Y-m-d H:i:s.u"
- time => string (5) "H:i:s"
- public deleteHack -> boolean true
- public mysqli -> mysqli#113 (18)
- Properties (18)
- Methods (43)
- Static methods (1)
- public readonly affected_rows -> integer 1
- public readonly client_info -> string (14) "mysqlnd 8.3.23"
- public readonly client_version -> integer 80323
- public readonly connect_errno -> integer 0
- public readonly connect_error -> null
- public readonly errno -> integer 0
- public readonly error -> string (0) ""
- public readonly error_list -> array (0)
- public readonly field_count -> integer 5
- public readonly host_info -> string (31) "solisculv32.mysql.db via TCP/IP"
- public readonly info -> null
- public readonly insert_id -> integer 0
- public readonly server_info -> string (7) "8.4.7-7"
- public readonly server_version -> integer 80407
- public readonly sqlstate -> string (5) "00000"
- public readonly protocol_version -> integer 10
- public readonly thread_id -> integer 225484
- public readonly warning_count -> integer 0
- public autocommit(bool $enable)
- public character_set_name()
- public close()
- public dump_debug_info()
- public debug(string $options)
- public get_charset()
- public execute_query(string $query, ?array $params = null): mysqli_result|bool
- public get_client_info()
- public get_connection_stats()
- public get_server_info()
- public get_warnings()
- public init()
- public kill(int $process_id)
- public multi_query(string $query)
- public more_results()
- public next_result()
- public ping()
- public prepare(string $query)
- public reap_async_query()
- public real_query(string $query)
- public savepoint(string $name)
- public select_db(string $database)
- public set_charset(string $charset)
- public options(int $option, $value)
- public set_opt(int $option, $value)
- public stat()
- public stmt_init()
- public store_result(int $mode = 0)
- public thread_safe()
- public use_result()
- public refresh(int $flags)
- public resultMode -> integer 0
- public numberNative -> boolean false
- public foundRows -> boolean false
- public connect(bool $persistent = false): false|mysqli Connect to the database.
/** * Connect to the database. * * @return false|mysqli * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:102
- public reconnect(): void Keep or establish the connection if no queries have been sent for a length of...
/** * Keep or establish the connection if no queries have been sent for * a length of time exceeding the server's idle timeout. * * @return void */ Defined in .../system/Database/MySQLi/Connection.php:258
- protected _close(): void Close the database connection.
/** * Close the database connection. * * @return void */ Defined in .../system/Database/MySQLi/Connection.php:269
- public setDatabase(string $databaseName): bool Select a specific database table to use.
/** * Select a specific database table to use. */ Defined in .../system/Database/MySQLi/Connection.php:277
- public getVersion(): string Returns a string containing the version of the database being used.
/** * Returns a string containing the version of the database being used. */ Defined in .../system/Database/MySQLi/Connection.php:299
- protected execute(string $sql): false|mysqli_result Executes the query against the database.
/** * Executes the query against the database. * * @return false|mysqli_result */ Defined in .../system/Database/MySQLi/Connection.php:317
- protected prepQuery(string $sql): string Prep the query. If needed, each database adapter can prep the query string
/** * Prep the query. If needed, each database adapter can prep the query string */ Defined in .../system/Database/MySQLi/Connection.php:342
- public affectedRows(): int Returns the total number of rows affected by this query.
/** * Returns the total number of rows affected by this query. */ Defined in .../system/Database/MySQLi/Connection.php:356
- protected _escapeString(string $str): string Platform-dependant string escape
/** * Platform-dependant string escape */ Defined in .../system/Database/MySQLi/Connection.php:364
- public escapeLikeStringDirect($str): list<string>|string Escape Like String Direct There are a few instances where MySQLi queries cann...
/** * Escape Like String Direct * There are a few instances where MySQLi queries cannot take the * additional "ESCAPE x" parameter for specifying the escape character * in "LIKE" strings, and this handles those directly with a backslash. * * @param list<string>|string $str Input string * * @return list<string>|string */ Defined in .../system/Database/MySQLi/Connection.php:383
- protected _listTables(bool $prefixLimit = false, ?string $tableName = null): string Generates the SQL for listing tables in a platform-dependent manner. Uses esc...
/** * Generates the SQL for listing tables in a platform-dependent manner. * Uses escapeLikeStringDirect(). * * @param string|null $tableName If $tableName is provided will return only this table if exists. */ Defined in .../system/Database/MySQLi/Connection.php:409
- protected _listColumns($table = ''): string Generates a platform-specific query string so that the column names can be fe...
/** * Generates a platform-specific query string so that the column names can be fetched. * * @param string|TableName $table */ Defined in .../system/Database/MySQLi/Connection.php:429
- protected _fieldData(string $table): array Returns an array of objects with field data
/** * Returns an array of objects with field data * * @return list<stdClass> * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:448
- protected _indexData(string $table): array Returns an array of objects with index data
/** * Returns an array of objects with index data * * @return array<string, stdClass> * * @throws DatabaseException * @throws LogicException */ Defined in .../system/Database/MySQLi/Connection.php:481
- protected _foreignKeyData(string $table): array Returns an array of objects with Foreign key data
/** * Returns an array of objects with Foreign key data * * @return array<string, stdClass> * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:528
- protected _disableForeignKeyChecks(): string Returns platform-specific SQL to disable foreign key checks.
/** * Returns platform-specific SQL to disable foreign key checks. * * @return string */ Defined in .../system/Database/MySQLi/Connection.php:578
- protected _enableForeignKeyChecks(): string Returns platform-specific SQL to enable foreign key checks.
/** * Returns platform-specific SQL to enable foreign key checks. * * @return string */ Defined in .../system/Database/MySQLi/Connection.php:588
- public error(): array Returns the last error code and message. Must return this format: ['code' => ...
/** * Returns the last error code and message. * Must return this format: ['code' => string|int, 'message' => string] * intval(code) === 0 means "no error". * * @return array<string, int|string> */ Defined in .../system/Database/MySQLi/Connection.php:600
- public insertID(): int Insert ID
/** * Insert ID */ Defined in .../system/Database/MySQLi/Connection.php:618
- protected _transBegin(): bool Begin Transaction
/** * Begin Transaction */ Defined in .../system/Database/MySQLi/Connection.php:626
- protected _transCommit(): bool Commit Transaction
/** * Commit Transaction */ Defined in .../system/Database/MySQLi/Connection.php:636
- protected _transRollback(): bool Rollback Transaction
/** * Rollback Transaction */ Defined in .../system/Database/MySQLi/Connection.php:650
- public __construct(array $params) Saves our connection settings.
/** * Saves our connection settings. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:370
- public initialize(): void Initializes the database connection/settings.
/** * Initializes the database connection/settings. * * @return void * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:404
- public close(): void Close the database connection.
/** * Close the database connection. * * @return void */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:483
- public persistentConnect(): false|object|resource Create a persistent database connection.
/** * Create a persistent database connection. * * @return false|object|resource * @phpstan-return false|TConnection */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:504
- public getConnection(?string $alias = null): false|object|resource Returns the actual connection object. If both a 'read' and 'write' 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. * * @return false|object|resource * @phpstan-return TConnection */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:518
- public getDatabase(): string Returns the name of the current database being used.
/** * Returns the name of the current database being used. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:527
- public setPrefix(string $prefix = ''): string Set DB Prefix
/** * Set DB Prefix * * Set's the DB Prefix to something new without needing to reconnect * * @param string $prefix The prefix */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:539
- public getPrefix(): string Returns the database prefix.
/** * Returns the database prefix. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:547
- public getPlatform(): string The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc)
/** * The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:555
- public setAliasedTables(array $aliases): $this Sets the Table Aliases to use. These are typically collected during use of th...
/** * Sets the Table Aliases to use. These are typically * collected during use of the Builder, and set here * so queries are built correctly. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:567
- public addTableAlias(string $alias): $this Add a table alias to our list.
/** * Add a table alias to our list. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:579
- public query(string $sql, $binds = null, bool $setEscapeFlags = true, string $queryClass = ''): BaseResult|bool|Query BaseResult when “read” type query, bool when “write” type query, Query when prepared query Orchestrates a query against the database. Queries must use Database\Statemen...
/** * 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. * * @param array|string|null $binds * * @return BaseResult|bool|Query BaseResult when “read” type query, bool when “write” type query, Query when prepared query * @phpstan-return BaseResult<TConnection, TResult>|bool|Query * * @todo BC set $queryClass default as null in 4.1 */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:615
- public simpleQuery(string $sql): false|object|resource Performs a basic query against the database. No binding or caching is perform...
/** * 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. * * @return false|object|resource * @phpstan-return false|TResult */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:732
- public transOff(): void Disable Transactions
/** * Disable Transactions * * This permits transactions to be disabled at run-time. * * @return void */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:748
- public transStrict(bool $mode = true): $this Enable/disable Transaction Strict Mode
/** * 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 * * @param bool $mode = true * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:767
- public transStart(bool $testMode = false): bool Start Transaction
/** * Start Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:777
- public transException(bool $transException): $this If set to true, exceptions are thrown during transactions.
/** * If set to true, exceptions are thrown during transactions. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:791
- public transComplete(): bool Complete Transaction
/** * Complete Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:801
- public transStatus(): bool Lets you retrieve the transaction flag to determine if it has failed
/** * Lets you retrieve the transaction flag to determine if it has failed */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:827
- public transBegin(bool $testMode = false): bool Begin Transaction
/** * Begin Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:835
- public transCommit(): bool Commit Transaction
/** * Commit Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:869
- public transRollback(): bool Rollback Transaction
/** * Rollback Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:888
- public resetTransStatus(): static Reset transaction status - to restart transactions after strict mode failure
/** * Reset transaction status - to restart transactions after strict mode failure */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:907
- public table($tableName): BaseBuilder Returns a non-shared new instance of the query builder for this connection.
/** * Returns a non-shared new instance of the query builder for this connection. * * @param array|string|TableName $tableName * * @return BaseBuilder * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:938
- public newQuery(): CodeIgniter\Database\BaseBuilder Returns a new instance of the BaseBuilder class with a cleared FROM clause.
/** * Returns a new instance of the BaseBuilder class with a cleared FROM clause. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:952
- public prepare(Closure $func, array $options = array()): BasePreparedQuery|null Creates a prepared statement with the database that can then be used to execu...
/** * 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(); * }) * * @param Closure(BaseConnection): mixed $func * * @return BasePreparedQuery|null */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:980
- public getLastQuery(): Query Returns the last query's statement object.
/** * Returns the last query's statement object. * * @return Query */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1008
- public showLastQuery(): string Returns a string representation of the last query's statement object.
/** * Returns a string representation of the last query's statement object. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1016
- public getConnectStart(): ?float Returns the time we started to connect to this database in seconds with micro...
/** * Returns the time we started to connect to this database in * seconds with microseconds. * * Used by the Debug Toolbar's timeline. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1027
- public getConnectDuration(int $decimals = 6): string Returns the number of seconds with microseconds that it took to connect to th...
/** * Returns the number of seconds with microseconds that it took * to connect to the database. * * Used by the Debug Toolbar's timeline. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1038
- public protectIdentifiers($item, bool $prefixSingle = false, ?bool $protectIdentifiers = null, bool $fieldExists = true): array|string Protect Identifiers
/** * 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. * * @param array|int|string|TableName $item * @param bool $prefixSingle Prefix a table name with no segments? * @param bool $protectIdentifiers Protect table or column names? * @param bool $fieldExists Supplied $item contains a column name? * * @return array|string * @phpstan-return ($item is array ? array : string) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1071
- public escapeIdentifier($item): string Escape the SQL Identifier
/** * Escape the SQL Identifier * * This function escapes single identifier. * * @param non-empty-string|TableName $item */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1236
- public escapeIdentifiers($item): array|string Escape the SQL Identifiers
/** * Escape the SQL Identifiers * * This function escapes column and table names * * @param array|string $item * * @return array|string * @phpstan-return ($item is array ? array : string) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1276
- public prefixTable(string $table = ''): string Prepends a database prefix if one exists in configuration
/** * Prepends a database prefix if one exists in configuration * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1336
- public escape($str): array|float|int|string "Smart" Escape String
/** * "Smart" Escape String * * Escapes data based on type. * Sets boolean and null types * * @param array|bool|float|int|object|string|null $str * * @return array|float|int|string * @phpstan-return ($str is array ? array : float|int|string) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1361
- public escapeString($str, bool $like = false): list<string>|string Escape String
/** * Escape String * * @param list<string|Stringable>|string|Stringable $str Input string * @param bool $like Whether the string will be used in a LIKE condition * * @return list<string>|string */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1394
- public escapeLikeString($str): list<string>|string Escape LIKE String
/** * Escape LIKE String * * Calls the individual driver for platform * specific escaping for LIKE conditions * * @param list<string|Stringable>|string|Stringable $str * * @return list<string>|string */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1444
- public callFunction(string $functionName, $params): bool This function enables you to call PHP database functions that are not nativel...
/** * This function enables you to call PHP database functions that are not natively included * in CodeIgniter, in a platform independent manner. * * @param array ...$params * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1467
- protected getDriverFunctionPrefix(): string Get the prefix of the function to access the DB.
/** * Get the prefix of the function to access the DB. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1489
- public listTables(bool $constrainByPrefix = false): false|list<string> Returns an array of table names
/** * Returns an array of table names * * @return false|list<string> * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1505
- public tableExists(string $tableName, bool $cached = true): bool Determine if a particular table exists
/** * Determine if a particular table exists * * @param bool $cached Whether to use data cache */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1542
- public getFieldNames($tableName): false|list<string> Fetch Field Names
/** * Fetch Field Names * * @param string|TableName $tableName * * @return false|list<string> * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1585
- public fieldExists(string $fieldName, string $tableName): bool Determine if a particular field exists
/** * Determine if a particular field exists */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1632
- public getFieldData(string $table): list<stdClass> Returns an object with field data
/** * Returns an object with field data * * @return list<stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1642
- public getIndexData(string $table): array<string, stdClass> Returns an object with key data
/** * Returns an object with key data * * @return array<string, stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1652
- public getForeignKeyData(string $table): array<string, stdClass> Returns an object with foreign key data
/** * Returns an object with foreign key data * * @return array<string, stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1662
- protected foreignKeyDataToObjects(array $data): array<string, stdClass> Converts array of arrays generated by _foreignKeyData() to array of objects
/** * Converts array of arrays generated by _foreignKeyData() to array of objects * * @return array<string, stdClass> * * 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 * ] * ] */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1686
- public disableForeignKeyChecks(): bool Disables foreign key checks temporarily.
/** * Disables foreign key checks temporarily. * * @return bool */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1719
- public enableForeignKeyChecks(): bool Enables foreign key checks temporarily.
/** * Enables foreign key checks temporarily. * * @return bool */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1736
- public pretend(bool $pretend = true): $this Allows the engine to be set into a mode where queries are not actually execut...
/** * 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. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1756
- public resetDataCache(): $this Empties our data cache. Especially helpful during testing.
/** * Empties our data cache. Especially helpful during testing. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1768
- public isWriteType($sql): bool Determines if the statement is a write-type query or not.
/** * Determines if the statement is a write-type query or not. * * @param string $sql */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1780
- public __get(string $key): array|bool|float|int|object|resource|string|null Accessor for properties if they exist.
/** * Accessor for properties if they exist. * * @return array|bool|float|int|object|resource|string|null */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1884
- public __isset(string $key): bool Checker for properties existence.
/** * Checker for properties existence. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1896
- private CodeIgniter\Database\BaseConnection::protectDotItem(string $item, string $alias, bool $protectIdentifiers, bool $fieldExists): string
Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1160
- private CodeIgniter\Database\BaseConnection::escapeTableName(CodeIgniter\Database\TableName $tableName): string Returns escaped table name with alias.
/** * Returns escaped table name with alias. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1258
- protected insertID -> integer 0
- protected DBGroup -> null
- protected returnType -> string (36) "KoclikoDisplay\Entities\ContentOwner"
- protected tempReturnType -> string (36) "KoclikoDisplay\Entities\ContentOwner"
- protected casts -> array (0)
- protected castHandlers -> array (0)
- protected converter -> null
- protected protectFields -> boolean true
- protected allowedFields -> array (4)
- 0 => string (16) "content_owner_id"
- 1 => string (10) "content_id"
- 2 => string (10) "owner_name"
- 3 => string (8) "owner_id"
- protected useTimestamps -> boolean false
- protected dateFormat -> string (8) "datetime"
- protected createdField -> string (10) "created_at"
- protected updatedField -> string (10) "updated_at"
- protected useSoftDeletes -> boolean false
- protected tempUseSoftDeletes -> boolean false
- protected deletedField -> string (10) "deleted_at"
- protected allowEmptyInserts -> boolean false
- protected updateOnlyChanged -> boolean true
- protected validationRules -> array (0)
- protected validationMessages -> array (0)
- protected skipValidation -> boolean false
- protected cleanValidationRules -> boolean true
- protected validation -> null
- protected allowCallbacks -> boolean true
- protected tempAllowCallbacks -> boolean true
- protected beforeInsert -> array (3)
- 0 => string (7) "slugify"
- 1 => string (16) "identifiateImage"
- 2 => string (16) "identifiateVideo"
- protected afterInsert -> array (0)
- protected beforeUpdate -> array (3)
- 0 => string (7) "slugify"
- 1 => string (16) "identifiateImage"
- 2 => string (16) "identifiateVideo"
- protected afterUpdate -> array (0)
- protected beforeInsertBatch -> array (0)
- protected afterInsertBatch -> array (0)
- protected beforeUpdateBatch -> array (0)
- protected afterUpdateBatch -> array (0)
- protected beforeFind -> array (0)
- protected afterFind -> array (0)
- protected beforeDelete -> array (0)
- protected afterDelete -> array (0)
- protected table -> string (13) "content_owner"
- protected primaryKey -> string (16) "content_owner_id"
- protected useAutoIncrement -> boolean true
- protected builder -> CodeIgniter\Database\MySQLi\Builder#127 (33)
- Properties (33)
- Methods (136)
- protected resetDeleteData -> boolean false
- protected QBSelect -> array (0)
- protected QBDistinct -> boolean false
- protected QBFrom -> array (1)
- 0 => string (15) "`content_owner`"
- protected QBJoin -> array (0)
- protected QBWhere -> array (0)
- public QBGroupBy -> array (0)
- protected QBHaving -> array (0)
- protected QBKeys -> array (0)
- protected QBLimit -> boolean false
- protected QBOffset -> boolean false
- public QBOrderBy -> array (0)
- protected QBUnion -> array (0)
- public QBNoEscape -> array (0)
- protected QBSet -> array (0)
- protected QBWhereGroupStarted -> boolean false
- protected QBWhereGroupCount -> integer 0
- protected QBIgnore -> boolean false
- protected QBOptions -> null
- protected db -> CodeIgniter\Database\MySQLi\Connection#102 (45)
- Properties (45)
- Methods (78)
- protected DSN -> string (0) ""
- protected port -> integer 3306
- protected hostname -> string (20) "solisculv32.mysql.db"
- protected username -> string (11) "solisculv32"
- protected password -> string (18) "tybzodpebsu5cexWiq"
- protected database -> string (11) "solisculv32"
- public DBDriver -> string (6) "MySQLi"
- protected subdriver -> null
- protected DBPrefix -> string (0) ""
- protected pConnect -> boolean false
- protected DBDebug -> boolean true
- protected charset -> string (7) "utf8mb4"
- protected DBCollat -> string (18) "utf8mb4_general_ci"
- protected swapPre -> string (0) ""
- protected encrypt -> boolean false
- protected compress -> boolean false
- protected strictOn -> boolean false
- protected failover -> array (0)
- protected lastQuery -> CodeIgniter\Database\Query#130 (10)
- Properties (10)
- Methods (19)
- toString
- protected originalQueryString -> string (100) "SELECT * FROM `content_owner` WHERE `owner_name` = :owner_name: AND `owner_i...
SELECT * FROM `content_owner` WHERE `owner_name` = :owner_name: AND `owner_id` = :owner_id: LIMIT 1
- protected swappedQueryString -> uninitialized
- protected finalQueryString -> string (91) "SELECT * FROM `content_owner` WHERE `owner_name` = 'Actuality' AND `owner_id...
SELECT * FROM `content_owner` WHERE `owner_name` = 'Actuality' AND `owner_id` = 18 LIMIT 1
- protected binds -> array (2)
- Table (2)
- Contents (2)
0 1 owner_name Actuality true owner_id 18 true - owner_name => array (2)
- 0 => string (9) "Actuality"
- 1 => boolean true
- owner_id => array (2)
- 0 => integer 18
- 1 => boolean true
- protected bindMarker -> string (1) "?"
- protected startTime -> double 1773430017.03
- protected endTime -> double 1773430017.0311
- protected errorCode -> null
- protected errorString -> null
- public db -> CodeIgniter\Database\MySQLi\Connection#102 Recursion
- public __construct(CodeIgniter\Database\ConnectionInterface $db)
Defined in .../system/Database/Query.php:98
- public setQuery(string $sql, $binds = null, bool $setEscape = true): $this Sets the raw query string to use for this statement.
/** * Sets the raw query string to use for this statement. * * @param mixed $binds * * @return $this */ Defined in .../system/Database/Query.php:110
- public setBinds(array $binds, bool $setEscape = true): $this Will store the variables to bind into the query later.
/** * Will store the variables to bind into the query later. * * @return $this */ Defined in .../system/Database/Query.php:141
- public getQuery(): string Returns the final, processed query string after binding, etal has been perfor...
/** * Returns the final, processed query string after binding, etal * has been performed. */ Defined in .../system/Database/Query.php:160
- public setDuration(float $start, ?float $end = null): $this Records the execution time of the statement using microtime(true) for it's st...
/** * Records the execution time of the statement using microtime(true) * for it's start and end values. If no end value is present, will * use the current time to determine total duration. * * @return $this */ Defined in .../system/Database/Query.php:176
- public getStartTime(bool $returnRaw = false, int $decimals = 6): float|string Returns the start time in seconds with microseconds.
/** * Returns the start time in seconds with microseconds. * * @return float|string */ Defined in .../system/Database/Query.php:194
- public getDuration(int $decimals = 6): string Returns the duration of this query during execution, or null if the query has...
/** * Returns the duration of this query during execution, or null if * the query has not been executed yet. * * @param int $decimals The accuracy of the returned time. */ Defined in .../system/Database/Query.php:209
- public setError(int $code, string $error): $this Stores the error description that happened for this query.
/** * Stores the error description that happened for this query. * * @return $this */ Defined in .../system/Database/Query.php:219
- public hasError(): bool Reports whether this statement created an error not.
/** * Reports whether this statement created an error not. */ Defined in .../system/Database/Query.php:230
- public getErrorCode(): int Returns the error code created while executing this statement.
/** * Returns the error code created while executing this statement. */ Defined in .../system/Database/Query.php:238
- public getErrorMessage(): string Returns the error message created while executing this statement.
/** * Returns the error message created while executing this statement. */ Defined in .../system/Database/Query.php:246
- public isWriteType(): bool Determines if the statement is a write-type query or not.
/** * Determines if the statement is a write-type query or not. */ Defined in .../system/Database/Query.php:254
- public swapPrefix(string $orig, string $swap): $this Swaps out one table prefix for a new one.
/** * Swaps out one table prefix for a new one. * * @return $this */ Defined in .../system/Database/Query.php:264
- public getOriginalQuery(): string Returns the original SQL that was passed into the system.
/** * Returns the original SQL that was passed into the system. */ Defined in .../system/Database/Query.php:281
- protected compileBinds() Escapes and inserts any binds into the finalQueryString property.
/** * Escapes and inserts any binds into the finalQueryString property. * * @see https://regex101.com/r/EUEhay/5 */ Defined in .../system/Database/Query.php:291
- protected matchNamedBinds(string $sql, array $binds): string Match bindings
/** * Match bindings */ Defined in .../system/Database/Query.php:319
- protected matchSimpleBinds(string $sql, array $binds, int $bindCount, int $ml): string Match bindings
/** * Match bindings */ Defined in .../system/Database/Query.php:343
- public debugToolbarDisplay(): string Returns string to display in debug toolbar
/** * Returns string to display in debug toolbar */ Defined in .../system/Database/Query.php:373
- public __toString(): string Return text representation of the query
/** * Return text representation of the query */ Defined in .../system/Database/Query.php:427
- lastQuery string (91) "SELECT * FROM `content_owner` WHERE `owner_name` = 'Actuality' AND `owner_id...
SELECT * FROM `content_owner` WHERE `owner_name` = 'Actuality' AND `owner_id` = 18 LIMIT 1
- public connID -> mysqli#113 (18)
- Properties (18)
- Methods (43)
- Static methods (1)
- public readonly affected_rows -> integer 1
- public readonly client_info -> string (14) "mysqlnd 8.3.23"
- public readonly client_version -> integer 80323
- public readonly connect_errno -> integer 0
- public readonly connect_error -> null
- public readonly errno -> integer 0
- public readonly error -> string (0) ""
- public readonly error_list -> array (0)
- public readonly field_count -> integer 5
- public readonly host_info -> string (31) "solisculv32.mysql.db via TCP/IP"
- public readonly info -> null
- public readonly insert_id -> integer 0
- public readonly server_info -> string (7) "8.4.7-7"
- public readonly server_version -> integer 80407
- public readonly sqlstate -> string (5) "00000"
- public readonly protocol_version -> integer 10
- public readonly thread_id -> integer 225484
- public readonly warning_count -> integer 0
- public autocommit(bool $enable)
- public character_set_name()
- public close()
- public dump_debug_info()
- public debug(string $options)
- public get_charset()
- public execute_query(string $query, ?array $params = null): mysqli_result|bool
- public get_client_info()
- public get_connection_stats()
- public get_server_info()
- public get_warnings()
- public init()
- public kill(int $process_id)
- public multi_query(string $query)
- public more_results()
- public next_result()
- public ping()
- public prepare(string $query)
- public reap_async_query()
- public real_query(string $query)
- public savepoint(string $name)
- public select_db(string $database)
- public set_charset(string $charset)
- public options(int $option, $value)
- public set_opt(int $option, $value)
- public stat()
- public stmt_init()
- public store_result(int $mode = 0)
- public thread_safe()
- public use_result()
- public refresh(int $flags)
- public resultID -> mysqli_result#131 (5)
- Properties (5)
- Methods (16)
- Iterator
- public current_field -> uninitialized
- public field_count -> uninitialized
- public lengths -> uninitialized
- public num_rows -> uninitialized
- public type -> uninitialized
- public close()
- public free()
- public data_seek(int $offset)
- public fetch_field()
- public fetch_fields()
- public fetch_all(int $mode = 2)
- public fetch_array(int $mode = 3)
- public fetch_assoc()
- public fetch_row()
- public fetch_column(int $column = 0): string|int|float|false|null
- public field_seek(int $index)
- public free_result()
- public getIterator(): Iterator
- mysqli_result Iterator Contents uninitialized Blacklisted
- public protectIdentifiers -> boolean true
- protected reservedIdentifiers -> array (1)
- 0 => string (1) "*"
- public escapeChar -> string (1) "`"
- public likeEscapeStr -> string (13) " ESCAPE '%s' "
- public likeEscapeChar -> string (1) "!"
- protected pregEscapeChar -> array (4)
- 1 => string (1) "`"
- 0 => string (1) "`"
- 3 => string (1) "`"
- 2 => string (1) "`"
- public dataCache -> array (0)
- protected connectTime -> double 1773430016.9987
- protected connectDuration -> double 0.0024290084838867
- protected pretend -> boolean false
- public transEnabled -> boolean true
- public transStrict -> boolean true
- protected transDepth -> integer 0
- protected transStatus -> boolean true
- protected transFailure -> boolean false
- protected transException -> boolean false
- protected aliasedTables -> array (0)
- protected queryClass -> string (26) "CodeIgniter\Database\Query"
- protected dateFormat -> array (5)
- date => string (5) "Y-m-d"
- datetime => string (11) "Y-m-d H:i:s"
- datetime-ms => string (13) "Y-m-d H:i:s.v"
- datetime-us => string (13) "Y-m-d H:i:s.u"
- time => string (5) "H:i:s"
- public deleteHack -> boolean true
- public mysqli -> mysqli#113 (18)
- Properties (18)
- Methods (43)
- Static methods (1)
- public readonly affected_rows -> integer 1
- public readonly client_info -> string (14) "mysqlnd 8.3.23"
- public readonly client_version -> integer 80323
- public readonly connect_errno -> integer 0
- public readonly connect_error -> null
- public readonly errno -> integer 0
- public readonly error -> string (0) ""
- public readonly error_list -> array (0)
- public readonly field_count -> integer 5
- public readonly host_info -> string (31) "solisculv32.mysql.db via TCP/IP"
- public readonly info -> null
- public readonly insert_id -> integer 0
- public readonly server_info -> string (7) "8.4.7-7"
- public readonly server_version -> integer 80407
- public readonly sqlstate -> string (5) "00000"
- public readonly protocol_version -> integer 10
- public readonly thread_id -> integer 225484
- public readonly warning_count -> integer 0
- public autocommit(bool $enable)
- public character_set_name()
- public close()
- public dump_debug_info()
- public debug(string $options)
- public get_charset()
- public execute_query(string $query, ?array $params = null): mysqli_result|bool
- public get_client_info()
- public get_connection_stats()
- public get_server_info()
- public get_warnings()
- public init()
- public kill(int $process_id)
- public multi_query(string $query)
- public more_results()
- public next_result()
- public ping()
- public prepare(string $query)
- public reap_async_query()
- public real_query(string $query)
- public savepoint(string $name)
- public select_db(string $database)
- public set_charset(string $charset)
- public options(int $option, $value)
- public set_opt(int $option, $value)
- public stat()
- public stmt_init()
- public store_result(int $mode = 0)
- public thread_safe()
- public use_result()
- public refresh(int $flags)
- public resultMode -> integer 0
- public numberNative -> boolean false
- public foundRows -> boolean false
- public connect(bool $persistent = false): false|mysqli Connect to the database.
/** * Connect to the database. * * @return false|mysqli * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:102
- public reconnect(): void Keep or establish the connection if no queries have been sent for a length of...
/** * Keep or establish the connection if no queries have been sent for * a length of time exceeding the server's idle timeout. * * @return void */ Defined in .../system/Database/MySQLi/Connection.php:258
- protected _close(): void Close the database connection.
/** * Close the database connection. * * @return void */ Defined in .../system/Database/MySQLi/Connection.php:269
- public setDatabase(string $databaseName): bool Select a specific database table to use.
/** * Select a specific database table to use. */ Defined in .../system/Database/MySQLi/Connection.php:277
- public getVersion(): string Returns a string containing the version of the database being used.
/** * Returns a string containing the version of the database being used. */ Defined in .../system/Database/MySQLi/Connection.php:299
- protected execute(string $sql): false|mysqli_result Executes the query against the database.
/** * Executes the query against the database. * * @return false|mysqli_result */ Defined in .../system/Database/MySQLi/Connection.php:317
- protected prepQuery(string $sql): string Prep the query. If needed, each database adapter can prep the query string
/** * Prep the query. If needed, each database adapter can prep the query string */ Defined in .../system/Database/MySQLi/Connection.php:342
- public affectedRows(): int Returns the total number of rows affected by this query.
/** * Returns the total number of rows affected by this query. */ Defined in .../system/Database/MySQLi/Connection.php:356
- protected _escapeString(string $str): string Platform-dependant string escape
/** * Platform-dependant string escape */ Defined in .../system/Database/MySQLi/Connection.php:364
- public escapeLikeStringDirect($str): list<string>|string Escape Like String Direct There are a few instances where MySQLi queries cann...
/** * Escape Like String Direct * There are a few instances where MySQLi queries cannot take the * additional "ESCAPE x" parameter for specifying the escape character * in "LIKE" strings, and this handles those directly with a backslash. * * @param list<string>|string $str Input string * * @return list<string>|string */ Defined in .../system/Database/MySQLi/Connection.php:383
- protected _listTables(bool $prefixLimit = false, ?string $tableName = null): string Generates the SQL for listing tables in a platform-dependent manner. Uses esc...
/** * Generates the SQL for listing tables in a platform-dependent manner. * Uses escapeLikeStringDirect(). * * @param string|null $tableName If $tableName is provided will return only this table if exists. */ Defined in .../system/Database/MySQLi/Connection.php:409
- protected _listColumns($table = ''): string Generates a platform-specific query string so that the column names can be fe...
/** * Generates a platform-specific query string so that the column names can be fetched. * * @param string|TableName $table */ Defined in .../system/Database/MySQLi/Connection.php:429
- protected _fieldData(string $table): array Returns an array of objects with field data
/** * Returns an array of objects with field data * * @return list<stdClass> * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:448
- protected _indexData(string $table): array Returns an array of objects with index data
/** * Returns an array of objects with index data * * @return array<string, stdClass> * * @throws DatabaseException * @throws LogicException */ Defined in .../system/Database/MySQLi/Connection.php:481
- protected _foreignKeyData(string $table): array Returns an array of objects with Foreign key data
/** * Returns an array of objects with Foreign key data * * @return array<string, stdClass> * * @throws DatabaseException */ Defined in .../system/Database/MySQLi/Connection.php:528
- protected _disableForeignKeyChecks(): string Returns platform-specific SQL to disable foreign key checks.
/** * Returns platform-specific SQL to disable foreign key checks. * * @return string */ Defined in .../system/Database/MySQLi/Connection.php:578
- protected _enableForeignKeyChecks(): string Returns platform-specific SQL to enable foreign key checks.
/** * Returns platform-specific SQL to enable foreign key checks. * * @return string */ Defined in .../system/Database/MySQLi/Connection.php:588
- public error(): array Returns the last error code and message. Must return this format: ['code' => ...
/** * Returns the last error code and message. * Must return this format: ['code' => string|int, 'message' => string] * intval(code) === 0 means "no error". * * @return array<string, int|string> */ Defined in .../system/Database/MySQLi/Connection.php:600
- public insertID(): int Insert ID
/** * Insert ID */ Defined in .../system/Database/MySQLi/Connection.php:618
- protected _transBegin(): bool Begin Transaction
/** * Begin Transaction */ Defined in .../system/Database/MySQLi/Connection.php:626
- protected _transCommit(): bool Commit Transaction
/** * Commit Transaction */ Defined in .../system/Database/MySQLi/Connection.php:636
- protected _transRollback(): bool Rollback Transaction
/** * Rollback Transaction */ Defined in .../system/Database/MySQLi/Connection.php:650
- public __construct(array $params) Saves our connection settings.
/** * Saves our connection settings. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:370
- public initialize(): void Initializes the database connection/settings.
/** * Initializes the database connection/settings. * * @return void * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:404
- public close(): void Close the database connection.
/** * Close the database connection. * * @return void */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:483
- public persistentConnect(): false|object|resource Create a persistent database connection.
/** * Create a persistent database connection. * * @return false|object|resource * @phpstan-return false|TConnection */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:504
- public getConnection(?string $alias = null): false|object|resource Returns the actual connection object. If both a 'read' and 'write' 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. * * @return false|object|resource * @phpstan-return TConnection */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:518
- public getDatabase(): string Returns the name of the current database being used.
/** * Returns the name of the current database being used. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:527
- public setPrefix(string $prefix = ''): string Set DB Prefix
/** * Set DB Prefix * * Set's the DB Prefix to something new without needing to reconnect * * @param string $prefix The prefix */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:539
- public getPrefix(): string Returns the database prefix.
/** * Returns the database prefix. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:547
- public getPlatform(): string The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc)
/** * The name of the platform in use (MySQLi, Postgre, SQLite3, OCI8, etc) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:555
- public setAliasedTables(array $aliases): $this Sets the Table Aliases to use. These are typically collected during use of th...
/** * Sets the Table Aliases to use. These are typically * collected during use of the Builder, and set here * so queries are built correctly. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:567
- public addTableAlias(string $alias): $this Add a table alias to our list.
/** * Add a table alias to our list. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:579
- public query(string $sql, $binds = null, bool $setEscapeFlags = true, string $queryClass = ''): BaseResult|bool|Query BaseResult when “read” type query, bool when “write” type query, Query when prepared query Orchestrates a query against the database. Queries must use Database\Statemen...
/** * 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. * * @param array|string|null $binds * * @return BaseResult|bool|Query BaseResult when “read” type query, bool when “write” type query, Query when prepared query * @phpstan-return BaseResult<TConnection, TResult>|bool|Query * * @todo BC set $queryClass default as null in 4.1 */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:615
- public simpleQuery(string $sql): false|object|resource Performs a basic query against the database. No binding or caching is perform...
/** * 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. * * @return false|object|resource * @phpstan-return false|TResult */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:732
- public transOff(): void Disable Transactions
/** * Disable Transactions * * This permits transactions to be disabled at run-time. * * @return void */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:748
- public transStrict(bool $mode = true): $this Enable/disable Transaction Strict Mode
/** * 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 * * @param bool $mode = true * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:767
- public transStart(bool $testMode = false): bool Start Transaction
/** * Start Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:777
- public transException(bool $transException): $this If set to true, exceptions are thrown during transactions.
/** * If set to true, exceptions are thrown during transactions. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:791
- public transComplete(): bool Complete Transaction
/** * Complete Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:801
- public transStatus(): bool Lets you retrieve the transaction flag to determine if it has failed
/** * Lets you retrieve the transaction flag to determine if it has failed */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:827
- public transBegin(bool $testMode = false): bool Begin Transaction
/** * Begin Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:835
- public transCommit(): bool Commit Transaction
/** * Commit Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:869
- public transRollback(): bool Rollback Transaction
/** * Rollback Transaction */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:888
- public resetTransStatus(): static Reset transaction status - to restart transactions after strict mode failure
/** * Reset transaction status - to restart transactions after strict mode failure */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:907
- public table($tableName): BaseBuilder Returns a non-shared new instance of the query builder for this connection.
/** * Returns a non-shared new instance of the query builder for this connection. * * @param array|string|TableName $tableName * * @return BaseBuilder * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:938
- public newQuery(): CodeIgniter\Database\BaseBuilder Returns a new instance of the BaseBuilder class with a cleared FROM clause.
/** * Returns a new instance of the BaseBuilder class with a cleared FROM clause. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:952
- public prepare(Closure $func, array $options = array()): BasePreparedQuery|null Creates a prepared statement with the database that can then be used to execu...
/** * 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(); * }) * * @param Closure(BaseConnection): mixed $func * * @return BasePreparedQuery|null */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:980
- public getLastQuery(): Query Returns the last query's statement object.
/** * Returns the last query's statement object. * * @return Query */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1008
- public showLastQuery(): string Returns a string representation of the last query's statement object.
/** * Returns a string representation of the last query's statement object. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1016
- public getConnectStart(): ?float Returns the time we started to connect to this database in seconds with micro...
/** * Returns the time we started to connect to this database in * seconds with microseconds. * * Used by the Debug Toolbar's timeline. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1027
- public getConnectDuration(int $decimals = 6): string Returns the number of seconds with microseconds that it took to connect to th...
/** * Returns the number of seconds with microseconds that it took * to connect to the database. * * Used by the Debug Toolbar's timeline. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1038
- public protectIdentifiers($item, bool $prefixSingle = false, ?bool $protectIdentifiers = null, bool $fieldExists = true): array|string Protect Identifiers
/** * 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. * * @param array|int|string|TableName $item * @param bool $prefixSingle Prefix a table name with no segments? * @param bool $protectIdentifiers Protect table or column names? * @param bool $fieldExists Supplied $item contains a column name? * * @return array|string * @phpstan-return ($item is array ? array : string) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1071
- public escapeIdentifier($item): string Escape the SQL Identifier
/** * Escape the SQL Identifier * * This function escapes single identifier. * * @param non-empty-string|TableName $item */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1236
- public escapeIdentifiers($item): array|string Escape the SQL Identifiers
/** * Escape the SQL Identifiers * * This function escapes column and table names * * @param array|string $item * * @return array|string * @phpstan-return ($item is array ? array : string) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1276
- public prefixTable(string $table = ''): string Prepends a database prefix if one exists in configuration
/** * Prepends a database prefix if one exists in configuration * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1336
- public escape($str): array|float|int|string "Smart" Escape String
/** * "Smart" Escape String * * Escapes data based on type. * Sets boolean and null types * * @param array|bool|float|int|object|string|null $str * * @return array|float|int|string * @phpstan-return ($str is array ? array : float|int|string) */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1361
- public escapeString($str, bool $like = false): list<string>|string Escape String
/** * Escape String * * @param list<string|Stringable>|string|Stringable $str Input string * @param bool $like Whether the string will be used in a LIKE condition * * @return list<string>|string */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1394
- public escapeLikeString($str): list<string>|string Escape LIKE String
/** * Escape LIKE String * * Calls the individual driver for platform * specific escaping for LIKE conditions * * @param list<string|Stringable>|string|Stringable $str * * @return list<string>|string */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1444
- public callFunction(string $functionName, $params): bool This function enables you to call PHP database functions that are not nativel...
/** * This function enables you to call PHP database functions that are not natively included * in CodeIgniter, in a platform independent manner. * * @param array ...$params * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1467
- protected getDriverFunctionPrefix(): string Get the prefix of the function to access the DB.
/** * Get the prefix of the function to access the DB. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1489
- public listTables(bool $constrainByPrefix = false): false|list<string> Returns an array of table names
/** * Returns an array of table names * * @return false|list<string> * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1505
- public tableExists(string $tableName, bool $cached = true): bool Determine if a particular table exists
/** * Determine if a particular table exists * * @param bool $cached Whether to use data cache */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1542
- public getFieldNames($tableName): false|list<string> Fetch Field Names
/** * Fetch Field Names * * @param string|TableName $tableName * * @return false|list<string> * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1585
- public fieldExists(string $fieldName, string $tableName): bool Determine if a particular field exists
/** * Determine if a particular field exists */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1632
- public getFieldData(string $table): list<stdClass> Returns an object with field data
/** * Returns an object with field data * * @return list<stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1642
- public getIndexData(string $table): array<string, stdClass> Returns an object with key data
/** * Returns an object with key data * * @return array<string, stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1652
- public getForeignKeyData(string $table): array<string, stdClass> Returns an object with foreign key data
/** * Returns an object with foreign key data * * @return array<string, stdClass> */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1662
- protected foreignKeyDataToObjects(array $data): array<string, stdClass> Converts array of arrays generated by _foreignKeyData() to array of objects
/** * Converts array of arrays generated by _foreignKeyData() to array of objects * * @return array<string, stdClass> * * 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 * ] * ] */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1686
- public disableForeignKeyChecks(): bool Disables foreign key checks temporarily.
/** * Disables foreign key checks temporarily. * * @return bool */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1719
- public enableForeignKeyChecks(): bool Enables foreign key checks temporarily.
/** * Enables foreign key checks temporarily. * * @return bool */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1736
- public pretend(bool $pretend = true): $this Allows the engine to be set into a mode where queries are not actually execut...
/** * 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. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1756
- public resetDataCache(): $this Empties our data cache. Especially helpful during testing.
/** * Empties our data cache. Especially helpful during testing. * * @return $this */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1768
- public isWriteType($sql): bool Determines if the statement is a write-type query or not.
/** * Determines if the statement is a write-type query or not. * * @param string $sql */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1780
- public __get(string $key): array|bool|float|int|object|resource|string|null Accessor for properties if they exist.
/** * Accessor for properties if they exist. * * @return array|bool|float|int|object|resource|string|null */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1884
- public __isset(string $key): bool Checker for properties existence.
/** * Checker for properties existence. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1896
- private CodeIgniter\Database\BaseConnection::protectDotItem(string $item, string $alias, bool $protectIdentifiers, bool $fieldExists): string
Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1160
- private CodeIgniter\Database\BaseConnection::escapeTableName(CodeIgniter\Database\TableName $tableName): string Returns escaped table name with alias.
/** * Returns escaped table name with alias. */ Inherited from CodeIgniter\Database\BaseConnection Defined in .../system/Database/BaseConnection.php:1258
- protected tableName -> string (13) "content_owner"
- protected randomKeyword -> array (2)
- 0 => string (6) "RAND()"
- 1 => string (8) "RAND(%d)"
- protected countString -> string (19) "SELECT COUNT(*) AS "
- protected binds -> array (0)
- protected bindsKeyCount -> array (0)
- protected canLimitDeletes -> boolean true
- protected canLimitWhereUpdates -> boolean true
- protected supportedIgnoreStatements -> array (3)
- update => string (6) "IGNORE"
- insert => string (6) "IGNORE"
- delete => string (6) "IGNORE"
- protected testMode -> boolean false
- protected joinTypes -> array (6)
- 0 => string (4) "LEFT"
- 1 => string (5) "RIGHT"
- 2 => string (5) "OUTER"
- 3 => string (5) "INNER"
- 4 => string (10) "LEFT OUTER"
- 5 => string (11) "RIGHT OUTER"
- protected isLiteralStr -> array (0)
- protected pregOperators -> array (12)
- 0 => string (17) "\s*(?:<|>|!)?=\s*"
- 1 => string (9) "\s*<>?\s*"
- 2 => string (7) "\s*>\s*"
- 3 => string (10) "\s+IS NULL"
- 4 => string (14) "\s+IS NOT NULL"
- 5 => string (18) "\s+EXISTS\s*\(.*\)"
- 6 => string (22) "\s+NOT EXISTS\s*\(.*\)"
- 7 => string (13) "\s+BETWEEN\s+"
- 8 => string (14) "\s+IN\s*\(.*\)"
- 9 => string (18) "\s+NOT IN\s*\(.*\)"
- 10 => string (31) "\s+LIKE\s+\S.*(\s+ESCAPE '\!')?"
- 11 => string (35) "\s+NOT LIKE\s+\S.*(\s+ESCAPE '\!')?"
- protected escapeChar -> string (1) "`"
- protected _fromTables(): string FROM tables
/** * FROM tables * * Groups tables in FROM clauses if needed, so there is no confusion * about operator precedence. * * Note: This is only used (and overridden) by MySQL. */ Defined in .../system/Database/MySQLi/Builder.php:52
- protected _updateBatch(string $table, array $keys, array $values): string Generates a platform-specific batch update string from the supplied data
/** * Generates a platform-specific batch update string from the supplied data */ Defined in .../system/Database/MySQLi/Builder.php:64
- public __construct($tableName, CodeIgniter\Database\ConnectionInterface $db, ?array $options = null) Constructor
/** * Constructor * * @param array|string|TableName $tableName tablename or tablenames with or without aliases * * Examples of $tableName: `mytable`, `jobs j`, `jobs j, users u`, `['jobs j','users u']` * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:307
- public db(): CodeIgniter\Database\ConnectionInterface Returns the current database connection
/** * Returns the current database connection * * @return BaseConnection */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:346
- public testMode(bool $mode = true): $this Sets a test mode status.
/** * Sets a test mode status. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:356
- public getTable(): string Gets the name of the primary table.
/** * Gets the name of the primary table. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:366
- public getBinds(): array Returns an array of bind values and their named parameters for binding in the...
/** * Returns an array of bind values and their * named parameters for binding in the Query object later. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:375
- public ignore(bool $ignore = true): $this Ignore
/** * Ignore * * Set ignore Flag for next insert, * update or delete query. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:388
- public select($select = '*', ?bool $escape = null): $this Generates the SELECT portion of the query
/** * Generates the SELECT portion of the query * * @param list<RawSql|string>|RawSql|string $select * @param bool|null $escape Whether to protect identifiers * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:403
- public selectMax(string $select = '', string $alias = ''): $this Generates a SELECT MAX(field) portion of a query
/** * Generates a SELECT MAX(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:456
- public selectMin(string $select = '', string $alias = ''): $this Generates a SELECT MIN(field) portion of a query
/** * Generates a SELECT MIN(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:466
- public selectAvg(string $select = '', string $alias = ''): $this Generates a SELECT AVG(field) portion of a query
/** * Generates a SELECT AVG(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:476
- public selectSum(string $select = '', string $alias = ''): $this Generates a SELECT SUM(field) portion of a query
/** * Generates a SELECT SUM(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:486
- public selectCount(string $select = '', string $alias = ''): $this Generates a SELECT COUNT(field) portion of a query
/** * Generates a SELECT COUNT(field) portion of a query * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:496
- public selectSubquery(CodeIgniter\Database\BaseBuilder $subquery, string $as): self Adds a subquery to the selection
/** * Adds a subquery to the selection */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:504
- protected maxMinAvgSum(string $select = '', string $alias = '', string $type = 'MAX'): $this SELECT [MAX|MIN|AVG|SUM|COUNT]()
/** * SELECT [MAX|MIN|AVG|SUM|COUNT]() * * @used-by selectMax() * @used-by selectMin() * @used-by selectAvg() * @used-by selectSum() * * @return $this * * @throws DatabaseException * @throws DataException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:524
- protected createAliasFromTable(string $item): string Determines the alias name based on the table
/** * Determines the alias name based on the table */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:555
- public distinct(bool $val = true): $this Sets a flag which tells the query string compiler to add DISTINCT
/** * Sets a flag which tells the query string compiler to add DISTINCT * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:571
- public from($from, bool $overwrite = false): self Generates the FROM portion of the query
/** * Generates the FROM portion of the query * * @param array|string $from * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:585
- public fromSubquery(CodeIgniter\Database\BaseBuilder $from, string $alias): self
/** * @param BaseBuilder $from Expected subquery * @param string $alias Subquery alias * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:616
- public join(string $table, $cond, string $type = '', ?bool $escape = null): $this Generates the JOIN portion of the query
/** * Generates the JOIN portion of the query * * @param RawSql|string $cond * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:633
- public where($key, $value = null, ?bool $escape = null): $this Generates the WHERE portion of the query. Separates multiple calls with 'AND'.
/** * Generates the WHERE portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:720
- public orWhere($key, $value = null, ?bool $escape = null): $this OR WHERE
/** * OR WHERE * * Generates the WHERE portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:736
- protected whereHaving(string $qbKey, $key, $value = null, string $type = 'AND ', ?bool $escape = null): $this
/** * @used-by where() * @used-by orWhere() * @used-by having() * @used-by orHaving() * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:752
- public whereIn(?string $key = null, $values = null, ?bool $escape = null): $this Generates a WHERE field IN('item', 'item') SQL query, joined with 'AND' if ap...
/** * Generates a WHERE field IN('item', 'item') SQL query, * joined with 'AND' if appropriate. * * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:848
- public orWhereIn(?string $key = null, $values = null, ?bool $escape = null): $this Generates a WHERE field IN('item', 'item') SQL query, joined with 'OR' if app...
/** * Generates a WHERE field IN('item', 'item') SQL query, * joined with 'OR' if appropriate. * * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:861
- public whereNotIn(?string $key = null, $values = null, ?bool $escape = null): $this Generates a WHERE field NOT IN('item', 'item') SQL query, joined with 'AND' i...
/** * Generates a WHERE field NOT IN('item', 'item') SQL query, * joined with 'AND' if appropriate. * * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:874
- public orWhereNotIn(?string $key = null, $values = null, ?bool $escape = null): $this Generates a WHERE field NOT IN('item', 'item') SQL query, joined with 'OR' if...
/** * Generates a WHERE field NOT IN('item', 'item') SQL query, * joined with 'OR' if appropriate. * * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:887
- public havingIn(?string $key = null, $values = null, ?bool $escape = null): $this Generates a HAVING field IN('item', 'item') SQL query, joined with 'AND' if a...
/** * Generates a HAVING field IN('item', 'item') SQL query, * joined with 'AND' if appropriate. * * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:900
- public orHavingIn(?string $key = null, $values = null, ?bool $escape = null): $this Generates a HAVING field IN('item', 'item') SQL query, joined with 'OR' if ap...
/** * Generates a HAVING field IN('item', 'item') SQL query, * joined with 'OR' if appropriate. * * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:913
- public havingNotIn(?string $key = null, $values = null, ?bool $escape = null): $this Generates a HAVING field NOT IN('item', 'item') SQL query, joined with 'AND' ...
/** * Generates a HAVING field NOT IN('item', 'item') SQL query, * joined with 'AND' if appropriate. * * @param array|BaseBuilder|(Closure(BaseBuilder):BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:926
- public orHavingNotIn(?string $key = null, $values = null, ?bool $escape = null): $this Generates a HAVING field NOT IN('item', 'item') SQL query, joined with 'OR' i...
/** * Generates a HAVING field NOT IN('item', 'item') SQL query, * joined with 'OR' if appropriate. * * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:939
- protected _whereIn(?string $key = null, $values = null, bool $not = false, string $type = 'AND ', ?bool $escape = null, string $clause = 'QBWhere'): $this
/** * @used-by WhereIn() * @used-by orWhereIn() * @used-by whereNotIn() * @used-by orWhereNotIn() * * @param non-empty-string|null $key * @param array|BaseBuilder|(Closure(BaseBuilder): BaseBuilder)|null $values The values searched on, or anonymous function with subquery * * @return $this * * @throws InvalidArgumentException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:957
- public like($field, string $match = '', string $side = 'both', ?bool $escape = null, bool $insensitiveSearch = false): $this Generates a %LIKE% portion of the query. Separates multiple calls with 'AND'.
/** * Generates a %LIKE% portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1008
- public notLike($field, string $match = '', string $side = 'both', ?bool $escape = null, bool $insensitiveSearch = false): $this Generates a NOT LIKE portion of the query. Separates multiple calls with 'AND'.
/** * Generates a NOT LIKE portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1021
- public orLike($field, string $match = '', string $side = 'both', ?bool $escape = null, bool $insensitiveSearch = false): $this Generates a %LIKE% portion of the query. Separates multiple calls with 'OR'.
/** * Generates a %LIKE% portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1034
- public orNotLike($field, string $match = '', string $side = 'both', ?bool $escape = null, bool $insensitiveSearch = false): $this Generates a NOT LIKE portion of the query. Separates multiple calls with 'OR'.
/** * Generates a NOT LIKE portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1047
- public havingLike($field, string $match = '', string $side = 'both', ?bool $escape = null, bool $insensitiveSearch = false): $this Generates a %LIKE% portion of the query. Separates multiple calls with 'AND'.
/** * Generates a %LIKE% portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1060
- public notHavingLike($field, string $match = '', string $side = 'both', ?bool $escape = null, bool $insensitiveSearch = false): $this Generates a NOT LIKE portion of the query. Separates multiple calls with 'AND'.
/** * Generates a NOT LIKE portion of the query. * Separates multiple calls with 'AND'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1073
- public orHavingLike($field, string $match = '', string $side = 'both', ?bool $escape = null, bool $insensitiveSearch = false): $this Generates a %LIKE% portion of the query. Separates multiple calls with 'OR'.
/** * Generates a %LIKE% portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1086
- public orNotHavingLike($field, string $match = '', string $side = 'both', ?bool $escape = null, bool $insensitiveSearch = false): $this Generates a NOT LIKE portion of the query. Separates multiple calls with 'OR'.
/** * Generates a NOT LIKE portion of the query. * Separates multiple calls with 'OR'. * * @param array|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1099
- protected _like($field, string $match = '', string $type = 'AND ', string $side = 'both', string $not = '', ?bool $escape = null, bool $insensitiveSearch = false, string $clause = 'QBWhere'): $this
/** * @used-by like() * @used-by orLike() * @used-by notLike() * @used-by orNotLike() * @used-by havingLike() * @used-by orHavingLike() * @used-by notHavingLike() * @used-by orNotHavingLike() * * @param array<string, string>|RawSql|string $field * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1118
- protected _like_statement(?string $prefix, string $column, ?string $not, string $bind, bool $insensitiveSearch = false): string Platform independent LIKE statement builder.
/** * Platform independent LIKE statement builder. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1193
- public union($union): $this Add UNION statement
/** * Add UNION statement * * @param BaseBuilder|Closure(BaseBuilder): BaseBuilder $union * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1209
- public unionAll($union): $this Add UNION ALL statement
/** * Add UNION ALL statement * * @param BaseBuilder|Closure(BaseBuilder): BaseBuilder $union * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1221
- protected addUnionStatement($union, bool $all = false): $this
/** * @used-by union() * @used-by unionAll() * * @param BaseBuilder|Closure(BaseBuilder): BaseBuilder $union * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1234
- public groupStart(): $this Starts a query group.
/** * Starts a query group. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1249
- public orGroupStart(): $this Starts a query group, but ORs the group
/** * Starts a query group, but ORs the group * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1259
- public notGroupStart(): $this Starts a query group, but NOTs the group
/** * Starts a query group, but NOTs the group * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1269
- public orNotGroupStart(): $this Starts a query group, but OR NOTs the group
/** * Starts a query group, but OR NOTs the group * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1279
- public groupEnd(): $this Ends a query group
/** * Ends a query group * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1289
- public havingGroupStart(): $this Starts a query group for HAVING clause.
/** * Starts a query group for HAVING clause. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1299
- public orHavingGroupStart(): $this Starts a query group for HAVING clause, but ORs the group.
/** * Starts a query group for HAVING clause, but ORs the group. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1309
- public notHavingGroupStart(): $this Starts a query group for HAVING clause, but NOTs the group.
/** * Starts a query group for HAVING clause, but NOTs the group. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1319
- public orNotHavingGroupStart(): $this Starts a query group for HAVING clause, but OR NOTs the group.
/** * Starts a query group for HAVING clause, but OR NOTs the group. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1329
- public havingGroupEnd(): $this Ends a query group for HAVING clause.
/** * Ends a query group for HAVING clause. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1339
- protected groupStartPrepare(string $not = '', string $type = 'AND ', string $clause = 'QBWhere'): $this Prepate a query group start.
/** * Prepate a query group start. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1349
- protected groupEndPrepare(string $clause = 'QBWhere'): $this Prepate a query group end.
/** * Prepate a query group end. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1370
- protected groupGetType(string $type): string
/** * @used-by groupStart() * @used-by _like() * @used-by whereHaving() * @used-by _whereIn() * @used-by havingGroupStart() */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1390
- public groupBy($by, ?bool $escape = null): $this
/** * @param array|string $by * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1405
- public having($key, $value = null, ?bool $escape = null): $this Separates multiple calls with 'AND'.
/** * Separates multiple calls with 'AND'. * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1439
- public orHaving($key, $value = null, ?bool $escape = null): $this Separates multiple calls with 'OR'.
/** * Separates multiple calls with 'OR'. * * @param array|RawSql|string $key * @param mixed $value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1452
- public orderBy(string $orderBy, string $direction = '', ?bool $escape = null): $this
/** * @param string $direction ASC, DESC or RANDOM * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1462
- public limit(?int $value = null, ?int $offset = 0): $this
/** * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1514
- public offset(int $offset): $this Sets the OFFSET value
/** * Sets the OFFSET value * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1537
- protected _limit(string $sql, bool $offsetIgnore = false): string Generates a platform-specific LIMIT clause.
/** * Generates a platform-specific LIMIT clause. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1549
- public set($key, $value = '', ?bool $escape = null): $this Allows key/value pairs to be set for insert(), update() or replace().
/** * Allows key/value pairs to be set for insert(), update() or replace(). * * @param array|object|string $key Field name, or an array of field/value pairs, or an object * @param mixed $value Field value, if $key is a single field * @param bool|null $escape Whether to escape values * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1563
- public getSetData(bool $clean = false): array Returns the previously set() data, alternatively resetting it if needed.
/** * Returns the previously set() data, alternatively resetting it if needed. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1589
- public getCompiledSelect(bool $reset = true): string Compiles a SELECT query string and returns the sql.
/** * Compiles a SELECT query string and returns the sql. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1603
- protected compileFinalQuery(string $sql): string Returns a finalized, compiled query string with the bindings inserted and pre...
/** * Returns a finalized, compiled query string with the bindings * inserted and prefixes swapped out. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1618
- public get(?int $limit = null, int $offset = 0, bool $reset = true): false|ResultInterface Compiles the select statement based on the other functions called and runs th...
/** * Compiles the select statement based on the other functions called * and runs the query * * @return false|ResultInterface */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1636
- public countAll(bool $reset = true): int|string Generates a platform-specific query string that counts all records in the par...
/** * Generates a platform-specific query string that counts all records in * the particular table * * @return int|string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1667
- public countAllResults(bool $reset = true): int|string Generates a platform-specific query string that counts all records returned b...
/** * Generates a platform-specific query string that counts all records * returned by an Query Builder query. * * @return int|string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1699
- public getCompiledQBWhere(): array Compiles the set conditions and returns the sql statement
/** * Compiles the set conditions and returns the sql statement * * @return array */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1758
- public getWhere($where = null, ?int $limit = null, ?int $offset = 0, bool $reset = true): ResultInterface Allows the where clause, limit and offset to be added directly
/** * Allows the where clause, limit and offset to be added directly * * @param array|string $where * * @return ResultInterface */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1770
- protected batchExecute(string $renderMethod, int $batchSize = 100): false|int|list<string> Number of rows inserted or FALSE on failure, SQL array when testMode Compiles batch insert/update/upsert strings and runs the queries
/** * Compiles batch insert/update/upsert strings and runs the queries * * @param '_deleteBatch'|'_insertBatch'|'_updateBatch'|'_upsertBatch' $renderMethod * * @return false|int|list<string> Number of rows inserted or FALSE on failure, SQL array when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1808
- public setData($set, ?bool $escape = null, string $alias = ''): $this|null Allows a row or multiple rows to be set for batch inserts/upserts/updates
/** * Allows a row or multiple rows to be set for batch inserts/upserts/updates * * @param array|object $set * @param string $alias alias for sql table * * @return $this|null */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1861
- public getCompiledUpsert(): string Compiles an upsert query and returns the sql
/** * Compiles an upsert query and returns the sql * * @return string * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1925
- public upsert($set = null, ?bool $escape = null): false|int|list<string> Number of affected rows or FALSE on failure, SQL array when testMode Converts call to batchUpsert
/** * Converts call to batchUpsert * * @param array|object|null $set * * @return false|int|list<string> Number of affected rows or FALSE on failure, SQL array when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1945
- public upsertBatch($set = null, ?bool $escape = null, int $batchSize = 100): false|int|list<string> Number of affected rows or FALSE on failure, SQL array when testMode Compiles batch upsert strings and runs the queries
/** * Compiles batch upsert strings and runs the queries * * @param array|object|null $set a dataset * * @return false|int|list<string> Number of affected rows or FALSE on failure, SQL array when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:1981
- protected _upsertBatch(string $table, array $keys, array $values): string Generates a platform-specific upsertBatch string from the supplied data
/** * Generates a platform-specific upsertBatch string from the supplied data * * @used-by batchExecute() * * @param string $table Protected table name * @param list<string> $keys QBKeys * @param list<list<int|string>> $values QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2015
- public updateFields($set, bool $addToDefault = false, ?array $ignore = null): $this Sets update fields for upsert, update
/** * Sets update fields for upsert, update * * @param list<RawSql>|list<string>|string $set * @param bool $addToDefault adds update fields to the default ones * @param array|null $ignore ignores items in set * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2068
- public onConstraint($set): $this Sets constraints for batch upsert, update
/** * Sets constraints for batch upsert, update * * @param array|RawSql|string $set a string of columns, key value pairs, or RawSql * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2110
- public setQueryAsData($query, ?string $alias = null, $columns = null): CodeIgniter\Database\BaseBuilder Sets data source as a query for insertBatch()/updateBatch()/upsertBatch()/del...
/** * Sets data source as a query for insertBatch()/updateBatch()/upsertBatch()/deleteBatch() * * @param BaseBuilder|RawSql $query * @param array|string|null $columns an array or comma delimited string of columns */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2145
- protected fieldsFromQuery(string $sql): array Gets column names from a select query
/** * Gets column names from a select query */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2188
- protected formatValues(array $values): array Converts value array of array to array of strings
/** * Converts value array of array to array of strings */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2196
- public insertBatch($set = null, ?bool $escape = null, int $batchSize = 100): false|int|list<string> Number of rows inserted or FALSE on no data to perform an insert operation, SQL array when testMode Compiles batch insert strings and runs the queries
/** * Compiles batch insert strings and runs the queries * * @param array|object|null $set a dataset * * @return false|int|list<string> Number of rows inserted or FALSE on no data to perform an insert operation, SQL array when testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2208
- protected _insertBatch(string $table, array $keys, array $values): string Generates a platform-specific insert string from the supplied data.
/** * Generates a platform-specific insert string from the supplied data. * * @used-by batchExecute() * * @param string $table Protected table name * @param list<string> $keys QBKeys * @param list<list<int|string>> $values QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2242
- public setInsertBatch($key, string $value = '', ?bool $escape = null): $this|null Allows key/value pairs to be set for batch inserts
/** * Allows key/value pairs to be set for batch inserts * * @param mixed $key * * @return $this|null * * @deprecated */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2272
- public getCompiledInsert(bool $reset = true): bool|string Compiles an insert query and returns the sql
/** * Compiles an insert query and returns the sql * * @return bool|string * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2288
- public insert($set = null, ?bool $escape = null): BaseResult|bool|Query Compiles an insert string and runs the query
/** * Compiles an insert string and runs the query * * @param array|object|null $set * * @return BaseResult|bool|Query * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2321
- protected removeAlias(string $from): string
/** * @internal This is a temporary solution. * * @see https://github.com/codeigniter4/CodeIgniter4/pull/5376 * * @TODO Fix a root cause, and this method should be removed. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2363
- protected validateInsert(): bool This method is used by both insert() and getCompiledInsert() to validate that...
/** * This method is used by both insert() and getCompiledInsert() to * validate that the there data is actually being set and that table * has been chosen to be inserted into. * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2383
- protected _insert(string $table, array $keys, array $unescapedKeys): string Generates a platform-specific insert string from the supplied data
/** * Generates a platform-specific insert string from the supplied data * * @param string $table Protected table name * @param list<string> $keys Keys of QBSet * @param list<int|string> $unescapedKeys Values of QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2403
- public replace(?array $set = null): BaseResult|false|Query|string Compiles a replace into string and runs the query
/** * Compiles a replace into string and runs the query * * @return BaseResult|false|Query|string * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2415
- protected _replace(string $table, array $keys, array $values): string Generates a platform-specific replace string from the supplied data
/** * Generates a platform-specific replace string from the supplied data * * @param string $table Protected table name * @param list<string> $keys Keys of QBSet * @param list<int|string> $values Values of QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2445
- public getCompiledUpdate(bool $reset = true): bool|string Compiles an update query and returns the sql
/** * Compiles an update query and returns the sql * * @return bool|string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2466
- public update($set = null, $where = null, ?int $limit = null): bool Compiles an update string and runs the query.
/** * Compiles an update string and runs the query. * * @param array|object|null $set * @param array|RawSql|string|null $where * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2489
- protected _update(string $table, array $values): string Generates a platform-specific update string from the supplied data
/** * Generates a platform-specific update string from the supplied data * * @param string $table Protected table name * @param array<string, string> $values QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2542
- protected validateUpdate(): bool This method is used by both update() and getCompiledUpdate() to validate that...
/** * This method is used by both update() and getCompiledUpdate() to * validate that data is actually being set and that a table has been * chosen to be updated. * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2571
- public updateBatch($set = null, $constraints = null, int $batchSize = 100): false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode Sets data and calls batchExecute to run queries
/** * Sets data and calls batchExecute to run queries * * @param array|object|null $set a dataset * @param array|RawSql|string|null $constraints * * @return false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2592
- public setUpdateBatch($key, string $index = '', ?bool $escape = null): $this Allows key/value pairs to be set for batch updating
/** * Allows key/value pairs to be set for batch updating * * @param array|object $key * * @return $this * * @throws DatabaseException * * @deprecated */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2723
- public emptyTable(): bool|string TRUE on success, FALSE on failure, string on testMode Compiles a delete string and runs "DELETE FROM table"
/** * Compiles a delete string and runs "DELETE FROM table" * * @return bool|string TRUE on success, FALSE on failure, string on testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2739
- public truncate(): bool|string TRUE on success, FALSE on failure, string on testMode Compiles a truncate string and runs the query If the database does not suppor...
/** * Compiles a truncate string and runs the query * If the database does not support the truncate() command * This function maps to "DELETE FROM table" * * @return bool|string TRUE on success, FALSE on failure, string on testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2761
- protected _truncate(string $table): string Generates a platform-specific truncate string from the supplied data
/** * Generates a platform-specific truncate string from the supplied data * * If the database does not support the truncate() command, * then this method maps to 'DELETE FROM table' * * @param string $table Protected table name */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2784
- public getCompiledDelete(bool $reset = true): string Compiles a delete query string and returns the sql
/** * Compiles a delete query string and returns the sql */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2792
- public delete($where = '', ?int $limit = null, bool $resetData = true): bool|string Returns a SQL string if in test mode. Compiles a delete string and runs the query
/** * Compiles a delete string and runs the query * * @param array|RawSql|string $where * * @return bool|string Returns a SQL string if in test mode. * * @throws DatabaseException */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2809
- public deleteBatch($set = null, $constraints = null, int $batchSize = 100): false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode Sets data and calls batchExecute to run queries
/** * Sets data and calls batchExecute to run queries * * @param array|object|null $set a dataset * @param array|RawSql|null $constraints * * @return false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2859
- protected _deleteBatch(string $table, array $keys, array $values): string Generates a platform-specific batch update string from the supplied data
/** * Generates a platform-specific batch update string from the supplied data * * @used-by batchExecute() * * @param string $table Protected table name * @param list<string> $keys QBKeys * @param list<int|string> $values QBSet */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2895
- public increment(string $column, int $value = 1): bool Increments a numeric column by the specified value.
/** * Increments a numeric column by the specified value. * * @return bool */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2972
- public decrement(string $column, int $value = 1): bool Decrements a numeric column by the specified value.
/** * Decrements a numeric column by the specified value. * * @return bool */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2992
- protected _delete(string $table): string Generates a platform-specific delete string from the supplied data
/** * Generates a platform-specific delete string from the supplied data * * @param string $table Protected table name */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3012
- protected trackAliases($table): string|null Used to track SQL statements written with aliased tables.
/** * Used to track SQL statements written with aliased tables. * * @param array|string $table The table to inspect * * @return string|null */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3024
- protected compileSelect($selectOverride = false): string Compile the SELECT statement
/** * Compile the SELECT statement * * Generates a query string based on which functions were used. * Should not be called directly. * * @param mixed $selectOverride */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3063
- protected compileIgnore(string $statement): string Checks if the ignore option is supported by the Database Driver for the speci...
/** * Checks if the ignore option is supported by * the Database Driver for the specific statement. * * @return string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3120
- protected compileWhereHaving(string $qbKey): string Escapes identifiers in WHERE and HAVING statements at execution time.
/** * Escapes identifiers in WHERE and HAVING statements at execution time. * * Required so that aliases are tracked properly, regardless of whether * where(), orWhere(), having(), orHaving are called prior to from(), * join() and prefixTable is added only if needed. * * @param string $qbKey 'QBWhere' or 'QBHaving' * * @return string SQL statement */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3140
- protected compileGroupBy(): string Escapes identifiers in GROUP BY statements at execution time.
/** * Escapes identifiers in GROUP BY statements at execution time. * * Required so that aliases are tracked properly, regardless of whether * groupBy() is called prior to from(), join() and prefixTable is added * only if needed. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3229
- protected compileOrderBy(): string Escapes identifiers in ORDER BY statements at execution time.
/** * Escapes identifiers in ORDER BY statements at execution time. * * Required so that aliases are tracked properly, regardless of whether * orderBy() is called prior to from(), join() and prefixTable is added * only if needed. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3256
- protected unionInjection(string $sql): string
Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3277
- protected objectToArray($object): array Takes an object as input and converts the class variables to array key/vals
/** * Takes an object as input and converts the class variables to array key/vals * * @param array|object $object * * @return array */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3295
- protected batchObjectToArray($object): array Takes an object as input and converts the class variables to array key/vals
/** * Takes an object as input and converts the class variables to array key/vals * * @param array|object $object * * @return array */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3323
- protected isLiteral(string $str): bool Determines if a string represents a literal value or a field name
/** * Determines if a string represents a literal value or a field name */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3347
- public resetQuery(): $this Publicly-visible method to reset the QB values.
/** * Publicly-visible method to reset the QB values. * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3371
- protected resetRun(array $qbResetItems) Resets the query builder values. Called by the get() function
/** * Resets the query builder values. Called by the get() function * * @param array $qbResetItems An array of fields to reset */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3384
- protected resetSelect() Resets the query builder values. Called by the get() function
/** * Resets the query builder values. Called by the get() function */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3394
- protected resetWrite() Resets the query builder "write" values.
/** * Resets the query builder "write" values. * * Called by the insert() update() insertBatch() updateBatch() and delete() functions */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3425
- protected hasOperator(string $str): bool Tests whether the string has an SQL operator
/** * Tests whether the string has an SQL operator */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3442
- protected getOperator(string $str, bool $list = false): array|false|string Returns the SQL string operator
/** * Returns the SQL string operator * * @return array|false|string */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3455
- protected setBind(string $key, $value = null, bool $escape = true): string Stores a bind value after ensuring that it's unique. While it might be nicer ...
/** * Stores a bind value after ensuring that it's unique. * While it might be nicer to have named keys for our binds array * with PHP 7+ we get a huge memory/performance gain with indexed * arrays instead, so lets take advantage of that here. * * @param mixed $value */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3523
- protected cleanClone(): $this Returns a clone of a Base Builder with reset query builder values.
/** * Returns a clone of a Base Builder with reset query builder values. * * @return $this * * @deprecated */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3555
- protected isSubquery($value): bool
/** * @param mixed $value */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3563
- protected buildSubquery($builder, bool $wrapped = false, string $alias = ''): string
/** * @param BaseBuilder|Closure(BaseBuilder): BaseBuilder $builder * @param bool $wrapped Wrap the subquery in brackets * @param string $alias Subquery alias */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3573
- public when($condition, callable $callback, ?callable $defaultCallback = null): self Only runs the query when $condition evaluates to true
/** * Only runs the query when $condition evaluates to true * * @template TWhen of mixed * * @phpstan-param TWhen $condition * @phpstan-param callable(self, TWhen): mixed $callback * @phpstan-param (callable(self): mixed)|null $defaultCallback * @param array|bool|float|int|object|resource|string|null $condition * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Traits/ConditionalTrait.php:30
- public whenNot($condition, callable $callback, ?callable $defaultCallback = null): self Only runs the query when $condition evaluates to false
/** * Only runs the query when $condition evaluates to false * * @template TWhenNot of mixed * * @phpstan-param TWhenNot $condition * @phpstan-param callable(self, TWhenNot): mixed $callback * @phpstan-param (callable(self): mixed)|null $defaultCallback * @param array|bool|float|int|object|resource|string|null $condition * * @return $this */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Traits/ConditionalTrait.php:53
- private CodeIgniter\Database\BaseBuilder::setAlias(string $alias): CodeIgniter\Database\BaseBuilder Set table alias for dataset pseudo table.
/** * Set table alias for dataset pseudo table. */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:2049
- private CodeIgniter\Database\BaseBuilder::getOperatorFromWhereKey(string $whereKey): false|list<string> Returns the SQL string operator from where key
/** * Returns the SQL string operator from where key * * @return false|list<string> */ Inherited from CodeIgniter\Database\BaseBuilder Defined in .../system/Database/BaseBuilder.php:3489
- protected tempData -> array (0)
- protected escape -> array (0)
- private builderMethodsNotAvailable -> array (3)
- 0 => string (17) "getCompiledInsert"
- 1 => string (17) "getCompiledSelect"
- 2 => string (17) "getCompiledUpdate"
- public pager -> null
- public __construct(?KoclikoDisplay\Models\ConnectionInterface $db = null, ?KoclikoDisplay\Models\ValidationInterface $validation = null)new \KoclikoDisplay\Models\ContentOwnerModel()
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:21
- protected identifiateImage(array $data)
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:44
- protected identifiateVideo(array $data)
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:55
- public slugify(array $data)model('ContentOwnerModel')->slugify()
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:66
- public getClassExists($entityName, $namespaced = true)model('ContentOwnerModel')->getClassExists()
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:94
- public getEnumValues($field)model('ContentOwnerModel')->getEnumValues()
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:114
- public allowedField($attribute = null)model('ContentOwnerModel')->allowedField()
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:127
- public getAllowedFields()model('ContentOwnerModel')->getAllowedFields()
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:133
- public getPrimaryKey()model('ContentOwnerModel')->getPrimaryKey()
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Models/BaseModel.php:138
- public setTable(string $table): $this Specify the table associated with a modelmodel('ContentOwnerModel')->setTable()
/** * Specify the table associated with a model * * @param string $table Table * * @return $this */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:169
- protected doFind(bool $singleton, $id = null): array|object|null The resulting row of data, or null. Fetches the row(s) of database from $this->table with a primary key matching ...
/** * Fetches the row(s) of database from $this->table with a primary key * matching $id. * This method works only with dbCalls. * * @param bool $singleton Single or multiple results * @param array|int|string|null $id One primary key or an array of primary keys * * @return array|object|null The resulting row of data, or null. * @phpstan-return ($singleton is true ? row_array|null|object : list<row_array|object>) */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:187
- protected doFindColumn(string $columnName): array|null The resulting row of data, or null if no data found. Fetches the column of database from $this->table. This method works only with...
/** * Fetches the column of database from $this->table. * This method works only with dbCalls. * * @param string $columnName Column Name * * @return array|null The resulting row of data, or null if no data found. * @phpstan-return list<row_array>|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:250
- protected doFindAll(?int $limit = null, int $offset = 0): array Works with the current Query Builder instance to return all results, while op...
/** * Works with the current Query Builder instance to return * all results, while optionally limiting them. * This method works only with dbCalls. * * @param int|null $limit Limit * @param int $offset Offset * * @return array * @phpstan-return list<row_array|object> */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:266
- protected doFirst(): array|object|null Returns the first row of the result set. Will take any previous Query Builder...
/** * Returns the first row of the result set. Will take any previous * Query Builder calls into account when determining the result set. * This method works only with dbCalls. * * @return array|object|null * @phpstan-return row_array|object|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:308
- protected doInsert(array $row): bool Inserts data into the current table. This method works only with dbCalls.
/** * Inserts data into the current table. * This method works only with dbCalls. * * @param array $row Row data * @phpstan-param row_array $row * * @return bool */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:350
- protected doInsertBatch(?array $set = null, ?bool $escape = null, int $batchSize = 100, bool $testing = false): bool|int Number of rows inserted or FALSE on failure Compiles batch insert strings and runs the queries, validating each row prior...
/** * Compiles batch insert strings and runs the queries, validating each row prior. * This method works only with dbCalls. * * @param array|null $set An associative array of insert values * @param bool|null $escape Whether to escape values * @param int $batchSize The size of the batch to run * @param bool $testing True means only number of records is returned, false will execute the query * * @return bool|int Number of rows inserted or FALSE on failure */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:416
- protected doUpdate($id = null, $row = null): bool Updates a single record in $this->table. This method works only with dbCalls.
/** * Updates a single record in $this->table. * This method works only with dbCalls. * * @param array|int|string|null $id * @param array|null $row Row data * @phpstan-param row_array|null $row */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:439
- protected doUpdateBatch(?array $set = null, ?string $index = null, int $batchSize = 100, bool $returnSQL = false): false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode Compiles an update string and runs the query This method works only with dbCa...
/** * Compiles an update string and runs the query * This method works only with dbCalls. * * @param array|null $set An associative array of update values * @param string|null $index The where key * @param int $batchSize The size of the batch to run * @param bool $returnSQL True means SQL is returned, false will execute the query * * @return false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:477
- protected doDelete($id = null, bool $purge = false): bool|string SQL string when testMode Deletes a single record from $this->table where $id matches the table's prima...
/** * Deletes a single record from $this->table where $id matches * the table's primaryKey * This method works only with dbCalls. * * @param array|int|string|null $id The rows primary key(s) * @param bool $purge Allows overriding the soft deletes setting. * * @return bool|string SQL string when testMode * * @throws DatabaseException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:494
- protected doPurgeDeleted(): bool|string Returns a SQL string if in test mode. Permanently deletes all rows that have been marked as deleted through soft de...
/** * Permanently deletes all rows that have been marked as deleted * through soft deletes (deleted = 1) * This method works only with dbCalls. * * @return bool|string Returns a SQL string if in test mode. */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:531
- protected doOnlyDeleted(): void Works with the find* methods to return only the rows that have been deleted. ...
/** * Works with the find* methods to return only the rows that * have been deleted. * This method works only with dbCalls. * * @return void */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:545
- protected doReplace(?array $row = null, bool $returnSQL = false): BaseResult|false|Query|string Compiles a replace into string and runs the query This method works only with...
/** * Compiles a replace into string and runs the query * This method works only with dbCalls. * * @param array|null $row Data * @phpstan-param row_array|null $row * @param bool $returnSQL Set to true to return Query String * * @return BaseResult|false|Query|string */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:560
- protected doErrors(): array<string, string> Grabs the last error(s) that occurred from the Database connection. The retur...
/** * Grabs the last error(s) that occurred from the Database connection. * The return array should be in the following format: * ['source' => 'message'] * This method works only with dbCalls. * * @return array<string, string> */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:573
- public getIdValue($row): array|int|string|null Returns the id value for the data array or objectmodel('ContentOwnerModel')->getIdValue()
/** * Returns the id value for the data array or object * * @param array|object $row Row data * @phpstan-param row_array|object $row * * @return array|int|string|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:593
- public chunk(int $size, Closure $userFunc) Loops over records in batches, allowing you to operate on them. Works with $t...model('ContentOwnerModel')->chunk()
/** * Loops over records in batches, allowing you to operate on them. * Works with $this->builder to get the Compiled select to * determine the rows to operate on. * This method works only with dbCalls. */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:629
- public countAllResults(bool $reset = true, bool $test = false): int|string Override countAllResults to account for soft deleted accounts.model('ContentOwnerModel')->countAllResults()
/** * Override countAllResults to account for soft deleted accounts. * * @return int|string */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:663
- public builder(?string $table = null): BaseBuilder Provides a shared instance of the Query Builder.model('ContentOwnerModel')->builder()
/** * Provides a shared instance of the Query Builder. * * @param non-empty-string|null $table * * @return BaseBuilder * * @throws ModelException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:688
- public set($key, $value = '', ?bool $escape = null): $this Captures the builder's set() method so that we can validate the data here. Th...model('ContentOwnerModel')->set()
/** * Captures the builder's set() method so that we can validate the * data here. This allows it to be used with any of the other * builder methods and still get validated data, like replace. * * @param array|object|string $key Field name, or an array of field/value pairs, or an object * @param bool|float|int|object|string|null $value Field value, if $key is a single field * @param bool|null $escape Whether to escape values * * @return $this */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:735
- protected shouldUpdate($row): bool This method is called on save to determine if entry have to be updated If thi...
/** * This method is called on save to determine if entry have to be updated * If this method return false insert operation will be executed * * @param array|object $row Data */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:758
- public insert($row = null, bool $returnID = true): bool|int|string Inserts data into the database. If an object is provided, it will attempt to ...model('ContentOwnerModel')->insert()
/** * Inserts data into the database. If an object is provided, * it will attempt to convert it to an array. * * @param array|object|null $row * @phpstan-param row_array|object|null $row * @param bool $returnID Whether insert ID should be returned or not. * * @return bool|int|string * @phpstan-return ($returnID is true ? int|string|false : bool) * * @throws ReflectionException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:786
- protected doProtectFieldsForInsert(array $row): array Ensures that only the fields that are allowed to be inserted are in the data ...
/** * Ensures that only the fields that are allowed to be inserted are in * the data array. * * @used-by insert() to protect against mass assignment vulnerabilities. * @used-by insertBatch() to protect against mass assignment vulnerabilities. * * @param array $row Row data * @phpstan-param row_array $row * * @throws DataException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:815
- public update($id = null, $row = null): bool Updates a single record in the database. If an object is provided, it will at...model('ContentOwnerModel')->update()
/** * Updates a single record in the database. If an object is provided, * it will attempt to convert it into an array. * * @param array|int|string|null $id * @param array|object|null $row * @phpstan-param row_array|object|null $row * * @throws ReflectionException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:849
- protected objectToRawArray($object, bool $onlyChanged = true, bool $recursive = false): array Takes a class and returns an array of its public and protected properties as ...
/** * Takes a class and returns an array of its public and protected * properties as an array with raw values. * * @param object $object Object * @param bool $recursive If true, inner entities will be cast as array as well * * @return array<string, mixed> Array with raw values. * * @throws ReflectionException */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:877
- public __get(string $name): array|BaseBuilder|bool|float|int|object|string|null Provides/instantiates the builder/db connection and model's table/primary key...
/** * Provides/instantiates the builder/db connection and model's table/primary key names and return type. * * @param string $name Name * * @return array|BaseBuilder|bool|float|int|object|string|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:889
- public __isset(string $name): bool Checks for the existence of properties across this model, builder, and db con...
/** * Checks for the existence of properties across this model, builder, and db connection. * * @param string $name Name */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:903
- public __call(string $name, array $params): $this|array|BaseBuilder|bool|float|int|object|string|null Provides direct access to method in the builder (if available) and the databa...
/** * Provides direct access to method in the builder (if available) * and the database connection. * * @return $this|array|BaseBuilder|bool|float|int|object|string|null */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:918
- protected createDataConverter(): void Creates DataConverter instance.
/** * Creates DataConverter instance. */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:376
- protected useCasts(): bool Are casts used?
/** * Are casts used? */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:390
- protected initialize(): void Initializes the instance with any additional steps. Optionally implemented by...
/** * Initializes the instance with any additional steps. * Optionally implemented by child classes. * * @return void */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:401
- public find($id = null): array|object|null The resulting row of data, or null. Fetches the row of database.model('ContentOwnerModel')->find()
/** * Fetches the row of database. * * @param array|int|string|null $id One primary key or an array of primary keys * * @return array|object|null The resulting row of data, or null. * @phpstan-return ($id is int|string ? row_array|object|null : list<row_array|object>) */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:590
- public findColumn(string $columnName): array|null The resulting row of data, or null if no data found. Fetches the column of database.model('ContentOwnerModel')->findColumn()
/** * Fetches the column of database. * * @param string $columnName Column Name * * @return array|null The resulting row of data, or null if no data found. * * @throws DataException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:634
- public findAll(?int $limit = null, int $offset = 0): array Fetches all results, while optionally limiting them.model('ContentOwnerModel')->findAll()
/** * Fetches all results, while optionally limiting them. * * @param int $limit Limit * @param int $offset Offset * * @return array */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:653
- public first(): array|object|null Returns the first row of the result set.model('ContentOwnerModel')->first()
/** * Returns the first row of the result set. * * @return array|object|null */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:698
- public save($row): bool A convenience method that will attempt to determine whether the data should b...model('ContentOwnerModel')->save()
/** * A convenience method that will attempt to determine whether the * data should be inserted or updated. Will work with either * an array or object. When using with custom class objects, * you must ensure that the class will provide access to the class * variables, even if through a magic method. * * @param array|object $row Row data * @phpstan-param row_array|object $row * * @throws ReflectionException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:741
- public getInsertID(): int|string Returns last insert ID or 0.model('ContentOwnerModel')->getInsertID()
/** * Returns last insert ID or 0. * * @return int|string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:779
- protected setCreatedField(array $row, $date): array Set datetime to created field.
/** * Set datetime to created field. * * @phpstan-param row_array $row * @param int|string $date timestamp or datetime string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:869
- protected setUpdatedField(array $row, $date): array Set datetime to updated field.
/** * Set datetime to updated field. * * @phpstan-param row_array $row * @param int|string $date timestamp or datetime string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:884
- public insertBatch(?array $set = null, ?bool $escape = null, int $batchSize = 100, bool $testing = false): bool|int Number of rows inserted or FALSE on failure Compiles batch insert runs the queries, validating each row prior.model('ContentOwnerModel')->insertBatch()
/** * Compiles batch insert runs the queries, validating each row prior. * * @param list<array|object>|null $set an associative array of insert values * @phpstan-param list<row_array|object>|null $set * @param bool|null $escape Whether to escape values * @param int $batchSize The size of the batch to run * @param bool $testing True means only number of records is returned, false will execute the query * * @return bool|int Number of rows inserted or FALSE on failure * * @throws ReflectionException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:906
- public updateBatch(?array $set = null, ?string $index = null, int $batchSize = 100, bool $returnSQL = false): false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode Compiles an update and runs the query.model('ContentOwnerModel')->updateBatch()
/** * Compiles an update and runs the query. * * @param list<array|object>|null $set an associative array of insert values * @phpstan-param list<row_array|object>|null $set * @param string|null $index The where key * @param int $batchSize The size of the batch to run * @param bool $returnSQL True means SQL is returned, false will execute the query * * @return false|int|list<string> Number of rows affected or FALSE on failure, SQL array when testMode * * @throws DatabaseException * @throws ReflectionException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1053
- public delete($id = null, bool $purge = false): BaseResult|bool Deletes a single record from the database where $id matches.model('ContentOwnerModel')->delete()
/** * Deletes a single record from the database where $id matches. * * @param array|int|string|null $id The rows primary key(s) * @param bool $purge Allows overriding the soft deletes setting. * * @return BaseResult|bool * * @throws DatabaseException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1134
- public purgeDeleted(): bool|string Returns a string if in test mode. Permanently deletes all rows that have been marked as deleted through soft de...model('ContentOwnerModel')->purgeDeleted()
/** * Permanently deletes all rows that have been marked as deleted * through soft deletes (deleted = 1). * * @return bool|string Returns a string if in test mode. */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1175
- public withDeleted(bool $val = true): $this Sets $useSoftDeletes value so that we can temporarily override the soft delet...model('ContentOwnerModel')->withDeleted()
/** * Sets $useSoftDeletes value so that we can temporarily override * the soft deletes settings. Can be used for all find* methods. * * @param bool $val Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1192
- public onlyDeleted(): $this Works with the find* methods to return only the rows that have been deleted.model('ContentOwnerModel')->onlyDeleted()
/** * Works with the find* methods to return only the rows that * have been deleted. * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1205
- public replace(?array $row = null, bool $returnSQL = false): BaseResult|false|Query|string Compiles a replace and runs the query.model('ContentOwnerModel')->replace()
/** * Compiles a replace and runs the query. * * @param array|null $row Row data * @phpstan-param row_array|null $row * @param bool $returnSQL Set to true to return Query String * * @return BaseResult|false|Query|string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1222
- public errors(bool $forceDB = false): array<string, string> Grabs the last error(s) that occurred. If data was validated, it will first c...model('ContentOwnerModel')->errors()
/** * Grabs the last error(s) that occurred. If data was validated, * it will first check for errors there, otherwise will try to * grab the last error from the Database connection. * * The return array should be in the following format: * ['source' => 'message'] * * @param bool $forceDB Always grab the db error, not validation * * @return array<string, string> */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1246
- public paginate(?int $perPage = null, string $group = 'default', ?int $page = null, int $segment = 0): array|null Works with Pager to get the size and offset parameters. Expects a GET variabl...model('ContentOwnerModel')->paginate()
/** * Works with Pager to get the size and offset parameters. * Expects a GET variable (?page=2) that specifies the page of results * to display. * * @param int|null $perPage Items per page * @param string $group Will be used by the pagination library to identify a unique pagination set. * @param int|null $page Optional page number (useful when the page number is provided in different way) * @param int $segment Optional URI segment number (if page number is provided by URI segment) * * @return array|null */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1272
- public setAllowedFields(array $allowedFields): $this It could be used when you have to change default or override current allowed ...model('ContentOwnerModel')->setAllowedFields()
/** * It could be used when you have to change default or override current allowed fields. * * @param array $allowedFields Array with names of fields * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1297
- public protect(bool $protect = true): $this Sets whether or not we should whitelist data set during updates or inserts ag...model('ContentOwnerModel')->protect()
/** * Sets whether or not we should whitelist data set during * updates or inserts against $this->availableFields. * * @param bool $protect Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1312
- protected doProtectFields(array $row): array Ensures that only the fields that are allowed to be updated are in the data a...
/** * Ensures that only the fields that are allowed to be updated are * in the data array. * * @used-by update() to protect against mass assignment vulnerabilities. * @used-by updateBatch() to protect against mass assignment vulnerabilities. * * @param array $row Row data * @phpstan-param row_array $row * * @throws DataException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1331
- protected setDate(?int $userData = null): int|string Sets the date or current date if null value is passed.
/** * Sets the date or current date if null value is passed. * * @param int|null $userData An optional PHP timestamp to be converted. * * @return int|string * * @throws ModelException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1376
- protected intToDate(int $value): int|string A utility function to allow child models to use the type of date/time format ...
/** * A utility function to allow child models to use the type of * date/time format that they prefer. This is primarily used for * setting created_at, updated_at and deleted_at values, but can be * used by inheriting classes. * * The available time formats are: * - 'int' - Stores the date as an integer timestamp * - 'datetime' - Stores the data in the SQL datetime format * - 'date' - Stores the date (only) in the SQL date format. * * @param int $value value * * @return int|string * * @throws ModelException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1400
- protected timeToDate(CodeIgniter\I18n\Time $value): int|string Converts Time value to string using $this->dateFormat.
/** * Converts Time value to string using $this->dateFormat. * * The available time formats are: * - 'int' - Stores the date as an integer timestamp * - 'datetime' - Stores the data in the SQL datetime format * - 'date' - Stores the date (only) in the SQL date format. * * @param Time $value value * * @return int|string */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1422
- public skipValidation(bool $skip = true): $this Set the value of the skipValidation flag.model('ContentOwnerModel')->skipValidation()
/** * Set the value of the skipValidation flag. * * @param bool $skip Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1439
- public setValidationMessages(array $validationMessages): $this Allows to set (and reset) validation messages. It could be used when you have...model('ContentOwnerModel')->setValidationMessages()
/** * Allows to set (and reset) validation messages. * It could be used when you have to change default or override current validate messages. * * @param array $validationMessages Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1454
- public setValidationMessage(string $field, array $fieldMessages): $this Allows to set field wise validation message. It could be used when you have t...model('ContentOwnerModel')->setValidationMessage()
/** * Allows to set field wise validation message. * It could be used when you have to change default or override current validate messages. * * @param string $field Field Name * @param array $fieldMessages Validation messages * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1470
- public setValidationRules(array $validationRules): $this Allows to set (and reset) validation rules. It could be used when you have to...model('ContentOwnerModel')->setValidationRules()
/** * Allows to set (and reset) validation rules. * It could be used when you have to change default or override current validate rules. * * @param array<string, array<string, array<string, string>|string>|string> $validationRules Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1485
- public setValidationRule(string $field, $fieldRules): $this Allows to set field wise validation rules. It could be used when you have to ...model('ContentOwnerModel')->setValidationRule()
/** * Allows to set field wise validation rules. * It could be used when you have to change default or override current validate rules. * * @param string $field Field Name * @param array|string $fieldRules Validation rules * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1501
- public cleanRules(bool $choice = false): $this Should validation rules be removed before saving? Most handy when doing updates.model('ContentOwnerModel')->cleanRules()
/** * Should validation rules be removed before saving? * Most handy when doing updates. * * @param bool $choice Value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1529
- public validate($row): bool Validate the row data against the validation rules (or the validation group) ...model('ContentOwnerModel')->validate()
/** * Validate the row data against the validation rules (or the validation group) * specified in the class property, $validationRules. * * @param array|object $row Row data * @phpstan-param row_array|object $row */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1543
- public getValidationRules(array $options = array()): array Returns the model's defined validation rules so that they can be used elsewhe...model('ContentOwnerModel')->getValidationRules()
/** * Returns the model's defined validation rules so that they * can be used elsewhere, if needed. * * @param array $options Options */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1585
- protected ensureValidation(): void
Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1608
- public getValidationMessages(): array Returns the model's validation messages, so they can be used elsewhere, if ne...model('ContentOwnerModel')->getValidationMessages()
/** * Returns the model's validation messages, so they * can be used elsewhere, if needed. */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1619
- protected cleanValidationRules(array $rules, ?array $row = null): array Removes any rules that apply to fields that have not been set currently so th...
/** * Removes any rules that apply to fields that have not been set * currently so that rules don't block updating when only updating * a partial row. * * @param array $rules Array containing field name and rule * @param array $row Row data (@TODO Remove null in param type) * @phpstan-param row_array $row */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1633
- public allowCallbacks(bool $val = true): $this Sets $tempAllowCallbacks value so that we can temporarily override the settin...model('ContentOwnerModel')->allowCallbacks()
/** * Sets $tempAllowCallbacks value so that we can temporarily override * the setting. Resets after the next method that uses triggers. * * @param bool $val value * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1656
- protected trigger(string $event, array $eventData): array A simple event trigger for Model Events that allows additional data manipulat...
/** * A simple event trigger for Model Events that allows additional * data manipulation within the model. Specifically intended for * usage by child models this can be used to format data, * save/load related classes, etc. * * It is the responsibility of the callback methods to return * the data itself. * * Each $eventData array MUST have a 'data' key with the relevant * data for callback methods (like an array of key/value pairs to insert * or update, an array of results, etc.) * * If callbacks are not allowed then returns $eventData immediately. * * @param string $event Event * @param array $eventData Event Data * * @return array * * @throws DataException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1685
- public asArray(): $this Sets the return type of the results to be as an associative array.model('ContentOwnerModel')->asArray()
/** * Sets the return type of the results to be as an associative array. * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1708
- public asObject(string $class = 'object'): $this Sets the return type to be of the specified type of object. Defaults to a sim...model('ContentOwnerModel')->asObject()
/** * Sets the return type to be of the specified type of object. * Defaults to a simple object, but can be any class that has * class vars with the same name as the collection columns, * or at least allows them to be created. * * @param 'object'|class-string $class Class Name * * @return $this */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1725
- protected objectToArray($object, bool $onlyChanged = true, bool $recursive = false): array Takes a class and returns an array of its public and protected properties as ...
/** * Takes a class and returns an array of its public and protected * properties as an array suitable for use in creates and updates. * This method uses objectToRawArray() internally and does conversion * to string on all Time instances * * @param object $object Object * @param bool $onlyChanged Only Changed Property * @param bool $recursive If true, inner entities will be cast as array as well * * @return array<string, mixed> * * @throws ReflectionException */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1746
- protected timeToString(array $properties): array Convert any Time instances to appropriate $dateFormat.
/** * Convert any Time instances to appropriate $dateFormat. * * @param array<string, mixed> $properties * * @return array<string, mixed> */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1761
- protected transformDataToArray($row, string $type): array Transform data to array.
/** * Transform data to array. * * @param array|object|null $row Row data * @phpstan-param row_array|object|null $row * @param string $type Type of data (insert|update) * * @throws DataException * @throws InvalidArgumentException * @throws ReflectionException * * @used-by insert() * @used-by update() */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1823
- public allowEmptyInserts(bool $value = true): self Sets $allowEmptyInserts.model('ContentOwnerModel')->allowEmptyInserts()
/** * Sets $allowEmptyInserts. */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1925
- protected convertToReturnType(array $row, string $returnType): object|array Converts database data array to return type value.
/** * Converts database data array to return type value. * * @param array<string, mixed> $row Raw data from database * @param 'array'|'object'|class-string $returnType */ Inherited from CodeIgniter\BaseModel Defined in .../system/BaseModel.php:1938
- public findClassInNamespaces(string $className, string $subNamespace = 'Entities'): string|false Nom complet de la classe si trouvée, sinon false. Recherche une classe dans les namespaces définis dans config/Autoload.php.model('ContentOwnerModel')->findClassInNamespaces()
/** * Recherche une classe dans les namespaces définis dans config/Autoload.php. * * @param string $className Nom de la classe à rechercher. * @param string $subNamespace Sous-namespace comme 'Entities', 'Models', etc. * @return string|false Nom complet de la classe si trouvée, sinon false. * @throws Exception Si le nom de la classe est vide. */ Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:15
- public getClassName(object|string $className = ''): string Récupère le nom simple de la classe à partir de son nom complet avec namespace.model('ContentOwnerModel')->getClassName()
/** * Récupère le nom simple de la classe à partir de son nom complet avec namespace. * * @param string|object $className Nom complet de la classe. Si vide, utilise la classe courante. * @return string Nom simple de la classe. */ Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:63
- public isNamespaced(string $className): bool Vérifie si une classe est namespacée selon la configuration PSR4.model('ContentOwnerModel')->isNamespaced()
/** * Vérifie si une classe est namespacée selon la configuration PSR4. * * @param string $className Nom de la classe. * @return bool True si la classe est dans un namespace PSR4, False sinon. */ Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:79
- public findViewInNamespaces(string $viewPath, string $type = 'entities', string $group = ''): string|false Chemin complet de la vue ou false si non trouvée. Recherche une vue spécifique dans les namespaces définis dans config/Autoload...model('ContentOwnerModel')->findViewInNamespaces()
/** * Recherche une vue spécifique dans les namespaces définis dans config/Autoload.php. * Retourne le chemin complet de la vue trouvée ou false si non trouvée. * * @param string $viewPath Le chemin relatif ou namespacé de la vue (par exemple, 'cells/card/view' ou 'KoclikoDisplay\Views\my\path\test'). * @param string $type Le type de répertoire (par exemple, 'entities', 'cells'). * @param string $group Le groupe de vues, par exemple 'admin' (facultatif). * @return string|false Chemin complet de la vue ou false si non trouvée. */ Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:103
- public resolveViewCell(string $classname = '', string $method = '')model('ContentOwnerModel')->resolveViewCell()
Inherited from KoclikoDisplay\Models\BaseModel Defined in .../KoclikoDisplay/Traits/NamespaceResolverTrait.php:157
- private CodeIgniter\Model::checkBuilderMethod(string $name): void Checks the Builder method name that should not be used in the Model.
/** * Checks the Builder method name that should not be used in the Model. */ Inherited from CodeIgniter\Model Defined in .../system/Model.php:943
- public __construct(?KoclikoDisplay\Models\ConnectionInterface $db = null, ?KoclikoDisplay\Models\ValidationInterface $validation = null)
notre Actualité
15 oct.
La phycocyanine est à la fois une molécule, une protéine, un pigment, un antioxydant, un anti-inflammatoire et ces diverses facettes… Voir
25 sept.
Nous recherchions un partenaire capable de produire une spiruline française certifiée BIO, de qualité, et pouvant fournir de gros volumes… Voir
30 août
Nathalie de Poix (membre ADASMAE et EABA) s'indigne de ce coup dur porté à la filière de spiruline française explications. Voir