Rader från MySQL till XML med PHP

$pdh      = new PDO('mysql:host=localhost;dbname=DATABASNAMN', 'ANVÄNDARE', 'LÖSENORD');
$pdh->query("set names 'utf8' collate 'utf8_swedish_ci'");

$columns  = $pdh->query("show columns from TABELL");
$posts    = $pdh->query("select * from TABELL");

$xml      = '<' . '?xml version="1.0" encoding="UTF-8"?' . '>' . "\n";
$xml     .= "<products>\n";

foreach ($posts as $post) {
	$xml .= "<product>\n";
	
	foreach ($columns as $column) {
		$xml .= "<" . $column['Field'] . ">" . $post[$column['Field']] . "</" . $column['Field'] . ">\n";
	}
	
	$xml .= "</product>\n";
}

$xml     .= "</products>\n";

header("Content-Type: text/xml; charset=UTF-8");
die($xml);