PHP MYSQL
(quick guide & example)
DUMMY USER TABLE id | BIGINT | PRIMARY KEY email | VARCHAR name | VARCHAR
DUMMY USERS 1| job@doe.com | Job Doe 2 | jon@doe.com | Jon Doe 3 | joy@doe.com | Joy Doe
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);
HTTP "SAVE AS CSV" HEADERS header("Content-Type: application/ octet-stream"); header("Content-Transfer-Encoding: Binary"); header("Content-disposition: attachment; filename=\"demo.csv\"");
GET USERS & OUTPUT $out = fopen("php://output", "w"); $stmt = $pdo->prepare("SELECT * FROM `users`"); $stmt->execute(); while ($row = $stmt->fetch()) { fputcsv($out, $row); } fclose($out);