【www.gdgbn.com--mysql教程】
include_once(dirname(__FILE__)."../../Inc/Conn.php");
include_once(dirname(__FILE__)."../../photo/Inc/function.php");
$Date = date("Y-m-d");
$Filename = $Date."_".date("h_i_s").".csv";
$a = "帐号,邮箱,性别,宝宝出生日期,省份,真实姓名,邮编,手机,地址 rn";
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=".$Filename);
$Sql = "Select * from oy_use";
$Result = mysql_query($Sql) or die(mysql_error());
while($rs = mysql_fetch_array($Result) ){
// if(get_days($rs["m_time"])<= $Table ){
$a.=$rs["User_Name"].",". $rs["User_Mail"].",".($rs["User_Baby_Sex"]?"男":"女").",". $rs["User_Baby_Birth"].",";
$a.="".$rs["sheng"].",". $rs["User_rname"].",".$rs["User_Zip"].",".$rs["User_Hand"].",".$rs["User_Address"]." rn ";
// }
}
echo $a;
function get_days($base){
$Date_1=date("Y-m-d");//格式也可以是:$Date_1="2003-6-25 23:29:14";
$Date_2=substr($base,0,10);
$Date_List_a1=explode("-",$Date_1);
$Date_List_a2=explode("-",$Date_2);
//print_r($Date_List_a2);
$d1=mktime(0,0,0,$Date_List_a1[1],$Date_List_a1[2],$Date_List_a1[0]);
$d2=mktime(0,0,0,$Date_List_a2[1],$Date_List_a2[2],$Date_List_a2[0]);
//echo round(($d1-$d2)/3600/24),"
";
return round(($d1-$d2)/3600/24);
}
?>