Does anyone know how to fix a website hosting error?

Question

someone knows how to fix an error in the

$stmt = mysqli_prepare($mysqli, $sql);
    mysqli_stmt_bind_param($stmt, 'i', $id);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);

it does not bring the proposed function in the hosting of Locaweb. I decided to give a var dump in my localhost and he brings me the results but in Ocaweb he does not bring me those results. I read that it could be the version by which in Ocaweb the default and version 5.2 of php intao I changed the version to the 5.6 but nothing appears the results someone could help me?

good on my detail page has this code:

 $id = $_GET['cod'];

                        $sqql = mysqli_query($mysqli, "SELECT * FROM produtos WHERE id_produto = $id");
                        $test = mysqli_query($mysqli, "SELECT votos, pontos FROM produtos WHERE id_produto = $id");

                        $aux = mysqli_fetch_array($sqql);
                        $idprod = $aux['id_produto'];

                        $row = mysqli_fetch_array($test);
                        $voto = $row['votos'];
                        $ponto = $row['pontos'];
                        $calc = round(($ponto/$voto),1);

until this section is working because I gave var_dump($idprod) and it returns me the id of the right product but continuing now has the part that brings the result:

$sql = "SELECT * FROM produtos WHERE id_produto = ?";
                        $stmt = mysqli_prepare($mysqli, $sql);
                        mysqli_stmt_bind_param($stmt, 'i', $id);
                        mysqli_stmt_execute($stmt);
                        $result = mysqli_stmt_get_result($stmt);
                while ($aqq = mysqli_fetch_assoc($result)){

                   $nome = $aqq['nome'];
                   $desc = $aqq['descricao'];
                   $preco = $aqq['preco'];
                   $img = $aqq['img'];

already here in this passage I gave var_dump($nome) it would be right for him to show me string aaaa but he won’t show me anything in Ocaweb, but I will run the same var_dump on my localhost and even at the same location there it returns me string aaaa

Answer 1

Not if it is not possible to install/ o mysqlnd in your accommodation, change get_result() for bind_result(), which changes is the return the first method returns an array the second N variables one for each field of the field list.

Subastitua:

mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt); 

The code below will be applied for this query SELECT * FROM produtos WHERE id_produto = ?, the table seems to have 4 fields.

For:

mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $nome, $preco, $descricao, $imagem);
while (mysqli_stmt_fetch($stmt)) {
    echo $nome .' - '. $preco .' - '. $descricao .' - '. $imagem .'<br>;
}
mysqli_stmt_close($stmt);