{"id":894,"date":"2016-05-14T09:19:44","date_gmt":"2016-05-14T02:19:44","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=894"},"modified":"2024-10-29T08:04:16","modified_gmt":"2024-10-29T01:04:16","slug":"connect","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-php\/connect\/","title":{"rendered":"SQLite PHP: Connecting to SQLite Databases"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to connect to an SQLite database from PHP using PDO.<\/p>\n\n\n\n

PHP includes the SQLite extension by default, so you don’t need to configure it to work with SQLite.<\/p>\n\n\n\n

Creating a new SQLite database<\/h2>\n\n\n\n

Step 1. Open your terminal and create a new project directory in your web server:<\/p>\n\n\n

mkdir php-sqlite\ncd php-sqlite<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 2. Create a new directory called database<\/code> to store the SQLite database file:<\/p>\n\n\n
mkdir database<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 3. Create a new file config.php<\/code> to store the path to the SQLite database file:<\/p>\n\n\n
<?php<\/span>\n\n$db = '.\/database\/my.db'<\/span>;<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
In the config.php<\/code> file, we define a variable $db<\/code> that stores the path to the SQLite file in the database<\/code> directory.<\/p>\n\n\n\n
Step 4. Create the connect.php<\/code> file with the following code:<\/p>\n\n\n
<?php<\/span>\n\nrequire_once<\/span> 'config.php'<\/span>;\n\n$dsn = \"sqlite:$db\"<\/span>;\n\ntry<\/span> {\n    $pdo = new<\/span> \\PDO($dsn);\n    echo<\/span> 'Connected to the SQLite database successfully!'<\/span>;\n} catch<\/span> (\\PDOException $e) {\n    echo<\/span> $e->getMessage();\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
How it works.<\/p>\n\n\n\n
First, load the config.php<\/code> file using the require_once<\/code> construct:<\/p>\n\n\n
require_once<\/span> 'config.php'<\/span>;<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The require_once<\/code> will run the config.php<\/code> that brings the $db<\/code> variable into the connect.php<\/code> file.<\/p>\n\n\n\n
Second, define a variable $dsn<\/code> that stores the data source name of the SQLite database file:<\/p>\n\n\n
$dsn = \"sqlite:$db\"<\/span>;<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
SQLite dsn<\/code> consists of the following elements:<\/p>\n\n\n\n