<?php
require "include/bd-connect.php";
$pdo = bd_connect();
//Header
header("Content-Type:text/csv; charset=utf-8");
header("Content-Disposition: attachment; filename='report.cvs'");
//Salida de archivo
$exit = fopen("php://output", "w");
//Encabezados:
fputcsv($exit, array('id', 'Title', 'Author'));
//Consulta para crear reporte:
$sql_libros = $pdo->prepare("SELECT id,title,author FROM books WHERE active = 1 ORDER BY id ASC");
$sql_libros->execute();
$resultado_libros = $sql_libros->fetchAll();
foreach ($resultado_libros as $row) {
fputcsv($exit, array($row["id"],
$row["title"],
$row["author"]));
}
fclose($exit);
?>