[ class tree: ] [ index: ] [ all elements ]

Index of all elements

[ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ i ] [ l ] [ m ] [ n ] [ r ] [ s ] [ t ] [ u ] [ v ] [ _ ]

a

alterTable
in file sqlite.php, method MDB2_Driver_Manager_sqlite::alterTable()
    alter an existing table
top

b

beginTransaction
in file sqlite.php, method MDB2_Driver_sqlite::beginTransaction()
    Start a transaction or set a savepoint.
top

c

commit
in file sqlite.php, method MDB2_Driver_sqlite::commit()
    Commit the database changes done during a transaction that is in progress or release a savepoint. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.
connect
in file sqlite.php, method MDB2_Driver_sqlite::connect()
    Connect to the database
createConstraint
in file sqlite.php, method MDB2_Driver_Manager_sqlite::createConstraint()
    create a constraint on a table
createDatabase
in file sqlite.php, method MDB2_Driver_Manager_sqlite::createDatabase()
    create a new database
createIndex
in file sqlite.php, method MDB2_Driver_Manager_sqlite::createIndex()
    Get the stucture of a field into an array
createSequence
in file sqlite.php, method MDB2_Driver_Manager_sqlite::createSequence()
    create sequence
createTable
in file sqlite.php, method MDB2_Driver_Manager_sqlite::createTable()
    create a new table
currID
in file sqlite.php, method MDB2_Driver_sqlite::currID()
    Returns the current id of a sequence
top

d

databaseExists
in file sqlite.php, method MDB2_Driver_sqlite::databaseExists()
    check if given database name is exists?
disconnect
in file sqlite.php, method MDB2_Driver_sqlite::disconnect()
    Log out and disconnect from the database.
dropConstraint
in file sqlite.php, method MDB2_Driver_Manager_sqlite::dropConstraint()
    drop existing constraint
dropDatabase
in file sqlite.php, method MDB2_Driver_Manager_sqlite::dropDatabase()
    drop an existing database
dropIndex
in file sqlite.php, method MDB2_Driver_Manager_sqlite::dropIndex()
    drop existing index
dropSequence
in file sqlite.php, method MDB2_Driver_Manager_sqlite::dropSequence()
    drop existing sequence
dropTable
in file sqlite.php, method MDB2_Driver_Manager_sqlite::dropTable()
    drop an existing table
top

e

errorInfo
in file sqlite.php, method MDB2_Driver_sqlite::errorInfo()
    This method is used to collect information about an error
escape
in file sqlite.php, method MDB2_Driver_sqlite::escape()
    Quotes a string so it can be safely used in a query. It will quote the text so it can safely be used within a query.
top

f

$fix_assoc_fields_names
in file sqlite.php, variable MDB2_Driver_sqlite::$fix_assoc_fields_names
fetchRow
in file sqlite.php, method MDB2_Result_sqlite::fetchRow()
    Fetch a row and insert the data into an existing array.
top

g

getServerVersion
in file sqlite.php, method MDB2_Driver_sqlite::getServerVersion()
    return version information about the server
getTableConstraintDefinition
in file sqlite.php, method MDB2_Driver_Reverse_sqlite::getTableConstraintDefinition()
    Get the stucture of a constraint into an array
getTableFieldDefinition
in file sqlite.php, method MDB2_Driver_Reverse_sqlite::getTableFieldDefinition()
    Get the stucture of a field into an array
getTableIndexDefinition
in file sqlite.php, method MDB2_Driver_Reverse_sqlite::getTableIndexDefinition()
    Get the stucture of an index into an array
getTriggerDefinition
in file sqlite.php, method MDB2_Driver_Reverse_sqlite::getTriggerDefinition()
    Get the structure of a trigger into an array
getTypeDeclaration
in file sqlite.php, method MDB2_Driver_Datatype_sqlite::getTypeDeclaration()
    Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.
top

i

$identifier_quoting
in file sqlite.php, variable MDB2_Driver_sqlite::$identifier_quoting
top

l

lastInsertID
in file sqlite.php, method MDB2_Driver_sqlite::lastInsertID()
    Returns the autoincrement ID if supported or $id or fetches the current ID in a sequence called: $table.(empty($field) ? '' : '_'.$field)
listDatabases
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listDatabases()
    list all databases
listSequences
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listSequences()
    list all sequences in the current database
listTableConstraints
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listTableConstraints()
    list all constraints in a table
listTableFields
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listTableFields()
    list all fields in a table in the current database
listTableIndexes
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listTableIndexes()
    list all indexes in a table
listTables
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listTables()
    list all tables in the current database
listTableTriggers
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listTableTriggers()
    list all triggers in the database that reference a given table
listTableViews
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listTableViews()
    list the views in the database that reference a given table
listUsers
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listUsers()
    list all users
listViews
in file sqlite.php, method MDB2_Driver_Manager_sqlite::listViews()
    list all views in the current database
top

m

matchPattern
in file sqlite.php, method MDB2_Driver_Datatype_sqlite::matchPattern()
    build a pattern matching string
MDB2_BufferedResult_sqlite
in file sqlite.php, class MDB2_BufferedResult_sqlite
    MDB2 SQLite buffered result driver
MDB2_Driver_Datatype_sqlite
in file sqlite.php, class MDB2_Driver_Datatype_sqlite
    MDB2 SQLite driver
MDB2_Driver_Function_sqlite
in file sqlite.php, class MDB2_Driver_Function_sqlite
    MDB2 SQLite driver for the function modules
MDB2_Driver_Manager_sqlite
in file sqlite.php, class MDB2_Driver_Manager_sqlite
    MDB2 SQLite driver for the management modules
MDB2_Driver_Native_sqlite
in file sqlite.php, class MDB2_Driver_Native_sqlite
    MDB2 SQLite driver for the native module
MDB2_Driver_Reverse_sqlite
in file sqlite.php, class MDB2_Driver_Reverse_sqlite
    MDB2 SQlite driver for the schema reverse engineering module
MDB2_Driver_sqlite
in file sqlite.php, class MDB2_Driver_sqlite
    MDB2 SQLite driver
MDB2_Result_sqlite
in file sqlite.php, class MDB2_Result_sqlite
    MDB2 SQLite result driver
MDB2_Statement_sqlite
in file sqlite.php, class MDB2_Statement_sqlite
    MDB2 SQLite statement driver
top

n

nextID
in file sqlite.php, method MDB2_Driver_sqlite::nextID()
    Returns the next free id of a sequence
now
in file sqlite.php, method MDB2_Driver_Function_sqlite::now()
    Return string to call a variable with the current timestamp inside an SQL statement There are three special variables for current date and time.
numCols
in file sqlite.php, method MDB2_Result_sqlite::numCols()
    Count the number of columns returned by the DBMS in a query result.
numRows
in file sqlite.php, method MDB2_BufferedResult_sqlite::numRows()
    Returns the number of rows in a result object
top

r

random
in file sqlite.php, method MDB2_Driver_Function_sqlite::random()
    return string to call a function to get random value inside an SQL statement
replace
in file sqlite.php, method MDB2_Driver_sqlite::replace()
    Execute a SQL REPLACE query. A REPLACE query is identical to a INSERT query, except that if there is already a row in the table with the same key field values, the old row is deleted before the new row is inserted.
replace
in file sqlite.php, method MDB2_Driver_Function_sqlite::replace()
    return string to call a function to get a replacement inside an SQL statement.
rollback
in file sqlite.php, method MDB2_Driver_sqlite::rollback()
    Cancel any database changes done during a transaction or since a specific savepoint that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.
top

s

$string_quoting
in file sqlite.php, variable MDB2_Driver_sqlite::$string_quoting
sqlite.php
procedural page sqlite.php
sqlite.php
procedural page sqlite.php
sqlite.php
procedural page sqlite.php
sqlite.php
procedural page sqlite.php
sqlite.php
procedural page sqlite.php
sqlite.php
procedural page sqlite.php
seek
in file sqlite.php, method MDB2_BufferedResult_sqlite::seek()
    Seek to a specific row in a result set
setTransactionIsolation
in file sqlite.php, method MDB2_Driver_sqlite::setTransactionIsolation()
    Set the transacton isolation level.
substring
in file sqlite.php, method MDB2_Driver_Function_sqlite::substring()
    return string to call a function to get a substring inside an SQL statement
top

t

tableInfo
in file sqlite.php, method MDB2_Driver_Reverse_sqlite::tableInfo()
    Returns information about a table
top

u

unixtimestamp
in file sqlite.php, method MDB2_Driver_Function_sqlite::unixtimestamp()
    return string to call a function to get the unix timestamp from a iso timestamp
top

v

vacuum
in file sqlite.php, method MDB2_Driver_Manager_sqlite::vacuum()
    Optimize (vacuum) all the tables in the db (or only the specified table) and optionally run ANALYZE.
valid
in file sqlite.php, method MDB2_BufferedResult_sqlite::valid()
    Check if the end of the result set has been reached
top

_

_doQuery
in file sqlite.php, method MDB2_Driver_sqlite::_doQuery()
    Execute a query
_getAdvancedFKOptions
in file sqlite.php, method MDB2_Driver_Manager_sqlite::_getAdvancedFKOptions()
    Return the FOREIGN KEY query section dealing with non-standard options as MATCH, INITIALLY DEFERRED, ON UPDATE, ...
_getDatabaseFile
in file sqlite.php, method MDB2_Driver_sqlite::_getDatabaseFile()
    Builds the string with path+dbname+extension
_getIntegerDeclaration
in file sqlite.php, method MDB2_Driver_Datatype_sqlite::_getIntegerDeclaration()
    Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.
_mapNativeDatatype
in file sqlite.php, method MDB2_Driver_Datatype_sqlite::_mapNativeDatatype()
    Maps a native array description of a field to a MDB2 datatype and length
_modifyQuery
in file sqlite.php, method MDB2_Driver_sqlite::_modifyQuery()
    Changes a query string for various DBMS specific reasons
__construct
in file sqlite.php, method MDB2_Driver_sqlite::__construct()
    Constructor
__construct
in file sqlite.php, method MDB2_Driver_Function_sqlite::__construct()
    Constructor
top

Documentation generated on Mon, 11 Mar 2019 15:51:25 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.