本文實例為大家分享了php實現按天數、星期、月份查詢的搜索框，搜索時候展示數據的統計圖，主要展示圖形的效果，供大家參考，具體內容如下
1.ajax.php
<?php $year = $_GET['y']; if(!isset($_GET['m'])){ $month=1; }else{ $month = $_GET['m']; } $week_arr = getMonthWeekArr($year, $month); echo json_encode($week_arr); die; /** * 獲得系統某月的周數組，第一周不足的需要補足 * * @param int $current_year * @param int $current_month * @return string[][] */function getMonthWeekArr($current_year, $current_month){ //該月第一天 $firstday = strtotime($current_year.'-'.$current_month.'-01'); //該月的第一周有幾天 $firstweekday = (7 - date('N',$firstday) +1); //計算該月第一個周一的時間 $starttime = $firstday-3600*24*(7-$firstweekday); //該月的最后一天 $lastday = strtotime($current_year.'-'.$current_month.'-01'." +1 month -1 day"); //該月的最后一周有幾天 $lastweekday = date('N',$lastday); //該月的最后一個周末的時間 $endtime = $lastday-3600*24*($lastweekday%7); $step = 3600*24*7;//步長值 $week_arr = array(); for ($i=$starttime; $i<$endtime; $i= $i+3600*24*7){ $week_arr[] = array('key'=>date('Y-m-d',$i).'|'.date('Y-m-d',$i+3600*24*6), 'val'=>date('Y-m-d',$i).'~'.date('Y-m-d',$i+3600*24*6)); } return $week_arr;} 2.datehelper.php
<?php //獲得系統年份數組/** * * @return string[] */function getSystemYearArr(){ $year_arr = array('2010'=>'2010','2011'=>'2011','2012'=>'2012','2013'=>'2013','2014'=>'2014','2015'=>'2015','2016'=>'2016','2017'=>'2017','2018'=>'2018','2019'=>'2019','2020'=>'2020'); return $year_arr;} /** * 獲得系統月份數組 * * @return array */function getSystemMonthArr(){ $month_arr = array('1'=>'01','2'=>'02','3'=>'03','4'=>'04','5'=>'05','6'=>'06','7'=>'07','8'=>'08','9'=>'09','10'=>'10','11'=>'11','12'=>'12'); return $month_arr;} /** * 獲得系統周數組 * * @return string[] */function getSystemWeekArr(){ $week_arr = array('1'=>'周一','2'=>'周二','3'=>'周三','4'=>'周四','5'=>'周五','6'=>'周六','7'=>'周日'); return $week_arr;} /** * 獲取某月的最后一天 * * @param int $year * @param int $month * @return number */function getMonthLastDay($year, $month){ $t = mktime(0, 0, 0, $month + 1, 1, $year); $t = $t - 60 * 60 * 24; return $t;} /** * 獲得系統某月的周數組，第一周不足的需要補足 * * @param int $current_year * @param int $current_month * @return string[][] */function getMonthWeekArr($current_year, $current_month){ //該月第一天 $firstday = strtotime($current_year.'-'.$current_month.'-01'); //該月的第一周有幾天 $firstweekday = (7 - date('N',$firstday) +1); //計算該月第一個周一的時間 $starttime = $firstday-3600*24*(7-$firstweekday); //該月的最后一天 $lastday = strtotime($current_year.'-'.$current_month.'-01'." +1 month -1 day"); //該月的最后一周有幾天 $lastweekday = date('N',$lastday); //該月的最后一個周末的時間 $endtime = $lastday-3600*24*($lastweekday%7); $step = 3600*24*7;//步長值 $week_arr = array(); for ($i=$starttime; $i<$endtime; $i= $i+3600*24*7){ $week_arr[] = array('key'=>date('Y-m-d',$i).'|'.date('Y-m-d',$i+3600*24*6), 'val'=>date('Y-m-d',$i).'~'.date('Y-m-d',$i+3600*24*6)); } return $week_arr;} /** * 處理搜索時間 */ function dealwithSearchTime($search_arr=''){ //初始化時間 //天 if(!isset($search_arr['search_time'])){ $search_arr['search_time'] = date('Y-m-d', time()- 86400); } $search_arr['day']['search_time'] = strtotime($search_arr['search_time']);//搜索的時間 //周 if(!isset($search_arr['searchweek_year'])){ $search_arr['searchweek_year'] = date('Y', time()); } if(!isset($search_arr['searchweek_month'])){ $search_arr['searchweek_month'] = date('m', time()); } if(!isset($search_arr['searchweek_week'])){ $search_arr['searchweek_week'] = implode('|', getWeek_SdateAndEdate(time())); } $weekcurrent_year = $search_arr['searchweek_year']; $weekcurrent_month = $search_arr['searchweek_month']; $weekcurrent_week = $search_arr['searchweek_week']; $search_arr['week']['current_year'] = $weekcurrent_year; $search_arr['week']['current_month'] = $weekcurrent_month; $search_arr['week']['current_week'] = $weekcurrent_week; //月 if(!isset($search_arr['searchmonth_year'])){ $search_arr['searchmonth_year'] = date('Y', time()); } if(!isset($search_arr['searchmonth_month'])){ $search_arr['searchmonth_month'] = date('m', time()); } $monthcurrent_year = $search_arr['searchmonth_year']; $monthcurrent_month = $search_arr['searchmonth_month']; $search_arr['month']['current_year'] = $monthcurrent_year; $search_arr['month']['current_month'] = $monthcurrent_month; return $search_arr; } /** * 獲取本周的開始時間和結束時間 * * @param int $current_time * @return string */ function getWeek_SdateAndEdate($current_time){ $current_time = strtotime(date('Y-m-d',$current_time)); $return_arr['sdate'] = date('Y-m-d', $current_time-86400*(date('N',$current_time) - 1)); $return_arr['edate'] = date('Y-m-d', $current_time+86400*(7- date('N',$current_time))); return $return_arr; } /** * 查詢每月的周數組 */ function getweekofmonth(){ $year = $_GET['y']; $month = $_GET['m']; $week_arr = getMonthWeekArr($year, $month); echo json_encode($week_arr); die; } 3.statistics.php
<?php/** * 統計 * * @abstract * * @copyright 格里西,2016 * * @author liujun * * @version Id:statics v1.0 2016/2/5 */ /** * 獲得折線圖統計圖數據 * * param $statarr 圖表需要的設置項 * @return string */function getStatData_LineLabels($stat_arr){ //圖表區、圖形區和通用圖表配置選項 $stat_arr['chart']['type'] = 'line'; //圖表序列顏色數組 $stat_arr['colors']?'':$stat_arr['colors'] = array('#058DC7', '#ED561B', '#8bbc21', '#0d233a'); //去除版權信息 $stat_arr['credits']['enabled'] = false; //導出功能選項 $stat_arr['exporting']['enabled'] = false; //標題如果為字符串則使用默認樣式 is_string($stat_arr['title'])?$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):''; //子標題如果為字符串則使用默認樣式 is_string($stat_arr['subtitle'])?$stat_arr['subtitle'] = array('text'=>"<b>{$stat_arr['subtitle']}</b>",'x'=>-20):''; //Y軸如果為字符串則使用默認樣式 if(is_string($stat_arr['yAxis'])){ $text = $stat_arr['yAxis']; unset($stat_arr['yAxis']); $stat_arr['yAxis']['title']['text'] = $text; } return json_encode($stat_arr);} /** * 獲得Column2D統計圖數據 * * @param array $stat_arr * @return string */function getStatData_Column2D($stat_arr){ //圖表區、圖形區和通用圖表配置選項 $stat_arr['chart']['type'] = 'column'; //去除版權信息 $stat_arr['credits']['enabled'] = false; //導出功能選項 $stat_arr['exporting']['enabled'] = false; //標題如果為字符串則使用默認樣式 is_string($stat_arr['title'])?$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):''; //子標題如果為字符串則使用默認樣式 is_string($stat_arr['subtitle'])?$stat_arr['subtitle'] = array('text'=>"<b>{$stat_arr['subtitle']}</b>",'x'=>-20):''; //Y軸如果為字符串則使用默認樣式 if(is_string($stat_arr['yAxis'])){ $text = $stat_arr['yAxis']; unset($stat_arr['yAxis']); $stat_arr['yAxis']['title']['text'] = $text; } //柱形的顏色數組 $color = array('#7a96a4','#cba952','#667b16','#a26642','#349898','#c04f51','#5c315e','#445a2b','#adae50','#14638a','#b56367','#a399bb','#070dfa','#47ff07','#f809b7'); foreach ($stat_arr['series'] as $series_k=>$series_v){ foreach ($series_v['data'] as $data_k=>$data_v){ $data_v['color'] = $color[$data_k]; $series_v['data'][$data_k] = $data_v; } $stat_arr['series'][$series_k]['data'] = $series_v['data']; } //print_r($stat_arr); die; return json_encode($stat_arr);} /** * 獲得Basicbar統計圖數據 * * @param array $stat_arr * @return string */function getStatData_Basicbar($stat_arr){ //圖表區、圖形區和通用圖表配置選項 $stat_arr['chart']['type'] = 'bar'; //去除版權信息 $stat_arr['credits']['enabled'] = false; //導出功能選項 $stat_arr['exporting']['enabled'] = false; //顯示datalabel $stat_arr['plotOptions']['bar']['dataLabels']['enabled'] = true; //標題如果為字符串則使用默認樣式 is_string($stat_arr['title'])?$stat_arr['title'] = array('text'=>"<b>{$stat_arr['title']}</b>",'x'=>-20):''; //子標題如果為字符串則使用默認樣式 is_string($stat_arr['subtitle'])?$stat_arr['subtitle'] = array('text'=>"<b>{$stat_arr['subtitle']}</b>",'x'=>-20):''; //Y軸如果為字符串則使用默認樣式 if(is_string($stat_arr['yAxis'])){ $text = $stat_arr['yAxis']; unset($stat_arr['yAxis']); $stat_arr['yAxis']['title']['text'] = $text; } //柱形的顏色數組 $color = array('#7a96a4','#cba952','#667b16','#a26642','#349898','#c04f51','#5c315e','#445a2b','#adae50','#14638a','#b56367','#a399bb','#070dfa','#47ff07','#f809b7'); foreach ($stat_arr['series'] as $series_k=>$series_v){ foreach ($series_v['data'] as $data_k=>$data_v){ if (!$data_v['color']){ $data_v['color'] = $color[$data_k%15]; } $series_v['data'][$data_k] = $data_v; } $stat_arr['series'][$series_k]['data'] = $series_v['data']; } //print_r($stat_arr); die; return json_encode($stat_arr);} /** * 計算環比 * * @param array $updata * @param array $currentdata * @return string */function getHb($updata, $currentdata){ if($updata != 0){ $mtomrate = round(($currentdata - $updata)/$updata*100, 2).'%'; } else { $mtomrate = '-'; } return $mtomrate; } /** * 計算同比 * * @param array $updata * @param array $currentdata * @return string */function getTb($updata, $currentdata){ if($updata != 0){ $ytoyrate = round(($currentdata - $updata)/$updata*100, 2).'%'; } else { $ytoyrate = '-'; } return $ytoyrate; } /** * 地圖統計圖 * * @param array $stat_arr * @return string */function getStatData_Map($stat_arr){ //$color_arr = array('#f63a3a','#ff5858','#ff9191','#ffc3c3','#ffd5d5'); $color_arr = array('#fd0b07','#ff9191','#f7ba17','#fef406','#25aae2'); $stat_arrnew = array(); foreach ($stat_arr as $k=>$v){ $stat_arrnew[] = array('cha'=>$v['cha'],'name'=>$v['name'],'des'=>$v['des'],'color'=>$color_arr[$v['level']]); } return json_encode($stat_arrnew);} /** * 獲得餅形圖數據 * * @param array $data * @return string */function getStatData_Pie($data){ $stat_arr['chart']['type'] = 'pie'; $stat_arr['credits']['enabled'] = false; $stat_arr['title']['text'] = $data['title']; $stat_arr['tooltip']['pointFormat'] = '{series.name}: <b>{point.y}</b>'; $stat_arr['plotOptions']['pie'] = array( 'allowPointSelect'=>true, 'cursor'=>'pointer', 'dataLabels'=>array( 'enabled'=>$data['label_show'], 'color'=>'#000000', 'connectorColor'=>'#000000', 'format'=>'<b>{point.name}</b>: {point.percentage:.1f} %' ) ); $stat_arr['series'][0]['name'] = $data['name']; $stat_arr['series'][0]['data'] = array(); foreach ($data['series'] as $k=>$v){ $stat_arr['series'][0]['data'][] = array($v['p_name'],$v['allnum']); } //exit(json_encode($stat_arr)); return json_encode($stat_arr);} 4.theline.php
<!DOCTYPE><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><!--引入ECharts文件--><title>Echarts</title><script src="js/echarts.common.min.js"></script></head><script src="js/jquery.js"></script><?php include('php/datehelper.php');include('php/statistics.php');?><?php //獲得系統年份 $year_arr = getSystemYearArr(); //獲得系統月份 $month_arr = getSystemMonthArr(); //存儲參數 $search_arr = $_REQUEST; $search_arr =dealwithSearchTime($search_arr); //獲得本月的周時間段 $week_arr = getMonthWeekArr($search_arr['week']['current_year'],$search_arr['week']['current_month']); //天數 if(!isset($_REQUEST['search_time'])){ $_REQUEST['search_time'] = date('Y-m-d', time()-86400); } $search_time = $_REQUEST['search_time'];//搜索的時間 //周 if(!isset($_REQUEST['search_time_year'])){ $_REQUEST['search_time_year'] = date('Y', time()); } if(!isset($_REQUEST['search_time_month'])){ $_REQUEST['search_time_month'] = date('m', time()); } if(!isset($_REQUEST['search_time_week'])){ $_REQUEST['search_time_week'] = implode('|', getWeek_SdateAndEdate(time())); } $current_year = $_REQUEST['search_time_year']; $current_month = $_REQUEST['search_time_month']; $current_week = $_REQUEST['search_time_week']; ?><style>#search_type{float:left}#searchtype_day{float:left}#searchtype_week{float:left}#searchtype_month{float:left} </style><body> <select name="search_type" id="search_type" > <option value="day" >按照天統計</option> <option value="week" >按照周統計</option> <option value="month">按照月統計</option> </select> <div class="w140" id="searchtype_day"> <div class='input-group date' id='datetimepicker1'> <input id="stime" class="form-control" type="text" value="<?php echo $search_time;?>" name="search_time"> <span class="input-group-addon"><span class="glyphicon glyphicon-calendar"></span></span> </div> </div> <div id="searchtype_week" style="display:none;"> <select name="search_time_year" id="searchweek_year"> <?php foreach ($year_arr as $k=>$v){?> <option value="<?php echo $k;?>" <?php echo $current_year == $k?'selected':'';?>><?php echo $v; ?></option> <?php } ?> </select> <select name="search_time_month" id="searchweek_mouth"> <?php foreach ($month_arr as $k=>$v){?> <option value="<?php echo $k;?>" <?php echo $current_month == $k?'selected':'';?>><?php echo $v; ?></option> <?php } ?> </select> <select name="search_time_week" id="searchweek_week"> <?php foreach ($week_arr as $k=>$v){?> <option value="<?php echo $v['key'];?>" <?php echo $current_week == $v['key']?'selected':'';?> ><?php echo $v['val']; ?></option> <?php } ?> </select> </div> <div id="searchtype_month" style="display:none;"> <select name="search_time_year" class="querySelect"> <?php foreach ($year_arr as $k=>$v){?> <option value="<?php echo $k;?>" <?php echo $current_year == $k?'selected':'';?> ><?php echo $v; ?></option> <?php } ?> </select> <select name="search_time_month" class="querySelect"> <?php foreach ($month_arr as $k=>$v){?> <option value="<?php echo $k;?>" <?php echo $current_month == $k?'selected':'';?>><?php echo $v; ?></option> <?php } ?> </select> </div> <div id="line_chart" style="width:600px;height:400px;"></div> <?php $thearray=array(11,11,15,13,12,13,10);?> <script type="text/javascript"> // 基于準備好的dom，初始化echarts實例 var mylineChart=echarts.init(document.getElementById('line_chart')); option1 = { title: { text: '未來一周氣溫變化', subtext: '純屬虛構' }, tooltip: { trigger: 'axis' }, legend: { data:['最高氣溫','最低氣溫'] }, toolbox: { show: true, feature: { dataZoom: {}, // dataView: {readOnly: false}, magicType: {type: ['line', 'bar']}, restore: {}, saveAsImage: {} } }, xAxis: { type: 'category', boundaryGap: false, data: ['周一','周二','周三','周四','周五','周六','周日'] }, yAxis: { type: 'value', axisLabel: { formatter: '{value} °C' } }, series: [ { name:'最高氣溫', type:'line', data:<?php echo(json_encode($thearray)); ?>, markPoint: { data: [ {type: 'max', name: '最大值'}, {type: 'min', name: '最小值'} ] }, markLine: { data: [ {type: 'average', name: '平均值'} ] } }, { name:'最低氣溫', type:'line', data:[1, 4, 2, 5, 3, 2, 0], markPoint: { data: [ {name: '周最低', value: -2, xAxis: 1, yAxis: -1.5} ] }, markLine: { data: [ {type: 'average', name: '平均值'} ] } } ]}; // 使用剛指定的配置項和數據顯示圖表。 mylineChart.setOption(option1); </script> <script> //展示搜索時間框function show_searchtime(){ s_type = $("#search_type").val(); $("[id^='searchtype_']").hide(); $("#searchtype_"+s_type).show();} $(function(){ show_searchtime(); $("#search_type").change(function(){ show_searchtime(); }); //更新周數組 $("[name='search_time_month']").change(function(){ var year = $("[name='search_time_year']").val(); var month = $("[name='search_time_month']").val(); $("[name='search_time_week']").empty(); $.getJSON('php/ajax.php',{y:year,m:month},function(data){ if(data != null){ for(var i = 0; i < data.length; i++) { $("[name='search_time_week']").append('<option value="'+data[i].key+'">'+data[i].val+'</option>'); } } }); }); //更新年數組 $("[name='search_time_year']").change(function(){ var year = $("[name='search_time_year']").val(); $("[name='search_time_week']").empty(); $("#searchweek_mouth option:first").prop("selected", 'selected'); $.getJSON('php/ajax.php',{y:year},function(data){ if(data != null){ for(var i = 0; i < data.length; i++) { $("[name='search_time_week']").append('<option value="'+data[i].key+'">'+data[i].val+'</option>'); } } }); }); }); </script></body></html> 5.time_deal.php
<?php //獲取系統年份/** * * @return string[] */function getSystemYearArr(){ $year_arr = array('2010'=>'2010','2011'=>'2011','2012'=>'2012','2013'=>'2013','2014'=>'2014','2015'=>'2015','2016'=>'2016','2017'=>'2017','2018'=>'2018','2019'=>'2019','2020'=>'2020'); return $year_arr;} /** * 獲得系統月份數組 * * @return array */function getSystemMonthArr(){ $month_arr = array('1'=>'01','2'=>'02','3'=>'03','4'=>'04','5'=>'05','6'=>'06','7'=>'07','8'=>'08','9'=>'09','10'=>'10','11'=>'11','12'=>'12'); return $month_arr;} /** * 處理搜索時間 */ public function dealwithSearchTime($search_arr){ //初始化時間 //天 if(!$search_arr['search_time']){ $search_arr['search_time'] = date('Y-m-d', time()- 86400); } $search_arr['day']['search_time'] = strtotime($search_arr['search_time']);//搜索的時間 //周 if(!$search_arr['searchweek_year']){ $search_arr['searchweek_year'] = date('Y', time()); } if(!$search_arr['searchweek_month']){ $search_arr['searchweek_month'] = date('m', time()); } if(!$search_arr['searchweek_week']){ $search_arr['searchweek_week'] = implode('|', getWeek_SdateAndEdate(time())); } $weekcurrent_year = $search_arr['searchweek_year']; $weekcurrent_month = $search_arr['searchweek_month']; $weekcurrent_week = $search_arr['searchweek_week']; $search_arr['week']['current_year'] = $weekcurrent_year; $search_arr['week']['current_month'] = $weekcurrent_month; $search_arr['week']['current_week'] = $weekcurrent_week; //月 if(!$search_arr['searchmonth_year']){ $search_arr['searchmonth_year'] = date('Y', time()); } if(!$search_arr['searchmonth_month']){ $search_arr['searchmonth_month'] = date('m', time()); } $monthcurrent_year = $search_arr['searchmonth_year']; $monthcurrent_month = $search_arr['searchmonth_month']; $search_arr['month']['current_year'] = $monthcurrent_year; $search_arr['month']['current_month'] = $monthcurrent_month; return $search_arr; } 以上就是本文的全部內容，希望對大家的學習有所幫助。
