Why Am I Getting the \'Call to a Member Function prepare() on a non-Object\' Error in PHP?

PHP: Addressing the "Call to a Member Function prepare() on a non-Object" Error

When utilizing prepared statements in PHP, the "Call to a member function prepare() on a non-object" error indicates an incorrect or missing database connection. To resolve this issue, ensure that the database connection is properly created and accessible within the function.

In the example provided, the error occurs because the $DBH variable is not accessible within the selectInfo() function. This is due to variable scoping. To address this, we have several options:

1. Use the global Keyword:

   • Make the $DBH variable global by prepending it with global, allowing the function to access it. However, this is not recommended as it pollutes the global namespace.

2. Pass the Database Connection as a Parameter:

   • Pass the $DBH variable as a parameter to the selectInfo() function, ensuring its availability within the function. This maintains variable locality but requires modifying the function call.

3. Create a Database Connection Retrieval Function:

   • Define a function to retrieve the database connection, making it available to functions that require it. This encapsulates the connection logic and avoids referencing global variables.

4. Implement a Database Wrapper Class:

   • Encapsulate database access within a class, providing an interface to perform operations without directly manipulating the connection. This allows for centralized connection management and simplifies database interactions.

5. Use a Pre-Built Framework or Library:

   • Utilize established frameworks or database access libraries, which provide a structured and efficient way to handle database connections and operations, including prepared statements.

By employing one of these methods, you can establish a proper connection and resolve the "Call to a member function prepare() on a non-object" error, allowing your prepared statement to execute successfully.

The above is the detailed content of Why Am I Getting the \'Call to a Member Function prepare() on a non-Object\' Error in PHP?. For more information, please follow other related articles on the PHP Chinese website!