--- a/exportData.csv.php +++ b/exportData.csv.php @@ -1,1 +1,30 @@ +<?php +include_once("./lib/common.inc.php"); + +// source: http://stackoverflow.com/questions/81934/easy-way-to-export-a-sql-table-without-access-to-the-server-or-phpmyadmin#81951 +$result = mysql_query(' +SELECT CNID,contractnotice.agencyName,agency.abn as agencyABN,publishDate,contractStart,contractEnd,value,description,procurementMethod,category,categoryUNSPSC +,supplierABN,supplierName,supplierCity,supplierPostcode,supplierCountry,contactPostcode, +IF(supplierABN != "",supplierABN,supplierName) as supplierID, +concat("https://www.tenders.gov.au/?event=public.advancedsearch.keyword&keyword=CN",CNID) as sourceURL FROM `contractnotice` join agency on contractnotice.agencyName=agency.agencyName where childCN = 0'); +if (!$result) die('Couldn\'t fetch records'); +$num_fields = mysql_num_fields($result); +$headers = array(); +for ($i = 0; $i < $num_fields; $i++) { + $headers[] = mysql_field_name($result , $i); +} +$fp = fopen('php://output', 'w'); +if ($fp && $result) { + header('Content-Type: text/csv'); + header('Content-Disposition: attachment; filename="export.'.date("c").'.csv"'); + header('Pragma: no-cache'); + header('Expires: 0'); + fputcsv($fp, $headers); + while ($row = mysql_fetch_assoc($result)) { + fputcsv($fp, array_values($row)); + } + die; +} +?> +