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.");
}
?>
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
Beschreibung
public static PDO::getAvailableDrivers
( void
) : array
pdo_drivers
( void
) : array
This function returns all currently available PDO drivers which can be used
in DSN parameter of
PDO::__construct().
Rückgabewerte
PDO::getAvailableDrivers() returns an array of PDO driver names. If no drivers are available, it returns an empty array.
Beispiele
Beispiel #1 A PDO::getAvailableDrivers() example
<?php
print_r(PDO::getAvailableDrivers());
?>
Das oben gezeigte Beispiel erzeugt eine ähnliche Ausgabe wie:
Array
(
[0] => mysql
[1] => sqlite
)
add a note
User Contributed Notes 2 notes
iabdullah ¶
4 years ago
faruk at pamukbilisim dot com ¶
5 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);
