如何使用PHP和MYSQL查找今天庆祝的朋友的生日 [英] How to find the Birthday of FRIENDS Who are celebrating today using PHP and 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屋！