$mysql_server_name =
"*.*.*.*"
;
$mysql_username=
"user"
;
$mysql_password=
"dbpasswd"
;
$mysql_database=
"test"
;
$conn = mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database);
if
($conn->connect_error) {
die(
"连接失败: "
. $conn->connect_error);
}
$conn->query(
"set names utf8"
);
$sql =
"SELECT * FROM testdata WHERE inserttime > '2019-09-13' AND inserttime <'2019-0916'"
;
$result = $conn->query($sql);
$data =array();
while
($row = $result->fetch_assoc())
{
$data[] = $row;
}
require_once(&
#39;./PHPExcel/PHPExcel.php');
$objPHPExcel =
new
PHPExcel();
$objPHPExcel->getProperties()->setCreator(
"wnn"
)
->setLastModifiedBy(
"wnn"
)
->setTitle(
"原创文章链接"
);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue(&
#39;A1','文章ID')
->setCellValue(&
#39;B1','标题')
->setCellValue(&
#39;C1','链接')
->setCellValue(&
#39;D1','作者')
->setCellValue(&
#39;E1','发布时间');
$objPHPExcel->getActiveSheet()->getColumnDimension(&
#39;A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension(&
#39;B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension(&
#39;C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension(&
#39;D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension(&
#39;E')->setAutoSize(true);
$i=2;
foreach ($data as $k=>$v){
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue(&
#39;A'.$i,$v['id'])
->setCellValue(&
#39;B'.$i,$v['title'])
->setCellValue(&
#39;C'.$i,$v['arcurl'])
->setCellValue(&
#39;D'.$i,$v['writer'])
->setCellValue(&
#39;E'.$i,$v['senddate']);
$objPHPExcel->getActiveSheet()->getCell(&
#39;C'.$i)->getHyperlink()->setUrl($v['arcurl']);
$i++;
}
$length = count($data)+1;
$objPHPExcel->getActiveSheet()->getStyle( &
#39;C2:C'.$length)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLUE);
$filename=urlencode(&
#39;原创作品').'_'.date('YmdHis');
ob_end_clean();
header(&
#39;Content-Type: application/vnd.ms-excel');
header(&
#39;Content-Disposition: attachment;filename="'.$filename.'.xls"');
header(&
#39;Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, &
#39;Excel5');
$objWriter->save(&
#39;php://output');