PHP访问mysqli_fetch_assoc值

Question

I have been trying to store the results of a MySQL query in a PHP array, however I have been struggling to access the values after they have been stored.

I used this to store the query:

while($row = mysqli_fetch_assoc($result)) {
    array_push($array, $row);
}

Which when showing the array with var_dump gives an output similar to this, just with more values:

array(147) { [0]=> array(1) { ["TABLE_NAME"]=> string(8) "_3085515" } }

I want to be able to access the value with the _NUMBER, but I can't figure out how to do this?

Answer 1

1st : Declare the variable as a array

   $array = array();
    while($row = mysqli_fetch_assoc($result)) {
       array_push($array, $row);
    }

2nd : Access the value like this

 $array[0]['TABLE_NAME']