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;
}
以上就是本文的全部内容，希望对大家的学习有所帮助。
类似资料：
-
我尝试创建一个查询，显示入住和退房日期之间的可用酒店。此外，当我为特定房间预订时，我将他们的预订列设置为1。这意味着，在现实生活中，当结账日期到来时，触发函数将该预订列设置成0。 如果酒店的所有房间都已预订（预订=1），并且这些房间的签入-退房日期是特定日期（签入-退房输入），则不要将该酒店放在列表中。我的查询不会显示我想要的结果。 查询：输入：国家（状态）、签入和签出。 当我运行查询时，它总是显
-
在给定年、月和周的情况下，是否有可能获得一周中第一个日期的DAYOFMONTH？ 请注意，一周的第一个日期也可能是前一个月，甚至是前一年。 我知道这是可以通过编程实现的，至少使用java。时间、时间场等。。但我想在sql查询级别上这样做，因为当涉及周时，过程中会涉及两个额外的参数，即被视为一周的第一天的DayOfWeek和一个月内一周的最小天数。如果sql和api上的配置不完全相同，则可能会导致不
-
问题内容： 所以我有一个脚本，可以返回特定月份和年份中的星期数。我该如何从该月开始的某一天，确定是该月的第1,2,3,4或5周的一部分？ 问题答案： 我尝试过的最令人沮丧的事情-就是这里！
-
问题内容： 大家好，我有以下问题。我的MySQL数据库中有一个保留表，日期列定义为DATETIME。我需要使用hibernate进行查询以找到一天中的所有储备，无论是小时还是同一年的月份和日期，而我正在这样做 … 我真的不知道如何进行比较，并只带给我指定日期的信息，没有任何帮助吗？ 问题答案： 我希望有一种与日期无关的将日期时间转换为日期的方法。通常，这就是我处理您的情况的方式。
-
问题内容： 我需要从具有列的表中抓住一些记录，这是一个（没有时间）。我只需要通过比较年份和月份来过滤记录。例如，我希望所有出生于1990年3月的用户。日子并不重要。 您如何处理？ 问题答案： 您可以使用 它将对HQL有效
-
本文向大家介绍php、mysql查询当天,查询本周,查询本月的数据实例(字段是时间戳)，包括了php、mysql查询当天,查询本周,查询本月的数据实例(字段是时间戳)的使用技巧和注意事项，需要的朋友参考一下 php、mysql查询当天,查询本周,查询本月的数据实例(字段是时间戳) php 获取今日、昨日、上周、本月的起始时间戳和结束时间 以上这篇php、mysql查询当天,查询本周,查询本月的数据