Connect SQLite with PHP

For Connecting SQLite database with PHP, you must have PHP and SQLite installed on your system.

If sqlite is not installed, first install sqlite by using the following command:

Install Sqlite-php connection driver

Follow the steps given below systematically:

Create a folder "phpsqliteconnect" in www directory.
Create two subfolders "app" and "db" inside "phpsqliteconnect".
Create a JSON file "composer.json" inside "phpsqliteconnect", having the following code:

{
    "autoload": {
        "psr-4": {
            "App\\": "app/"
        }
    }
}

Open the Command prompt, go to the phpsqliteconnect and execute the following code:

Now, you will get the following message:

Note: The composer will create a new folder named "vendor" automatically.

if composer is not installed then first install composer

Now create a file name "index.php" in the root folder "phpsqliteconnect", having the following code:

<?php
require 'vendor/autoload.php';
</textarea></div>
<hr/>
<h2 class="h2">Establish connection with SQLite database</h2>
<p>Create a new file "Config.php" inside the app folder, having the following code:</p>
<div class="codeblock"><textarea name="code" class="php">
<?php
 
namespace App;
 
class Config {
   /**
    * path to the sqlite file
    */
    const PATH_TO_SQLITE_FILE = 'db/javatpoint.db';
 
}

The constant PATH_TO_SQLITE_FILE is used to store the path to the sqlite database file inside the db folder.

Now, create a new SQLiteConnection.php file and add the SQLiteConnection class as follows:

<?php
namespace App;
 
/**
 * SQLite connnection
 */
class SQLiteConnection {
    /**
     * PDO instance
     * @var type 
     */
    private $pdo;
 
    /**
     * return in instance of the PDO object that connects to the SQLite database
     * @return \PDO
     */
    public function connect() {
        if ($this->pdo == null) {
            $this->pdo = new \PDO("sqlite:" . Config::PATH_TO_SQLITE_FILE);
        }
        return $this->pdo;
    }
}

After having all classes in places, you use the following command to generate the autoload file:

<?php

ini_set('display_errors', 1);
error_reporting(E_ALL ^ E_NOTICE);

require 'vendor/autoload.php';
 
use App\SQLiteConnection;
 
$pdo = (new SQLiteConnection())->connect();
if ($pdo != null)
    echo 'Connected to the SQLite database successfully!';
else
    echo 'Whoops, could not connect to the SQLite database!';

?>