Add data from database

Question

I am using this function to search for a field in a table:

function rendimentoDia($conexao, $dia) {
$rendimentos = array();
$resultado = mysqli_query($conexao, "select valor from hospedes where dia = 
$dia");
while($rendimento = mysqli_fetch_assoc($resultado)) {
    array_push($rendimentos, $rendimento);
}
return $rendimentos;
}

then I use this code to display the data on the screen:

<table class="container">

<?php
    $rendimentos = rendimentoDia($conexao, $dia);

    foreach($rendimentos as $rendimento) :
?>
<tr>
    <td><?= $rendimento['valor']?></td>
</tr>
<?php

   endforeach
?>
</table>

This field brings the values entered in a day, I would like to add these values and I am not getting, I tried to add using array_sum in a variable that saved the value yield, but it did not work.. the function is bringing everything right and displaying, I just can’t add even. I thank anyone who can help

Answer 1

Well, as you said in the comments that you only need the total value and not the separate values, you can change the functionality directly in your query that will work, just leave your code this way:

$rendimentos = mysqli_query($conexao, "select SUM(valor) from hospedes where dia = $dia");
$rendimento = mysqli_num_rows($resultado);

<table>

<?php
while($rendimento = mysqli_fetch_array($resultado)) {
?>

<tr>
    <td><?= $rendimento['sum(valor)']; ?></td>
</tr>
        <?php
    }
?>
</table>

Thinking about the chance you said you get the $conexaothrough a include and the $dia through the date you declare ( I believe in the same file ), these variables will be accessible, so you do not need to declare a function and call it right after. You can simply mount your Query and just below do the while together to your table to print the column sum value. You can put the variables responsible for your query at the top of your file or even before your table, just be sure to put it between PHP tags.