codeigniterphp搜索日期明智不顯示所有結果-有解無憂

我有一個 codeigniter 網站，其中有一個簡單的搜索框，如下所示：

<form method="post" action="<?php echo base_url()?>homecontroller/search">
  <label>Month: </label>

  <select class="form-select" id="basicSelect" name="month">
    <option value="01">January</option>
    <option value="02">February</option>
    <option value="03">March</option>
    <option value="04">April</option>
    <option value="05">May</option>
    <option value="06">June</option>
    <option value="07">July</option>
    <option value="08">August</option>
    <option value="09">September</option>
    <option value="10">October</option>
    <option value="11">November</option>
    <option value="12">December</option>


  </select>

  <label>Year: </label>

  <select class="form-select" id="basicSelect" name="year">
    <option value="2022">2022</option>
    <option value="2021">2021</option>
    <option value="2020">2020</option>
    <option value="2019">2019</option>
    <option value="2018">2018</option>
    <option value="2017">2017</option>
    <option value="2016">2016</option>
    <option value="2015">2015</option>
    <option value="2014">2014</option>
    <option value="2013">2013</option>
    <option value="2012">2012</option>


  </select>

  <input style="margin-top:24%" type="submit" class="btn btn-primary ml-1" name="billing" value="SEARCH">

</form>

我的控制器看起來像：

  $month=$this->input->post('month');
    $year=$this->input->post('year');

    $stotal=$year.'-'.$month;
   
    $data['search'] = $this->user->searchbilling($stotal);

我在模型中執行了以下代碼來獲取結果：

public function searchbilling($stotal) { 
$this->db->select('*, SUM(quantity) as quantity'); 
$this->db->from('delivered'); 
$this->db->like('date', $stotal); 
$this->db->group_by('YEAR(date), MONTH(date), customer'); 
$query = $this->db->get(); 
$result = $query->result(); 
return $result; }

但是，這并沒有顯示該特定月份的所有結果，任何人都可以告訴我這里出了什么問題，在此先感謝

uj5u.com熱心網友回復：

你可以這樣嘗試where("DATE_FORMAT(date,'%Y-%m') =", $stotal)

public function searchbilling($stotal) { 
  $this->db->select('*, SUM(quantity) as quantity'); 
  $this->db->from('delivered'); 
  $this->db->where("DATE_FORMAT(date,'%Y-%m') =", $stotal); 
  $this->db->group_by('YEAR(date), MONTH(date), customer'); 
  $query = $this->db->get(); 
  $result = $query->result(); 
  return $result; 
}

uj5u.com熱心網友回復：

你可以這樣做 where("DATE_FORMAT(date,'FORMAT YOU NEED') =", $stotal)

public function searchbilling($stotal) { 
  $this->db->select('*, SUM(quantity) as quantity'); 
  $this->db->from('delivered'); 
  $this->db->where("DATE_FORMAT(date,'FORMAT YOU NEED') =", $stotal); 
  $this->db->group_by('YEAR(date), MONTH(date), customer'); 
  $query = $this->db->get(); 
  $result = $query->result(); 
  return $result; 
}

轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/483510.html

標籤：php 日期代码点火器搜索 codeigniter-3

上一篇：codeigniter：加密URL引數

下一篇：Codeigniter表單驗證自定義訊息