Call to a member function bind_param() on boolean (MySQLi not running)

Question

I am trying to create a login script that collects the information a user posts and then creates a session if the user has provided the relevant information. Every time I try to login I get the error:

PHP Fatal error: Call to a member function bind_param() on boolean

I have provided my code below: require '../../../db-config.php'; require '../distributor-config.php';

$user_role = $_POST['user_role'];
$user_username = $_POST['user_username'];
$user_password = $_POST['user_password'];

$stmt = $conn->prepare("SELECT role, id, emailaddress, username, firstname, surname FROM users WHERE role = ?, username = ?, password = ?");
$stmt->bind_param("sss", $user_role, $user_username, $user_password);
$stmt->execute();

$stmt->bind_result($role, $id, $emailaddress, $username, $firstname, $surname);

while($stmt->fetch()) {
    if($stmt == 1 && $user_role == 'Manager') {
        session_start();
        $_SESSION['userinfo']['role'] = $id;
        $_SESSION['userinfo']['id'] = $id;
        $_SESSION['userinfo']['emailaddress'] = $emailaddress;
        $_SESSION['userinfo']['username'] = $username;
        $_SESSION['userinfo']['firstname'] = $firstname;
        $_SESSION['userinfo']['surname'] = $surname;

        header('location: ../manager-index.php?page=login&status=success');
    }

    elseif($stmt == 1 && $user_role == 'User') {
        session_start();
        $_SESSION['userinfo']['role'] = $id;
        $_SESSION['userinfo']['id'] = $id;
        $_SESSION['userinfo']['emailaddress'] = $emailaddress;
        $_SESSION['userinfo']['username'] = $username;
        $_SESSION['userinfo']['firstname'] = $firstname;
        $_SESSION['userinfo']['surname'] = $surname;

        header('location: ../user-index.php?page=login&status=success');
    }

    else {
        header('location: ../login.php?page=login&status=error');
    }
}

$stmt->close();
$conn->close();

did you install mysqli module and check it is enabled or not... — Naga, Oct 21 '16 at 09:18
look this place remove comma , add and in where condition WHERE role = ? and username = ? and password = ?"); instead of WHERE role = ?, username = ?, password = ?"); — JYoThI, Oct 21 '16 at 09:22
session_start(); should be once and also it should be in page top most place — JYoThI, Oct 21 '16 at 09:23
You are missing your exit(); methods after your header('Location:.., aswell — Jaquarh, Oct 21 '16 at 09:30

score 0 · Answer 1 · edited May 23 '17 at 11:59

0

The Problem is in the SQL-Statement. If the SQL fails, it returns FALSE

See: stackoverflow.com

$stmt = $conn->prepare("SELECT role, id, emailaddress, username, firstname, surname FROM users WHERE role = ? and username = ? and password = ?");

edited May 23 '17 at 11:59

Community

1
1

answered Oct 21 '16 at 09:24

drPhilip

96
4

score 0 · Answer 2 · answered Oct 21 '16 at 09:27

This is wrong :

$stmt = $conn->prepare("SELECT role, id, emailaddress, username, firstname, surname FROM users WHERE role = ?, username = ?, password = ?");

It should be :

$stmt = $conn->prepare("SELECT role, id, emailaddress, username, firstname, surname FROM users WHERE role = ? AND username = ? AND  password = ?");

score 0 · Answer 3 · answered Oct 21 '16 at 09:29

Look this place remove comma , add and in where condition

$stmt = $conn->prepare("SELECT role, id, emailaddress, username, firstname, surname FROM users WHERE role = ? AND username = ? AND  password = ?");

Docs refer the mysqli prepared statement

Note:

1) session_start(); should be once and also it should be in page top most place

Call to a member function bind_param() on boolean (MySQLi not running)

3 Answers3