'local_schedules',
));
// if the user has supplied "as_csv" in query string
if ( $_REQUEST['as_csv']) {
// specify fields to output
$fields = array('age_group', 'home_team', 'away_team', 'field', 'date');
$filename = "schedule_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
// output csv header row
print(join(',', $fields) . "\n");
// loop over records, outputting a row for each
foreach ($records as $record) {
$row = array();
foreach ($fields as $field) {
$value = $record[$field];
// if this value contains a special character, quote and escape it
if ( preg_match('/[," \t\n]/', $value) ) {
$value = '"' . preg_replace('/"/', '""', $value) . '"';
}
array_push($row, $value);
}
echo(join(',', $row) . "\n");
}
// exit -- we are finished with the page
exit;
}
?>
Schedules
|
|
|
|
Age Group |
Date |
Time |
Home Team |
Away Team |
Field |
|
|
|
|
|
|
Download these results in CSV format