internet explorer error-while saving data in excel
Posted: Mon Dec 12, 2011 5:18 am
hi,
I am generating excel as per below code.
I am using google chrome as internet explorer and I am getting accurate result(excel for driver name given in html form).
But when i am using internet explorer, i am getting always previous excel.
I need to use internet explorer on client pc.
Kindly tell me how to fix issue in case of internet explorer.
rgds,
pc
I am generating excel as per below code.
Code: Select all
<?PHP
$Driver_Name=$_POST[`Driver_Name`];
$now_date=date('d-m-Y');
$fp = fopen('CTT_Driver_Dump.xls', "w");
$header ="
<table align='center' bgcolor='#666666' width='1000px' >
<tr bgcolor='green'>
<td colspan=2>Date : $now_date</td>
<td colspan=16 align='center'><font size=+3><strong> CTT Driver Dump</strong></font> </td>
</tr>
<tr bgcolor='#808080'>
<th>Status</th>
<th>Driver Name</th>
<th>Driver DL NO</th>
<th>Driver Mobile</th>
<th>Driver Address</th>
<th>CAB Number</th>
<th>CAB Type</th>
<th>CAB Capcity</th>
<th>Vendor Id</th>
<th>Route No</th>
<th>Start Date</th>
<th>End Date</th>
<th>Total CAB Route</th>
<th>Remarks</th>
</tr> ";
fwrite($fp, $header);
$sql = "select `Driver_Name`, `Driver_DL_NO`, `Driver_Mobile_No`, `Driver_Address`,`Cab_Number`,
`Cab_Type`, `Cab_Status`, `Tot_Cab_route`, `Cab_Capcity`,DATE_FORMAT(`Cab_Strt_Dt`,'%d-%m-%Y')Cab_Strt_Dt,
DATE_FORMAT(`Cab_End_Dt`,'%d-%m-%Y') `Cab_End_Dt`, `Route_Dtl`, `Vendor_Id`, `Vendor_Name`, `Vendor_Mobile`,`Vendor_Address`,
`Remarks`, `Created_By`, `Created_On`, `Updated_By`,
`Updated_On`,`Timestmp`
from ctt_cab_detail
where Driver_Name = ‘$ Driver_Name’
order by Driver_Name asc,Timestmp desc ";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$data="
<tr bgcolor='#9C9C4E' >
<td>$row[Cab_Status]</td>
<td>$row[Driver_Name]</td>
<td>$row[Driver_DL_NO]</td>
<td>$row[Driver_Mobile_No]</td>
<td>$row[Driver_Address]</td>
<td>$row[Cab_Number]</td>
<td>$row[Cab_Type]</td>
<td>$row[Cab_Capcity]</td>
<td>$row[Vendor_Id]</td>
<td>$row[Route_Dtl]</td>
<td>$row[Cab_Strt_Dt]</td>
<td>$row[Cab_End_Dt]</td>
<td>$row[Tot_Cab_route]</td>
<td>$row[Remarks]</td>
</tr> ";
fwrite($fp, $data);
}
fclose($fp);
}
But when i am using internet explorer, i am getting always previous excel.
I need to use internet explorer on client pc.
Kindly tell me how to fix issue in case of internet explorer.
rgds,
pc