在计算JS文件中的测验等级后,我试图使用该变量以更新PHP文件中该特定学生的等级。

该脚本在设置用户ID的用户区域中执行。

错误:未更新指示的用户,可能该变量未到达或未正确设置PHP;

要将等级变量从JS运输到PHP文件,我使用了该代码,该代码在测验末尾执行

quiz.js

var vote = userScore * 10;

window.open('/php/vote.php?vote='+vote);

private-area.php

<?php
    require 'php/config.php';

    $_SESSION["id_utente"];

    $sessionId = $_SESSION["id_utente"];
    
    $user = mysqli_fetch_assoc(mysqli_query($connessione, "SELECT * FROM utenti WHERE id_utente = $sessionId"));
?>

potd.php(我第一次更新)

<?php

require_once('config.php');

$var_voto = $_GET['vote'];


if($connessione->connect_error){
    echo "Registrazione avvenuta con successo";

    $query = $connessione->prepare("UPDATE utenti SET voto = $var_voto  WHERE id = $user ");
    $query->bind_param('voto', $id);
    $result = $query->execute();

}else{
    echo "Error";
}


?>
分析解答

您可以使用下面的Bindparam

$ query = $connessione-> prepar("UPDATE utenti SET voto = :var_voto WHERE id = :user ");

$ query-> bindparam(':var_voto',$ var_voto);

$ query-> bindparam(':user',$user);