Php-mysql duplicated rows

Question

I made a like-unlike feature in my iOS-PHP Application.

(Of course userId and session is in the get parameter also)

Calling like.php?id=10 does two things

checks if the content 10 is liked already,
if not then adds a row to the database’s table

Calling unlike.php?id=10 removes the like the user has made.

—————

The problem is, that sometimes if the user likes-unlikes the given content too fast, my table will receive 2 rows of the given like.

————

I assume it is because two requests to the like.php file happens exactly at the same moment..

What could I do to prevent multiple rows from same user?

Yasir Mushtaq · Accepted Answer · 2019-04-26 11:49:06Z

1

Use UNIQUE index in your database's table for user's id and content's id. The database will not insert a same user with same content in the like table.

answered Apr 26, 2019 at 11:49

Yasir Mushtaq

1781 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Grzegorz Lasak · Accepted Answer · 2019-04-26 11:30:57Z

0

For me, 2 things: 1. Disable option for clicking button until request is finished (thanks to simple JS) 2. Lock the table for actions but keep it visible for reading for time of performing query.

you can even use both options so you will avoid having it clicked at the same time by 2 different users.

answered Apr 26, 2019 at 11:30

Grzegorz Lasak

964 bronze badges

Collectives™ on Stack Overflow

Php-mysql duplicated rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related