Fill mySQL table to PHP matrix

Fill mySQL table to PHP matrix

 

Yes there is a way to do that. First, create a temporary storage where you will put the data you will be getting from your MySQL table. Say for example you choose $temp.

$temp = mysql_query (‘select * from table’);

Now you have to create another temporary storage for the array and for this, we will be using the same $temp to make a loop.

$temp = array ();

A condition is needed at this point. The condition’s logic should be like this: if you get a result from the query you made in $temp, it should be stored in an array and for each result you get, there is a corresponding array for that. It should look something like this:

While ($a = mysql_fetch_array ($temp)) {

Foreach ($a as $a1=>$b1) {

                   $temp [$a1] = $b1;

          }

          array_push ($temp);

          unset($temp);

}