create an ascii text file with php

[irandoct]

Hi,
I'm trying to output a text file using php. how may i set this file as ascii?
this is my code:

function export_listnm(){
  global $conn, $Language, $Security;
  $sdate = preg_replace('/-|:/', null, $_GET['sdate']);
  $edate = preg_replace('/-|:/', null, $_GET['edate']);
  $MedicalCouncilNumber = strip_tags(ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'MedicalCouncilNumber'"));
  $NIDCode = strip_tags(ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'NIDCode'"));
  $MainStaffName = strip_tags(ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'MainStaffName'"));
  $MainStaffLastName = strip_tags(ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'MainStaffLastName'"));
  $tedadnoskheh = ew_ExecuteScalar("SELECT COUNT(TreatmentID) FROM  treatmenthistory WHERE ReportDate >= '".$_GET['sdate']."' AND ReportDate <= '".$_GET['edate']."' AND InsuranceID = '".$_GET['insurance']."'");
  $sitename = ew_ExecuteScalar("SELECT ConfigValue FROM configs WHERE ConfigKey = 'SiteName'");
  $insurance = ew_ExecuteScalar("SELECT InsuranceName FROM insurances WHERE InsuranceID = '".$_GET['insurance']."'");
  $inscode = ew_ExecuteScalar("SELECT InsCode FROM insurances WHERE InsuranceID = '".$_GET['insurance']."'");
  $cliniccode = ew_ExecuteScalar("SELECT ClinicCode FROM insurances WHERE InsuranceID = '".$_GET['insurance']."'");
  $Percentage = ew_ExecuteScalar("SELECT Percentage FROM insurances WHERE InsuranceID = '".$_GET['insurance']."'");
  $conn->Execute("SET @row_num = 0;");
  $sSqlWrk = "SELECT @row_num := @row_num + 1 as row_number, treatmenthistory.*, referrers.RefName, referrers.MedicalCouncil, patients.FullName, patients.gender FROM treatmenthistory join referrers on treatmenthistory.RefID = referrers.RefID join patients on treatmenthistory.PatientID = patients.PatientID WHERE treatmenthistory.ReportDate >= '".$_GET['sdate']."' AND treatmenthistory.ReportDate <= '".$_GET['edate']."' AND InsuranceID = '".$_GET['insurance']."' ORDER BY treatmenthistory.ReceptionDate ASC";
  $theres = $conn->Execute($sSqlWrk);
  if (!file_exists('insurancereports')) {
	mkdir('insurancereports', 0777, true);
  }
  $f = fopen("insurancereports/insurance.txt", "a");
  fwrite($f, "<Y>\n");
  fwrite($f, "<HR>\n");
  fwrite($f, "<DC>".$cliniccode."</DC>\n");
  fwrite($f, "<DN>".$sitename."</DN>\n");
  fwrite($f, "<CR>kimia System 09133999236</CR>\n");
  fwrite($f, "<RC>".$tedadnoskheh."</RC>\n");
  fwrite($f, "<FD>".$sdate."</FD>\n");
  fwrite($f, "<TD>".$edate."</TD>\n");
  fwrite($f, "<MC>".$MedicalCouncilNumber."</MC>\n");
  fwrite($f, "<NM>".$NIDCode."</NM>\n");
  fwrite($f, "<AN>".$MainStaffName."</AN>\n");
  fwrite($f, "<AF>".$MainStaffLastName."</AF>\n");
  fwrite($f, "</HR>\n");
  while (!$theres->EOF) {
  $row = ew_ExecuteRow("SELECT SUM(ExPriceIns) AS ExPriceIns FROM treatmentdetails  WHERE TreatmentID = '".$theres->fields('TreatmentID')."'");
  $fullprice = $row["ExPriceIns"];
  $patientprice = $fullprice * $Percentage /100;
  $insprice = $fullprice - $patientprice;
  if ($theres->fields('gender') == "F"){
  $gender = "0";
  }else if ($theres->fields('gender') == "M"){
  $gender = "1";
  }
  $orderdate = preg_replace('/-|:/', null, $theres->fields('InsOrderDate'));
  $insuranceenddate = preg_replace('/-|:/', null, $theres->fields('InsEndDate'));
  $firstsession = ew_ExecuteScalar("SELECT VisitDay FROM appointments WHERE TreatmentID = '".$theres->fields('TreatmentID')."' AND IsCanceled = 'N' ORDER BY VisitDay ASC LIMIT 1");
  $firstsession = preg_replace('/-|:/', null, $firstsession);
  $lastsession = ew_ExecuteScalar("SELECT VisitDay FROM appointments WHERE TreatmentID = '".$theres->fields('TreatmentID')."' AND IsCanceled = 'N' ORDER BY VisitDay DESC LIMIT 1");
  $lastsession = preg_replace('/-|:/', null, $lastsession);
  fwrite($f, "<X>\n");
  fwrite($f, "<PH>\n");
  fwrite($f, "<SQ>".$theres->fields('row_number')."</SQ><ND>".$orderdate."</ND><RD>".$firstsession."</RD><LD>".$lastsession."</LD><VD>".$insuranceenddate."</VD><PT>".$inscode."</PT><SN>".$theres->fields('InsuranceNumber')."</SN><GR>".$gender."</GR><RN>".$theres->fields('InsPageNumber')."</RN><PG>1</PG><PC>".$theres->fields('MedicalCouncil')."</PC><DD>18</DD><PP>".$fullprice."</PP><IS>".$insprice."</IS><PS>".$patientprice."</PS>\n");
  fwrite($f, "</PH>\n");
  $sSqlWrk2 = "SELECT treatmentdetails.*, products.ProductCode FROM treatmentdetails join products on treatmentdetails.ProductID = products.ProductID WHERE treatmentdetails.TreatmentID = '".$theres->fields('TreatmentID')."' AND treatmentdetails.ShowInList = 'Y'";
  $theres2 = $conn->Execute($sSqlWrk2);
  while (!$theres2->EOF) {
  $sahmbimeh = $theres2->fields('ExPriceIns') * $Percentage / 100;
  $sahmbimar  = $theres2->fields('ExPriceIns') - $sahmbimeh;
  fwrite($f, "<MH><MG>".$theres2->fields('ProductCode')."</MG><OZ></OZ><NG>".$theres2->fields('Quantity')."</NG><NA>".$theres2->fields('BodyAreaIns')."</NA><FC>".$MedicalCouncilNumber."</FC><TK>1</TK><MD>".$theres2->fields('Quantity')."</MD><MR>".$theres2->fields('Quantity')."</MR><MP>".$theres2->fields('ExPriceIns')."</MP><MI>".$sahmbimeh."</MI><MS>".$sahmbimar."</MS></MH>\n");
  $theres2->MoveNext();
}
$theres2->Close();
  fwrite($f, "<BY>\n");
  fwrite($f, "</BY>\n");
  fwrite($f, "</X>\n");
  $theres->MoveNext();
}
$theres->Close();
fwrite($f, "</Y>\n");
fclose($f);
echo "<br><br>";
echo "<a href=insurancereports/insurance.txt>Download</a>";
echo "<br><br><br><br>";
} 

please help me save the text file as ascii!

Thank you 

Mansour

 

[ginerjm]

Have you read anything in the php manual that sounds like it might help?