PHP/MySQL Database Table Structure Viewer

PHP-MySQL Database Table Structure Viewer

This PHP script is designed to fetch and display detailed information about the fields within a MySQL database table. In simpler terms, it helps you visualize the structure of a table by printing a neat HTML table with essential details about each field, such as its name, data type, length, and various flags.

The script uses MySQLi, a modern and more secure extension for interacting with MySQL databases in PHP. It provides a beginner-friendly way to understand the composition of your database tables. The script connects to the database, query the structure of a specific table and presents the information in an organized HTML format.

<?php
// Connect to the database
$dbLink = mysqli_connect("localhost", "freetrade", "", "freetrade");

// Check the connection
if (!$dbLink) {
    die("Connection failed: " . mysqli_connect_error());
}

// Get list of fields
$tableName = "invoice";
$query = "DESCRIBE $tableName";
$result = mysqli_query($dbLink, $query);

// Start HTML table
echo "<table>\n";
echo "<tr>\n";
echo "<th>Name</th>\n";
echo "<th>Type</th>\n";
echo "<th>Length</th>\n";
echo "<th>Flags</th>\n";
echo "</tr>\n";

// Loop over each field
while ($row = mysqli_fetch_assoc($result)) {
    echo "<tr>\n";
    echo "<td>" . $row['Field'] . "</td>\n";
    echo "<td>" . $row['Type'] . "</td>\n";
    echo "<td>" . $row['Length'] . "</td>\n";
    echo "<td>" . $row['Null'] . " " . $row['Key'] . " " . $row['Default'] . " " . $row['Extra'] . "</td>\n";
    echo "</tr>\n";
}

// Close HTML table
echo "</table>\n";

// Close the connection
mysqli_close($dbLink);
?>
Categories: PHP Source Code
M. Saqib: Saqib is Master-level Senior Software Engineer with over 14 years of experience in designing and developing large-scale software and web applications. He has more than eight years experience of leading software development teams. Saqib provides consultancy to develop software systems and web services for Fortune 500 companies. He has hands-on experience in C/C++ Java, JavaScript, PHP and .NET Technologies. Saqib owns and write contents on mycplus.com since 2004.
Related Post