PHP jpgraph库的配置及生成统计图表

functiongb2utf8($gb) {

return$gb;

}

<?php

require_once("jpgraph/jpgraph.php");

require_once("jpgraph/jpgraph_line.php");

$data1=array(523,634,371,278,685,587,490,256,398,545,367,577);//第一条曲线的数组

$graph=newGraph(500,300); 

$graph->SetScale("textlin");

$graph->SetShadow();  

$graph->img->SetMargin(60,30,30,70);//设置图像边距

$graph->graph_theme = null;//设置主题为null，否则value->Show(); 无效

$lineplot1=newLinePlot($data1);//创建设置两条曲线对象

$lineplot1->value->SetColor("red");

$lineplot1->value->Show();

$graph->Add($lineplot1);//将曲线放置到图像上

$graph->title->Set("CDN流量图"); //设置图像标题

$graph->xaxis->title->Set("月份");//设置坐标轴名称

$graph->yaxis->title->Set("流 量(Gbits)");

$graph->title->SetMargin(10);

$graph->xaxis->title->SetMargin(10);

$graph->yaxis->title->SetMargin(10);

$graph->title->SetFont(FF_SIMSUN,FS_BOLD);//设置字体

$graph->yaxis->title->SetFont(FF_SIMSUN,FS_BOLD);

$graph->xaxis->title->SetFont(FF_SIMSUN,FS_BOLD); 

$graph->xaxis->SetTickLabels($gDateLocale->GetShortMonth());

$graph->Stroke();//输出图像

?>

<?php

require_once("jpgraph/jpgraph.php");

require_once("jpgraph/jpgraph_bar.php");

$data=array(19,23,34,38,45,67,71,78,85,87,96,145);     

$ydata=array("一","二","三","四","五","六","七","八","九","十","十一","十二");

$graph=newGraph(500,300);//创建新的Graph对象

$graph->SetScale("textlin");//刻度样式

$graph->SetShadow();    //设置阴影

$graph->img->SetMargin(40,30,40,50);//设置边距

$graph->graph_theme = null;//设置主题为null，否则value->Show(); 无效

$barplot=newBarPlot($data);//创建BarPlot对象

$barplot->SetFillColor('blue');//设置颜色

$barplot->value->Show();//设置显示数字

$graph->Add($barplot);//将柱形图添加到图像中

$graph->title->Set("CDN流量图"); 

$graph->xaxis->title->Set("月份");//设置标题和X-Y轴标题

$graph->yaxis->title->Set("流 量(Mbits)");                                   

$graph->title->SetColor("red");

$graph->title->SetMargin(10);

$graph->xaxis->title->SetMargin(5);

$graph->xaxis->SetTickLabels($ydata);

$graph->title->SetFont(FF_SIMSUN,FS_BOLD);//设置字体

$graph->yaxis->title->SetFont(FF_SIMSUN,FS_BOLD);

$graph->xaxis->title->SetFont(FF_SIMSUN,FS_BOLD);

$graph->xaxis->SetFont(FF_SIMSUN,FS_BOLD);

$graph->Stroke();

?>

<?php

require_once("jpgraph/jpgraph.php");

require_once("jpgraph/jpgraph_pie.php");

require_once("jpgraph/jpgraph_pie3d.php");

$data=array(19,23,34,38,45,67,71,78,85,87,90,96);

$graph=newPieGraph(550,500);

$graph->SetShadow();

$graph->title->Set("CDN流量比例");

$graph->title->SetFont(FF_SIMSUN,FS_BOLD);

$pieplot=newPiePlot3D($data);//创建PiePlot3D对象

$pieplot->SetCenter(0.4, 0.5);//设置饼图中心的位置

$pieplot->SetLegends($gDateLocale->GetShortMonth());//设置图例

$graph->Add($pieplot);

$graph->Stroke();

?>

$path="/wamp/www/xiong/hadf";

    if(is_dir($path)){

      echo"存在";

    }else{

      mkdir($path, 0777, true);

      echo"chuangji";

    }

    require_once"./PHPExcel.php";

    $filePath="./1233.xlsx";

    $PHPReader=newPHPExcel_Reader_Excel2007();

          if(!$PHPReader->canRead($filePath)) {

            $PHPReader=newPHPExcel_Reader_Excel5();

            if(!$PHPReader->canRead($filePath)) {

              echo'no Excel'

              exit;

            }

          }

    $PHPExcel=$PHPReader->load($filePath);

          /**读取excel文件中的第一个工作表*/

          $currentSheet=$PHPExcel->getSheet(0);

          /**取得最大的列号*/

          $allColumn=$currentSheet->getHighestColumn();

          // echo $allColumn;exit;

          /**取得一共有多少行*/

          $allRow=$currentSheet->getHighestRow();

          /**从第二行开始输出，因为excel表中第一行为列名*/

          $val=''

          for($currentRow= 1;$currentRow<=$allRow;$currentRow++) {

          /**从第A列开始输出*/

            for($currentColumn='A'$currentColumn<=$allColumn;$currentColumn++) {

              $val.=$currentSheet->getCellByColumnAndRow(ord($currentColumn)  - 65,$currentRow);//->getValue();/**ord()将字符转为十进制数*/

              $val.="&%|%&";

              /**如果输出汉字有乱码，则需将输出内容用iconv函数进行编码转换，如下将GBK编码转为UTF-8编码输出*/

              //$val .= iconv('GBK','UTF-8', $val);

            }

            $val.="\n";

          }$member_info_arr=explode("\n",$val);

          unset($member_info_arr[count($member_info_arr) - 1]);

          $present_time=date("Y-m-d H:i:s");

          if(count($member_info_arr) <= 0) {

            sys_msg_json(0,"会员信息文件中无数据，请添加");

          }

          unset($member_info_arr[0]);

          // var_dump($member_info_arr);exit;

          foreach($member_info_arras$key=>$val) {

            $arr[$key] =explode("&%|%&",$val);

          }

          // var_dump($arr);exit;

          foreach($arras$key=>$val) {

            unset($arr[$key][2]);

          }

          var_dump($arr);

functionfile_upload($ftpIp,$ftpUser,$ftpPwd,$path,$fileSavePath){

  $curlobj= curl_init();//初始化

  //传入ftp的目标文件，如'ftp://192.168.3.1/test/1.jpg'

  curl_setopt($curlobj,CURLOPT_URL,"ftp://".$ftpIp."/".$path);

  curl_setopt($curlobj,CURLOPT_HEADER,0);//不输出header

  curl_setopt($curlobj,CURLOPT_RETURNTRANSFER,0);

  //time out after 300s

  curl_setopt($curlobj,CURLOPT_TIMEOUT,2000);//超时时间

  //通过这个函数设置ftp的用户名和密码,没设置就不需要!

  curl_setopt($curlobj,CURLOPT_USERPWD,$ftpUser.':'.$ftpPwd);

  $outfile=fopen($fileSavePath,'w+');//保存到本地文件的文件名

  curl_setopt($curlobj,CURLOPT_FILE,$outfile);

  $rtn= curl_exec($curlobj);

  if(curl_errno($curlobj)){

    writeLog('Curl error: '. curl_error($curlobj));

  }

  fclose($outfile);

  curl_close($curlobj);

   if($rtn== 1){

    returntrue;

   }else{

    unlink($fileSavePath);//如果下载失败，但是本地open了这个文件，所以要删除

    returnfalse;

   }

}

<?php

include‘./Classes/PHPExcel/IOFactory.php'

$inputFileName= ‘./test.xls'

date_default_timezone_set(‘PRC');

// 读取excel文件

try{

$inputFileType= PHPExcel_IOFactory::identify($inputFileName);

$objReader= PHPExcel_IOFactory::createReader($inputFileType);

$objPHPExcel=$objReader->load($inputFileName);

}catch(Exception$e) {

die(‘加载文件发生错误：”‘.pathinfo($inputFileName,PATHINFO_BASENAME).'”: ‘.$e->getMessage());

}

// 确定要读取的sheet，什么是sheet，看excel的右下角，真的不懂去百度吧

$sheet=$objPHPExcel->getSheet(0);

$highestRow=$sheet->getHighestRow();

$highestColumn=$sheet->getHighestColumn();

// 获取一行的数据

for($row= 1;$row<=$highestRow;$row++){

// Read a row of data into an array

$rowData=$sheet->rangeToArray(‘A' . $row . ‘:'.$highestColumn.$row, NULL, TRUE, FALSE);

//这里得到的rowData都是一行的数据，得到数据后自行处理，我们这里只打出来看看效果

var_dump($rowData);

echo“
”;

}

<?php

/** Error reporting */

error_reporting(E_ALL);

ini_set('display_errors', TRUE);

ini_set('display_startup_errors', TRUE);

date_default_timezone_set('PRC');

/** 引入PHPExcel */

require_oncedirname(__FILE__) .'./Classes/PHPExcel.php'

// 创建Excel文件对象

$objPHPExcel=newPHPExcel();

// 设置文档信息，这个文档信息windows系统可以右键文件属性查看

$objPHPExcel->getProperties()->setCreator("作者简庆旺")

 ->setLastModifiedBy("最后更改者")

 ->setTitle("文档标题")

 ->setSubject("文档主题")

 ->setDescription("文档的描述信息")

 ->setKeywords("设置文档关键词")

 ->setCategory("设置文档的分类");

//根据excel坐标，添加数据

$objPHPExcel->setActiveSheetIndex(0)

 ->setCellValue('A1','你好')

 ->setCellValue('B2','世界')

 ->setCellValue('C1','你好')

 ->setCellValue('D2','世界');

// 混杂各种符号, 编码为UTF-8

$objPHPExcel->setActiveSheetIndex(0)

 ->setCellValue('A4','Miscellaneous glyphs')

 ->setCellValue('A5','éàèùâêîôûëïüÿäöüç');

$objPHPExcel->getActiveSheet()->setCellValue('A8',"你好世界");

$objPHPExcel->getActiveSheet()->getRowDimension(8)->setRowHeight(-1);

$objPHPExcel->getActiveSheet()->getStyle('A8')->getAlignment()->setWrapText(true);

$value="-ValueA\n-Value B\n-Value C";

$objPHPExcel->getActiveSheet()->setCellValue('A10',$value);

$objPHPExcel->getActiveSheet()->getRowDimension(10)->setRowHeight(-1);

$objPHPExcel->getActiveSheet()->getStyle('A10')->getAlignment()->setWrapText(true);

$objPHPExcel->getActiveSheet()->getStyle('A10')->setQuotePrefix(true);

// 重命名工作sheet

$objPHPExcel->getActiveSheet()->setTitle('第一个sheet');

// 设置第一个sheet为工作的sheet

$objPHPExcel->setActiveSheetIndex(0);

// 保存Excel 2007格式文件，保存路径为当前路径，名字为export.xlsx

$objWriter= PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

$objWriter->save('export.xlsx');

// 保存Excel 95格式文件，，保存路径为当前路径，

$objWriter= PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');

$objWriter->save('export.xls');