<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <title>SQLite Functions (PDO_SQLITE)</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="pdo.pgsqllobunlink.html">PDO::pgsqlLOBUnlink</a></div> <div class="next" style="text-align: right; float: right;"><a href="ref.pdo-sqlite.connection.html">PDO_SQLITE DSN</a></div> <div class="up"><a href="pdo.drivers.html">PDO Drivers</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="ref.pdo-sqlite" class="reference"> <h1 class="title">SQLite Functions (PDO_SQLITE)</h1> <div class="partintro"> <div class="section" id="pdo-sqlite.intro"> <h2 class="title">Introduction</h2> <p class="para"> PDO_SQLITE is a driver that implements the <a href="intro.pdo.html" class="link">PHP Data Objects (PDO) interface</a> to enable access to SQLite 3 databases. </p> <p class="para"> In PHP 5.1, the <a href="ref.sqlite.html" class="link">SQLite</a> extension also provides a driver for SQLite 2 databases; while it is not technically a part of the PDO_SQLITE driver, it behaves similarly, so it is documented alongside it. The SQLite 2 driver for PDO is provided primarily to make it easier to import legacy SQLite 2 database files into an application that uses the faster, more efficient SQLite 3 driver. As a result, the SQLite 2 driver is not as feature-rich as the SQLite 3 driver. </p> <blockquote class="note"><p><strong class="note">Note</strong>: <p class="para"> PDO_SQLITE allows using strings apart from streams together with <strong><code>PDO::PARAM_LOB</code></strong>. </p> </p></blockquote> </div> <div class="section" id="ref.pdo-sqlite.installation"> <h2 class="title">Installation</h2> <p class="para"> The PDO_SQLITE PDO driver is enabled by default. To disable, <strong class="option configure">--without-pdo-sqlite[=DIR]</strong> may be used, where the optional <em>[=DIR]</em> is the sqlite base install directory. </p> </div> </div> <h2>Table of Contents</h2><ul class="chunklist chunklist_reference"><li><a href="ref.pdo-sqlite.connection.html">PDO_SQLITE DSN</a> — Connecting to SQLite databases</li><li><a href="pdo.sqlitecreateaggregate.html">PDO::sqliteCreateAggregate</a> — Registers an aggregating User Defined Function for use in SQL statements</li><li><a href="pdo.sqlitecreatefunction.html">PDO::sqliteCreateFunction</a> — Registers a User Defined Function for use in SQL statements</li></ul> </div> <hr /><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="pdo.pgsqllobunlink.html">PDO::pgsqlLOBUnlink</a></div> <div class="next" style="text-align: right; float: right;"><a href="ref.pdo-sqlite.connection.html">PDO_SQLITE DSN</a></div> <div class="up"><a href="pdo.drivers.html">PDO Drivers</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>