Return all results of a query with mysqli_fetch_array

Question

Hello,

I am trying to implement a block scheduling system where the user chooses the date and location of his preference. After that, he will choose the times according to availability and need to block schedules that are unavailable. I tried to search the database and create an array of all schedules that are possible to schedule to compare with the results obtained, but I believe that I am with some logic error, because the function mysqli_fetch_array does not return all values and starts a new search when it falls in the if() condition I put. Exemplifying:

Have been scheduled the times of 18h00, 19h00 and 20h00 for the day 28/05/2018 on the court whose id = 1.

With the code below, it returns me 3 entire columns with the arrays specified, and in the first column only the time of 18h00 appears unavailable, in the second column only 19h00 and in the third column only 20h00 as unavailable.

Any idea to adjust and bring me just a column with the three times unavailable? Thank you so much already

                   $consulta_sql= "SELECT hora_agendada FROM tabela_agendamentos WHERE data='$data_escolhida_pelo_usuario' AND id_quadra_escolhida_pelo_usuario='1'";
                   $query   = mysqli_query($infos_conexao, $consulta_sql)

                    while ($dados_do_mysql = mysqli_fetch_array($query)){ 
                       foreach ( array("9:00","10:00","11:00","12:00","13:00","14:00","15:00","16:00","17:00","18:00","19:00","20:00","21:00","22:00","23:00") as $hora_array ) {
                            if($hora_array == $dados_do_mysql['hora']){
                                $hora_array ='Horário Indisponível';
                              }
                              echo $hora_array;
                          }

                     }  

Answer 1

One solution I found for your problem is the following:

You have the array() hours that have already been chosen as a query response through the mysqli_fetch_array(), which in the example I attributed as $horas_cadastradas, in your case would:

$horas_cadastradas = mysqli_fetch_array($query);

You have the total hours matrix, which in the example I assigned as $horas_totais.

Using the loop foreach() in the array $horas_totais and using the function in_array() to check if the time exists in the array $horas_cadastradas:

$horas_cadastradas = array("18:00","19:00","20:00");
$horas_totais = array("9:00","10:00","11:00","12:00","13:00","14:00","15:00","16:00","17:00","18:00","19:00","20:00","21:00","22:00","23:00");
foreach ($horas_totais as $hora) {
    if(in_array($hora,$horas_cadastradas)){
        echo '"Horário Indisponível"<br>';
    }else{
        echo $hora."<br>";
    }
}

We were able to achieve the result of:

9:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
17:00
"Horário Indisponível"
"Horário Indisponível"
"Horário Indisponível"
21:00
22:00
23:00

♦ Reference of the in_array function()

while of creation of array():

while ($dados_do_mysql = mysqli_fetch_array($query)){
    $horas_cadastradas[]=$dados_do_mysql['hora'];
}