Show PHP table data

Question

I have a problem, I wanted to show the data of the respective table the query that is made. I can only show the two values within the for cycle. What I want is to show the data outside of the for cycle, like save to an array and show that array.

for($y=2; $y>0; $y--){
                    $base_hndl  =   new SQLite3($dir.$base);                    
                    $requete    =   "SELECT id, title, start, end, description, jour, mois, annee, date 
                        FROM \"event\" 
                        WHERE jour=\"$i\"
                        AND id=$y";

                    $resultat   =   $base_hndl->query($requete);     
                    $affiche    =   $resultat->fetchArray();

                    $result = "<label><b>$affiche[title]</b></label><br>";

                    echo $result;

                }

Answer 1

create an empty variable of the Array type outside your loop. Then inside the for, use the array_push function to insert at the end of the variable the result found. To go through the variable use foreach

$array_resultados = array();
for($y=2; $y>0; $y--){
                        $base_hndl  =   new SQLite3($dir.$base);                    
                        $requete    =   "SELECT id, title, start, end, description, jour, mois, annee, date 
                            FROM \"event\" 
                            WHERE jour=\"$i\"
                            AND id=$y";
                    $resultat   =   $base_hndl->query($requete);     
                    $affiche    =   $resultat->fetchArray();
                    array_push($array_resultados, $affiche);

            }
foreach($array_resultados as $key =>$value){

                $echo "<label><b>".$value['title']."</b></label><br>";

}