What are the common methods to retrieve table names and columns from a database in PHP?

When working with databases in PHP, you may need to retrieve table names and columns for various reasons such as dynamically generating SQL queries or displaying database information in your application. One common method to achieve this is by querying the database's information schema, specifically the tables and columns tables. By querying these system tables, you can fetch the necessary metadata about the database's structure. 

<?php
// Establish a connection to the database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Query the information schema to retrieve table names
$tables = $pdo->query("SELECT table_name FROM information_schema.tables WHERE table_schema = 'your_database'")->fetchAll(PDO::FETCH_COLUMN);

// Query the information schema to retrieve column names for a specific table
$columns = $pdo->query("SELECT column_name FROM information_schema.columns WHERE table_schema = 'your_database' AND table_name = 'your_table'")->fetchAll(PDO::FETCH_COLUMN);

// Output the retrieved table names and columns
echo "Table Names: " . implode(", ", $tables) . "<br>";
echo "Column Names for 'your_table': " . implode(", ", $columns);
?>

Keywords

PHP database table names columns retrieval

Related Questions