1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / gceburdwan / public_html / Online_Admission /
Filename : exceldownload.php
back
<?php 

// $link = mysql_connect("localhost", "kaln_for_general", "zbpi0dipk0tt") or die("Couldn't make connection.");
// $db = mysql_select_db("kaln_general_admission", $link) or die("Couldn't select database");

include("link_to_database.php");

$setCounter = 0;

$setExcelName = "download_excal_file";

$setSql = "select RegistrationNo,std_name,std_mobile from tbl_Student_2k22 where std_category='ST' AND Applied_As='FRESHER' AND bank_transtions_code!='' AND ifSecondList=1";

$setRec = mysql_query($setSql);

$setCounter = mysql_num_fields($setRec);

for ($i = 0; $i < $setCounter; $i++) {
    $setMainHeader .= mysql_field_name($setRec, $i)."\t";
}

while($rec = mysql_fetch_row($setRec))  {
  $rowLine = '';
  foreach($rec as $value)       {
    if(!isset($value) || $value == "")  {
      $value = "\t";
    }   else  {
//It escape all the special charactor, quotes from the data.
      $value = strip_tags(str_replace('"', '""', $value));
      $value = '"' . $value . '"' . "\t";
    }
    $rowLine .= $value;
  }
  $setData .= trim($rowLine)."\n";
}
  $setData = str_replace("\r", "", $setData);

if ($setData == "") {
  $setData = "\nno matching records found\n";
}

$setCounter = mysql_num_fields($setRec);



//This Header is used to make data download instead of display the data
 header("Content-type: application/octet-stream");

header("Content-Disposition: attachment; filename=".$setExcelName."_Reoprt.xls");

header("Pragma: no-cache");
header("Expires: 0");

//It will print all the Table row as Excel file row with selected column name as header.
echo ucwords($setMainHeader)."\n".$setData."\n";
?>