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:

snippet
sudo apt-get install sqlite3 libsqlite3-dev

Install Sqlite-php connection driver

snippet
sudo apt install php-sqlite3

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:
snippet
{
    "autoload": {
        "psr-4": {
            "App\\": "app/"
        }
    }
}

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

snippet
composer update
SQLite Connect sqlite with php 1

Now, you will get the following message:

SQLite Connect sqlite with php 2
Note
Note: The composer will create a new folder named "vendor" automatically.

if composer is not installed then first install composer

snippet
apt install composer

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

snippet
<?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:

snippet
<?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:

snippet
composer dump-autoload -o
snippet
<?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!';

?>
SQLite Connect sqlite with php 3

Now, open the localhost an your browser http://localhost/phpsqliteconnect/

SQLite Connect sqlite with php 4

Connection is established successfully. You can also see the tree sturcture by by using the tree command:

SQLite Connect sqlite with php 5
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents