<?php
/*******EDIT LINES 3-8*******/
$DB_Server="192.168.66.209";//MySQL Server
$DB_Username="snh48";//MySQL Username
$DB_Password="akb48@mina";//MySQL Password
$DB_DBName="snh48";//MySQL Database Name
//var_dump($_GET);die;
if(!$_GET)exit("parameter needed");
if($_GET['a']=='weekly'){?
$DB_TBLName="eighth_join_girls";//MySQL Table Name
$filename="daily_sum_".date('y-m-d');//File Name
/*******YOU DO NOT NEED TO EDIT ANYTHING BELOW THIS LINE*******/
//create MySQL connection
$sql="Selectcount(*) as daily_sum,date(submit_time) as time? from$DB_TBLNamegroup by time";
$Connect= @mysql_connect($DB_Server, $DB_Username, $DB_Password)or die("Couldn't connect to MySQL:
".mysql_error()."
".mysql_errno());
//select database
$Db= @mysql_select_db($DB_DBName, $Connect)or die("Couldn't select database:
".mysql_error()."
".mysql_errno());
//execute query
$result= @mysql_query($sql,$Connect)or die("Couldn't execute query:
".mysql_error()."
".mysql_errno());
$file_ending="xls";
//header info for browser
header("Content-Type: application/xls");//設(shè)置請(qǐng)求頭部崎溃，下載xls文件袁翁；/Content-Disposition: attachment設(shè)置文件以附件形式下載
header("Content-Disposition: attachment; filename=$filename.xls");
header("Pragma: no-cache");
header("Expires: 0");
/*******Start of Formatting for Excel*******/
//define separator (defines columns in excel & tabs in word)
$sep="\t";//tabbed character
//start of printing column names as names of MySQL fields
for($i=0; $i
echomysql_field_name($result,$i)."\t";
}
print("\n");
//end of printing column names
//start while loop to get data
while($row=mysql_fetch_row($result))
{
$schema_insert="";
for($j=0; $j
{
if(!isset($row[$j]))
$schema_insert.="NULL".$sep;
elseif($row[$j]!="")
$schema_insert.="$row[$j]".$sep;
else
$schema_insert.="".$sep;
}
$schema_insert=str_replace($sep."$","", $schema_insert);
$schema_insert=preg_replace("/\r\n|\n\r|\n|\r/"," ", $schema_insert);
$schema_insert.="\t";
print(trim($schema_insert));
print"\n";
}
}
