How to connect to SQLite using PHP

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

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.

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:

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

   <?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
       $result = $myPDO->query("SELECT lastname FROM employees");
   ?>
   

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

   <?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.