PHP - 在 MySQL 中输入不带引号的查询

Question

我在尝试在 MySQL 中输入不带引号的数据时遇到问题。

下面是它在 MySQL 中的显示截图

下面是将其放入数据库的 INSERT INTO 代码，我需要将它输入到 MySQL 中而不带引号，这证明是具有挑战性的......

    <?php include('db_connect.inc');?>

<?php
$result = $conn->prepare("INSERT INTO dog_park.reviews (review_text, username, date, rating, item) VALUES (:review, :id, :date, :rating, :keyword)");
$result->bindParam(':review', $value1);
$result->bindParam(':id', $value2);
$result->bindParam(':date', $value3);
$result->bindParam(':rating', $value4);
$result->bindParam(':keyword', $value5);


$value1 = $_POST['review'];
$value2 = $_SESSION['id'];
$value3 = $date = date("Y-m-d");
$value4 = $_POST['rating'];
$value5 = $_SESSION['KEYWORD'];
$result->execute();
echo "Review entry Successful, you will now be redirected to the home page";

header( "refresh:10; url=index.php" );
?>

也许与 $_SESSION 有关？

Answer 1

也许修剪掉每个发布值两侧的无关引号可以为您解决问题，如下所示:

    <?php
        include('db_connect.inc');
        $result = $conn->prepare("INSERT INTO dog_park.reviews (review_text, username, date, rating, item) VALUES (:review, :id, :date, :rating, :keyword)");

        $date   = date("Y-m-d");
        $value1 = trim($_POST['review'],        "'\"");
        $value2 = trim($_SESSION['id'],         "'\"");
        $value3 = trim($date,                   "'\"");
        $value4 = trim($_POST['rating'],        "'\"");
        $value5 = trim($_SESSION['KEYWORD'],    "'\"");

        $result->bindParam(':review',   $value1);
        $result->bindParam(':id',       $value2);
        $result->bindParam(':date',     $value3);
        $result->bindParam(':rating',   $value4);
        $result->bindParam(':keyword',  $value5);

        $result->execute();
        echo "Review entry Successful, you will now be redirected to the home page";

        header( "refresh:10; url=index.php" );
    ?>