如果没有，是否可以在数据库中发送查询。 喜欢超过50

Question

I am creating a page in which user can upload their picture and other users can like it.

Now is there any method that when the user's like goes above 50 lets say 51, then execute a query that saves this users name and postid. And then show a notification to user that your post have crossed 50 likes.

Also i dont want the query to execute again and again i want it to send that query only once for that particular post i am using php any suggestions

this is the code that i used but didnt work:

<?php if ($vote>=50){
mysqli_query($con, "insert into notifications (user_id,post_id) values('$id3','$pixid')")or die(mysqli_error($con));
}
 ?>

Answer 1

try below :

if($vote > 50) {
    $result = mysqli_query("select * from notifications where user_id = " . $id3 . " And post_id = " . $pixid);
    if(!mysqli_num_rows($result)) {
        mysqli_query($con, "insert into notifications (user_id,post_id) values('$id3','$pixid')")or die(mysqli_error($con));
    }
}