Fatal error: Uncaught Error: Call to undefined method DB::prepare() in

Xdenominal · Sep 23, 2020

Hi guys.
Please I have the above error. And I dont know how to solve please.

Please help me!

That is the complete error log:

Fatal error: Uncaught Error: Call to undefined method DB::prepare() in /usr/www/users/claquwvcjt/new/classes/Crud.php:398
Stack trace:
#0 /usr/www/users/claquwvcjt/new/metades/cabeca.php(160): Crud->clubeInfo()
#1 /usr/www/users/claquwvcjt/new/index.php(85): include('/usr/www/users/...')
#2 {main}
  thrown in /usr/www/users/claquwvcjt/new/classes/Crud.php on line 398

My Classs CRUD.php

<?php
require_once "DB.php";

abstract class Crud extends DB
{

  protected $tabela;
  protected $tblcateg;
  protected $tblsubcateg;
  protected $tblcoments;
  protected $tblclassificacao;
  protected $tblclubes;
  protected $tblresultados;
  protected $tblclaquetv;
  protected $tblproxjogos;
  protected $tblcompeticao;
  protected $tblpaises;
  protected $tblestadios;
  protected $tbljogadores;
  protected $tblposicoes;
  protected $tblclaquefotos;
  protected $tblclaqueaudio;



  abstract public function inserirRegisto();
  abstract public function atualizarRegisto($id);


  public function procura($id)
  {

$sql = "SELECT * FROM $this->tabela WHERE " . $id . " = :id";
$stmt = DB::prepare($sql);
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
$stmt->execute();
return $stmt->fetchAll();
  }

  public function procuras()
  {
    $sql = "SELECT * FROM $this->tabela ";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  public function procuraTudo()
  {
    $sql = "SELECT * FROM $this->tabela ORDER BY postDataCriado DESC ";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function procuraTudo0($id)
  {
    $sql = "SELECT * FROM tblposts WHERE id='$id' ORDER BY postDataCriado DESC ";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }


  

  public function procuraTudoX($id)
  {
    $sql = "SELECT * FROM tblposts WHERE id='$id'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function procuraCategoria($cat)
  {
    $sql = "SELECT * FROM $this->tabela WHERE categoria='$cat' LIMIT 7 ";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }


  

  public function procuraCategorias($cat)
  {
    $sql = "SELECT * FROM $this->tabela WHERE categoria='$cat' LIMIT 5 ";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function procuraTudoL($num)
  {
    $sql = "SELECT * FROM $this->tabela ORDER BY postDataCriado DESC LIMIT $num ";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }



  public function mostrarClubes($clube)
  {
    $sql = "SELECT * FROM tblclubes WHERE id='$clube'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  

  public function procuraTudo4($pagina)
  {$item_por_pagina=10;
    $sql = "SELECT * FROM $this->tabela ORDER BY postDataCriado DESC $pagina,$item_por_pagina";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function procuraTudo1()
  {
    $sql = "SELECT * FROM $this->tabela ORDER BY postTitulo LIMIT 4";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  public function procuraTudo2()
  {
    $sql = "SELECT * FROM $this->tabela ORDER BY categoria DESC LIMIT 4";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function procuraTudo3()
  {
    $sql = "SELECT * FROM $this->tabela ORDER BY postDataCriado DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function mostraForaJogo()
  {
    $sql = "SELECT * FROM tblposts  WHERE categoria = 18";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  public function apagar($id)
  {
    $sql = "DELETE FROM $this->tabela WHERE id = :id";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':id', $id, PDO::PARAM_INT);
    return $stmt->execute();
  }


  #PROCURA PARA MOSTRAR NOTICIAS NO TOP DA PAGINA
  public function mostraDestaquePrincipal()
  {
    $sql = "SELECT * FROM $this->tabela WHERE is_Active=1 LIMIT 1; DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PROCURA PARA MOSTRAR NOTICIAS NO PE DA PAGINA
  public function procuraLimitada()
  {
    $sql = "SELECT * FROM $this->tabela WHERE is_Active=1 LIMIT 2; DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PROCURA PARA MOSTRAR NOTICIAS DE DIASPORA NA PAGINA
  public function procuraDiaspora()
  {
    $sql = "SELECT * FROM $this->tabela WHERE categoria = 11";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PROCURA PARA MOSTRAR NOTICIAS DE ENTREVISTAS NA PAGINA
  public function procuraEntrevistas()
  {
    $sql = "SELECT * FROM $this->tabela WHERE categoria = 12";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PROCURA PARA MOSTRAR CATEGORIA NA PAGINA
  public function procuraCateg()
  {
    $sql = "SELECT * FROM $this->tblcateg LIMIT 8; DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PROCURA PARA MOSTRAR SUB CATEGORIA NA PAGINA
  public function procuraSubCateg($stid)
  {
    $sql = "SELECT * FROM $this->tblsubcateg WHERE CategoryId = :stid";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':stid', $stid, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }


  #PROCURA PARA MOSTRAR COMENTARIOS NA PAGINA
  public function procuraComment($comId)
  {
    $sql = "SELECT * FROM $this->tblcomments WHERE postId = :comId AND status = 1 LIMIT 14; DESC";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':comId', $comId, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #FILTRA NOTICIAS POR CATEGORIA NA PAGINA DE CATEGORIAS
  public function listaPorCategoria($getCatid)
  {
    $sql = "SELECT * FROM $this->tabela WHERE categoria = " . $getCatid . "";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA POSTS POR PUBLICADOR
  public function postPorPublicador($getPublicador)
  {
    $sql = "SELECT * FROM $this->tabela WHERE publicadoPor = '$getPublicador'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA CLASSIFICACAO NA PAGINA CLASSFICACAO
  public function classificacao($compet)
  {
    $sql = "SELECT * FROM $this->tblclassificacao WHERE competicao = '$compet' ORDER BY pontos DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA CLASSIFICACAO NA PAGINA CLASSFICACAO
  public function classificacaoLateral($compet)
  {
    $sql = "SELECT * FROM $this->tblclassifica WHERE competicao = '$compet'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA RESULTADOS NA PAGINA INICIAL
  public function mostraResultados($num)
  {
    $sql = "SELECT * FROM $this->tblresultados ORDER BY dataup DESC LIMIT $num";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA RESULTADOS NA PAGINA RESULTADOS DE ACORDO A COMPETICAO
  public function mostraResultadosGeral($compet)
  {
    $sql = "SELECT * FROM $this->tblresultados WHERE competicao = '$compet' ORDER BY dataup DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA RESULTADOS NA PAGINA INICIAL
  public function mostraTodosResultados($getAno)
  {
    $sql = "SELECT * FROM $this->tblresultados WHERE Ano = $getAno";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

   #MOSTRA RESULTADOS NA PAGINA INICIAL
   public function mostraMelhorMarcador()
   {
     $sql = "SELECT * FROM tblmarcador ORDER BY golo DESC";
     $stmt = DB::prepare($sql);
     $stmt->execute();
     return $stmt->fetchAll();
   }
 
   

   #MOSTRA RESULTADOS DA EQUIPE CLAQUEMAGAZINE
   public function mostraEquipe()
   {
     $sql = "SELECT * FROM tbequipa ORDER BY id DESC";
     $stmt = DB::prepare($sql);
     $stmt->execute();
     return $stmt->fetchAll();
   }
 
   

   #MOSTRA RESULTADOS DOS JOGADORES
   public function jogadores($nome_jogador)
   {
     $sql = "SELECT * FROM tbljogadores WHERE nome_jogador='$nome_jogador'";
     $stmt = DB::prepare($sql);
     $stmt->execute();
     return $stmt->fetchAll();
   }
 

  #MOSTRA DADOS CLUBE NA PAGINA DE CLUBES
  public function dadosClube($getclube)
  {
    $sql = "SELECT * FROM $this->tblclubes WHERE id = '$getclube'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #RESULTADO DE PESQUISA  

  public function resultadoPesquisa($rp)
  {
    $sql = "SELECT * FROM $this->tabela WHERE postTexto LIKE '%$rp%' OR postTitulo LIKE '%$rp%'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function publicidadesVertical()
  {
    $sql = "SELECT * FROM tbpublicidade WHERE Tipo='Vertical' ORDER BY id DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function publicidades()
  {
    $sql = "SELECT * FROM tbpublicidade WHERE Tipo='Horizontal' ORDER BY id DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function procuraVideos()
  {
    $sql = "SELECT * FROM $this->tblclaquetv ORDER BY post_data DESC";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  

  public function procuraVideosP($lim)
  {
    $sql = "SELECT * FROM $this->tblclaquetv ORDER BY post_data DESC LIMIT $lim";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
	  public function procuraVideos1()
  {
    $sql = "SELECT * FROM $this->tblclaquetv ORDER BY post_data DESC LIMIT 4";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  public function procuraVideoself($idvideo)
  {
    $sql = "SELECT * FROM $this->tblclaquetv WHERE id = '$idvideo'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
	
  public function procuraVideos3()
  {
    $sql = "SELECT * FROM $this->tblclaquetv ORDER BY post_data ASC LIMIT 3";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  public function mostraClassifica()
  {
    $sql = "SELECT * FROM $this->tblclassificacao ORDER BY posicao ASC, jogoVictorias DESC LIMIT 5";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }



###   Function that is being calling
	
  **public function clubeInfo()
  {
    $sql = "SELECT * FROM $this->tblclubes";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }**

  #trazer palavras chave referente ao post

  public function mostraCategs($stid)
  {
    $sql = "SELECT * FROM tblposts WHERE id = :stid";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':stid', $stid, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PROCURA PARA MOSTRAR CATEGORIA NA PAGINA
  public function mostraCateg($stid)
  {
    $sql = "SELECT * FROM $this->tblcateg WHERE id = :stid";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':stid', $stid, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }



  #PROCURA LOGOTIPO DO CLUBE
  public function procLogoClube($id_clube)
  {
    $sql = "SELECT * FROM $this->tblclubes WHERE id = :id_clube";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':id_clube', $id_clube, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA NOTICIAS COM BASE NA CATEGORIA
  public function noticiaPorCat($stid,$num)
  {
    $sql = "SELECT * FROM $this->tabela WHERE categoria = :stid  LIMIT $num";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':stid', $stid, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PROCURA PARA MOSTRAR NOTICIAS NO TOP DA PAGINA
  public function noticiaPorCatDestaPrin($stid)
  {
    $sql = "SELECT * FROM tbposts WHERE categoria = :stid ";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':stid', $stid, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA PROXIMOS JOGOS NA PAGINA DE JOGOS
  public function mostraProxJogos($num)
  {
    $sql = "SELECT * FROM $this->tblproxjogos ORDER BY data_ini DESC LIMIT $num";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA PROXIMOS JOGOS NA PAGINA DE JOGOS
  public function proxJogPorCompet($compId)
  {
    $sql = "SELECT * FROM $this->tblproxjogos WHERE competicao = :compId";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':compId', $compId, PDO::PARAM_STR);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #LISTA COMPETICAO NA PAGINA COMPETICAO
  public function listaCompeticao()
  {
    $sql = "SELECT * FROM $this->tblcompeticao";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }


  #MOSTRA DADOS CLUBE NA PAGINA DE CLUBES
  public function clubeInfoPorCompet($getclube)
  {
    $sql = "SELECT * FROM $this->tblclubes WHERE clube_competicao = '$getclube'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PEGA O PAIS ATRAVES DO ID
  public function listaPaises($getPais)
  {
    $sql = "SELECT * FROM $this->tblpaises WHERE id = :getPais";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':getPais', $getPais, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #PEGA O CAMPO/ESTADIO ATRAVES DO ID
  public function listaCamposEstadios($getEstadio)
  {
    $sql = "SELECT * FROM $this->tblestadios WHERE id = :getEstadio";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':getEstadio', $getEstadio, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA ÚLTIMOS RESULTADOS DO CLUBE NA PÁGINA DO CLUBE
  public function ultimosResultClube($idClube)
  {
    $sql = "SELECT * FROM $this->tblresultados WHERE id_clube1 = $idClube OR id_clube2 = $idClube ORDER BY dataup DESC LIMIT 3";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  public function ultimosResultClubeX($idClube,$numero)
  {
    $sql = "SELECT * FROM $this->tblresultados WHERE id_clube1 = $idClube OR id_clube2 = $idClube  LIMIT $numero";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
  #MOSTRA ÚLTIMOS RESULTADOS DO CLUBE NA PÁGINA DO CLUBE
  public function ultimosResultClubeBanner($idClube)
  {
    $sql = "SELECT * FROM $this->tblresultados WHERE id_clube1 = $idClube OR id_clube2 = $idClube ORDER BY dataup DESC LIMIT 1";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA PROXIMOS JOGOS CLUBE NA PÁGINA DO CLUBE
  public function mostraProxJogosClube($idClube2)
  {
    $sql = "SELECT * FROM $this->tblproxjogos WHERE id_clube1 = $idClube2 OR id_clube2 = $idClube2 ORDER BY data_ini, hora_ini DESC LIMIT 1";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }


  #MOSTRA JOGADORES NO PLANTEL
  public function mostraJogadoresPlantel($getClubeJogador)
  {
    $sql = "SELECT * FROM $this->tbljogadores WHERE clube = " . $getClubeJogador . "";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }



  #MOSTRA POSICOES DE CADA JOGADOR
  public function getPosicaoJogador($getPosiJogador)
  {
    $sql = "SELECT * FROM $this->tblposicoes WHERE id = " . $getPosiJogador . "";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  #MOSTRA DADOS INDIVIUAL DO JOGADOR
  public function mostraDadosJogador($getJogadorId)
  {
    $sql = "SELECT * FROM $this->tbljogadores WHERE id = " . $getJogadorId . "";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }


  #MOSTRA PROXIMOS ADVERSARIO
  public function mostraProxAdver($clubeId)
  {
    $sql = "SELECT * FROM $this->tblproxjogos WHERE id_clube1 = $clubeId OR id_clube2 = $clubeId ORDER BY data_ini, hora_ini DESC LIMIT 1";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }


  #PROCURA PARA MOSTRAR SUB CATEGORIA NA PAGINA
  public function palavrasChave()
  {
    $sql = "SELECT * FROM $this->tblsubcateg";
    $stmt = DB::prepare($sql);
    $stmt->bindParam(':stid', $stid, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll();
  }
	
  #LISTA TODAS FOTOS DA GALERIA
  public function listaFotosGaleria()
  {
    $sql = "SELECT * FROM $this->tblclaquefotos";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
    

  public function listaFotosGaleria2()
  {
    $sql = "SELECT * FROM $this->tblclaquefotos ORDER BY post_data DESC LIMIT 4";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }

  public function listaFotosGaleria1($lim)
  {
    $sql = "SELECT * FROM $this->tblclaquefotos ORDER BY post_data DESC LIMIT $lim";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
	
public function procuraFotoself($idfoto)
  {
    $sql = "SELECT * FROM $this->tblclaquefotos WHERE id = '$idfoto'";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }	
	
  #LISTA TODOS AUDIOS DA GALERIA
  public function procuraAudios()
  {
    $sql = "SELECT * FROM $this->tblclaqueaudio";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }public function procuraAudiosP($lim)
  {
    $sql = "SELECT * FROM $this->tblclaqueaudio ORDER BY post_data DESC LIMIT $lim";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
    


  public function procuraAudios2()
  {
    $sql = "SELECT * FROM $this->tblclaqueaudio ORDER BY post_data DESC LIMIT 6";
    $stmt = DB::prepare($sql);
    $stmt->execute();
    return $stmt->fetchAll();
  }
	


}

NogDog · Sep 23, 2020

Welcome to the forums. I edited your post to include [code]...[/code] tags for better formatting of your code. Please be sure to use them in future posts.

Now I'll look at the actual question....

NogDog · Sep 23, 2020

Since your class extends that DB class, maybe you just need to change instances of DB:: to be $this->, such as $stmt = $this->prepare($sql);, instead of trying to use a static call to the parent class?

Xdenominal · Sep 25, 2020

NogDog Thanks i am a new user.

Xdenominal · Sep 25, 2020

NogDog Ok dear. I will try this sugestion now. Thanks!

Xdenominal · Sep 25, 2020

NogDog Just to say you, the script run on localserver. But on remote server I verify this error.

Fatal error: Uncaught Error: Call to undefined method DB::prepare() in

XXdenominal

That is the complete error log:

NogDog

NogDog

XXdenominal

XXdenominal

XXdenominal