PHP SQLite support using phpinfo() and php.ini

Check PDO_SQLITE and SQLite3 support

Use extension_loaded() or PDO::getAvailableDrivers() to verify the SQLite interfaces available in the current PHP runtime.

<?php
$pdoSqlite = in_array('sqlite', PDO::getAvailableDrivers(), true);
$sqlite3 = extension_loaded('sqlite3');

echo 'PDO_SQLITE: ' . ($pdoSqlite ? 'available' : 'not available') . '
';
echo 'SQLite3: ' . ($sqlite3 ? 'available' : 'not available');
?>

PHP Portable Data Object ( PDO ) has a driver for SQLite database as pdo_sqlite. We can check the support for the driver by using phpinfo().
Use phpinfo() to get PHP installation details, code is here

<?php
echo phpinfo();
?>

Enabling SQLite database support in PHP using PDO and sqlite3 A1

pdo_sqlite

Part of the output is shown here with PDO SQLite support.

Checking PDO driver support using if - else

To check for different database PDO driver support we can use this code.

var_dump(PDO::getAvailableDrivers());

By using PDO::getAvailableDrivers() we can get an array of available PDO drivers, so we can use in_array() to check the presence of SQLite inside the array and 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>";
}
?>

If SQLite dirver support is missing then follow the instructions at php.ini here to enable the support. ( restart web server if php.ini is changed )

Enabling pdo_sqlite support inside php.ini

sqlite3 support

Check phpinfo() to know about sqlite3 library support.

Update or enable sqlite3 library support in your php.ini file.

Enable php_sqlite3.dll inside your php.ini file.

sqlite3 enable at php.ini file

Version details of sqlite3 library

$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) }

PHP Data Object PDO installation or enable and creating connection string to manage MySQL database

Download sample script for SQLite with instructions on how to use.

Connection to SQLite and create table

PHP SQLite PDO Functions

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

Check SQLite Support in PHP