SELECT *
FROM `METATAGS`
WHERE `METATAGS`.`deleted_at` ISNULL
Event: dbquery
Events
0.09 ms
Query
Database
24.45 ms
CALL periodosCategorias;
Event: dbquery
Events
0.05 ms
Routing
Timer
3.81 ms
Before Filters
Timer
0.04 ms
Controller
Timer
50.98 ms
Controller Constructor
Timer
3.42 ms
Query
Database
0.69 ms
SELECT `url`
FROM `CINEMA`
WHERE `CINEMA`.`deleted_at` ISNULL
Event: dbquery
Events
0.03 ms
Query
Database
0.57 ms
SELECT *
FROM `CINEMA`
WHERE `CINEMA`.`deleted_at` ISNULL
Event: dbquery
Events
0.02 ms
Query
Database
1.93 ms
SELECT *
FROM `CINEMA`
WHERE `CINEMA`.`deleted_at` ISNULLORDERBY `estado` ASC, `cidade` ASC
Event: dbquery
Events
0.04 ms
Query
Database
0.82 ms
SELECT p.*
FROM POSTAGEM AS p
INNERJOIN BANNER as b
ON b.FK_Postagem = p.id
INNERJOIN REL_PERIODO_CINEMA rpc
ON b.id = rpc.FK_Periodo
INNERJOIN CINEMA c ON c.id = rpc.FK_Cinema
AND c.FK_Claquete = 835
WHERE p.inicio <= CURDATE()
AND p.fim >= CURDATE()
AND p.deleted_at ISNULLAND p.type = 'promo';
Event: dbquery
Events
0.01 ms
Query
Database
0.57 ms
SELECTDISTINCT M.conteudo,
M.tipo,
M.ordem,
M.prioridade,
MP.inicio,
MP.fim,
MP.FK_MSG,
RCM.FK_CINEMA,
C.nome
FROM MSG as M
INNERJOIN MSG_PERIODO as MP
ON M.id = MP.FK_MSG
LEFTJOIN R_CINEMA_MSG as RCM
ON M.id = RCM.FK_MSG
INNERJOIN CINEMA as C
ON RCM.FK_CINEMA = C.id
WHERE M.deleted_at ISNULLAND tipo = 'p'
AND RCM.FK_CINEMA = 7
AND CURDATE() BETWEEN MP.inicio AND MP.fim
ORDER by MP.inicio DESC,
C.nome
LIMIT 1;
SELECT a.*
FROM BANNER_INTERVENCAO AS a
INNERJOIN REL_BANNER_INTERVENCAO AS b ON a.CODIGO = b.COD_BANNER
WHERE a.DATA_INICIO <= DATE(NOW()) AND a.DATA_FIM >= DATE(NOW())
AND COD_CLIENTETONKS = 10
Event: dbquery
Events
0.05 ms
Query
Database
0.97 ms
SELECT *
FROM `MENSAGENS`
WHERE `FK_Cinema` = '7'
AND `MENSAGENS`.`deleted_at` ISNULLLIMIT 1
Event: dbquery
Events
0.02 ms
Query
Database
1.40 ms
SELECT *
FROM `METATAGS`
WHERE `page` = 'brasilia'
AND `FK_Cinema` = '835'
AND `METATAGS`.`deleted_at` ISNULL
Event: dbquery
Events
0.03 ms
Query
Database
5.54 ms
SELECTDISTINCT IF(f.NOMEP <> '', f.NOMEP, f.NOMEO) AS titulo
FROM claquete_principal.FILMES AS f
INNERJOIN PROGRAMACAO AS p
ON p.FK_Filme = f.CODIGO
AND DATE(p.data_hora) >= CURDATE()
AND p.FK_Cinema = 835;
Event: dbquery
Events
0.05 ms
Query
Database
3.44 ms
SELECT *
FROM `CINEMA`
WHERE `FK_Claquete` = '835'
AND `CINEMA`.`deleted_at` ISNULL
Event: dbquery
Events
0.06 ms
Query
Database
1.28 ms
SELECT DIST.NOME_CONHECIDO,
ce.categoria,
F.*,
CASE
WHEN F.CENSURA >= 0 THEN F.CENSURA
WHEN F.AUTO_CENSURA > 0 THEN F.AUTO_CENSURA
END AS CENSURA
FROM claquete_principal.FILMES AS F
LEFTJOIN claquete_principal.DISTRIBUIDORA AS DIST
ON F.COD_DIST = DIST.CODIGO
LEFTJOIN CATEGORIA_EXIBICAO ce
ON ce.FK_Filme = F.CODIGO
AND ce.`data` = (SELECTMAX(ce2.`data`)
FROM CATEGORIA_EXIBICAO ce2
WHERE ce2.`data` <= CURDATE())
WHERE F.CODIGO = 16636;
SELECT p.*
FROM POSTAGEM AS p
INNERJOIN BANNER as b
ON b.FK_Postagem = p.id
INNERJOIN REL_PERIODO_CINEMA rpc
ON b.id = rpc.FK_Periodo
INNERJOIN CINEMA c ON c.id = rpc.FK_Cinema
AND c.FK_Claquete = 835
WHERE p.inicio <= CURDATE()
AND p.fim >= CURDATE()
AND p.deleted_at ISNULLAND p.type = 'promo';
SELECTDISTINCT M.conteudo,
M.tipo,
M.ordem,
M.prioridade,
MP.inicio,
MP.fim,
MP.FK_MSG,
RCM.FK_CINEMA,
C.nome
FROM MSG as M
INNERJOIN MSG_PERIODO as MP
ON M.id = MP.FK_MSG
LEFTJOIN R_CINEMA_MSG as RCM
ON M.id = RCM.FK_MSG
INNERJOIN CINEMA as C
ON RCM.FK_CINEMA = C.id
WHERE M.deleted_at ISNULLAND tipo = 'p'
AND RCM.FK_CINEMA = 7
AND CURDATE() BETWEEN MP.inicio AND MP.fim
ORDER by MP.inicio DESC,
C.nome
LIMIT 1;
SELECT a.*
FROM BANNER_INTERVENCAO AS a
INNERJOIN REL_BANNER_INTERVENCAO AS b ON a.CODIGO = b.COD_BANNER
WHERE a.DATA_INICIO <= DATE(NOW()) AND a.DATA_FIM >= DATE(NOW())
AND COD_CLIENTETONKS = 10
SELECTDISTINCT IF(f.NOMEP <> '', f.NOMEP, f.NOMEO) AS titulo
FROM claquete_principal.FILMES AS f
INNERJOIN PROGRAMACAO AS p
ON p.FK_Filme = f.CODIGO
AND DATE(p.data_hora) >= CURDATE()
AND p.FK_Cinema = 835;
SELECT DIST.NOME_CONHECIDO,
ce.categoria,
F.*,
CASE
WHEN F.CENSURA >= 0 THEN F.CENSURA
WHEN F.AUTO_CENSURA > 0 THEN F.AUTO_CENSURA
END AS CENSURA
FROM claquete_principal.FILMES AS F
LEFTJOIN claquete_principal.DISTRIBUIDORA AS DIST
ON F.COD_DIST = DIST.CODIGO
LEFTJOIN CATEGORIA_EXIBICAO ce
ON ce.FK_Filme = F.CODIGO
AND ce.`data` = (SELECTMAX(ce2.`data`)
FROM CATEGORIA_EXIBICAO ce2
WHERE ce2.`data` <= CURDATE())
WHERE F.CODIGO = 16636;
public db -> CodeIgniter\Database\MySQLi\Connection#83 Recursion
public __construct(CodeIgniter\Database\ConnectionInterface $db)
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/Query.php:291
protected matchNamedBinds(string $sql, array $binds): string Match bindings
/**
* Match bindings
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:319
protected matchSimpleBinds(string $sql, array $binds, int $bindCount, int $ml): string Match bindings
/**
* Match bindings
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:343
public debugToolbarDisplay(): string Returns string to display in debug toolbar
/**
* Returns string to display in debug toolbar
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:373
public __toString(): string Return text representation of the query
/**
* Return text representation of the query
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:427
lastQuery string (23) "CALL salasByCineFK(835)"
public connID -> mysqli#91 (18)
Properties (18)
Methods (43)
Static methods (1)
public readonly affected_rows -> integer 0
public readonly client_info -> string (14) "mysqlnd 8.2.27"
public readonly client_version -> integer 80227
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 3
public readonly host_info -> string (25) "Localhost via UNIX socket"
public readonly info -> null
public readonly insert_id -> integer 0
public readonly server_info -> string (6) "8.0.41"
public connect(bool $persistent = false): false|mysqli Connect to the database.
/**
* Connect to the database.
*
* @return false|mysqli
*
* @throws DatabaseException
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/MySQLi/Connection.php:258
protected _close(): void Close the database connection.
/**
* Close the database connection.
*
* @return void
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/MySQLi/Connection.php:356
/**
* Platform-dependant string escape
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/MySQLi/Connection.php:528
/**
* Returns platform-specific SQL to enable foreign key checks.
*
* @return string
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/MySQLi/Connection.php:600
public insertID(): int Insert ID
/**
* Insert ID
*/
Defined in .../codeigniter4/framework/system/Database/MySQLi/Connection.php:618
protected _transBegin(): bool Begin Transaction
/**
* Begin Transaction
*/
Defined in .../codeigniter4/framework/system/Database/MySQLi/Connection.php:626
protected _transCommit(): bool Commit Transaction
/**
* Commit Transaction
*/
Defined in .../codeigniter4/framework/system/Database/MySQLi/Connection.php:636
/**
* Rollback Transaction
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:539
public getPrefix(): string Returns the database prefix.
/**
* Returns the database prefix.
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:767
public transStart(bool $testMode = false): bool Start Transaction
/**
* Start Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:791
public transComplete(): bool Complete Transaction
/**
* Complete Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:827
public transBegin(bool $testMode = false): bool Begin Transaction
/**
* Begin Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/system/Database/BaseConnection.php:835
public transCommit(): bool Commit Transaction
/**
* Commit Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/system/Database/BaseConnection.php:869
public transRollback(): bool Rollback Transaction
/**
* Rollback Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:1038
/**
* 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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:1896
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:1258
protected originalQueryString -> string (48) "SELECT * FROM FOTOS2 WHERE ID_FILME = 16636"
SELECT * FROM FOTOS2
WHERE ID_FILME = 16636
protected swappedQueryString -> uninitialized
protected finalQueryString -> string (48) "SELECT * FROM FOTOS2 WHERE ID_FILME = 16636"
SELECT * FROM FOTOS2
WHERE ID_FILME = 16636
protected binds -> array (0)
protected bindMarker -> string (1) "?"
protected startTime -> double 1747312982.3752
protected endTime -> double 1747312982.3759
protected errorCode -> null
protected errorString -> null
public db -> CodeIgniter\Database\MySQLi\Connection#87 Recursion
public __construct(CodeIgniter\Database\ConnectionInterface $db)
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/Query.php:291
protected matchNamedBinds(string $sql, array $binds): string Match bindings
/**
* Match bindings
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:319
protected matchSimpleBinds(string $sql, array $binds, int $bindCount, int $ml): string Match bindings
/**
* Match bindings
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:343
public debugToolbarDisplay(): string Returns string to display in debug toolbar
/**
* Returns string to display in debug toolbar
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:373
public __toString(): string Return text representation of the query
/**
* Return text representation of the query
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:427
lastQuery string (48) "SELECT * FROM FOTOS2 WHERE ID_FILME = 16636"
SELECT * FROM FOTOS2
WHERE ID_FILME = 16636
public connID -> mysqli#156 (18)
Properties (18)
Methods (43)
Static methods (1)
public readonly affected_rows -> integer 0
public readonly client_info -> string (14) "mysqlnd 8.2.27"
public readonly client_version -> integer 80227
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 (25) "Localhost via UNIX socket"
public readonly info -> null
public readonly insert_id -> integer 0
public readonly server_info -> string (6) "8.0.41"
public connect(bool $persistent = false): false|mysqli Connect to the database.
/**
* Connect to the database.
*
* @return false|mysqli
*
* @throws DatabaseException
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/MySQLi/Connection.php:258
protected _close(): void Close the database connection.
/**
* Close the database connection.
*
* @return void
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/MySQLi/Connection.php:356
/**
* Platform-dependant string escape
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/MySQLi/Connection.php:528
/**
* Returns platform-specific SQL to enable foreign key checks.
*
* @return string
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/MySQLi/Connection.php:600
public insertID(): int Insert ID
/**
* Insert ID
*/
Defined in .../codeigniter4/framework/system/Database/MySQLi/Connection.php:618
protected _transBegin(): bool Begin Transaction
/**
* Begin Transaction
*/
Defined in .../codeigniter4/framework/system/Database/MySQLi/Connection.php:626
protected _transCommit(): bool Commit Transaction
/**
* Commit Transaction
*/
Defined in .../codeigniter4/framework/system/Database/MySQLi/Connection.php:636
/**
* Rollback Transaction
*/
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:539
public getPrefix(): string Returns the database prefix.
/**
* Returns the database prefix.
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:767
public transStart(bool $testMode = false): bool Start Transaction
/**
* Start Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:791
public transComplete(): bool Complete Transaction
/**
* Complete Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:827
public transBegin(bool $testMode = false): bool Begin Transaction
/**
* Begin Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/system/Database/BaseConnection.php:835
public transCommit(): bool Commit Transaction
/**
* Commit Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/system/Database/BaseConnection.php:869
public transRollback(): bool Rollback Transaction
/**
* Rollback Transaction
*/
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:1038
/**
* 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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:1896
Inherited from CodeIgniter\Database\BaseConnection
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/Database/BaseConnection.php:1258
/**
* @param int $id identificador do Filme,
* @param string $titulo Titulo do filme no Brasil
* @param string $tituloOriginal Titulo do filme no pais de origem,
* @param DateTime $estreia data de estreia do filme,
* @param string $genero Lista de genero de origem multivalorada a ser transformada em lista. Ex: ação,aventura,romance
* @param string $exibicao Letra que representa o estado de exibição do filme. Ex: c => 'Em Cartaz'; b => 'Em Breve'
* @param int $classIndicativa Idade ao qual o filme se indica, caso esse e o auto sejam 0, retorna falso
* @param int $autoClassIndicativa Idade ao qual filme se classificação não oficial, caso a oficial seja zero, é utilizada no lugar
* @param int $duracao Tempo de duração do filme em minutos
* @param string $sinopse Resumo do filme
* @param string $elenco Atrizes e Atores que atuaram no filme.
* @param string $diretor Nome(s) do responsavel pela direção do filme
* @param string $roteiro Nome(s) do responsavel pelo roteiro do filme
* @param string $producao Time de producao
* @param string $distribuidora id da distribuidora do filme
* @param string $trailer identificador da url de um trailer no youtube
*
* @return self
*/
Defined in .../app/Models/FilmeClass.php:52
public showData()
$value->showData()
Defined in .../app/Models/FilmeClass.php:102
public getRelFilmeIngresso(): object lista de programação ingresso. Retorna a programação da Ingresso.com no Claquete
$value->getRelFilmeIngresso()
/**
* Retorna a programação da Ingresso.com no Claquete
*
* @return object lista de programação ingresso.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:19
public getRelFilmeVelox(): object lista de programação ingresso. Retorna a programação da Ingresso.com no Claquete
$value->getRelFilmeVelox()
/**
* Retorna a programação da Ingresso.com no Claquete
*
* @return object lista de programação ingresso.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:32
public getMoviesInProg($data = 0, $fim = 0, $new = 0): object Lista de Filmes e sua Categoria de exibição. Retorna uma lista dos filmes na Programação, caso o filme não tenha um status...
$value->getMoviesInProg()
/**
* Retorna uma lista dos filmes na Programação, caso o filme não tenha um status
* o mesmo recebra automaticamente o status 'c' que representa em cartaz(1°Query).
* Caso o filme ja exista é consultado no sistema o status atual do mesmo e
* retornado(2°Query).
*
* @param data $data Data de inicio do periodo
* @param int $fim Irrelevante
* @param int $new Se a consulta deve ser executada como filme novo ou existente.
* @return object Lista de Filmes e sua Categoria de exibição.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:51
public getRelFilmeCategoriaGroupByDay(): array Lista de Filmes e Status de Exibição. Retorna a listagem dos Filmes pelos periodos de exibição definidos nas Catego...
$value->getRelFilmeCategoriaGroupByDay()
/**
* Retorna a listagem dos Filmes pelos periodos de exibição definidos nas Categorias.
*
* @return array Lista de Filmes e Status de Exibição.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:64
public getRelProgramacaoStatus($FkCinemaClaquete): array listagem de Filmes e status. Retorna a listagem do Status de Exibição de todos os filmes em todas as categ...
$value->getRelProgramacaoStatus()
/**
* Retorna a listagem do Status de Exibição de todos os filmes em todas as categorias junto a
* seus respectivos filmes.
*
* @param int $cod_cinema_claquete
* @return array listagem de Filmes e status.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:83
public getDataRelProgramacaoStatus(): date Data de inicio da Programação. Retorna a data de inicio da Programação presente no sistema.
$value->getDataRelProgramacaoStatus()
/**
* Retorna a data de inicio da Programação presente no sistema.
*
* @return date Data de inicio da Programação.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:168
public getMovieById($fkClaquete): object Filme e status. Retorna um filme por seu ID junto com seu status de exibição atual.
$value->getMovieById()
/**
* Retorna um filme por seu ID junto com seu status de exibição atual.
*
* @param int $cine Id do Cinema.
* @param int $fkClaquete Id do Filme.
* @return object Filme e status.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:185
public getFotosFilme($fkClaquete) método para pegar o filme
$value->getFotosFilme()
/** método para pegar o filme */
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:210
public getExibicao($cod_cinema, $tipo): object Lista de Staus de Exibição atual dos Filmes. Retorna os filmes pelo cinema agrupado pelo status, no tipo 1 temos a aba Em ...
$value->getExibicao()
/**
* Retorna os filmes pelo cinema agrupado pelo status, no tipo 1 temos a aba Em Cartaz
* da Homepage do Publico do site. Caso tipo seja 0 deveria-se poder especificar qual grupo d
* e status se quer ter, aguardando desenvolvimento.
*
* @param int $cod_cinema id do Cinema.
* @param int $tipo tipo de pesquisa 1 -> Cartaz se não um status especifico.
* @return object Lista de Staus de Exibição atual dos Filmes.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:227
public getFilmesEmBreve()
$value->getFilmesEmBreve()
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:273
public cinemasFilmeEmBreve($FK_Filme)
$value->cinemasFilmeEmBreve()
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:293
public filmesVendaBem(): object lista de Filmes VendaBem. Retorna um a lista dos filmes da vendaBem que ja foram cadastrados.
$value->filmesVendaBem()
/**
* Retorna um a lista dos filmes da vendaBem que ja foram cadastrados.
*
* @return object lista de Filmes VendaBem.
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:314
public buscaFilmes($termo)
$value->buscaFilmes()
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:323
public statusFilme($fkCinema): object Pegas os filme em Cartaz e exibição e
$value->statusFilme()
/**
* Pegas os filme em Cartaz e exibição e
*
* @return object
*/
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:340
public seekAcessibilidade($idFilme)
$value->seekAcessibilidade()
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:377
public generos()
$value->generos()
Inherited from App\Models\FilmeClaqueteMD
Defined in .../app/Models/FilmeClaqueteMD.php:396
protected initialize(): void Inicializa os bancos de dados e define o cinema principal.
/**
* Inicializa os bancos de dados e define o cinema principal.
*
* @return void
*/
Inherited from App\Models\BaseModel
Defined in .../app/Models/BaseModel.php:56
public proxQuinta(): date Retorna a proxima quinta-feira
$value->proxQuinta()
/**
* Retorna a proxima quinta-feira
*
* @return date
*/
Inherited from App\Models\BaseModel
Defined in .../app/Models/BaseModel.php:227
public getLinkVendBem($cinema, $filme, $sessao, $idSessao): String Retorna o link de Sessão VendaBem
$value->getLinkVendBem()
/**
* Retorna o link de Sessão VendaBem
*
* @return String
*/
Inherited from App\Models\BaseModel
Defined in .../app/Models/BaseModel.php:243
public __construct(?CodeIgniter\Database\ConnectionInterface $db = null, ?CodeIgniter\Validation\ValidationInterface $validation = null)
new \App\Models\FilmeClass()
Inherited from CodeIgniter\Model
Defined in .../codeigniter4/framework/system/Model.php:150
public setTable(string $table): $this Specify the table associated with a model
$value->setTable()
/**
* Specify the table associated with a model
*
* @param string $table Table
*
* @return $this
*/
Inherited from CodeIgniter\Model
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Model.php:573
public getIdValue($row): array|int|string|null Returns the id value for the data array or object
$value->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 .../codeigniter4/framework/system/Model.php:593
public chunk(int $size, Closure $userFunc) Loops over records in batches, allowing you to operate on them. Works with $t...
$value->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 .../codeigniter4/framework/system/Model.php:629
public countAllResults(bool $reset = true, bool $test = false): int|string Override countAllResults to account for soft deleted accounts.
$value->countAllResults()
/**
* Override countAllResults to account for soft deleted accounts.
*
* @return int|string
*/
Inherited from CodeIgniter\Model
Defined in .../codeigniter4/framework/system/Model.php:663
public builder(?string $table = null): BaseBuilder Provides a shared instance of the Query Builder.
$value->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 .../codeigniter4/framework/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...
$value->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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 ...
$value->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 .../codeigniter4/framework/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 .../codeigniter4/framework/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...
$value->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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/Model.php:918
/**
* Creates DataConverter instance.
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:376
protected useCasts(): bool Are casts used?
/**
* Are casts used?
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:390
public find($id = null): array|object|null The resulting row of data, or null. Fetches the row of database.
$value->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 .../codeigniter4/framework/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.
$value->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 .../codeigniter4/framework/system/BaseModel.php:634
public findAll(?int $limit = null, int $offset = 0): array Fetches all results, while optionally limiting them.
$value->findAll()
/**
* Fetches all results, while optionally limiting them.
*
* @param int $limit Limit
* @param int $offset Offset
*
* @return array
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:653
public first(): array|object|null Returns the first row of the result set.
$value->first()
/**
* Returns the first row of the result set.
*
* @return array|object|null
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:698
public save($row): bool A convenience method that will attempt to determine whether the data should b...
$value->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 .../codeigniter4/framework/system/BaseModel.php:741
public getInsertID(): int|string Returns last insert ID or 0.
$value->getInsertID()
/**
* Returns last insert ID or 0.
*
* @return int|string
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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.
$value->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 .../codeigniter4/framework/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.
$value->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 .../codeigniter4/framework/system/BaseModel.php:1053
public delete($id = null, bool $purge = false): BaseResult|bool Deletes a single record from the database where $id matches.
$value->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 .../codeigniter4/framework/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...
$value->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 .../codeigniter4/framework/system/BaseModel.php:1175
public withDeleted(bool $val = true): $this Sets $useSoftDeletes value so that we can temporarily override the soft delet...
$value->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 .../codeigniter4/framework/system/BaseModel.php:1192
public onlyDeleted(): $this Works with the find* methods to return only the rows that have been deleted.
$value->onlyDeleted()
/**
* Works with the find* methods to return only the rows that
* have been deleted.
*
* @return $this
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:1205
public replace(?array $row = null, bool $returnSQL = false): BaseResult|false|Query|string Compiles a replace and runs the query.
$value->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 .../codeigniter4/framework/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...
$value->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 .../codeigniter4/framework/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...
$value->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 .../codeigniter4/framework/system/BaseModel.php:1272
public setAllowedFields(array $allowedFields): $this It could be used when you have to change default or override current allowed ...
$value->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 .../codeigniter4/framework/system/BaseModel.php:1297
public protect(bool $protect = true): $this Sets whether or not we should whitelist data set during updates or inserts ag...
$value->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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/BaseModel.php:1422
public skipValidation(bool $skip = true): $this Set the value of the skipValidation flag.
$value->skipValidation()
/**
* Set the value of the skipValidation flag.
*
* @param bool $skip Value
*
* @return $this
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:1439
public setValidationMessages(array $validationMessages): $this Allows to set (and reset) validation messages. It could be used when you have...
$value->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 .../codeigniter4/framework/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...
$value->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 .../codeigniter4/framework/system/BaseModel.php:1470
public setValidationRules(array $validationRules): $this Allows to set (and reset) validation rules. It could be used when you have to...
$value->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 .../codeigniter4/framework/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 ...
$value->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 .../codeigniter4/framework/system/BaseModel.php:1501
public cleanRules(bool $choice = false): $this Should validation rules be removed before saving? Most handy when doing updates.
$value->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 .../codeigniter4/framework/system/BaseModel.php:1529
public validate($row): bool Validate the row data against the validation rules (or the validation group) ...
$value->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 .../codeigniter4/framework/system/BaseModel.php:1543
public getValidationRules(array $options = array()): array Returns the model's defined validation rules so that they can be used elsewhe...
$value->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 .../codeigniter4/framework/system/BaseModel.php:1585
protected ensureValidation(): void
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:1608
public getValidationMessages(): array Returns the model's validation messages, so they can be used elsewhere, if ne...
$value->getValidationMessages()
/**
* Returns the model's validation messages, so they
* can be used elsewhere, if needed.
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/BaseModel.php:1633
public allowCallbacks(bool $val = true): $this Sets $tempAllowCallbacks value so that we can temporarily override the settin...
$value->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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/BaseModel.php:1685
public asArray(): $this Sets the return type of the results to be as an associative array.
$value->asArray()
/**
* Sets the return type of the results to be as an associative array.
*
* @return $this
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/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...
$value->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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/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 .../codeigniter4/framework/system/BaseModel.php:1823
public allowEmptyInserts(bool $value = true): self Sets $allowEmptyInserts.
$value->allowEmptyInserts()
/**
* Sets $allowEmptyInserts.
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/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 .../codeigniter4/framework/system/BaseModel.php:1938
private App\Models\BaseModel::confApply() Aplica as configurações salvas no arquivo conf.json
/**
* Aplica as configurações salvas no arquivo conf.json
*/
Inherited from App\Models\BaseModel
Defined in .../app/Models/BaseModel.php:76
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 .../codeigniter4/framework/system/Model.php:943
public static App\Models\BaseModel::url_amigavel($string): string texto normalizado. Recebe uma string e remove os acentos.
/**
* Recebe uma string e remove os acentos.
*
* @param string $string texto a ter caracteres substituidos.
* @return string texto normalizado.
*/
Defined in .../app/Models/BaseModel.php:205
public static App\Models\BaseModel::$urlName :: boolean true
public static App\Models\BaseModel::$globalBanner :: array (4)
0 => string (4) "prom"
\App\Models\BaseModel::$globalBanner[0]
1 => string (4) "b300"
\App\Models\BaseModel::$globalBanner[1]
2 => string (4) "b728"
\App\Models\BaseModel::$globalBanner[2]
3 => string (4) "prod"
\App\Models\BaseModel::$globalBanner[3]
public static App\Models\BaseModel::$confs :: stdClass#121 (22)
nome -> string (30) "Multicine Santa Maria Shopping"
$value[2]->nome
cidade -> UTF-8 string (10) "Brasília "
$value[2]->cidade
estado -> string (2) "DF"
$value[2]->estado
cep -> string (8) "72544200"
$value[2]->cep
endereco -> string (22) "Avenida Alagado CL 114"
$value[2]->endereco
telefone -> string (11) "613627-3837"
$value[2]->telefone
sala -> string (1) "6"
$value[2]->sala
status -> string (1) "1"
$value[2]->status
link -> string (0) ""
$value[2]->link
latitude -> string (13) "-16.005857788"
$value[2]->latitude
longitude -> string (13) "-48.000539832"
$value[2]->longitude
FK_Claquete -> string (3) "835"
$value[2]->FK_Claquete
created_at -> string (19) "2025-02-10 09:41:12"
$value[2]->created_at
updated_at -> string (19) "2025-03-26 15:37:10"
$value[2]->updated_at
deleted_at -> null
$value[2]->deleted_at
mensagem -> stdClass#123 (9)
$value[2]->mensagem
Properties (9)
id -> string (2) "59"
$value[2]->mensagem->id
msg -> string (386) "<p style="text-align: justify;"><strong>Sobre esse cinema<br><br>6 Salas</st...
$value[2]->mensagem->msg
<p style="text-align: justify;"><strong>Sobre esse cinema<br><br>6 Salas</strong><br><strong>2 Salas 3D - 4 e 6</strong><br><strong>Bomboniére</strong><br><strong>Acesso para port. de necessidades especiais</strong><br><strong>Ar Condicionado</strong><br><strong>Capacidade: Sala 1 - 112, Sala 2 - 112, Sala 3 - 148, Sala 4 - 148, Sala 5 - 112, Sala 6 - 124</strong> <br><br></p>
tipo -> string (1) "p"
$value[2]->mensagem->tipo
prioridade -> string (1) "n"
$value[2]->mensagem->prioridade
ordem -> string (1) "0"
$value[2]->mensagem->ordem
FK_Cinema -> string (1) "7"
$value[2]->mensagem->FK_Cinema
created_at -> string (19) "2025-03-26 15:37:10"
$value[2]->mensagem->created_at
updated_at -> string (19) "2025-03-26 15:37:10"
$value[2]->mensagem->updated_at
deleted_at -> null
$value[2]->mensagem->deleted_at
3 => stdClass#133 (17)
$value[3]
Properties (17)
id -> string (1) "4"
$value[3]->id
url -> string (12) "aguas-lindas"
$value[3]->url
nome -> UTF-8 string (23) "Multicine Águas Lindas"
$value[3]->nome
cidade -> UTF-8 string (13) "Águas Lindas"
$value[3]->cidade
estado -> string (2) "GO"
$value[3]->estado
cep -> string (8) "72910000"
$value[3]->cep
endereco -> UTF-8 string (87) "Avenida Marginal QD 6-B-2<br> Mansões Centro - Oeste<br> Águas de Lindóia Sh...
$value[3]->endereco
Avenida Marginal QD 6-B-2<br>
Mansões Centro - Oeste<br>
Águas de Lindóia Shopping
