注册或登录表致命错误-Java 学习之路

以下PHP / MySQL代码无法正常工作，并且在连接MySQL表时产生致命错误，我正在尝试制作注册表和登录表（在同一页面上，使用不同的z-index并隐藏和显示按钮，但由于一些MySQL的致命错误，它不会加载 . 我正在努力完成这项工作，但似乎我的教程要么已经过时，要么我试图以完全屠杀的方式将其复制到我的情境中 .

if (session_status() == PHP_SESSION_NONE) {
    session_start();
}
$mysql = mysql_connect("localhost:****", "*****", "W*********") or die("Failed to connect to MySQL: " . mysql_error());
$db=mysql_select_db('matrixhu_logins',$mysql) or die("Failed to connect to MySQL: " . mysql_error());
if(isset($_POST['log'])) {
$username = $_POST['usr'];
$password = $_POST['pass'];
$query = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";
$data = mysql_query($query) or die("Failed to connect to MySQL: " . mysql_error());
if($data) {
    echo "It Worked!"
} else if(isset($_POST['sign'])) {
    $username = $_POST['username'];
    $password = $_POST['password'];
    $passconfirm = $_POST['confirmpass'];
    $email = $_POST['email'];
    $bio = $_POST['bio'];
    if($password !== $passconfirm) {
        $error = "Passwords are not the same!";
        die;
    }
    $query = "INSERT INTO users (username,password,email,bio) VALUES ('$username','$password','$email','$bio')";
    $data = mysqli_query($query) or die("Failed to connect to MySQL: " . mysqli_error());
    if($data) {
        echo "Success!";
    }
} else {
    $username = "Guest";
}

1 回答

使用mysqli到处而不是mysql . 问题是你在someplaces使用mysqli而在某些地方使用mysql . 你也混合了两者的语法 .

if (session_status() == PHP_SESSION_NONE) {
    session_start();
}
$mysql = mysqli_connect("localhost:****", "*****", "W*********") or die("Failed to connect to MySQL: " . mysqli_error());
$db=mysqli_select_db($mysql,'matrixhu_logins') or die("Failed to connect to MySQL: " . mysql_error());
if(isset($_POST['log'])) {
$username = $_POST['usr'];
$password = $_POST['pass'];
$query = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";
$data = mysqli_query($mysql,$query) or die("Failed to connect to MySQL: " . mysqli_error());
if($data) {
    echo "It Worked!"
} else if(isset($_POST['sign'])) {
    $username = $_POST['username'];
    $password = $_POST['password'];
    $passconfirm = $_POST['confirmpass'];
    $email = $_POST['email'];
    $bio = $_POST['bio'];
    if($password !== $passconfirm) {
        $error = "Passwords are not the same!";
        die;
    }
    $query = "INSERT INTO users (username,password,email,bio) VALUES ('$username','$password','$email','$bio')";
    $data = mysqli_query($mysql,$query) or die("Failed to connect to MySQL: " . mysqli_error());
    if($data) {
        echo "Success!";
    }
} else {
    $username = "Guest";
}

回复于 2024-05-05T11:47:54+08:00

注册或登录表致命错误

1 回答

相关问题