Error in the Database

Question

I am trying to make every time the user clicks a button happen an UPDATE, but for some reason gives the No database selected, what’s wrong with that code?

Update.PHP

<?php
 require_once 'Classes/BancoDAO.php';
 $codTarefa=$_GET['codTarefa'];

require_once "Classes/TarefasVO.php";
require_once "Classes/TarefasDAO.php";

 $objTarefa = new TarefasVO();
 $objBDTarefa = new TarefasDAO();

$mysqli = new mysqli('localhost', 'root', '', 'bdpi');

$sqlDetalhes= "Select * from tarefas where codigo_TAREFA='$codTarefa'";
$rsDetalhes= mysqli_query($mysqli, $sqlDetalhes) or die (mysqli_error($mysqli));

$tblDetalhes=mysqli_fetch_array($rsDetalhes);

$status=($tblDetalhes['status_TAREFA']+1);

 $objTarefa->setCodigoTarefa($codTarefa);
 $objTarefa->setStatusTarefa($status);

  $objBDTarefa->EditaStatusTarefa($codTarefa, $objTarefa);

  $codigo=$tblDetalhes['codidoAtividade_TAREFA'];

   header("location:Atividade.php?codAtividade=$codigo");


?>

Taskforce.phph -> Taskforce

  public function EditaStatusTarefa($codTarefa,$tmp){

  $mysqli = new mysqli('localhost', 'root', '', 'bdpi');

   $sqlEditaSN= "Update tarefas set status_TAREFA=";
$sqlEditaSN.="'".$tmp->getStatusTarefa()."'";
$sqlEditaSN.=" where codigo_TAREFA = '$codTarefa'";

mysqli_query($mysqli,$sqlEditaSN) or die(mysqli_error($mysqli));

$sqlDetalhes= "Select * from tarefas where codigo_TAREFA='$codTarefa'";
$rsDetalhes= mysqli_query($mysqli, $sqlDetalhes) or die (mysqli_error($mysqli));

$tblDetalhes=mysqli_fetch_array($rsDetalhes);

$codigo=$tblDetalhes['codidoAtividade_TAREFA'];

header("location:Atividade.php?codAtividade=$codigo");

}

Answer 1

The problem is that you are not selecting the database. The way you made the connection is object oriented, however its query is in procedural form.

Change that line:

$mysqli = new mysqli('localhost', 'root', '', 'bdpi');

To:

$mysqli = mysqli_connect('localhost', 'root', '', 'bdpi');

Thus, your connection with the bank will also be in procedural form.