Connecting to SQLite using PHP

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

📘

Note

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.

📘

Note

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 hosting.com account username, path with the path to the database file, and filename with the name of the database file:

   PHP

   <?php
       $myPDO = new PDO('sqlite:/home/username/path/filename');
   ?>
   

   📘

   Note

   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:

   PHP

   <?php
       $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:

   PHP

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

   👍

   Tip

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

   PHP

   <?php
       foreach($result as $row)
       {
           print $row['lastname'] . "\n";
       }
   ?>
   

More Information

For more information about PDO, please visit http://www.php.net/manual/en/book.pdo.php.

Related Articles

• Connecting to SQLite from the command line