Introducción
This is an extension for the SQLite Embeddable SQL Database Engine_
SQLite is a C library that implements an embeddable SQL database engine_
Programs that link with the SQLite library can have SQL database access
without running a separate RDBMS process_
SQLite is not a client library used to connect to a big database server_
SQLite is the server_ The SQLite library reads and writes directly to and from
the database files on disk_
Installation
Read the INSTALL file, which comes with the package_ Or just use the PEAR
installer with "pear install sqlite"_
SQLite itself is already included, You do not need to install
any additional software_
Windows users may download the DLL version of the SQLite extension here:
(php_sqlite_dll)_
Contact Information
Any questions about the extension should be asked on one of the
PHP Mailing lists_
Requerimientos
In order to have these functions available, you must compile PHP with
SQLite support, or load the SQLite extension dynamically from your
php_ini_
Tipos de recursos
There are two resources used in the SQLite Interface_ The first one is the
database connection, the second one the result set_
Predefined Constants
The functions sqlite_fetch_array() and
sqlite_current() use a constant for
the different types of result arrays_ The following constants are
defined:
Tabla 1_ SQLite fetch constants
| constant | meaning |
|---|
| SQLITE_ASSOC |
Columns are returned into the array having the fieldname as the array
index_
|
| SQLITE_BOTH |
Columns are returned into the array having both a numerical index
and the fieldname as the array index_
|
| SQLITE_NUM |
Columns are returned into the array having a numerical index to the
fields_ This index starts with 0, the first field in the result_
|
Configuración en tiempo de
ejecución
El comportamiento de estas
funciones está afectado por los valores definidos en
php_ini_
Tabla 2_ SQLite Configuration Options
| Name | Default | Changeable |
|---|
| sqlite_assoc_case | 0 | PHP_INI_ALL |
For further details and definition of the PHP_INI_* constants see
ini_set()_
A continuación se
presenta una corta explicación de las directivas de
configuración
- sqlite_assoc_case
int
Whether to use mixed case (0), upper case
(1) or lower case (2) hash
indexes_
This option is primarily useful when you need compatibility with other
database systems, where the names of the columns are always returned as
uppercase or lowercase, regardless of the case of the actual field names
in the database schema_
The SQLite library returns the column names in their natural case (that
matches the case you used in your schema)_ When
sqlite_assoc_case is set to 0
the natural case will be preserved_ When it is set to
1 or 2, PHP will apply case
folding on the hash keys to upper_ or lower_case the keys, respectively_
Use of this option incurrs a slight performance penalty, but is MUCH
faster than performing the case folding yourself using PHP script_
Zona Clientes
Entrar
