SELECT `url`
FROM `CINEMA`
WHERE `CINEMA`.`deleted_at` ISNULL
Event: DBQuery
Events
0.04 ms
Query
Database
9.28 ms
SELECT *
FROM `CINEMA`
WHERE `url` = 'valparaiso'
AND `CINEMA`.`deleted_at` ISNULLLIMIT 1
Event: DBQuery
Events
0.04 ms
Query
Database
0.94 ms
SELECT *
FROM `CINEMA`
WHERE `CINEMA`.`deleted_at` ISNULLORDERBY `nome` ASC
Event: DBQuery
Events
0.03 ms
Query
Database
2.12 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 = 1
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.04 ms
Query
Database
0.87 ms
SELECT *
FROM MENSAGENS
WHERE FK_Cinema = 1
AND deleted_at is null
LIMIT 1
Event: DBQuery
Events
0.03 ms
Query
Database
0.92 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 = 414;
Event: DBQuery
Events
0.04 ms
Query
Database
1.56 ms
SELECT bc.*,
COALESCE(f.NOMEP, f.NOMEO) as titulo
FROM BANNER_CORNER as bc
inner join REL_BANNER_CORNER as rbc
on bc.CODIGO = rbc.COD_BANNER
inner join FILMES as f
on f.CODIGO = bc.COD_FILME
where curdate() between bc.DATA_INI AND bc.DATA_EXP
and rbc.COD_CLIENTETONKS = 10;
Event: DBQuery
Events
0.04 ms
Query
Database
0.86 ms
SELECT *
FROM `METATAGS`
WHERE `page` IN ('Home','*')
AND `FK_Cinema` = '414'
AND `METATAGS`.`deleted_at` ISNULL
Event: DBQuery
Events
0.04 ms
Query
Database
0.88 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 = 414;
Event: DBQuery
Events
0.03 ms
Query
Database
0.71 ms
SELECT *
FROM `CINEMA`
WHERE `FK_Claquete` = '414'
AND `CINEMA`.`deleted_at` ISNULL
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16551
Event: DBQuery
Events
0.51 ms
Query
Database
5.89 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16551
Event: DBQuery
Events
0.04 ms
Query
Database
0.81 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16551
Event: DBQuery
Events
0.03 ms
Query
Database
0.85 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16579
Event: DBQuery
Events
0.03 ms
Query
Database
0.86 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16429
Event: DBQuery
Events
0.03 ms
Query
Database
0.74 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 3284
Event: DBQuery
Events
0.03 ms
Query
Database
1.82 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16692
Event: DBQuery
Events
0.05 ms
Query
Database
0.71 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16365
Event: DBQuery
Events
0.03 ms
Query
Database
0.77 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 1438
Event: DBQuery
Events
0.02 ms
Query
Database
0.70 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 1438
Event: DBQuery
Events
0.02 ms
Query
Database
1.33 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 1031
Event: DBQuery
Events
0.03 ms
Query
Database
2.32 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16688
Event: DBQuery
Events
0.04 ms
Query
Database
3.18 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16041
Event: DBQuery
Events
0.04 ms
Query
Database
0.64 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15901
Event: DBQuery
Events
0.03 ms
Query
Database
2.01 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15288
Event: DBQuery
Events
0.04 ms
Query
Database
1.34 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16310
Event: DBQuery
Events
0.03 ms
Query
Database
1.41 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16199
Event: DBQuery
Events
0.03 ms
Query
Database
0.97 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16509
Event: DBQuery
Events
0.03 ms
Query
Database
0.81 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 8490
Event: DBQuery
Events
0.02 ms
Query
Database
2.92 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 12246
Event: DBQuery
Events
0.04 ms
Query
Database
2.41 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16688
Event: DBQuery
Events
0.04 ms
Query
Database
3.15 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15889
Event: DBQuery
Events
0.05 ms
Query
Database
1.02 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15148
Event: DBQuery
Events
0.05 ms
Query
Database
4.46 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 12651
Event: DBQuery
Events
0.05 ms
Query
Database
4.75 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16431
Event: DBQuery
Events
0.05 ms
Query
Database
8.87 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15276
Event: DBQuery
Events
0.05 ms
Query
Database
1.37 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16333
Event: DBQuery
Events
0.05 ms
Query
Database
2.48 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15887
Event: DBQuery
Events
0.05 ms
Query
Database
1.01 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16694
Event: DBQuery
Events
0.05 ms
Query
Database
1.66 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 14662
Event: DBQuery
Events
0.06 ms
Query
Database
1.53 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15583
Event: DBQuery
Events
0.05 ms
Query
Database
0.76 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16568
Event: DBQuery
Events
0.04 ms
Query
Database
1.14 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 16521
Event: DBQuery
Events
0.05 ms
Query
Database
0.88 ms
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNERJOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15155
Event: DBQuery
Events
0.04 ms
Query
Database
6.18 ms
CALL carrosselAtivo(414);
Event: DBQuery
Events
0.04 ms
Query
Database
2.45 ms
CALL BannersByCineTipo(414, 'dife');
Event: DBQuery
Events
0.04 ms
Query
Database
1.70 ms
CALL BannersByCineTipo(414, 'b728');
Event: DBQuery
Events
0.12 ms
Query
Database
1.21 ms
CALL BannersByCineTipo(414, 'b7X2');
Event: DBQuery
Events
0.04 ms
Query
Database
1.04 ms
CALL BannersByCineTipo(414, 'b300');
Event: DBQuery
Events
0.04 ms
Query
Database
0.70 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 = 414
WHERE p.inicio <= CURDATE()
AND p.fim >= CURDATE()
AND p.deleted_at ISNULLAND p.type = 'promo';
Event: DBQuery
Events
0.03 ms
Query
Database
1.38 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 = 414;
Event: DBQuery
Events
0.03 ms
Query
Database
3.29 ms
SELECTDISTINCT DATE(MIN(P.data_hora)) AS dataProg
FROM PROGRAMACAO AS P
WHERE P.data_hora >= CURRENT_TIMESTAMP();
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 = 1
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
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 = 414;
SELECT bc.*,
COALESCE(f.NOMEP, f.NOMEO) as titulo
FROM BANNER_CORNER as bc
inner join REL_BANNER_CORNER as rbc
on bc.CODIGO = rbc.COD_BANNER
inner join FILMES as f
on f.CODIGO = bc.COD_FILME
where curdate() between bc.DATA_INI AND bc.DATA_EXP
and rbc.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 = 414;
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 = 414
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 = 414;
<p style="text-align: justify;"><strong>3 Salas</strong></p>
<p style="text-align: justify;"><strong>Salas 3D - 5</strong><br><strong>Bomboniére</strong><br><strong>Acesso para port. de necessidades especiais</strong><br><strong>Ar Condicionado</strong><br><strong>Capacidade: Sala 3 (2D) - 104, Sala 4 (2D) - 104, Sala 5 </strong><strong>(3D)</strong><strong> - 186</strong></p>
<p style="text-align: justify;"><strong>3 Salas</strong></p>
<p style="text-align: justify;"><strong>Salas 3D - 5</strong><br><strong>Bomboniére</strong><br><strong>Acesso para port. de necessidades especiais</strong><br><strong>Ar Condicionado</strong><br><strong>Capacidade: Sala 3 (2D) - 104, Sala 4 (2D) - 104, Sala 5 </strong><strong>(3D)</strong><strong> - 186</strong></p>
sinopse -> UTF-8 string (408) "Terror em Shelby Oaks acompanha a busca desesperada de Mia por sua irmã desa...
$value['Em Cartaz'][16551]['info']->sinopse
Terror em Shelby Oaks acompanha a busca desesperada de Mia por sua irmã desaparecida, Riley, uma youtuber famosa por investigar o paranormal. A obsessão de Mia recomeça quando ela recebe uma fita misteriosa com indícios de que Riley ainda pode estar viva. A partir daí, ela mergulha em uma espiral de horror de um mal desconhecido, repleta de revelações perturbadoras e uma atmosfera sufocante.​
elenco -> string (44) "Keith David, Camille Sullivan, Michael Beach"
$value['Em Cartaz'][16551]['info']->elenco
diretor -> string (15) "Chris Stuckmann"
$value['Em Cartaz'][16551]['info']->diretor
roteiro -> string (26) "Sam Liz, Chris Stuckmann "
sinopse -> UTF-8 string (288) "Denji se tornou o "Homem-Motosserra", um garoto com um coração de demônio, e...
$value['Em Cartaz'][16579]['info']->sinopse
Denji se tornou o "Homem-Motosserra", um garoto com um coração de demônio, e agora faz parte dos Caçadores de Demônios da Divisão Especial 4. Após um encontro com Makima, a mulher dos seus sonhos, Denji se abriga da chuva. Lá ele conhece Reze, uma garota que trabalha em um café.
sinopse -> UTF-8 string (357) "Baseado no romance homônimo de Colleen Hoover, o filme “Se não Fosse Você” n...
$value['Em Cartaz'][16429]['info']->sinopse
Baseado no romance homônimo de Colleen Hoover, o filme “Se não Fosse Você” narra a história de Morgan Grant (Allison Williams) e sua filha Clara (Mckenna Grace) enquanto elas precisam lidar com o que ficou após um acidente devastador revelar uma traição chocante e forçá-las a confrontar segredos da família, redefinir o amor e se redescobrir.
sinopse -> UTF-8 string (234) "Victor está nervoso diante da possibilidade de casar-se quando, sozinho na f...
$value['Em Cartaz'][3284]['info']->sinopse
Victor está nervoso diante da possibilidade de casar-se quando, sozinho na floresta para ensaiar seus votos, tropeça no braço do cadáver de uma noiva assassinada depois de fugir com seu amor. Ela então o leva ao mundo dos mortos.
elenco -> string (154) "<i>Vozes de: </i> Johnny Depp, Helena Bonham Carter, Emily Watson, Tracey Ul...
$value['Em Cartaz'][3284]['info']->elenco
<i>Vozes de: </i>
Johnny Depp,
Helena Bonham Carter,
Emily Watson,
Tracey Ullman,
Paul Whitehouse,
Joanna Lumley,
Albert Finney,
Richard E. Grant,
diretor -> string (25) "Tim Burton, Mike Johnson"
$value['Em Cartaz'][3284]['info']->diretor
Tim Burton,
Mike Johnson
roteiro -> string (17) "Caroline Thompson"
$value['Em Cartaz'][3284]['info']->roteiro
producao -> string (27) "Allison Abbate, Tim Burton"
sinopse -> UTF-8 string (723) "Enquanto Finn, agora com 17 anos, tenta lidar com a vida após o cativeiro, G...
$value['Em Cartaz'][16692]['info']->sinopse
Enquanto Finn, agora com 17 anos, tenta lidar com a vida após o cativeiro, Gwen, de 15 anos e determinada, começa a receber ligações em seus sonhos através do telefone preto ? e a ter visões perturbadoras de três garotos sendo perseguidos em um acampamento de inverno chamado Alpine Lake. Decidida a resolver o mistério e acabar com o tormento que aflige a ela e seu irmão, Gwen convence Finn a visitar o acampamento durante uma tempestade de inverno. Lá, ela descobre uma ligação devastadora entre O Sequestrador e a própria história de sua família. Juntos, Gwen e Finn terão que enfrentar um assassino que se tornou ainda mais poderoso após a morte ? e mais ligado a eles do que jamais poderiam imaginar.
elenco -> UTF-8 string (103) "Ethan Hawke, Mason Thames, Madeleine McGraw, Demián Bichir, Miguel Mora, Jer...
$value['Em Cartaz'][16692]['info']->elenco
Ethan Hawke, Mason Thames, Madeleine McGraw, Demián Bichir, Miguel Mora, Jeremy Davies, Arianna Rivas
diretor -> string (16) "Scott Derrickson"
$value['Em Cartaz'][16692]['info']->diretor
roteiro -> string (45) "C. Robert Cargill, Scott Derrickson, Joe Hill"
sinopse -> UTF-8 string (708) "Criado entre galinhas e protegido por sua mãe adotiva e sua irmã Catraca, o ...
$value['Em Cartaz'][16365]['info']->sinopse
Criado entre galinhas e protegido por sua mãe adotiva e sua irmã Catraca, o pequeno Pena Dourada, uma águia, acredita que não pode voar – ou pelo menos é o que lhe disseram. Determinado a provar seu valor e descobrir a verdade, ele parte com sua irmã para Bird City, onde pretende solucionar o mistério de seu nascimento. Lá, Pena Dourada encontra parentes distantes, incluindo seu tio, o prefeito da cidade, e descobre a incrível história de sua família. Mas, enquanto segredos profundos e traições são revelados, uma batalha inevitável se forma entre as águias e as galinhas, levando Pena Dourada a enfrentar escolhas decisivas que definirão seu futuro e o seu verdadeiro lugar no mundo.
elenco -> string (159) "Park Shi-yoon, Liu Xingzuo, Chen Hao, Kim Yong, Jeong Seok-won, Seo Jeongik,...
$value['Em Cartaz'][16365]['info']->elenco
Park Shi-yoon, Liu Xingzuo, Chen Hao, Kim Yong, Jeong Seok-won, Seo Jeongik, Huan Ting, Zeno Robinson, Sean Kenin, Debi Derryberry, Debra Wilson, Jason Patrick
diretor -> string (27) "Nigel W. Tierney, Dong Long"
$value['Em Cartaz'][16365]['info']->diretor
roteiro -> string (42) "Robert N. Skir, Jeff Sloniker, Vivian Yoon"
sinopse -> UTF-8 string (513) "Em seu 4º ano na Escola de Magia e Bruxaria de Hogwards, Harry Potter (Danie...
$value['Pré-Venda'][1438]['info']->sinopse
Em seu 4º ano na Escola de Magia e Bruxaria de Hogwards, Harry Potter (Daniel Radcliffe) é misteriosamente selecionado para participar do Torneio Tribruxo, uma competição internacional em que precisará enfrentar alunos mais velhos e experientes de Hogwards e também de outras escolas de magia. Além disso a aparição da marca negra de Voldemort (Ralph Fiennes) ao término da Copa do Mundo de Quadribol põe a comunidade de bruxos em pânico, já que sinaliza que o temido bruxo está prestes a retornar.
elenco -> string (103) "Daniel Radcliffe, Emma Watson, Rupert Grint, Mark Williams, James Phelps, Ol...
$value['Pré-Venda'][1438]['info']->elenco
Daniel Radcliffe, Emma Watson, Rupert Grint, Mark Williams, James Phelps, Oliver Phelps, Bonnie Wright
diretor -> string (11) "Mike Newell"
$value['Pré-Venda'][1438]['info']->diretor
roteiro -> string (48) "Steven Kloves, baseado em livro de J.K. Rowling "
sinopse -> UTF-8 string (540) "Marty McFly (Michael J. Fox) é um típico adolescente americano dos anos 80 q...
$value['Pré-Venda'][1031]['info']->sinopse
Marty McFly (Michael J. Fox) é um típico adolescente americano dos anos 80 que é mandado de volta para 1955 a bordo de um Delorean movido a plutônio, inventado pelo ligeiramente louco cientista Dr. Brown (Christopher Lloyd).
Durante sua viagem no tempo, sempre surpreendente, McFly precisa se certificar de que seus futuros pais, George Douglas McFly (Crispin Glover) e Lorraine Baines (Lea Thompson), se conheçam e se apaixonem, sem provocar alterações na linha do tempo. Somente depois disso ele poderá regressar para o futuro.
elenco -> string (266) "Michael J. Fox, Christopher Lloyd, Lea Thompson, Crispin Glover, Thomas F. W...
$value['Pré-Venda'][1031]['info']->elenco
Michael J. Fox,
Christopher Lloyd,
Lea Thompson,
Crispin Glover,
Thomas F. Wilson,
Claudia Wells,
Marc McClure,
Wendie Jo Sperber,
George DiCenzo,
Frances Lee McCain,
James Tolkan,
J.J. Cohen,
Casey Siemaszko,
Billy Zane,
Harry Waters Jr.
diretor -> string (15) "Robert Zemeckis"
$value['Pré-Venda'][1031]['info']->diretor
roteiro -> string (25) "Robert Zemeckis, Bob Gale"
sinopse -> UTF-8 string (204) "Wicked conta a história de Elphaba, a futura Bruxa Má do Oeste e seu relacio...
$value['Pré-Venda'][16688]['info']->sinopse
Wicked conta a história de Elphaba, a futura Bruxa Má do Oeste e seu relacionamento com Glinda, a Bruxa Boa do Norte. A segunda de uma adaptação cinematográfica de duas partes do musical da Broadway.
sinopse -> UTF-8 string (473) "Estrelado por Elle Fanning e Dimitrius Schuster-Koloamatangi, Predador: Terr...
$value['Em Breve'][16310]['info']->sinopse
Estrelado por Elle Fanning e Dimitrius Schuster-Koloamatangi, Predador: Terras Selvagens se passa em um futuro distante, em um planeta remoto, onde um jovem predador (Schuster-Koloamatangi), banido por seu clã, encontra uma inesperada aliada em Thia (Fanning) e embarca em uma perigosa jornada em busca de um adversário à sua altura. O filme é dirigido por Dan Trachtenberg e produzido por John Davis, Dan Trachtenberg, Marc Toberoff, Ben Rosenblatt e Brent O’Connor.
sinopse -> UTF-8 string (408) "A trama acompanha Edda, uma ratinha que sonha em competir no Grand Prix. Seu...
$value['Em Breve'][16199]['info']->sinopse
A trama acompanha Edda, uma ratinha que sonha em competir no Grand Prix. Seu mundo vira de cabeça para baixo quando, de forma inesperada, ela recebe a chance de disputar a corrida disfarçada de seu ídolo e piloto estrela, Ed. Ao longo da competição, Edda, sob a orientação de Ed como seu mentor, enfrenta uma série de desafios e armadilhas na pista - testando sua resiliência, habilidades e coragem.
sinopse -> UTF-8 string (256) "Quando um especialista em robótica canaliza o luto pela perda de seu filho d...
$value['Em Breve'][16509]['info']->sinopse
Quando um especialista em robótica canaliza o luto pela perda de seu filho de 11 anos na criação de "Robin", um boneco robótico totalmente funcional, uma série de eventos horríveis deixa claro que Robin fará de tudo para ter seu criador só para si.
elenco -> string (40) "Ethan Taylor, Simon Davies, Leona Clarke"
sinopse -> UTF-8 string (202) "Os Quatro Cavaleiros estão de volta com uma nova geração de ilusionistas e u...
$value['Em Breve'][8490]['info']->sinopse
Os Quatro Cavaleiros estão de volta com uma nova geração de ilusionistas e uma trama cheia de reviravoltas, mágicas e surpresas, que promete ser diferente de tudo o que já foi mostrado na franquia.
sinopse -> UTF-8 string (363) "Em 1989, Silvio Santos surpreendeu o país ao se candidatar à presidência. A ...
$value['Em Breve'][12246]['info']->sinopse
Em 1989, Silvio Santos surpreendeu o país ao se candidatar à presidência. A jornalista Marília é designada para investigar sua vida e prever possíveis ataques dos adversários. Embora seja um ícone da TV, Silvio mantém sua vida pessoal reservada. O convívio entre Silvio e Marília gera embates e descobertas. Desse encontro, ambos sairão transformados.
elenco -> UTF-8 string (106) "Leandro Hassum, Manu Gavassi, Marcelo Laham, Regiane Alves, Gabriel Godoy, H...
$value['Em Breve'][12246]['info']->elenco
Leandro Hassum, Manu Gavassi, Marcelo Laham, Regiane Alves, Gabriel Godoy, Hugo Bonemer e Vanessa Giácomo
sinopse -> UTF-8 string (204) "Wicked conta a história de Elphaba, a futura Bruxa Má do Oeste e seu relacio...
$value['Em Breve'][16688]['info']->sinopse
Wicked conta a história de Elphaba, a futura Bruxa Má do Oeste e seu relacionamento com Glinda, a Bruxa Boa do Norte. A segunda de uma adaptação cinematográfica de duas partes do musical da Broadway.
sinopse -> UTF-8 string (256) " Depois de levarem quase três milhões de espectadores aos cinemas com os pri...
$value['Em Breve'][15148]['info']->sinopse
Depois de levarem quase três milhões de espectadores aos cinemas com os primeiros filmes da franquia, os Detetives do Prédio Azul retornam às telonas com "D.P.A. 4 - O Filme” em mais um sucesso inspirado na série do Gloob, canal infantil da Globo.
sinopse -> UTF-8 string (570) "Doug (Jack Black) e Griff (Paul Rudd) são melhores amigos desde a infância e...
$value['Em Breve'][16431]['info']->sinopse
Doug (Jack Black) e Griff (Paul Rudd) são melhores amigos desde a infância e sempre sonharam em refazer seu filme favorito de todos os tempos: o "clássico" cinematográfico Anaconda. Quando uma crise de meia-idade os impulsiona a finalmente realizar esse sonho, eles vão até o coração da Amazônia para começar as filmagens. Mas as coisas ficam sérias quando uma anaconda gigante de verdade aparece, transformando o caótico e cômico set de filmagem em uma situação mortal. O filme que eles estão morrendo de vontade de fazer? Pode acabar matando os dois...
sinopse -> UTF-8 string (445) "Quando um filhote órfão de urso polar escapa de um circo itinerante, Toto fa...
$value['Em Breve'][15887]['info']->sinopse
Quando um filhote órfão de urso polar escapa de um circo
itinerante, Toto faz uma promessa de devolvê-lo ao seu habitat natural. Se ao menos ele soubesse que isso significava viajar para o Pólo Sul! Com a ajuda da equipe Little Eggs, eles terão que superar perigos inimagináveis como temperaturas congelantes, um trio de orcas malucas, piratas marinhos implacáveis, um leão-marinho enfurecido e um bando de pinguins surfistas malucos!
sinopse -> UTF-8 string (267) "Na aventura, a personagem conhecerá Catu (voz de Caio Guarnieri), Pepe (voz ...
$value['Em Breve'][14662]['info']->sinopse
Na aventura, a personagem conhecerá Catu (voz de Caio Guarnieri), Pepe (voz de Yuri Chesman) e Suri (voz de Laura Chasseraux) e o quarteto embarca em uma jornada em busca da Flecha Azul, amuleto ancestral que guiará seu caminho para que guarde e proteja a floresta.
elenco -> string (0) ""
$value['Em Breve'][14662]['info']->elenco
diretor -> UTF-8 string (27) "Alê Camargo e Jordan Nugem"
sinopse -> UTF-8 string (252) "Moscou, início do século XX. O cachorro Samson, fugindo dos caçadores de ani...
$value['Em Breve'][15583]['info']->sinopse
Moscou, início do século XX. O cachorro Samson, fugindo dos caçadores de animais, se encontra no Teatro Bolshoy. Assim, o personagem principal conhece o cachorro da primeira bailarina, após o que ajuda a devolver a decoração roubada da anfitriã.
sinopse -> UTF-8 string (433) "Nos dias que antecedem um dos momentos mais marcantes da humanidade, Jesus r...
$value['Em Breve'][16568]['info']->sinopse
Nos dias que antecedem um dos momentos mais marcantes da humanidade, Jesus reúne seus discípulos para a Última Ceia, um momento de comunhão que se tornará eterno. Entre palavras de amor e despedida, Ele anuncia o sacrifício que mudará a história, deixando ensinamentos que ecoarão para sempre. Enquanto a fé é fortalecida, a sombra da traição paira sobre a mesa, mas nem mesmo a dor pode apagar a promessa de redenção.
elenco -> string (96) "Robert Knepper, James Faulkner, Jamie Ward, Henry Garrett, Nathalie Rapti Go...
$value['Em Breve'][16568]['info']->elenco
Robert Knepper, James Faulkner, Jamie Ward, Henry Garrett, Nathalie Rapti Gomez, Daniel Fathers,
sinopse -> UTF-8 string (420) "Da New Line Cinema chega o mais recente capítulo da franquia de videogame de...
$value['Em Breve'][16521]['info']->sinopse
Da New Line Cinema chega o mais recente capítulo da franquia de videogame de sucesso, em toda a sua brutal glória: Mortal Kombat II. Desta vez, os campeões favoritos dos fãs — agora com a adição de Johnny Cage — são colocados uns contra os outros em uma batalha sangrenta e sem limites, para derrotar o domínio sombrio de Shao Kahn, que ameaça a própria existência do Reino da Terra, e de seus defensores.
elenco -> string (40) "Lewis Tan, Karl Urban, Hiroyuki Sanada "
$value['Em Breve'][16521]['info']->elenco
Lewis Tan, Karl Urban, Hiroyuki Sanada
diretor -> string (13) "Simon McQuoid"
$value['Em Breve'][16521]['info']->diretor
roteiro -> string (35) "Jeremy Slater, Ed Boon, John Tobias"
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 1761934115.8056
protected endTime -> double 1761934115.8089
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(): void 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
*
* @return void
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:293
protected matchNamedBinds(string $sql, array $binds): string Match bindings
/**
* Match bindings
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:321
protected matchSimpleBinds(string $sql, array $binds, int $bindCount, int $ml): string Match bindings
/**
* Match bindings
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:345
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:375
public __toString(): string Return text representation of the query
/**
* Return text representation of the query
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:429
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#118 (18)
Properties (18)
Methods (43)
Static methods (1)
public readonly affected_rows -> integer 1
public readonly client_info -> string (14) "mysqlnd 8.2.25"
public readonly client_version -> integer 80225
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.43"
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 (204) "SELECT aa.* FROM APPS_ACESSIBILIDADE as aa INNER JOIN REL_FILME_ACESSIBILIDA...
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNER JOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15155
protected swappedQueryString -> uninitialized
protected finalQueryString -> string (204) "SELECT aa.* FROM APPS_ACESSIBILIDADE as aa INNER JOIN REL_FILME_ACESSIBILIDA...
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNER JOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15155
protected binds -> array (0)
protected bindMarker -> string (1) "?"
protected startTime -> double 1761934115.7887
protected endTime -> double 1761934115.7896
protected errorCode -> null
protected errorString -> null
public db -> CodeIgniter\Database\MySQLi\Connection#117 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(): void 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
*
* @return void
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:293
protected matchNamedBinds(string $sql, array $binds): string Match bindings
/**
* Match bindings
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:321
protected matchSimpleBinds(string $sql, array $binds, int $bindCount, int $ml): string Match bindings
/**
* Match bindings
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:345
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:375
public __toString(): string Return text representation of the query
/**
* Return text representation of the query
*/
Defined in .../codeigniter4/framework/system/Database/Query.php:429
lastQuery string (204) "SELECT aa.* FROM APPS_ACESSIBILIDADE as aa INNER JOIN REL_FILME_ACESSIBILIDA...
SELECT aa.*
FROM APPS_ACESSIBILIDADE as aa
INNER JOIN REL_FILME_ACESSIBILIDADE as rfa
ON aa.CODIGO = rfa.COD_APP
WHERE rfa.COD_FILME = 15155
public connID -> mysqli#157 (18)
Properties (18)
Methods (43)
Static methods (1)
public readonly affected_rows -> integer 0
public readonly client_info -> string (14) "mysqlnd 8.2.25"
public readonly client_version -> integer 80225
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 4
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.43"
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:170
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:187
public getFotosFilme($fkClaquete) método para pegar o filme
$value->getFotosFilme()
/** método para pegar o filme */
Defined in .../app/Models/FilmeClaqueteMD.php:217
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:234
public getFilmesEmBreve()
$value->getFilmesEmBreve()
Defined in .../app/Models/FilmeClaqueteMD.php:280
public cinemasFilmeEmBreve($FK_Filme)
$value->cinemasFilmeEmBreve()
Defined in .../app/Models/FilmeClaqueteMD.php:300
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:321
public buscaFilmes($termo)
$value->buscaFilmes()
Defined in .../app/Models/FilmeClaqueteMD.php:330
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:347
public seekAcessibilidade($idFilme)
$value->seekAcessibilidade()
Defined in .../app/Models/FilmeClaqueteMD.php:384
public generos()
$value->generos()
Defined in .../app/Models/FilmeClaqueteMD.php:403
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:130
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:146
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:380
protected useCasts(): bool Are casts used?
/**
* Are casts used?
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:394
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:594
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:638
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:657
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:702
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:745
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:783
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:873
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:888
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:910
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:1057
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:1138
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:1179
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:1196
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:1209
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:1226
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:1250
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:1276
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:1301
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:1316
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:1335
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:1380
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:1404
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:1426
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:1443
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:1458
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:1474
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:1489
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:1505
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:1533
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:1547
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:1589
protected ensureValidation(): void
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:1612
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:1623
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:1637
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:1660
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:1689
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:1712
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:1729
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:1750
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:1765
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:1827
public allowEmptyInserts(bool $value = true): self Sets $allowEmptyInserts.
$value->allowEmptyInserts()
/**
* Sets $allowEmptyInserts.
*/
Inherited from CodeIgniter\BaseModel
Defined in .../codeigniter4/framework/system/BaseModel.php:1929
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:1942
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:72
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:108
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#415 (25)
<p style="text-align: justify;"><strong>3 Salas</strong></p>
<p style="text-align: justify;"><strong>Salas 3D - 5</strong><br><strong>Bomboniére</strong><br><strong>Acesso para port. de necessidades especiais</strong><br><strong>Ar Condicionado</strong><br><strong>Capacidade: Sala 3 (2D) - 104, Sala 4 (2D) - 104, Sala 5 </strong><strong>(3D)</strong><strong> - 186</strong></p>
