recently I was working on a simple voting system for my movie website and I´m stuck with a simple point counter. I have a button with id="point" and when you click it, it should send an ajax request with id number to PHP file, which should increase a value of score in the database (where id=number).
<button type="button" id="point">Points</button>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script>
$(document).ready(function(){
$("#point").click(function(){
$.ajax({
type: "POST",
url: 'update.php',
data: {id: 22}
});
});
});
</script>`
update.php
<?php
$num = $_POST['id']
$con = mysqli_connect("localhost", "username", "password", "movies");
$vote = "UPDATE movies SET score=score + 1 WHERE id='$num'";
$run_vote = mysqli_query($con,$vote);
?>
Unfortunately, this isn´t working and I can´t figure out why. If someone knows, please write it in the comments.