php小代码---从慢日志文件分离出日志记录并存放于excel文件中_PHP教程
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了php小代码---从慢日志文件分离出日志记录并存放于excel文件中_PHP教程,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3458字,纯文字阅读大概需要5分钟。
内容图文
php小代码---从慢日志文件分离出日志记录并存放于excel文件中
<?php header("Content-type:text/html; charset=UTF-8"); ini_set('max_execution_time', '10000'); ini_set('memory_limit','1024M'); function dealslowContent($content) { $data = array(); preg_match('/#\sUser@Host:(.+)\n#\sThread_id/', $content, $match); $data['User@Host'] = $match[1]; preg_match('/#\sQuery_time:\s(.+)\sLock_time/', $content, $match); $data['Query_time'] = $match[1]; preg_match('/\sLock_time:\s(.+)\sRows_sent/', $content, $match); $data['Lock_time'] = $match[1]; preg_match('/\sRows_examined:\s(.+)\sRows_affected/', $content, $match); $data['Rows_examined'] = $match[1]; preg_match('/\sRows_read:\s(.+)\n#\sBytes_sent/', $content, $match); $data['Rows_read'] = $match[1]; preg_match('/timestamp=(\d+);\s/', $content, $match); $data['timestamp'] = $match[1]; preg_match('/#\sBytes_sent:\s(.+)\sSET/', $content, $match); $data['Bytes_sent'] = $match[1]; $sqlPos = strpos($content, ';'); $data['sql'] = substr($content, $sqlPos + 1, strlen($content)); return $data; } $slowData = array(); $handle = fopen('mysql-slow.log.2', 'r'); $content = ''; $middlerCha = ''; $identifier = '# User@Host'; $identifierLength = strlen($identifier); while (!feof($handle)) { $oneTakeCha = fread($handle, 1); if ($oneTakeCha === '#') { $middlerCha = '#' . fread($handle, $identifierLength - 1); if ($middlerCha === $identifier) { if ($content != '') { $slowData[] = dealslowContent($content); $content = $middlerCha; } else { $content = $middlerCha; } } else { $content.=$middlerCha; } } else { $content.= $oneTakeCha; } } $slowData[] = dealslowContent($content); fclose($handle); include 'libraries/PHPExcel.php'; include 'libraries/PHPExcel/IOFactory.php'; $objPHPExcel = new PHPExcel(); $objPHPExcel->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 file header('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...
内容总结
以上是互联网集市为您收集整理的php小代码---从慢日志文件分离出日志记录并存放于excel文件中_PHP教程全部内容,希望文章能够帮你解决php小代码---从慢日志文件分离出日志记录并存放于excel文件中_PHP教程所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。