php - PHP MySQL 代码错误

Question

我的某些 PHP 似乎有问题。它从 HTML 页面获取数据，然后将其添加到 MySQL 数据库，但信息没有出现。

<?php

    // Variables
    $email = $_POST["email"]; 
    $username = $_POST["username"]; 
    $password = $_POST["password"]; 
    $passwordconfirmation = $_POST["passwordconfirmation"];

    // Failure
    if ($password !== $passwordconfirmation)
    { 
       echo "The password fields do not match. Please enter your password again."; 
    } 

    // Success
    else
    {
    $connection = mysqli_connect("*****.com", "*****", "*****", "charlesfriessdatabase"); // Connect

     // Error Message
    if (!$connection)
    {
        die ("Error"); 
    }

    mysqli_query("INSERT INTO accounts (email, username, password) VALUES ($email, $username, $password)"); // Inserter

    mysqli_close($connection); // Connection Closer

    echo "You have successfully signed up! Please check your email to confirm your account."; // Success Message
}

?>

Answer 1

在您需要放置 ' 的变量中尝试添加此字符并告知我们。

应该是这样的:

mysqli_query("INSERT INTO accounts (email, username, password) VALUES ('$email', '$username', '$password')");