'dms_home_page',
));
// if the user has supplied "as_csv" in query string
if (@$_REQUEST['as_csv']) {
// specify fields to output
$fields = array('title', 'approval_date', 'course_id', 'competency', 'cca', 'training_establishment');
$filename = "CCA_".date("Y-m-d",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 ($dms_home_pageRecords 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;
}
?>
CCA
CCA Search Results
Download these results in CSV format
Results page '' not found, start over >>.
No records were found!
Return to CCA Report Page