Birthdays should be a fairly straightforward feature for us to implement. We need to:
For us to quickly look up the birthdays of a user's connections, we need to quickly gain access to the IDs of users another user is connected to. We have some similar functionality in our relationships model (
models/relationships.php); however, the following method will give us a query returning IDs. We can then use this as a sub query in our birthdays lookup query:
/** * Get IDs of users a user has a relationship ...