I'm taking a beating with an update with variable. Please, can anyone help me?
$servidorBanco = "localhost";
$usuarioBanco = "root";
$senhaBanco = "";
$dadosBanco = "db";
$conexao = new mysqli($servidorBanco, $usuarioBanco, $senhaBanco, $dadosBanco);
date_default_timezone_set('America/Sao_Paulo');
$hora = date('H:i:s');
$idHost = 1;
$consulta2 = $conexao->escape_string("UPDATE host SET uptimeHost='".$hora."', avisoHost=0 WHERE idHost='".$idHost);
$resultado4 = $conexao->query($consulta2);
Not updating in MySQL database.