PHP массив в файл CSV

$prods = array(
	array(
		'id' => '697',
		'name' => 'Динамический ортез-стоподержатель',
		'category' => 'Ортезы',
		'price' => '35990 RUB',
	),    
	array(
		'id' => '698',
		'name' => 'Бандаж на коленный сустав',
		'category' => 'Ортезы',
		'price' => '3610 RUB',
	),    
	array(
		'id' => '699',
		'name' => 'Бандаж на плечевой сустав',
		'category' => 'Ортезы',
		'price' => '3700 RUB',
	),
);

// Подключение к БД.
$dbh = new PDO('mysql:dbname=НАЗВАНИЕ_БД;host=localhost', 'ЛОГИН', 'ПАРОЛЬ');

$sth = $dbh->prepare("SELECT * FROM `prods`");
$sth->execute();
$array = $sth->fetch(PDO::FETCH_ASSOC);

$prods = array();
foreach($array as $row) { 
	$prods[] = array(
		'id'       => $row['id'],
		'name'     => $row['name'],
		'category' => $row['category'],
		'price'    => $row['price'],
	);
} 

header("Content-type: text/csv"); 
header("Content-Disposition: attachment; filename=file.csv"); 
header("Pragma: no-cache"); 
header("Expires: 0"); 

$buffer = fopen('php://output', 'w'); 
fputs($buffer, chr(0xEF) . chr(0xBB) . chr(0xBF));
foreach($prods as $val) { 
	fputcsv($buffer, $val, ';'); 
} 
fclose($buffer); 
exit();

$buffer = fopen(__DIR__ . '/file.csv', 'w'); 
fputs($buffer, chr(0xEF) . chr(0xBB) . chr(0xBF));
foreach($prods as $val) { 
	fputcsv($buffer, $val, ';'); 
} 
fclose($buffer); 
exit();