php 判断是否为空行,php – 准备好的语句检查行是否存在

mysqli_num_rows适用于SELECT语句.

$stmt_check = $conn->prepare("SELECT * FROM users WHERE email =? AND password =?");

$stmt_check->bind_param("ss", $email, $password);

$stmt_check->execute();

if(mysqli_num_rows($stmt_check) > 0)

更新的代码

include '../config.php';

$email = $_POST['email'];

$password = $_POST['password'];

$stmt_check = $conn->prepare("SELECT * FROM users WHERE email =? AND password =?");

$stmt_check->bind_param("ss", $email, $password);

$stmt_check->execute();

if($stmt_check->num_rows > 0){

echo 'user already exists';

} else {

$stmt = $conn->prepare("INSERT INTO users (email, password) VALUES (?, ?)");

$stmt->bind_param("ss", $email, $password);

$stmt->execute();

header('Location: ../login.php');

}

$stmt->close();

$conn->close();

?>

快速链接

哪个国家,

This command is only valid for statements like SELECT or SHOW that

return an actual result set. To retrieve the number of rows affected

by a INSERT, UPDATE, REPLACE or DELETE query, use

07002.

编辑1

更改

if(mysqli_num_rows($stmt_check) > 0){

至

if($stmt_check->num_rows > 0){