PHP 导出mysql 所有数据或根据时间段导出为CSV

<?php
//date_default_timezone_set ("PRC");//设置时区
//set_time_limit(0);
//header('Access-Control-Allow-Origin:*');//允许所有来源访问
//header('Access-Control-Allow-Method:POST,GET');//允许访问的方式
include_once "csv.php"; //到这里 http://www.180it.com/archives/1832/
include_once "function.php";
 
$token=make_safe($_GET['token']);
$sdate=make_safe($_GET['sdate']);
$edate=make_safe($_GET['edate']);
$all=make_safe($_GET['all']);

$systoken=md5(date("Y-m-d",time()));


if ($systoken==$token)
{
    

$db_config = [
    'host' => '127.0.0.1',
    'user' => 'data_xxx_com',
    'password' => '0000000',
    'dbname' => 'data_xxx_com',
    'port' => 3306,
    'charset' => 'utf8'
];
$csv_header = ["ID","标题","价格","销量","日期","图片","链接"];
$format = ["order_status" => function($str){
    return $str == 1 ? "完成" : "取消";
}];

if ($all){$sql = 'select num_iid,title,price,sales,cdate,pic_url,detail_url from info';}
if ($sdate){
    $sql = 'select num_iid,title,price,sales,cdate,pic_url,detail_url from info WHERE cdate BETWEEN "'.$sdate.'" AND "'.$edate.'" ORDER BY cdate ASC';
}

$obj = \bigcsv\BigCSV::getinstance($db_config);
$obj->download($sql, $csv_header, $format);
}
else {
  echo 'token 错误';
}

赏 支付宝打赏 微信打赏

如果文章或资源对您有帮助，欢迎打赏作者。一路走来，感谢有您！