Fatal error: Call to a member function bind_param() for login page

Question

I have a database named "assignmentdb" and i'm using xampp to do my project. I'm using these codes for my login page for my website. There's an error for line "$stmt->bind_param("s", $userid); "

"Fatal error: Call to a member function bind_param() on a non-object in /Applications/XAMPP/xamppfiles/htdocs/Assignment/loginsuccess.php on line 50"

This is my codes:

$userid = $_POST['userid'];
$password = $_POST['password'];

$mysqli = new mysqli("localhost", "root", null, "assignmentdb");
$stmt = $mysqli->prepare("Select password from forumuser where userid=?");
$stmt->bind_param("s", $userid); 
$stmt->execute();
$stmt->bind_result($p);
$stmt->fetch();
$stmt->close();
$mysqli->close();

if($p == $password){ 
echo '<p>Welcome! You have logged in successfully!</p>';
echo 'Please <a href="comments.html">Click here to continue</a>';
echo "<p><a href='messages(7).php?userid=$userid'>Go To my Messages</a> </p>";
}
else{
    echo '<p><h1>Login unsuccessful!</h1>';
}

Also check if `$stmt` got prepared by `if ($stmt = $mysqli->prepare(...)) { $stmt->bind_param(...); ... } else { printf("Errormessage: %s\n", $mysqli->error); }` — Antonios Tsimourtos, Jan 26 '17 at 11:40
i think you saved plain password (by looking your attempt), which is not a good idea. Try using password hashing mecanism — Anant Kumar Singh, Jan 26 '17 at 11:45

score 1 · Answer 1 · answered Jan 26 '17 at 11:48

1

Mmm this seems that $stmt is not initialized, maybe u should check if conection to the database is right. This seems no errors with query.

answered Jan 26 '17 at 11:48

UmbrellaSpirit

5
2

how do i initialize it? – Learning Javascript Jan 26 '17 at 14:02

Fatal error: Call to a member function bind_param() for login page

1 Answers1