douhuan3448 2018-08-12 12:01
浏览 36
已采纳

使用ajax更新mysql

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.

  • 写回答

1条回答 默认 最新

  • douhong1703 2018-08-12 12:05
    关注

    It might be syntax error from your side, please try the below code:

    <?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);
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?