Is it standard practice for public methods in PHP classes to directly execute queries or should they call private methods to handle query execution?

It is generally recommended to have public methods in PHP classes call private methods to handle query execution, rather than directly executing queries. This separation of concerns helps improve code maintainability, readability, and reusability. By delegating query execution to private methods, you can easily make changes to the database interaction logic without affecting the public interface of the class. 

class DatabaseHandler {
    private $connection;

    public function __construct($connection) {
        $this->connection = $connection;
    }

    public function getUserById($userId) {
        $query = "SELECT * FROM users WHERE id = :id";
        $params = array(':id' => $userId);
        return $this->executeQuery($query, $params);
    }

    private function executeQuery($query, $params) {
        // Code to execute query using $this->connection
        // Return query result
    }
}

Keywords

PHP public methods private methods query execution classes

Related Questions