Knowledge Base

How to connect to SQLite using PHP

This article describes how to connect to a SQLite database using PHP.

The SQLite database must already exist before you can use the following method. For information about how to create a SQLite database, please see this article.

Connecting to SQLite using PDO (PHP Data Objects)

PDO (PHP Data Objects) abstracts database access and enables you to create code that can handle different types of databases. One of the database types that PDO supports is SQLite.

There is a set of legacy PHP SQLite functions whose names start with sqlite_ (for example, sqlite_open). These functions only support SQLite2. You must use PDO to access SQLite3 databases.

To connect to SQLite using PDO, follow these steps:

  1. Use the following PHP code to connect to the SQLite database. Replace username with your A2 Hosting account username, path with the path to the database file, and filename with the name of the database file:
        $myPDO = new PDO('sqlite:/home/username/path/filename');

    For example, if you have a SQLite database named books.db in your home directory, and your username is example, you would use the following statement:

        $myPDO = new PDO('sqlite:/home/example/books.db');
  2. After the code connects to the SQLite database, you can run SQL queries and perform other operations. For example, the following PHP code runs a SQL query that extracts the last names from the employees table, and stores the result in the $result variable:

        $result = $myPDO->query("SELECT lastname FROM employees");

    Here is one way to access the result set's values and print them:

        foreach($result as $row)
            print $row['lastname'] . "\n";

More Information

For more information about PDO, please visit