php实现按天数、星期、月份查询的搜索框,php天数
php实现按天数、星期、月份查询的搜索框,php天数
本文实例为大家分享了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; }
以上就是本文的全部内容,希望对大家的学习有所帮助。

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 is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.

I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.
