<?Php
echo phpinfo();
?>
var_dump(PDO::getAvailableDrivers());
By using PDO::getAvailableDrivers()
we can get an array of available PDO drivers, so we can use if-else to display appropriate message to user .
<?php
if (!in_array("sqlite",PDO::getAvailableDrivers(),TRUE))
{
throw new PDOException ("Cannot work without a proper database setting up");
}else{
echo "<font color='green'>Database setup is OK</font>";
}
?>
php_sqlite3.dll
inside your php.ini file. $ver_dtl = SQLite3::version();
echo $ver_dtl['versionString'] . "<br>";
echo $ver_dtl['versionNumber'] . "<br>";
var_dump($ver_dtl);
Output is here ( may change based on your installation )
3.8.10.2
3008010
array(2) { ["versionString"]=> string(8) "3.8.10.2" ["versionNumber"]=> int(3008010) }
Download sample script for SQLite with instructions on how to use.