Cacher is the code snippet organizer for pro developers

$curdate = date("d / m / Y");
header('Content-Type: text/csv; charset=utf-8');
header("Content-Disposition: attachment; filename=leads-csv".$curdate.".csv");

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


$con = mysqli_connect("server", "user", "pass", "db");
$sql = mysqli_query($con,"SELECT * FROM leadz ORDER BY id ASC");

// loop over the rows, outputting them
while ($data = mysqli_fetch_assoc($sql)) {
	$therow = $data['nome'].",".$data['email'].",".$data['telefono'].",".$data['citta'].",".$data['provincia'].", ,".$data['view_num'].",".$data['first_view'].",".$data['first_view_ref'].",".$data['data'].",".$data['pagina'].",".$data['referral'].",".$data['camp_name'].",".$data['camp_source'].",".$data['camp_medium'].",".$data['camp_term'].",".$data['camp_cont'].",".$data['f_camp_ref'].",".$data['f_camp_name'].",".$data['f_camp_source'].",".$data['f_camp_medium'].",".$data['f_camp_term'].",".$data['f_camp_cont'];
fputcsv($output,explode(",",$therow));
}