在计算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);