sql准备语句没有运行?

bjp0bcyl  于 2021-06-18  发布在  Mysql
关注(0)|答案(0)|浏览(150)

我在我的主页上通过ajax异步运行了以下.php文件,该主页本应提交评论:

<?php
session_start();
include "dxbase.php";
$conn = new mysqli($servername, $username, $password, $dbname);

    $comment = "practice";
    $prid = 2;

    if(isset($_SESSION['user'])){

    $usera = $_SESSION['user'];

    $stmt = $conn->prepare("INSERT INTO reviews (prid, content, username) VALUES (?, ?, ?)");
    $stmt->bind_param("sss", $prid, $comment, $usera);
    $stmt->execute();
    echo "Review submitted!";
    $stmt->close();

    } else {
        echo "Oops! You need to be signed in to review products!";

    }
    $conn->close();
?>

当我运行它时,它回显它已经提交了一条评论,但当我检查我的数据库时,它不在那里:db
为什么不插?!

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题