if ( $_POST['action'] == '匯出'){
header("Content-type: application/vnd.ms-excel"); //文件內容為excel格式
header("Content-Disposition: attachment; filename=$file;"); //將PHP轉成下載的檔案指定名稱與副檔名.xls
}
if ($_POST["course_Sdate"] ==""){
$str_num="select count(*) from present";
$result_num=mysql_query($str_num,$conn);
list($num)=mysql_fetch_row($result_num);
$str1="SELECT `book_name` , `presenter` , `present_date` FROM `present` ORDER BY `present`.`present_date` DESC";
$result=mysql_query($str1,$conn);
}
else
{
//結束日期固定加1天
$course_Edate = date("Y-m-d",strtotime("$course_Edate+1 day"));
$str_num="select count(*) from present where present_date BETWEEN '$course_Sdate' AND '$course_Edate'";
$result_num=mysql_query($str_num,$conn);
list($num)=mysql_fetch_row($result_num);
$str1="SELECT `book_name` , `presenter` , `present_date` FROM `present` WHERE present_date BETWEEN '$course_Sdate' AND '$course_Edate' ORDER BY `present`.`present_date` DESC";
$result=mysql_query($str1,$conn);
}
?>