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>';
}
  
 
 
  






















