<!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.
As of PHP 7.4.0 <a href="http://sqlite.org/" class="link external">» libsqlite</a> ≥ 3.5.0 is required.
Formerly, the bundled libsqlite could have been used instead, and was the
default, if <em>[=DIR]</em> has been omitted.
</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.sqlitecreatecollation.html">PDO::sqliteCreateCollation</a> — Registers a User Defined Function for use as a collating function 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>
