如何使用PHP和MYSQL查找今天庆祝的朋友的生日 [英] How to find the Birthday of FRIENDS Who are celebrating today using PHP and MYSQL
本文介绍了如何使用PHP和MYSQL查找今天庆祝的朋友的生日的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何使用PHP和MYSQL查找今天庆祝的朋友的生日
How to find the Birthday of FRIENDS Who are celebrating today using PHP and MYSQL
提前致谢...
费罗
推荐答案
这个处理 2 月 29 日 - 将 3 月 1 日视为非闰年的庆祝日.
This one handles February 29 - treating March 1st as the celebration day in non-leap years.
SELECT u.name
FROM users u INNER JOIN friendships f ON (f.user_id = u.id)
WHERE f.friend_id = 6 -- whatever your id is
AND (
MONTH(u.birthdate) = MONTH(NOW())
AND DAY(u.birthdate) = DAY(NOW())
) OR (
MONTH(c.birthdate) = 2 AND DAY(c.birthdate) = 29
AND MONTH(NOW()) = 3 AND DAY(NOW()) = 1
AND (YEAR(NOW()) % 4 = 0)
AND ((YEAR(NOW()) % 100 != 0) OR (YEAR(NOW()) % 400 = 0))
)
没有看到你的表结构,我只是猜测你是如何处理友情链接的
Having not see your table structure, I just made a guess about how you handle friendship links
这篇关于如何使用PHP和MYSQL查找今天庆祝的朋友的生日的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文