Set cursor to the first column, print the field's name, table, and max length in PHP

Description

The following code shows how to set cursor to the first column, print the field's name, table, and max length.

Example


/*from  w  w  w.j  a  va2 s .c om*/
<?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 info for 1st column ("Lastname")
             mysqli_field_seek($result,0);
             $fieldinfo=mysqli_fetch_field($result);

             printf("Name: %s\n",$fieldinfo->name);
             printf("Table: %s\n",$fieldinfo->table);
             printf("max. Len: %d\n",$fieldinfo->max_length);

             // Free result set
             mysqli_free_result($result);
      }

      mysqli_close($con);
?>

The code above generates the following result.





















Home »
  PHP Tutorial »
    MySQL »




MySQLi
MySQLi Object Oriented