Return the next field (column) in the result set, then print each field's name, table, and max length in PHP
Description
The following code shows how to return the next field (column) in the result set, then print each field's name, table, and max length.
Example
/*from www . j ava 2 s . c o 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
while ($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.