Source of: /manual/en/sqlite.constants.php
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/book.sqlite.inc";
$setup = array (
'home' =>
array (
0 => 'index.php',
1 => 'PHP Manual',
),
'head' =>
array (
0 => 'UTF-8',
1 => 'en',
),
'this' =>
array (
0 => 'sqlite.constants.php',
1 => 'Predefined Constants',
),
'up' =>
array (
0 => 'book.sqlite.php',
1 => 'SQLite',
),
'prev' =>
array (
0 => 'sqlite.resources.php',
1 => 'Resource Types',
),
'next' =>
array (
0 => 'ref.sqlite.php',
1 => 'SQLite Functions',
),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);
manual_header();
?>
<div>
<h1>Predefined Constants</h1>
<p class="simpara">
The constants below are defined by this extension, and
will only be available when the extension has either
been compiled into PHP or dynamically loaded at runtime.
</p>
<p class="para">
The functions <a href="function.sqlite-fetch-array.php" class="function">sqlite_fetch_array()</a> and
<a href="function.sqlite-current.php" class="function">sqlite_current()</a> use a constant for
the different types of result arrays. The following constants are
defined:
</p>
<dl>
<strong class="title">SQLite result type constants</strong>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_ASSOC</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Columns are returned into the array having the field name as the array
index.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_BOTH</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Columns are returned into the array having both a numerical index
and the field name as the array index.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_NUM</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Columns are returned into the array having a numerical index to the
fields. This index starts with 0, the first field in the result.
</span>
</dd>
</dl>
<p class="para">
A number of functions may return status codes. The following constants are
defined:
</p>
<dl>
<strong class="title">SQLite status code constants</strong>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_OK</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Successful result.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_ERROR</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
SQL error or missing database.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_INTERNAL</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
An internal logic error in SQLite.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_PERM</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Access permission denied.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_ABORT</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Callback routine requested an abort.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_BUSY</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
The database file is locked.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_LOCKED</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
A table in the database is locked.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_NOMEM</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Memory allocation failed.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_READONLY</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Attempt to write a readonly database.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_INTERRUPT</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Operation terminated internally.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_IOERR</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Disk I/O error occurred.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_NOTADB</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
File opened that is not a database file.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_CORRUPT</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
The database disk image is malformed.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_FORMAT</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Auxiliary database format error.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_NOTFOUND</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
(Internal) Table or record not found.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_FULL</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Insertion failed because database is full.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_CANTOPEN</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Unable to open the database file.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_PROTOCOL</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Database lock protocol error.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_EMPTY</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
(Internal) Database table is empty.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_SCHEMA</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
The database schema changed.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_TOOBIG</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Too much data for one row of a table.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_CONSTRAINT</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Abort due to constraint violation.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_MISMATCH</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Data type mismatch.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_MISUSE</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Library used incorrectly.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_NOLFS</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Uses of OS features not supported on host.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_AUTH</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Authorized failed.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_ROW</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Internal process has another row ready.
</span>
</dd>
<dt class="varlistentry">
<span class="term">
<b><tt class="constant">SQLITE_DONE</tt></b>
(<a href="language.types.integer.php" class="type int">int</a>)
</span>
</dt><dd class="listitem">
<span class="simpara">
Internal process has finished executing.
</span>
</dd>
</dl>
</div>
<?php manual_footer(); ?>
