CODEWITHSUNDEEP
phpmysqli
user3318525
user3318525

Reputation: 9

Check if user exist with mysqli doesn't work

$stmt = $db->prepare("SELECT * FROM user WHERE name='Steve Job'");
$stmt->execute();
if($stmt->num_rows){
    echo "1";
}

it return blank in my ajax callback. I've debugging for hours.

Upvotes: 0

Views: 29

Answers (1)

Andy Holmes
Andy Holmes

Reputation: 8047

$stmt = $db->prepare("SELECT * FROM user WHERE name='Steve Job'");
$stmt->execute();
$stmt->store_result();
$numRows = $stmt->num_rows;
if($numRows > 0){
    echo "1";
}

You need to use store_result before working with num_rows

Upvotes: 1

Related Questions