What are the best practices for incorporating MySQL queries in a PHP class?

When incorporating MySQL queries in a PHP class, it is best practice to separate the database logic from the business logic to maintain clean and organized code. One way to achieve this is by creating methods within the class that handle database operations, such as querying, inserting, updating, and deleting data. 

class Database {
    private $conn;

    public function __construct($host, $username, $password, $database) {
        $this->conn = new mysqli($host, $username, $password, $database);
        if ($this->conn->connect_error) {
            die("Connection failed: " . $this->conn->connect_error);
        }
    }

    public function query($sql) {
        return $this->conn->query($sql);
    }

    public function insert($table, $data) {
        $keys = implode(',', array_keys($data));
        $values = implode("','", array_values($data));
        $sql = "INSERT INTO $table ($keys) VALUES ('$values')";
        return $this->query($sql);
    }

    public function update($table, $data, $condition) {
        $set = '';
        foreach ($data as $key => $value) {
            $set .= "$key = '$value',";
        }
        $set = rtrim($set, ',');
        $sql = "UPDATE $table SET $set WHERE $condition";
        return $this->query($sql);
    }

    public function delete($table, $condition) {
        $sql = "DELETE FROM $table WHERE $condition";
        return $this->query($sql);
    }

    public function __destruct() {
        $this->conn->close();
    }
}

// Example of using the Database class
$db = new Database('localhost', 'username', 'password', 'database');
$result = $db->query("SELECT * FROM users");

Keywords

MySQL PHP class queries database optimization

Related Questions