Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
so i was thinking of adding a basic referral system in my project but I don't want to use a referral link instead I would like the user to give invited user his / her username
when the invited User input the invitee User username during registration or after registration then this check if the invitee Username exit then increase the invitee referral count
how can I do this ? how should I structure the database? how do I check if invitee exist?
So just check if that user exists and increment a counter on that user?
if ($user = User::where('username', $request->input('referrel'))->first()) {
$user->increment('referrel_count');
}
But personally I would probably keep track of who invited who on a seperate table instead
@Sinnbeck thanks , how would I structure the table if I am to follow your own way, how would you do it personally?
@kikter Personally I would make a pivot table (a many to many relationship)
referrals
id | referred_by_id | user_id
both would point to the users table. https://laravel.com/docs/9.x/eloquent-relationships#many-to-many
@Sinnbeck will give it a try and and get back to you thanks
Please or to participate in this conversation.