


PHP implements a search box for querying by days, weeks, and months_php skills
The example in this article shares with you the PHP search box that implements query by day, week, and month. The statistical graph of the data is displayed during the search. It mainly displays the effect of the graph for your reference. The specific content is as follows
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; }
The above is the entire content of this article, I hope it will be helpful to everyone’s study.

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

If you are an experienced PHP developer, you might have the feeling that you’ve been there and done that already.You have developed a significant number of applications, debugged millions of lines of code, and tweaked a bunch of scripts to achieve op

Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total

This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.
