PHP和MYSQL的日期到期日 [英] PHP and MYSQL date expiry near

问题描述

我想做的是当用户登录时，我想通知他们产品将会过期

What I wish to do is when the user logs in I want to notify them that the product is going to expire

任何想要使用什么查询的想法为了这个，我可以这样做吗？

Any ideas of what queries I need to use for this and how I can do this please?

谢谢。

推荐答案

p> 检查此

SELECT p.ProductName, s.Quantity, s.Price, s.DateExpiry FROM seller s, Product p
WHERE p.PID = s.PID AND Custid = $_SESSION['user'] AND
(DateExpiry BETWEEN curdate() and curdate() + interval 3 day) ORDER BY DateExpiry

这篇关于PHP和MYSQL的日期到期日的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！