/** * Checks and returns the SQL query to the appropriate driver * * */ private function sql() { // Retrieves the name of the current driver $driver = PDO4You::getDriver(); switch ($driver) { case 'mysql': case 'pgsql': case 'cubrid': case 'sqlite': $sql = 'SELECT * FROM books LIMIT 2;'; break; case 'mssql': case 'dblib': case 'sybase': case 'sqlsrv': $sql = 'SELECT TOP 2 * FROM books;'; break; case 'oracle': $sql = 'SELECT * FROM (SELECT ROW_NUMBER() OVER AS LIMIT FROM books) WHERE LIMIT <= 2;'; break; default: $sql = null; } return $sql; }