Fetch multiple rows using PHP, MySQL

<?php    

      $dbc = mysqli_connect("localhost", "my_user", "my_password", "my_database")  or die ("Error connecting to the mysql server. ");

      $query = "select * from my_table";

      $result = mysqli_query($dbc, $query)or die ("Could not connect to mysql server. ");

             

        $myArray = array();

    

        while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

             $myArray[] = $row;

        }

        $result->free(); 

    

        mysqli_close($dbc);

        //TEST TO SEE THE RESULT OF THE ARRAY 

        echo '<pre>';

             print_r($myArray);

        echo '</pre>';

?>