MySQL list columns names from table php pdo
$pdo = new PDO("mysql:host=localhost", "root", "");
$stmtnTable = $pdo->query("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ' database name ' AND TABLE_NAME = ' table name '");
$tables_name = $stmtnTable->fetchAll(PDO::FETCH_COLUMN);
foreach($tables_name as $columnsName){
echo $columnsName, '<br>';
}























