<?php

$link = mysqli_connect("10.4.105.141", "root", "yb9738z", "fullerton");

if(!link)
{
die("Connection Failed!".mysqli_connect_error());
}

$query	= "SELECT id,lan,client FROM records";
$sql = mysqli_query($link, $query);
$sqlResult = mysqli_fetch_all($sql,MYSQLI_ASSOC);

$reportArr = array();

foreach($sqlResult as $res)
{
	$reportArr[] = $res;
}

header('Content-Type: application/csv');
header('Content-Disposition: attachment; filename="record_empid_'.date('d_m').'.csv";');

$headers = ['id','lan','client'];

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

fputcsv($f, $headers);

foreach($reportArr as $arr)
{
	fputcsv($f, $arr);
}

mysqli_close($link);

?>