PDO::getAvailableDrivers

pdo_drivers

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 1.0.3)

PDO::getAvailableDrivers -- pdo_drivers Return an array of available PDO drivers

Descrierea

public static PDO::getAvailableDrivers ( ) : array
pdo_drivers ( ) : array

This function returns all currently available PDO drivers which can be used in DSN parameter of PDO::__construct().

Valorile întoarse

PDO::getAvailableDrivers() returns an array of PDO driver names. If no drivers are available, it returns an empty array.

Exemple

Example #1 A PDO::getAvailableDrivers() example

<?php
print_r
(PDO::getAvailableDrivers());
?>

Exemplul de mai sus va afișa ceva similar cu:

Array
(
    [0] => mysql
    [1] => sqlite
)

add a note add a note

User Contributed Notes 1 note

up
6
iabdullah
10 years ago
Since the method is a static, one practice is using it to check whether a specific server database driver is available and configured correctly with PDO before establishing the connection:
<?php
try {
    if (!
in_array("mysql",PDO::getAvailableDrivers(),TRUE))
    {
        throw new
PDOException ("Cannot work without a proper database setting up");
    }
}
catch (
PDOException $pdoEx)
{
    echo
"Database Error .. Details :<br /> {$pdoEx->getMessage()}";
}
?>

or to check for any driver in general:
<?php
   
if (empty(PDO::getAvailableDrivers()))
    {
        throw new
PDOException ("PDO does not support any driver.");
    }
?>
To Top