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>”;

}

Anil Kumar Panigrahi

With more than 10 years experience in PHP and Founder of Anil Labs, a blog for PHP and related posts. contributed posts regarding CodeIgniter, CakePHP and Learn PHP online ... Contact : [email protected]

You may also like...

2 Responses

  1. Gojeg says:

    I have not played with myql + PHP anymore .. But, thanks for reminding me.

  2. same problem i have faced now find good solution thanks for your awesome post.

Leave a Reply

Your email address will not be published. Required fields are marked *

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