Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

shez1983's avatar

matching system - need pointers?

if i am creating a match system.. so if i like a user, and they like me back its a match.. then we can chat and if we like each other then propose some dates we can swap houses (its a home swap system not dating :p) how would i do it?

currently i have a likes table.. so if i like you, i will check if you have liked me before and then perhaps create a match/proposal table (status = initial).. which will link to chat table..

after either of us propose some dates i turn it into pending.. the other user can then accept/reject/propose new dates..

if accepted.. i then have to get people to pay.. (invoices, with one row for each person?)

proposal table = id, recipient_id, 'sender_id', status, start_date, end_date, guests

0 likes
0 replies

Please or to participate in this conversation.