SELECT *
FROM `METATAGS`
WHERE `METATAGS`.`deleted_at` ISNULL
Event: dbquery
Events
0.04 ms
Query
Database
30.62 ms
CALL periodosCategorias;
Event: dbquery
Events
0.24 ms
Routing
Timer
4.93 ms
Before Filters
Timer
0.19 ms
Controller
Timer
125.13 ms
Controller Constructor
Timer
4.18 ms
Query
Database
1.26 ms
SELECT `url`
FROM `CINEMA`
WHERE `CINEMA`.`deleted_at` ISNULL
Event: dbquery
Events
0.02 ms
Query
Database
2.98 ms
SELECT *
FROM `CINEMA`
WHERE `CINEMA`.`deleted_at` ISNULL
Event: dbquery
Events
0.02 ms
Query
Database
1.30 ms
SELECT *
FROM `CINEMA`
WHERE `CINEMA`.`deleted_at` ISNULLORDERBY `estado` ASC, `cidade` ASC
Event: dbquery
Events
0.02 ms
Query
Database
2.25 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 = 1318
WHERE p.inicio <= CURDATE()
AND p.fim >= CURDATE()
AND p.deleted_at ISNULLAND p.type = 'promo';
Event: dbquery
Events
0.02 ms
Query
Database
1.04 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 = 14
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.65 ms
SELECT *
FROM `MENSAGENS`
WHERE `FK_Cinema` = '14'
AND `MENSAGENS`.`deleted_at` ISNULLLIMIT 1
Event: dbquery
Events
0.03 ms
Query
Database
0.90 ms
SELECT *
FROM `METATAGS`
WHERE `page` = 'cinemalista'
AND `FK_Cinema` = '1318'
AND `METATAGS`.`deleted_at` ISNULL
Event: dbquery
Events
0.04 ms
Query
Database
1.68 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 = 1318;
Event: dbquery
Events
0.03 ms
Query
Database
0.93 ms
SELECT *
FROM `CINEMA`
WHERE `FK_Claquete` = '1318'
AND `CINEMA`.`deleted_at` ISNULL
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 = 1318
WHERE p.inicio <= CURDATE()
AND p.fim >= CURDATE()
AND p.deleted_at ISNULLAND p.type = 'promo';
Event: dbquery
Events
0.06 ms
Query
Database
0.69 ms
SELECT C.*,
RS.id AS eid,
RS.logo AS rs_logo,
RS.nomePublico,
RS.link
FROM CINEMA AS C
INNERJOIN REDES_SOCIAIS AS RS
ON C.id = RS.FK_Cinema
AND RS.deleted_at ISNULLAND C.FK_Claquete = 1318;
Event: dbquery
Events
0.02 ms
Query
Database
3.58 ms
SELECTDISTINCT DATE(MIN(P.data_hora)) AS dataProg
FROM PROGRAMACAO AS P
WHERE P.data_hora >= CURRENT_TIMESTAMP();
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 = 1318
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 = 14
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 = 1318;
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 = 1318
WHERE p.inicio <= CURDATE()
AND p.fim >= CURDATE()
AND p.deleted_at ISNULLAND p.type = 'promo';
SELECT C.*,
RS.id AS eid,
RS.logo AS rs_logo,
RS.nomePublico,
RS.link
FROM CINEMA AS C
INNERJOIN REDES_SOCIAIS AS RS
ON C.id = RS.FK_Cinema
AND RS.deleted_at ISNULLAND C.FK_Claquete = 1318;
sinopse -> UTF-8 string (809) "Tom Cruise estará mais uma vez de volta às telonas no papel de Ethan Hunt pa...
$value['Em Cartaz'][16332]['info']->sinopse
Tom Cruise estará mais uma vez de volta às telonas no papel de Ethan Hunt para “Missão: Impossível - O Acerto Final”. Nesse novo capítulo da franquia, que é sequência do longa de 2023, Ethan Hunt vai aprender que a vida é a soma de nossas escolhas. Ao lado de Cruise, Hayley Atwell, Ving Rhames, Simon Pegg, Vanessa Kirby, Esai Morales, Pom Klementieff, Mariela Garriga, Henry Czerny, Holt McCallany, Janet McTeer, Nick Offerman, Hannah Waddingham, Angela Bassett, Shea Whigham, Greg Tarzan Davis, Charles Parnell e Frederick Schmidt integram o elenco. Baseado na série de televisão criada por Bruce Geller, o filme é dirigido por Christopher McQuarrie, que também assina a produção ao lado de Tom Cruise. A produção executiva é de David Ellison, Dana Goldberg, Don Granger e Chris Brock.
sinopse -> UTF-8 string (244) "A estudante universitária Stefanie é atormentada por um pesadelo recorrente....
$value['Em Cartaz'][16499]['info']->sinopse
A estudante universitária Stefanie é atormentada por um pesadelo recorrente. Ela decide voltar para casa e rastrear a única pessoa que, talvez, possa ser capaz de quebrar o ciclo fatal anunciado e salvar sua família de um destino terrível.
elenco -> string (80) "Tony Todd, Brec Bassinger, Richard Harmon, Gabrielle Rose, Kaitlyn Santa Jua...
$value['Em Cartaz'][16499]['info']->elenco
Tony Todd, Brec Bassinger, Richard Harmon, Gabrielle Rose, Kaitlyn Santa Juana
diretor -> string (28) "Zach Lipovsky, Adam B. Stein"
$value['Em Cartaz'][16499]['info']->diretor
roteiro -> string (40) "Guy Busick, Lori Evans Taylor, Jon Watts"
sinopse -> UTF-8 string (247) "A Marvel Studios, apresenta THUNDERBOLTS, um grupo irreverente liderado pela...
$value['Em Cartaz'][15047]['info']->sinopse
A Marvel Studios, apresenta THUNDERBOLTS, um grupo irreverente liderado pela ex-assassina Yelena Belova ao lado de uma inesperada turma de desajustados do MCU. THUNDERBOLTS*, da Marvel Studios, estreia nos cinemas do Brasil em 1º de maio de 2025.
elenco -> string (76) "Florence Pugh, Lewis Pullman, Sebastian Stan, Rachel Weisz, Olga Kurylenko "
$value['Em Cartaz'][15047]['info']->elenco
Florence Pugh, Lewis Pullman, Sebastian Stan, Rachel Weisz, Olga Kurylenko
sinopse -> UTF-8 string (710) "Em Karate Kid: Lendas, depois de uma tragédia familiar, o prodígio do kung f...
$value['Em Cartaz'][15167]['info']->sinopse
Em Karate Kid: Lendas, depois de uma tragédia familiar, o prodígio do kung fu Li Fong (Ben Wang) é forçado a sair de sua casa em Beijing para morar em Nova York com sua mãe. Li sofre para superar o passado enquanto ele tenta se encaixar na nova escola e, apesar de não querer lutar, os problemas parecem que o encontram em todos os lugares. Quando um novo amigo precisa de ajuda, Li entra em uma competição de caratê – mas só suas habilidades não bastam. O professor de kung fu de Li, Sr. Han (Jackie Chan) recruta o Karate Kid original, Daniel LaRusso (Ralph Macchio) para ajudar, e Li aprende uma nova maneira de lutar, unindo os dois estilos em um só para um show definitivo de artes marciais.
elenco -> string (108) "Jackie Chan, Ralph Macchio, Joshua Jackson, Ben Wang, Sadie Stanley, Ming-Na...
$value['Em Cartaz'][15167]['info']->elenco
Jackie Chan, Ralph Macchio, Joshua Jackson, Ben Wang, Sadie Stanley, Ming-Na Wen, Aramis Knight, Wyatt Oleff
sinopse -> UTF-8 string (268) "Live-action do famoso clássico de animação da Disney, Lilo & Stitch, onde St...
$value['Pré-Venda'][16292]['info']->sinopse
Live-action do famoso clássico de animação da Disney, Lilo & Stitch, onde Stitch (Chris Sanders), o experimento 626, é um alienígena expressivo que foi adotado como animal de estimação por Lilo (Maia Kealoha) e juntos eles descobrem o significado de família.
elenco -> string (49) "Billy Magnussen, Chris Sanders, Zach Galifianakis"
sinopse -> UTF-8 string (952) "Após sua estreia em fevereiro em Seul e passando por diversas cidades da Amé...
$value['Pré-Venda'][16637]['info']->sinopse
Após sua estreia em fevereiro em Seul e passando por diversas cidades da América do Norte e
Ásia, a primeira turnê solo mundial de j-hope encantou o público com 31 shows em 15 regiões.
Agora, a grande final de ‘HOPE ON THE STAGE’ será transmitida ao vivo aos cinemas do
mundo todo!
Viva esse momento poderoso em que j-hope compartilha suas esperanças, desejos e sonhos
com o público através de sua turnê solo de estreia. Não perca essa oportunidade tão
aguardada de ver ‘j-hope on stage’!
Sinta a energia de suas performances eletrizantes, incluindo faixas-título de seus álbuns solo,
‘MORE’, ‘Arson’ e ‘NEURON’ (com Gaeko e yoonmirae), além de lançamentos recentes
apresentados durante a turnê, como ‘Sweet Dreams (feat. Miguel)’ e ‘MONA LISA’!
Transmitido ao vivo com exclusividade aos cinemas do mundo inteiro – não perca a chance de
ver a apresentação inspiradora de j-hope nas telonas!
sinopse -> UTF-8 string (268) "Live-action do famoso clássico de animação da Disney, Lilo & Stitch, onde St...
$value['Em Breve'][16292]['info']->sinopse
Live-action do famoso clássico de animação da Disney, Lilo & Stitch, onde Stitch (Chris Sanders), o experimento 626, é um alienígena expressivo que foi adotado como animal de estimação por Lilo (Maia Kealoha) e juntos eles descobrem o significado de família.
elenco -> string (49) "Billy Magnussen, Chris Sanders, Zach Galifianakis"
sinopse -> UTF-8 string (809) "Tom Cruise estará mais uma vez de volta às telonas no papel de Ethan Hunt pa...
$value['Em Breve'][16332]['info']->sinopse
Tom Cruise estará mais uma vez de volta às telonas no papel de Ethan Hunt para “Missão: Impossível - O Acerto Final”. Nesse novo capítulo da franquia, que é sequência do longa de 2023, Ethan Hunt vai aprender que a vida é a soma de nossas escolhas. Ao lado de Cruise, Hayley Atwell, Ving Rhames, Simon Pegg, Vanessa Kirby, Esai Morales, Pom Klementieff, Mariela Garriga, Henry Czerny, Holt McCallany, Janet McTeer, Nick Offerman, Hannah Waddingham, Angela Bassett, Shea Whigham, Greg Tarzan Davis, Charles Parnell e Frederick Schmidt integram o elenco. Baseado na série de televisão criada por Bruce Geller, o filme é dirigido por Christopher McQuarrie, que também assina a produção ao lado de Tom Cruise. A produção executiva é de David Ellison, Dana Goldberg, Don Granger e Chris Brock.
sinopse -> UTF-8 string (155) "O mundo de John Wick se expande com "Bailarina", filme protagonizado por Ana...
$value['Em Breve'][15471]['info']->sinopse
O mundo de John Wick se expande com "Bailarina", filme protagonizado por Ana de Armas estrelando como uma assassina treinada nas tradições da Ruska Roma.
elenco -> string (71) "Ana de Armas, Keanu Reeves, Lance Reddick, Ian McShane, Anjelica Huston"
sinopse -> UTF-8 string (467) "Grace Pudel é uma garota solitária que coleciona caracóis ornamentais e tem ...
$value['Em Breve'][16548]['info']->sinopse
Grace Pudel é uma garota solitária que coleciona caracóis ornamentais e tem um enorme amor pelos livros. Ainda muito jovem, Grace foi separada do irmão gêmeo, o pirofagista Gilbert, e a partir daí, entrou em uma espiral contínua de ansiedade e angústia. Apesar dessas inúmeras dificuldades, a menina volta a encontrar inspiração e esperança quando inicia uma amizade duradoura com uma idosa excêntrica chamada Pinky, repleta de coragem e desejo de viver.
elenco -> string (73) "Jacki Weaver, Sarah Snook, Charlotte Belsey, Agnes Davison e Mason Litsos"
sinopse -> UTF-8 string (253) "Colorful Stage! O Filme: Uma Miku Que Não Sabe Cantar, traz uma nova perspec...
$value['Em Breve'][16555]['info']->sinopse
Colorful Stage! O Filme: Uma Miku Que Não Sabe Cantar, traz uma nova perspectiva sobre nossa idol favorita, onde ela enfrenta um desafio inesperado: não conseguir mais cantar. Mas será que ela conseguirá superar essa dificuldade e voltar aos palcos?
sinopse -> UTF-8 string (804) "Durante os séculos, os seres humanos enviaram mensagens ao universo em busca...
$value['Em Breve'][15137]['info']->sinopse
Durante os séculos, os seres humanos enviaram mensagens ao universo em busca de respostas e no novo filme da Disney e Pixar, ELIO, o universo responde! Essa aventura apresenta Elio, um menino apaixonado pelo espaço, com uma imaginação fértil e uma grande obsessão por alienígenas. Quando ele se vê transportado, sem querer, para o Comuniverso, uma organização interplanetária que abriga representantes de galáxias de todo o universo, Elio entra sem hesitar nessa missão épica. Identificado erroneamente como o embaixador da Terra no universo e sem nenhum preparo para esse tipo de pressão, Elio deve forjar novos laços com formas de vida extraterrestre excêntricas, enfrentar crises de proporções intergalácticas e, de alguma forma, descobrir quem ele realmente está destinado a ser.
sinopse -> UTF-8 string (818) "O diretor vencedor do Oscar Danny Boyle e o roteirista indicado ao Oscar Ale...
$value['Em Breve'][16036]['info']->sinopse
O diretor vencedor do Oscar Danny Boyle e o roteirista indicado ao Oscar Alex Garland se reúnem para “Extermínio: A Evolução”, uma nova história aterrorizante ambientada no mundo criado a partir de “Extermínio”. Já se passaram quase três décadas desde que o vírus da raiva escapou de um laboratório de armas biológicas e, neste momento, mesmo permanecendo em uma quarentena implacável, alguns encontraram maneiras de existir em meio aos infectados. Um desses grupos de sobreviventes vive em uma pequena ilha conectada ao continente por uma única passagem fortemente defendida. Quando um dos grupos deixa a ilha em uma missão no coração escuro do continente, ele descobre segredos, maravilhas e horrores que provocaram mutações não apenas nos infectados, mas também em outros sobreviventes.
elenco -> string (48) "Aaron Taylor Johnson, Jodie Comer, Ralph Fiennes"
$value['Em Breve'][16036]['info']->elenco
diretor -> string (11) "Danny Boyle"
$value['Em Breve'][16036]['info']->diretor
roteiro -> string (25) "Danny Boyle, Alex Garland"
sinopse -> UTF-8 string (268) "O aguardado longa-metragem de Fórmula 1® estrelado por Brad Pitt como um ex-...
$value['Em Breve'][16114]['info']->sinopse
O aguardado longa-metragem de Fórmula 1® estrelado por Brad Pitt como um ex-piloto, ao lado de Damson Idris como seu companheiro de equipe. O filme foi gravado durante finais de semana reais de Grande Prêmio, enquanto a equipe compete contra os gigantes do esporte.
elenco -> string (80) "Brad Pitt, Javier Bardem, Kerry Condon, Tobias Menzies, Callie Cooke, Kim Bo...
$value['Em Breve'][16114]['info']->elenco
Brad Pitt, Javier Bardem, Kerry Condon, Tobias Menzies, Callie Cooke, Kim Bodnia
sinopse -> UTF-8 string (457) "Filme protagonizado por Greg Kinnear (Pequena Miss Sunshine) e Terry Chen (A...
$value['Em Breve'][16189]['info']->sinopse
Filme protagonizado por Greg Kinnear (Pequena Miss Sunshine) e Terry Chen (Ainda Há Tempo), baseado na história real do médico Ming Wang, um imigrante chinês que
desafia todas as probabilidades para se tornar um cirurgião oftalmologista. O grande desafio de Wang será provar sua sabedoria quando se propõe a restaurar a visão de um órfão cego. Do mesmo diretor de Paulo, Apóstolo de Cristo (2018), Cheia de Graça (2015) e The Last Light (2014).
sinopse -> UTF-8 string (275) "Norman é um adolescente comum que gosta de alienígenas e tem uma preocupação...
$value['Em Breve'][15581]['info']->sinopse
Norman é um adolescente comum que gosta de alienígenas e tem uma preocupação acima da média com o futuro do nosso planeta. Tudo se torna muito real quando três alienígenas microscópicos que mantêm a paz caem em seu chá gelado e ficam presos no cérebro de Norman.
sinopse -> UTF-8 string (606) "“C.I.C. - Central de Inteligência Cearense” acompanha a saga de Wanderley (E...
$value['Em Breve'][15428]['info']->sinopse
“C.I.C. - Central de Inteligência Cearense” acompanha a saga de Wanderley (Edmilson Filho), conhecido como Agente Karkará, um agente secreto brasileiro que combate os criminosos mais perigosos do mundo representando a C.I.C. - Central de Inteligência Cearense. Quando um projeto ultrassecreto é roubado dos governos de Brasil, Argentina e Paraguai, ele precisará usar suas habilidades para recuperar a fórmula secreta antes que caiam em mãos erradas. O longa é produzido pela Paris Entretenimento em coprodução com o Fundo Setorial do Audiovisual (FSA) e terá distribuição da Paris Filmes.
sinopse -> UTF-8 string (781) "A história de Bambi é uma celebração da natureza e uma lição de resiliência....
$value['Em Breve'][16111]['info']->sinopse
A história de Bambi é uma celebração da natureza e uma lição de resiliência. Desde seus primeiros passos, o jovem cervo se encanta com o mundo à sua volta, guiado pela ternura e sabedoria de sua mãe, que lhe ensina as lições essenciais para sobreviver na floresta. Bambi descobre a amizade com os outros animais e se apaixona por Faline, mas sua vida muda drasticamente quando, com a chegada do outono, perde sua mãe para caçadores. Em meio à dor, Bambi encontra apoio em seu pai, o Príncipe da Floresta, que o prepara para enfrentar os desafios e perigos que o aguardam. Sob a proteção paterna, Bambi cresce, se fortalece e compreende o valor da esperança, mostrando que mesmo em meio às adversidades, é possível amadurecer e viver em harmonia com a natureza.
elenco -> string (13) "Mylene Farmer"
$value['Em Breve'][16111]['info']->elenco
diretor -> string (47) "Michel Fessler, Tristan L Hermite, Felix Salten"
protected originalQueryString -> string (145) "SELECT DISTINCT DATE(MIN(P.data_hora)) AS dataProg FROM PROGRAMACAO AS P WHE...
SELECT DISTINCT DATE(MIN(P.data_hora)) AS dataProg
FROM PROGRAMACAO AS P
WHERE P.data_hora >= CURRENT_TIMESTAMP();
protected swappedQueryString -> uninitialized
protected finalQueryString -> string (145) "SELECT DISTINCT DATE(MIN(P.data_hora)) AS dataProg FROM PROGRAMACAO AS P WHE...
SELECT DISTINCT DATE(MIN(P.data_hora)) AS dataProg
FROM PROGRAMACAO AS P
WHERE P.data_hora >= CURRENT_TIMESTAMP();
protected binds -> array (0)
protected bindMarker -> string (1) "?"
protected startTime -> double 1747754665.4414
protected endTime -> double 1747754665.445
protected errorCode -> null
protected errorString -> null
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 (145) "SELECT DISTINCT DATE(MIN(P.data_hora)) AS dataProg FROM PROGRAMACAO AS P WHE...
SELECT DISTINCT DATE(MIN(P.data_hora)) AS dataProg
FROM PROGRAMACAO AS P
WHERE P.data_hora >= CURRENT_TIMESTAMP();
public connID -> mysqli#91 (18)
Properties (18)
Methods (43)
Static methods (1)
public readonly affected_rows -> integer 1
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 1
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 (224) "SELECT a.* FROM BANNER_INTERVENCAO AS a INNER JOIN REL_BANNER_INTERVENCAO AS...
SELECT a.*
FROM BANNER_INTERVENCAO AS a
INNER JOIN 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
protected swappedQueryString -> uninitialized
protected finalQueryString -> string (224) "SELECT a.* FROM BANNER_INTERVENCAO AS a INNER JOIN REL_BANNER_INTERVENCAO AS...
SELECT a.*
FROM BANNER_INTERVENCAO AS a
INNER JOIN 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
protected binds -> array (0)
protected bindMarker -> string (1) "?"
protected startTime -> double 1747754665.35
protected endTime -> double 1747754665.3506
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 (224) "SELECT a.* FROM BANNER_INTERVENCAO AS a INNER JOIN REL_BANNER_INTERVENCAO AS...
SELECT a.*
FROM BANNER_INTERVENCAO AS a
INNER JOIN 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
public connID -> mysqli#160 (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 12
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
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.
*/
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.
*/
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.
*/
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.
*/
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.
*/
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.
*/
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.
*/
Defined in .../app/Models/FilmeClaqueteMD.php:185
public getFotosFilme($fkClaquete) método para pegar o filme
$value->getFotosFilme()
/** método para pegar o filme */
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.
*/
Defined in .../app/Models/FilmeClaqueteMD.php:227
public getFilmesEmBreve()
$value->getFilmesEmBreve()
Defined in .../app/Models/FilmeClaqueteMD.php:273
public cinemasFilmeEmBreve($FK_Filme)
$value->cinemasFilmeEmBreve()
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.
*/
Defined in .../app/Models/FilmeClaqueteMD.php:314
public buscaFilmes($termo)
$value->buscaFilmes()
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
*/
Defined in .../app/Models/FilmeClaqueteMD.php:340
public seekAcessibilidade($idFilme)
$value->seekAcessibilidade()
Defined in .../app/Models/FilmeClaqueteMD.php:377
public generos()
$value->generos()
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\FilmeClaqueteMD()
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#1228 (22)
199.3 ms 10.467 MB
Database 23
Logs
Views 9
Files 195
Routes 186
Events 24
History 20
Vars
