Call to a member function prepare() on a non-object PHP Help

by

It’s a scoping error. You’re making $DBH a global variable. So when you enter the function, the global variable is not available. You have 5 real options.

1. Use the global keyword

function doSomething() {
    global $DBH;
    //...

This is not a good idea, since it makes maintenance and testing a PITA. Imagine trying to debug that function call. You now need to go find out where $DBH is defined to try to figure out what’s going on…

2. Make $DBH a parameter to the function

function doSomething(MySQLi $DBH) {

It has the advantage of being explicit. But it’s still not great since the calling code then needs to keep track of the global variable.

3. Create a function to “get” the $DBH object

function getDBH() {
    static $DBH = null;
    if (is_null($DBH)) {
        $DBH = new mysqli(...);
    }
    return $DBH;
}

function doSomething() {
    $DBH = getDBH();
}

This has the advantage of getting around the global variable problem completely. But it’s also hard to have multiple connections or re-use any of the code for other connections.

4. Create a class to wrap database access

class Database {
    public function __construct($host, $user, $pass) {
        $this->DBH = new MySQli($host, $user, $pass);
    }
    public function doSOmething() {
        $this->DBH->foo();
    }
}

This encapsulates everything for you. All database access will go through a single class, so you don’t need to worry about global variable access or anything else.

5. Use a pre-built class/framework

This is the best option, since you don’t need to worry about doing it yourself.

Database Access Classes:

Full Frameworks:

Really, the choices are endless. Find something you like, and stick with it. It really will make your life easier…

More Related Contents:

  1. Use an array in a mysqli prepared statement: `WHERE .. IN(..)` query [duplicate]
  2. Call to a member function bind_param() on a non-object [duplicate]
  3. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  4. How to use mysqli prepared statements?
  5. MySQLi prepared statements error reporting [duplicate]
  6. Example of how to use bind_result vs get_result
  7. How to bind mysqli bind_param arguments dynamically in PHP?
  8. mysqli: can it prepare multiple queries in one statement?
  9. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  10. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  11. PHP UPDATE prepared statement
  12. using nulls in a mysqli prepared statement
  13. mySQLi prepared statement unable to get_result()
  14. MySQLi prepared statements with IN operator [duplicate]
  15. Is mysql_real_escape_string() necessary when using prepared statements?
  16. Using fetch_assoc on prepared statements
  17. store_result() and get_result() in mysql returns false
  18. Using wildcards in prepared statement – MySQLi
  19. bind_param Number of variables doesn’t match number of parameters in prepared statement
  20. How to prepare statement for update query? [duplicate]
  21. Using wildcards in prepared statement
  22. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  23. How to run the bind_param() statement in PHP?
  24. Is using prepared statements necessary? [duplicate]
  25. Using Prepared Statement, how I return the id of the inserted row?
  26. Should I use mysqli_real_escape_string or should I use prepared statements? [duplicate]
  27. Dynamically bind mysqli_stmt parameters and then bind result
  28. Check to see if an email is already in the database using prepared statements
  29. Is there any way to print the actual query that mysqli->execute() makes?
  30. When should I close a database connection in PHP?

Leave a Comment