How can PHP developers effectively handle database communication in object-oriented programming?

PHP developers can effectively handle database communication in object-oriented programming by creating a separate class specifically for database connections and operations. This class can encapsulate database logic, making it easier to manage and reuse code. By using prepared statements and parameterized queries, developers can prevent SQL injection attacks and ensure data integrity. 

<?php

class Database {
    private $host = 'localhost';
    private $username = 'root';
    private $password = '';
    private $dbname = 'my_database';
    private $conn;

    public function __construct() {
        $this->conn = new mysqli($this->host, $this->username, $this->password, $this->dbname);

        if ($this->conn->connect_error) {
            die("Connection failed: " . $this->conn->connect_error);
        }
    }

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

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

    public function bindParams($stmt, $params) {
        $types = '';
        $bindParams = array();

        foreach ($params as $param) {
            $types .= $param['type'];
            $bindParams[] = $param['value'];
        }

        $bindParams = array_merge(array($types), $bindParams);

        call_user_func_array(array($stmt, 'bind_param'), $this->refValues($bindParams));
    }

    private function refValues($arr){
        if (strnatcmp(phpversion(),'5.3') >= 0) //Reference is required for PHP 5.3+
        {
            $refs = array();
            foreach($arr as $key => $value)
                $refs[$key] = &$arr[$key];
            return $refs;
        }
        return $arr;
    }

    public function execute($stmt) {
        $stmt->execute();
        return $stmt->get_result();
    }

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

?>

Keywords

PHP object-oriented programming database communication SQL injection PDO

Related Questions