php - 如何使用 bootstrap 4 modal 创建日期过滤器过滤器
问题描述
我想使用引导模式创建一个日期过滤器,当我单击提交时,它将自动被定向到具有指定日期的新表。但是我的代码不起作用。
这是我的模式代码:
<div class="row justify-content-start">
<a href="#">
<button class="btn btn-danger ml-3 px-2 mb-2" data-toggle="modal" data-target="#userReservationModal"><i class="fas fa-fw fa-plus"></i> Add Reserve</button>
</a>
</div>
<div class="modal fade" id="userReservationModal" tabindex="-1" role="dialog" aria-labelledby="userReservationModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="userReservationModalLabel">What's Date You Want Meeting?</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<form action="<?php echo base_url('menu/myReservation'); ?>" method="GET">
<div class="modal-body">
<div class="row">
<div class="col-xl-6">
<div class="form-group">
<label>Date Start: </label>
<input class="form-control date" name="date1" id="date1" autocomplete="off" required>
</div>
</div>
<div class="col-xl-6">
<div class="form-group">
<label>Date End: </label>
<input class="form-control date" name="date2" id="date2" autocomplete="off" required>
</div>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" class="btn btn-primary">OK</button>
</div>
</form>
</div>
</div>
这是我的模型:
public function filter($data_filter_start, $data_filter_end)
{
$result1 = "SELECT*FROM ruang_meeting WHERE created_date >= '$data_filter_start'";
return $result1;
$result2 = "SELECT*FROM ruang_meeting WHERE created_date <= '$data_filter_end'";
return $result2;
}
这是我的控制器:
$date = $this->input->get('date1');
$date_month = substr($date, 0, 2);
$date_day = substr($date, 3, 2);
$date_year = substr($date, 6, 4);
$data_filter_start = mktime(0, 0, 0, $date_month, $date_day, $date_year);
$date2 = $this->input->get('date2');
$date2_month = substr($date2, 0, 2);
$date2_day = substr($date2, 3, 2);
$date2_year = substr($date2, 6, 4);
$data_filter_end = mktime(0, 0, 0, $date2_month, $date2_day, $date2_year);
$data['user'] = $this->db->get_where('user', ['nik' =>
$this->session->userdata('nik')])->row_array();
$data['reserve'] = $this->Model_reserve->getReserve();
$data['username'] = $this->Model_reserve->getUser();
$data['meeting'] = $this->Model_reserve->viewMr();
$data['filter'] = $this->Model_reserve->filter($data_filter_start, $data_filter_end);
解决方案
推荐阅读
- amazon-web-services - 如何在 aws gateway lambda 集成中获取查询字符串
- java - 在 Hibernate 中一次性添加所有实体类的方法是什么?
- java - 出现错误“找不到 org.openqa.selenium.remote.RemoteWebDriver 的类文件”
- html - 是否有任何 HTML 元素或插件可用于将文本和图像一起作为输入?
- javascript - 自动播放一页上有多个幻灯片的javascript幻灯片不起作用
- javascript - 如何在 Javascript 中对对象进行分组?
- java - 根据 GSI 索引和范围键从 Dynamo db 中获取所有列
- c# - 文本块未更新
- python - 使用嵌套字典替换字符串中的单词
- postgresql - Postgres 如何在没有 undo 日志的情况下支持回滚