How can one dynamically retrieve table column names from a MySQL database in PHP and store them in an associative array?

To dynamically retrieve table column names from a MySQL database in PHP and store them in an associative array, you can use the following steps: 1. Connect to the MySQL database using mysqli or PDO. 2. Execute a query to fetch the column names from the desired table. 3. Store the column names in an associative array where the key is the column name and the value is null. 

<?php
// Connect to the MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query to fetch column names from a table
$table = "your_table_name";
$query = "SHOW COLUMNS FROM $table";
$result = $conn->query($query);

// Store column names in an associative array
$columns = array();
while ($row = $result->fetch_assoc()) {
    $columns[$row['Field']] = null;
}

// Print the associative array of column names
print_r($columns);

// Close the connection
$conn->close();
?>

Keywords

PHP MySQL database dynamic associative array

Related Questions