如何从 php codeigniter 中的给定日期选择完整的月份

发布于 2025-01-19 16:11:27 字数 513 浏览 0 评论 0原文

我有一个CodeIgniter网站，我试图根据用户ID和日期显示一些结果，

我的数据库如下：

我有一个类似的日期，用户将选择：2022-04-08

我想要的是从该完整月份的表中获取所有数据，如果我得到一个日期，我想提取完整的月份。

我做了这样的事情：

  public function selectview($id,$date)
{
$this->db->select('*');
$this->db->from('delivered');
 $this->db->where("cid", $id);
$this->db->like('date', $date, 'after');
$query = $this->db->get();
$result = $query->result();
return $result;
}

但是，这并没有给那个月的所有日期，任何人都可以告诉我如何实现这一目标，谢谢

原文

i have a codeigniter website where i am trying to display some results based on user id and date,

my database is like below:

enter image description here

i have a single date like this which will be selected by user: 2022-04-08

what i want is to get all the data from table of that complete month, if i get a single day date i want to fetch the complete month.

i did something like this:

  public function selectview($id,$date)
{
$this->db->select('*');
$this->db->from('delivered');
 $this->db->where("cid", $id);
$this->db->like('date', $date, 'after');
$query = $this->db->get();
$result = $query->result();
return $result;
}

however this doesnt give all the dates of that month, can anyone please tell me how to accomplish this, thanks in advance

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

潦草背影 2025-01-26 16:11:27

您需要将$ date修改为Year和月。尝试这样的事情：

public function selectview($id,$date)
{
 //assuming your date format is YYYY-MM-DD
$newDate = substr($date,0, strrpos($date, "-")); // 2022-04
$this->db->select('*');
$this->db->from('delivered');
$this->db->where("cid", $id);
$this->db->like('date', $newDate); //pass new date here
$query = $this->db->get();
$result = $query->result();
return $result;
}

You need to modify $date to just year and month. try something like this :

public function selectview($id,$date)
{
 //assuming your date format is YYYY-MM-DD
$newDate = substr($date,0, strrpos($date, "-")); // 2022-04
$this->db->select('*');
$this->db->from('delivered');
$this->db->where("cid", $id);
$this->db->like('date', $newDate); //pass new date here
$query = $this->db->get();
$result = $query->result();
return $result;
}

回复收藏 0 原文

~没有更多了~