php小代碼---從慢記錄檔分離出日誌記錄並存放於excel檔案中_PHP教程

php小代碼---從慢記錄檔分離出日誌記錄並存放於excel檔案中

 getProperties()->setTitle("export")->setDescription("none");$objPHPExcel->setActiveSheetIndex(0);$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15);$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(15);$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(15); $titlearray = array(    "主機資訊" => 'User@Host', "查詢時間" => 'Query_time', "鎖表時間" => 'Lock_time'    , "查詢時檢查行數" => 'Rows_examined', "讀取行數" => 'Rows_read', "時間" => 'timestamp',    "發送位元組數" => 'Bytes_sent', "執行的sql" => 'sql'); $col = 0;foreach ($titlearray as $key => $title) {    $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $key);    $col++;} $j = 2;foreach ($slowData as $key => $sd) {    $col = 0;    foreach ($titlearray as $key2 => $title) {        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $j, $sd[$title]);        $col++;    }    $j++;} $objPHPExcel->setActiveSheetIndex(0);$objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5');// Sending headers to force the user to download the fileheader('Content-Type: application/vnd.ms-excel');header('Content-Disposition: attachment;filename="slowsql.xls"');header('Cache-Control: max-age=0');$objWriter->save('php://output');

http://www.bkjia.com/PHPjc/1055412.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/1055412.htmlTechArticlephp小代碼---從慢記錄檔分離出日誌記錄並存放於excel檔案中 ?php header(Content-type:text/html; charset=UTF-8);ini_set(max_execution_time, 10000);ini_set(memor...

