<?php include 'protect.php'; ?>
<?php
// export_farm_names.php

session_start();
include_once("db.php");

// Set headers to force download as CSV
header('Content-Type: text/csv');
header('Content-Disposition: attachment;filename=FarmSystemCustomers.csv');

// Open output stream
$output = fopen('php://output', 'w');

// Write CSV header
fputcsv($output, ['FarmSystemName']);

// Query first and last names
$sql = "SELECT first_name, last_name FROM customers ORDER BY last_name, first_name";
$result = mysqli_query($conn, $sql);

// Output full name for each customer
while ($row = mysqli_fetch_assoc($result)) {
    $fullName = trim($row['first_name'] . ' ' . $row['last_name']);
    fputcsv($output, [$fullName]);
}

fclose($output);
exit;
?>