Return an array of objects that represent the columns in a result set in PHP

//from www  .  ja  va 2 s .co  m
<?php
     $con=mysqli_connect("localhost","root","","test");
     // Check connection
     if (mysqli_connect_errno()){
         echo "Failed to connect to MySQL: " . mysqli_connect_error();
     }

     $sql="SELECT name FROM employee";

     if ($result=mysqli_query($con,$sql)){
         // Get field information for all fields
         $fieldinfo=mysqli_fetch_fields($result);

         foreach ($fieldinfo as $val){
           printf("Name: %s\n",$val->name);
           printf("Table: %s\n",$val->table);
           printf("max. Len: %d\n",$val->max_length);
         }
         // Free result set
         mysqli_free_result($result);
     }
     mysqli_close($con);
?>