PHP/MySQL Database/Table MetaData

Get column data type

   <source lang="html4strict">

<?php

  mysql_connect("mysql153.secureserver.net","wbex","password");
  mysql_select_db("wbex");
  $query = "SELECT id as Employee_ID FROM Employee";
  $result = mysql_query($query);
  $row = mysql_fetch_row($result);
  echo mysql_field_type($result, 0);

?>

      </source>
   
  

Get column name, type and max length

   <source lang="html4strict">

<?php

  mysql_connect("mysql153.secureserver.net","wbex","password");
  mysql_select_db("wbex");
  $query = "SELECT * FROM Employee LIMIT 1";
  $result = mysql_query($query);
  $fields = mysql_num_fields($result);
  for($count=0;$count<$fields;$count++) {
     $field = mysql_fetch_field($result,$count);

echo "

$field->name $field->type ($field->max_length)

";

  }

?>

      </source>
   
  

Get field length

   <source lang="html4strict">

<?php

  mysql_connect("mysql153.secureserver.net","wbex","password");
  mysql_select_db("wbex");
  $query = "SELECT FirstName FROM Employee ";
  $result = mysql_query($query);
  $row = mysql_fetch_row($result);
  echo mysql_field_len($result, 0);

?>

      </source>
   
  

Get table column flag

   <source lang="html4strict">

<?php

  mysql_connect("mysql153.secureserver.net","wbex","password");
  mysql_select_db("wbex");
  $query = "SELECT id as Employee_ID FROM Employee";
  $result = mysql_query($query);
  $row = mysql_fetch_row($result);
  echo mysql_field_flags($result, 0);

?>

      </source>
   
  

Total number of fields in a table

   <source lang="html4strict">

<?php

  mysql_connect("mysql153.secureserver.net","wbex","password");
  mysql_select_db("wbex");// databasename
  $fields = mysql_list_fields("wbex","Employee");// databasename and tablename
  echo "Total number of fields returned: ".mysql_num_fields($fields).".
";

?>

      </source>