Home >Database >Mysql Tutorial >How Can I Properly Access a MySQLi Connection from a Separate Class in PHP?

How Can I Properly Access a MySQLi Connection from a Separate Class in PHP?

Patricia Arquette
Patricia ArquetteOriginal
2024-12-10 16:22:09349browse

How Can I Properly Access a MySQLi Connection from a Separate Class in PHP?

Using MySQLi from Another Class in PHP

Problem Description:

The question seeks assistance in accessing a MySQLi connection established in a separate class from within another class. A database class with a connection property is created, and an API class attempts to access this connection. However, attempts to access the connection result in an internal server error.

Answer:

Bad Practices and Recommendations:

The provided code contains several bad practices that contribute to the error:

  • Extending a class (User) from the Database class is inappropriate.
  • The Database class lacks essential functionality.

It is recommended to:

  • Eliminate the Database class as it serves no meaningful purpose.
  • Create a single $db instance from vanilla mysqli.
  • Pass this instance as a constructor argument to classes that require a database connection.

Refactored Code:

database.php:

<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$db = new mysqli("localhost", "DBUserName", "UserPassword", "SelectedDB");
$db->set_charset('utf8mb4');

myapi.php:

<?php
class MyAPI
{
    protected $db;

    public function __construct($db, $request_uri, $postData, $origin)
    {
        $this->db = $db;
    }

    public function getUser($id)
    {
        $sql = "SELECT * FROM users where>

app.php:

<?php
# require_once 'Database.php';
# require_once 'myapi.php';
require 'vendor/autoload.php'; // autoloading is essential

$api = new MyAPI($db, $request_uri, $postData, $origin);
$user = $api->getUser($_POST['id']);

By following these recommendations, it is possible to access the MySQLi connection from another class effectively and without errors.

The above is the detailed content of How Can I Properly Access a MySQLi Connection from a Separate Class in PHP?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn