的变量有关
<?php
session_start();
$_SESSION['message'] = '';
$mysqli = new mysqli("192.99.56.236", "root", "fakepass", "thesucc");
if($_SERVER['REQUEST_METHOD'] == 'POST') {
//two passwords maching
if($_POST['password'] == $_POST['confirmpassword']) {
$username = $mysqli->real_escape_string($_POST['username']);
$email = $mysqli->real_escape_string($_POST['email']);
$password = md5($_POST['password']); //md5 is hash
$avatar_path = $mysqli->real_escape_string('images/'.$_FILES['avatar']['name']);
//make sure fike is image
if (preg_match("!image!", $_FILES['avatar']['type'])) {
//copy image to images folder
if (copy($_FILES['avatar']['tmp_name'], $avatar_path)) {
$_SESSION['username'] = $username;
$_SESSION['avatar'] = $avatar_path;
$sql = "INSERT INTO users (username, email, password, avatar) "
. "VALUES ('$username', '$email', '$password', '$avatar_path')";
//if the query success, redirect to welcome.php, done!
if ($mysqli->query($sql) === true) {
$_SESSION['message'] = "Registration succesfull! Added $username to the database!";
header("location: welcome.php");
} else {
$_SESSION['message'] = "User could not be created!";
}
} else {
$_SESSION['message'] = "File upload failed!";
}
} else {
$_SESSION['message'] = "Please only upload image files!";
}
} else {
$_SESSION['message'] = "Passwords do not match!";
}
}
?>
这是我的代码,MySQL信息已更改,但我知道我已经正确检查了很多时间。我已经浏览了很多东西,我似乎无法弄清楚问题是什么,但我认为我认为它与无法发布到mysql
更改此行:
if ($mysqli->query($sql) === true)
:
if ($mysqli->query($sql) )