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

报告相同问题?

悬赏问题

  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应
  • ¥15 matlab基于pde算法图像修复,为什么只能对示例图像有效
  • ¥100 连续两帧图像高速减法
  • ¥15 如何绘制动力学系统的相图
  • ¥15 对接wps接口实现获取元数据