bind_param() error - call to method function on bind_param() on a non-object

Question

I am very new to php and this is my first attempt at using mysqli. I can't seem to figure out why I am getting this error? I have reviewed similar questions on it but I still don't understand what the problem is.

Here is my code:

<?php
require_once('abstractDAO.php');

class customerDAO extends abstractDAO {

function __construct() {
    try{
        parent::__construct();
    } catch(mysqli_sql_exception $e){
        throw $e;
    }
}

public function getCustomers(){
    //The query method returns a mysqli_result object
    $result = $this->mysqli->query('SELECT * FROM customers');
    $customers = Array();

    if($result->num_rows >= 1){
        while($row = $result->fetch_assoc()){
            $customer = new Customer($row['customerName'], $row['phoneNumber'], $row['emailAddress']);
            $customers[] = $customer;
        }
        $result->free();
        return $customers;
    }
    $result->free();
    return false;
}

/*
 * This is an example of how to use a prepared statement
 * with a select query.
 */
public function getCustomer($customerName){
    $query = 'SELECT * FROM customers WHERE customerName = ?';
    $stmt = $this->mysqli->prepare($query);
    $stmt->bind_param('s', $customerName);
    $stmt->execute();
    $result = $stmt->get_result();
    if($result->num_rows == 1){
        $temp = $result->fetch_assoc();
        $customer = new Customer($temp['customerName'], $temp['phoneNumber'], $temp['emailAddress']);
        $result->free();
        return $customer;
    }
    $result->free();
    return false;
}

public function addCustomer($customer){

    if(!$this->mysqli->connect_errno){

        $query = 'INSERT INTO customers VALUES (?,?,?)';

        $stmt = $this->mysqli->prepare($query);

        $stmt->bind_param('sss', 
                $customer->getCustomerName(), 
                $customer->getPhoneNumber(), 
                $customer->getEmailAddress());

        $stmt->execute();

        if($stmt->error){
            return $stmt->error;
        } else {
            return $customer->getCustomerName() . ' added successfully!';
        }
    } else {
        return 'Could not connect to Database.';
    }
}

}

?>

Let me know if you need any more code snippets. Any suggestions would be very much appreciated!

Are you getting the error in addCustomer, getCustomer or both? Does get getCustomers work? — robbmj
– robbmj, Commented Nov 15, 2014 at 15:48
Here is the error message: Fatal error: Call to a member function bind_param() on a non-object in C:\xampp\htdocs\Week11Lab\customerDAO.php on line 59 — Mac
– Mac, Commented Nov 17, 2014 at 17:07
I'm getting the error in addCustomer. I don't know if getCustomers works as I can't add an initial customer. — Mac
– Mac, Commented Nov 17, 2014 at 17:35
have a look at my answer and try the $mysqli->error property what does it say? Also change your insert statement so that it matches mine. — robbmj
– robbmj, Commented Nov 17, 2014 at 17:48
I get the following messages: Notice: Undefined variable: mysqli in C:\xampp\htdocs\Week11Lab\customerDAO.php on line 57 — Mac
– Mac, Commented Nov 17, 2014 at 17:54

robbmj · Accepted Answer · 2014-11-17 21:46:50Z

1

mysqli::prepare returns false if there was an error.

false is not an object, thus you get the error:

call to method function on bind_param() on a non-object.

You can get the error message by examining the $mysqli->error property.

public function addCustomer($customer) {
    if(!$this->mysqli->connect_errno) {

        $query = 'INSERT INTO customers (customerName,phoneNumber,emailAddress) 
                                 VALUES (?,?,?)';

        $stmt = $this->mysqli->prepare($query);
        if (!$stmt) {
            $err = $this->mysqli->error;
            echo $err;
            // do something with $err
            return $err;
        }

        $stmt->bind_param('sss', 
            $customer->getCustomerName(), 
            $customer->getPhoneNumber(), 
            $customer->getEmailAddress());

        if(!$stmt->execute()){
            return $stmt->error;
        } else {
            return $customer->getCustomerName() . ' added successfully!';
        }
    } else {
        return 'Could not connect to Database.';
    }
}

The most typical reason why prepare fails is a malformed or invalid query, but without knowing the customer schema or constraints I can't be sure what your particular problem is.

edited Nov 17, 2014 at 21:46

answered Nov 15, 2014 at 16:02

robbmj

16.6k8 gold badges41 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

robbmj Over a year ago

@macattack Please see my updated answer, it focuses on the addCustomer method. You should be able to copy and paste it directly into your customerDAO class

Mac Over a year ago

Thanks that's helping with the debugging. Still not there though!

Mac Over a year ago

I have this error now which is at bind_param: Fatal error: Call to undefined method Customer::getCustomerName() in C:\xampp\htdocs\Week11Lab\customerDAO.php on line 92

robbmj Over a year ago

@macattack Your customer class does not have a method called getCustomerName. In either case your DB issue looks to be solved. Please consider up voting and accepting my answer.

Collectives™ on Stack Overflow

bind_param() error - call to method function on bind_param() on a non-object

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related