Home > Database > mysql > How to display the mysql table schema using php code?

How to display the mysql table schema using php code?

Hello friends,

The following script is for displaying the mysql connecting using php code and  table schema using php code.

It will be useful when we want to know the total fields of table.

1) Connecting with mysql :

$db_host     = “”;  // Database hostname
$db_username=””; // Database username
$db_password=””; // Database password
$db_name = “”; // Database name

$conn = mysql_connect($db_host,$db_username,$db_password) or die(“Could not connect to Server” .mysql_error());
mysql_select_db($db_name) or die(“Could not connect to Database” .mysql_error());

2) Write a query for the table which we want schema

$result = mysql_query(“SELECT * FROM {$tablename}”);
if (!$result) {
die(“Query to show fields from table failed”);
}

3) Getting the number of fields in that table

$fields_num = mysql_num_fields($result);

4) Display the table schema

for($i=0; $i<$fields_num; $i++)
{
$field = mysql_fetch_field($result);
echo “<b>{$field->name}</b>”;

echo “<br>”;

}

2 Responses

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.