为什么这个PHP代码访问MySQL数据库不起作用？ [关闭]

Question

<?php

require('database.php');
$user = $_POST["username"];
    $password = $_POST["password"];
    $location = $_POST["location"];

    $stmt = $mysqli->prepare("insert into Userinfo (username, password, location) values (?, ?, ?)");
    if(!$stmt) {
        //printf("Query prep failed: %s
", mysqli->error);
        echo "query prep failed".$mysqli->error;
        exit;
    }
    $stmt->bind_param('sss', $username, $password, $location);
    $stmt->execute();
    $stmt->close();
    error_log("username ".$user, 3, "/tmp/php_error.log");
} 
?>

Database.php

<?php

$mysqli = new mysqli('localhost', 'php', 'passtheword', 'Android');

if($mysqli->connect_errno) {
printf("Connection Failed: %s
", $mysqli->connect_error);
exit;
}
?>

This query is not modifying my database for some reason. I know 'database.php' is valid, and I don't get an error from the if(!$stmt) section. Nothing breaks, it just doesn't modify the table, Userinfo. Can anyone tell me why?

Answer 1

Change $user to $username. You are binding and inserting $username but you only $_POST to and define $user