PDO::getAvailableDrivers

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

PDO::getAvailableDrivers — Return an array of available PDO drivers

Description

public static array PDO::getAvailableDrivers ( void )

array pdo_drivers ( void )

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

Return Values

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

Examples

Example #1 A PDO::getAvailableDrivers() example


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

The above example will output something similar to:

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

User Contributed Notes

iabdullah

1 year 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.");
    }
?>

faruk at pamukbilisim dot com

2 years ago


/*
 * Coder : PamukBilisim
 * Date : 02/02/2014
 */
function getDriverList($ayrac = ",", $echo = true){
 
$ARR_DRIVERS = array();
$CountDrivers = 0;
foreach(PDO::getAvailableDrivers() AS $DRIVERS) :
      
    $CountDrivers++;
    $ARR_DRIVERS[$CountDrivers] = $DRIVERS;
 
endforeach;
 
$_GET_DRIVER_LIST = implode($ayrac, $ARR_DRIVERS);
 
if( $echo ): echo $_GET_DRIVER_LIST; else : return $_GET_DRIVER_LIST; endif;
 
}

Example :

echo "Kullanabileceğiniz pdo veritabanları : " . getDriverList(" , ", false);