I am trying to create a download file. The download works fine, but when I try and pass dates to the select statement by posting from a form, the download is empty expect for the column headings. (no data)
I have tried various formating of the date(mm-dd-yyyy, yyyy-mm-dd, mm/dd/yyyy...etc. None of them work.
If I plug the date directly into the select statement it returns the data as expected
The two fields being passed are in the form frmdates, and are labeled txtStartDate and txtEndDate
Any ideas?
<?
$filename = "issued_permits.csv";
header('Content-type: application/' . (($format == 'csv') ? 'octet-stream' : 'vnd.ms-excel'));
header('Content-Disposition: attachment; filename="' . $filename . ' "');
header("Content-Transfer-Encoding: binary");
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
?>
<?php
$hostname_tidemark = "10.1.0.65";
$database_tidemark = "tidemark";
$username_tidemark = "mason_web";
$password_tidemark = "adidas999";
$tidemark = mysql_pconnect($hostname_tidemark, $username_tidemark, $password_tidemark) or trigger_error(mysql_error(),E_USER_ERROR);
if (isset($HTTP_POST_VARS['txtStartDate'])) {
$startdate = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['txtStartDate'] : addslashes($HTTP_POST_VARS['txtStartDate']);
}
if (isset($HTTP_POST_VARS['txtEndDate'])) {
$enddate = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['txtEndDate'] : addslashes($HTTP_POST_VARS['txtEndDate']);
}
mysql_select_db($database_tidemark, $tidemark);
$query_export_file = "SELECT casemain.csm_caseno, prc_parcel_no, csm_description, csm_issued_date, csm_name_last , csm_name_first,vw_case_tot_val.totl_val, case_address.csm_st_nmbr, case_address.csm_st_pfx, case_address.csm_st_name, case_address.csm_st_unit FROM casemain left outer join vw_case_tot_val on casemain.csm_caseno = vw_case_tot_val.csm_caseno left outer join case_address on casemain.csm_caseno = case_address.csm_caseno WHERE case_type = 'BLD' and csm_issued_date BETWEEN '$startdate' AND '$enddate' order by csm_issued_date";
$export_file = mysql_query($query_export_file, $tidemark) or die(mysql_error());
$row_export_file = mysql_fetch_assoc($export_file);
$totalRows_export_file = mysql_num_rows($export_file);
$fp = fopen("issued_permits.csv", "w"); #open for write
print "Case Number"."," . "Parcel Number".","."Site Address".","."Applicant".","."Description".","."Issued Date".","."Total Value"."\n";
while($row_export_file = mysql_fetch_assoc($export_file))
{
print '"' . $row_export_file['csm_caseno'] . '",' .'"' . $row_export_file['prc_parcel_no'] . '",' .'"' . $row_export_file['csm_st_nmbr'] . ' ' . $row_export_file['csm_st_pfx'] .' ' . $row_export_file['csm_st_name'] . ' ' . $row_export_file['csm_st_unit'] . '",' .'"' . $row_export_file['csm_name_last'] .', '. $row_export_file['csm_name_first'] . '",' .'"' . $row_export_file['csm_description'] . '",' .'"' . $row_export_file['csm_issued_date'] . '",' .'"' . $row_export_file['totl_val'] . '"' ."\n";
}
fclose ($fp);
?>
