sql 
[ doc home ] [ class tree: sql ] [ index: sql ] [ all elements ]

Element index for package sql

[ a ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ i ] [ l ] [ m ] [ p ] [ q ] [ r ] [ s ] [ u ]

a

asyncQuery
in file IsterSqlQuery.php, method IsterSqlQuery::asyncQuery()
    Execute an asynchronous database query.
asyncQuery
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::asyncQuery()
    Send an asynchronous query.
asyncQuery
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::asyncQuery()
    Send an asynchronous query.
asyncQuery
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::asyncQuery()
    Send an asynchronous query.
top

c

close
in file IsterSqlConnection.php, method IsterSqlConnection::close()
    Close the current connection.
close
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::close()
    Close the current connection.
close
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::close()
    Close the current connection.
close
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::close()
    Close the current connection.
connect
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::connect()
    Establish a connection.
connect
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::connect()
    Establish a connection.
connect
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::connect()
    Establish a connection.
connect
in file IsterSqlConnection.php, method IsterSqlConnection::connect()
    Establish a connection to the databse server.
count
in file IsterSqlRow.php, method IsterSqlRow::count()
    Get the number of columns in row.
countPages
in file IsterSqlPager.php, method IsterSqlPager::countPages()
    Count the pages in the current result set.
countRows
in file IsterSqlQuery.php, method IsterSqlQuery::countRows()
    Count the rows of the current result set.
countRows
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::countRows()
    Count the rows in the current result set.
countRows
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::countRows()
    Count the rows in the current result set.
countRows
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::countRows()
    Count the rows in the current result set.
top

d

delete
in file IsterSqlDataObject.php, method IsterSqlDataObject::delete()
    Delete the object's data from database.
top

e

escape
in file IsterSqlDataObject.php, method IsterSqlDataObject::escape()
    Escape a string.
escapeString
in file IsterSqlQuery.php, method IsterSqlQuery::escapeString()
    Escape a string.
escapeString
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::escapeString()
escapeString
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::escapeString()
    Escape a string.
escapeString
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::escapeString()
    Escape a string.
execute
in file IsterSqlFunction.php, method IsterSqlFunction::execute()
    Execute a (Lambda :-)function
executeByName
in file IsterSqlFunction.php, method IsterSqlFunction::executeByName()
    Execute a function identified by name.
top

f

fetchAll
in file IsterSqlQuery.php, method IsterSqlQuery::fetchAll()
    Fetch all IsterSqlRow objects from the current result set.
fetchObject
in file IsterSqlQuery.php, method IsterSqlQuery::fetchObject()
    Alias of fetchRow().
fetchObject
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::fetchObject()
    Fetch the next IsterSqlRow object of the current result set.
fetchObject
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::fetchObject()
    Fetch the next IsterSqlRow object of the current result set.
fetchObject
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::fetchObject()
    Fetch the next IsterSqlRow object of the current result set.
fetchRow
in file IsterSqlQuery.php, method IsterSqlQuery::fetchRow()
    Fetch an IsterSqlRow object from the current result set.
free
in file IsterSqlQuery.php, method IsterSqlQuery::free()
    Free the current result set.
free
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::free()
    Free the current result set.
free
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::free()
    Free the current result set.
free
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::free()
    Free the current result set.
func
in file IsterSqlDataObject.php, method IsterSqlDataObject::func()
    Execute a function on the database.
top

g

getColumnNames
in file IsterSqlRow.php, method IsterSqlRow::getColumnNames()
    Get the names of all columns.
getColumnObject
in file IsterSqlRow.php, method IsterSqlRow::getColumnObject()
    Get an IsterSqlColumn object by name.
getColumnValue
in file IsterSqlRow.php, method IsterSqlRow::getColumnValue()
    Get the value of a column by name.
getConnection
in file IsterSqlConnection.php, method IsterSqlConnection::getConnection()
    Return the current connection parameters.
getConnection
in file IsterSqlDriver.php, method IsterSqlDriver::getConnection()
    Return the current connection parameters.
getDriver
in file IsterSqlConnection.php, method IsterSqlConnection::getDriver()
    Get the driver object of this connection.
getFunction
in file IsterSqlFunction.php, method IsterSqlFunction::getFunction()
    Get the function body of a function.
getID
in file IsterSqlDataObject.php, method IsterSqlDataObject::getID()
    Get the object's unique identifier name and value.
getLastError
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::getLastError()
    Get the last PostgreSQL or driver error.
getLastError
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::getLastError()
    Get the last MySQL or driver error.
getLastError
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::getLastError()
    Get the last MySQL or driver error.
getLastError
in file IsterSqlConnection.php, method IsterSqlConnection::getLastError()
    Get the last error of the driver.
getLastMethod
in file IsterSqlDataObject.php, method IsterSqlDataObject::getLastMethod()
    Get id of last executed method.
getLink
in file IsterSqlConnection.php, method IsterSqlConnection::getLink()
    Get the link ressource.
getLink
in file IsterSqlDriver.php, method IsterSqlDriver::getLink()
    Return the current connection resource.
getMaxlen
in file IsterSqlColumn.php, method IsterSqlColumn::getMaxlen()
    Dependant on the driver this method returns the maximum length of the field of a given result set or the printed length of the current field.
getName
in file IsterSqlDataObject.php, method IsterSqlDataObject::getName()
    Get the name of the object.
getNextPage
in file IsterSqlPager.php, method IsterSqlPager::getNextPage()
    Let the passed IsterSQLFunction object execute the query to fetch the next page.
getPrevNext
in file IsterSqlPager.php, method IsterSqlPager::getPrevNext()
getPrintLen
in file IsterSqlColumn.php, method IsterSqlColumn::getPrintLen()
getRandomPage
in file IsterSqlPager.php, method IsterSqlPager::getRandomPage()
    Let the passed IsterSQLFunction object fetch a single page randomly.
getTable
in file IsterSqlColumn.php, method IsterSqlColumn::getTable()
    This attribute may not be available for all drivers.
getType
in file IsterSqlColumn.php, method IsterSqlColumn::getType()
getValue
in file IsterSqlColumn.php, method IsterSqlColumn::getValue()
getWindow
in file IsterSqlPager.php, method IsterSqlPager::getWindow()
    Provide a window for very large result sets.
top

h

hasFunction
in file IsterSqlFunction.php, method IsterSqlFunction::hasFunction()
    Check whether a function is set in the function table.
hasList
in file IsterSqlDataObject.php, method IsterSqlDataObject::hasList()
    Test if a requested list has already be created.
top

i

$id
in file IsterSqlDataObject.php, variable IsterSqlDataObject::$id
    The object's unique identifier.
IsterSqlColumn.php
procedural page IsterSqlColumn.php
IsterSqlConnection.php
procedural page IsterSqlConnection.php
IsterSqlDataObject.php
procedural page IsterSqlDataObject.php
IsterSqlDriverDbx.php
procedural page IsterSqlDriverDbx.php
IsterSqlDriverMysql.php
procedural page IsterSqlDriverMysql.php
IsterSqlDriverPostgresql.php
procedural page IsterSqlDriverPostgresql.php
IsterSqlDriver.php
procedural page IsterSqlDriver.php
IsterSqlFunction.php
procedural page IsterSqlFunction.php
IsterSqlPager.php
procedural page IsterSqlPager.php
IsterSqlQuery.php
procedural page IsterSqlQuery.php
IsterSqlRow.php
procedural page IsterSqlRow.php
info
in file IsterSqlConnection.php, method IsterSqlConnection::info()
    Get an array with information about the driver and the connection.
info
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::info()
    This function returns useful information about the active driver.
info
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::info()
    This function returns useful information about the active driver.
info
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::info()
    This function returns useful information about the active driver.
insert
in file IsterSqlDataObject.php, method IsterSqlDataObject::insert()
    Insert object's attributes into database.
isConnected
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::isConnected()
    Check whether a connection is established.
isConnected
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::isConnected()
    Check whether a connection is established.
isConnected
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::isConnected()
    Check whether a connection is established.
isConnected
in file IsterSqlConnection.php, method IsterSqlConnection::isConnected()
    Check whether a connection is established.
isLo
in file IsterSqlColumn.php, method IsterSqlColumn::isLo()
IsterSqlColumn
in file IsterSqlColumn.php, method IsterSqlColumn::IsterSqlColumn()
    Constructor
IsterSqlColumn
in file IsterSqlColumn.php, class IsterSqlColumn
    This class represents a single field of a database table row.
IsterSqlConnection
in file IsterSqlConnection.php, class IsterSqlConnection
    This class represents database connections.
IsterSqlConnection
in file IsterSqlConnection.php, method IsterSqlConnection::IsterSqlConnection()
    Constructor
IsterSqlDataObject
in file IsterSqlDataObject.php, class IsterSqlDataObject
    This class represents a persistent data container.
IsterSqlDataObject
in file IsterSqlDataObject.php, method IsterSqlDataObject::IsterSqlDataObject()
    Constructor
IsterSqlDriver
in file IsterSqlDriver.php, method IsterSqlDriver::IsterSqlDriver()
    Constructor
IsterSqlDriver
in file IsterSqlDriver.php, class IsterSqlDriver
    Base class for SQL drivers.
IsterSqlDriverDbx
in file IsterSqlDriverDbx.php, class IsterSqlDriverDbx
    The Dbx driver of the package.
IsterSqlDriverDbx
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::IsterSqlDriverDbx()
    Constructor
IsterSqlDriverMysql
in file IsterSqlDriverMysql.php, class IsterSqlDriverMysql
    The MySQL driver of the package.
IsterSqlDriverMysql
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::IsterSqlDriverMysql()
    Constructor
IsterSqlDriverPostgresql
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::IsterSqlDriverPostgresql()
IsterSqlDriverPostgresql
in file IsterSqlDriverPostgresql.php, class IsterSqlDriverPostgresql
    The PostgreSQL driver of the package.
IsterSqlFunction
in file IsterSqlFunction.php, class IsterSqlFunction
    This class provides execution of SQL functions aka templates.
IsterSqlFunction
in file IsterSqlFunction.php, method IsterSqlFunction::IsterSqlFunction()
    Constructor
IsterSqlPager
in file IsterSqlPager.php, class IsterSqlPager
    This class provides methods to build a pager for large SQL result sets.
IsterSqlPager
in file IsterSqlPager.php, method IsterSqlPager::IsterSqlPager()
    Constructor
IsterSqlQuery
in file IsterSqlQuery.php, method IsterSqlQuery::IsterSqlQuery()
    Constructor
IsterSqlQuery
in file IsterSqlQuery.php, class IsterSqlQuery
    This class represents database queries.
IsterSqlRow
in file IsterSqlRow.php, class IsterSqlRow
    This class represents a row of a database table.
IsterSqlRow
in file IsterSqlRow.php, method IsterSqlRow::IsterSqlRow()
    Constructor
ISTER_SQL_AUTOESC
in file IsterSqlDataObject.php, constant ISTER_SQL_AUTOESC
ISTER_SQL_AUTOESC_BINARY
in file IsterSqlDataObject.php, constant ISTER_SQL_AUTOESC_BINARY
ISTER_SQL_DELETE
in file IsterSqlDataObject.php, constant ISTER_SQL_DELETE
ISTER_SQL_INSERT
in file IsterSqlDataObject.php, constant ISTER_SQL_INSERT
ISTER_SQL_SELECT
in file IsterSqlDataObject.php, constant ISTER_SQL_SELECT
ISTER_SQL_UPDATE
in file IsterSqlDataObject.php, constant ISTER_SQL_UPDATE
top

l

lastWasRead
in file IsterSqlQuery.php, method IsterSqlQuery::lastWasRead()
    Check whether the last query was a read (SELECT) operation or not.
lastWasRead
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::lastWasRead()
    Check whether the last query was a read (SELECT) operation or not.
lastWasRead
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::lastWasRead()
    Check whether the last query was a read (SELECT) operation or not.
lastWasRead
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::lastWasRead()
    Check whether the last query was a read (SELECT) operation or not.
top

m

makeID
in file IsterSqlDataObject.php, method IsterSqlDataObject::makeID()
    Generate an initial ID.
mklist
in file IsterSqlDataObject.php, method IsterSqlDataObject::mklist()
    Generate a list using a previously defined SQL function.
MULTILINE_TNT
in file IsterSqlFunction.php, constant MULTILINE_TNT
top

p

pagesLeft
in file IsterSqlPager.php, method IsterSqlPager::pagesLeft()
    Check whether pages are left in the current result set.
pconnect
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::pconnect()
    Establish a persistent connection.
pconnect
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::pconnect()
    Establish a persistent connection.
pconnect
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::pconnect()
    Establish a persistent connection.
pconnect
in file IsterSqlConnection.php, method IsterSqlConnection::pconnect()
    Establish a persistent connection to the databse server.
postRun
in file IsterSqlDataObject.php, method IsterSqlDataObject::postRun()
    Do something.
preRun
in file IsterSqlDataObject.php, method IsterSqlDataObject::preRun()
    Do something.
top

q

query
in file IsterSqlQuery.php, method IsterSqlQuery::query()
    Execute a database query.
query
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::query()
    Send a query.
query
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::query()
    Send a query.
query
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::query()
    Send a query.
top

r

$reschecker
in file IsterSqlDriver.php, variable IsterSqlDriver::$reschecker
    The object's ressource checker.
reset
in file IsterSqlPager.php, method IsterSqlPager::reset()
    Reset the pager.
resolve
in file IsterSqlFunction.php, method IsterSqlFunction::resolve()
    Resolve a SQL function, but do not execute.
top

s

select
in file IsterSqlDataObject.php, method IsterSqlDataObject::select()
    Select data into the object.
setAutoEscape
in file IsterSqlDataObject.php, method IsterSqlDataObject::setAutoEscape()
    Set auto escape behavior.
setConnection
in file IsterSqlConnection.php, method IsterSqlConnection::setConnection()
    Setup the connection.
setConnection
in file IsterSqlDriver.php, method IsterSqlDriver::setConnection()
    Setup the connection.
setConnection
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::setConnection()
    Setup the connection.
setFunction
in file IsterSqlFunction.php, method IsterSqlFunction::setFunction()
    Add a function to the function table.
setFunctionNames
in file IsterSqlDataObject.php, method IsterSqlDataObject::setFunctionNames()
    Set names of SQL functions.
setFunctionTable
in file IsterSqlFunction.php, method IsterSqlFunction::setFunctionTable()
    Add a whole function table in one single step.
setID
in file IsterSqlDataObject.php, method IsterSqlDataObject::setID()
    Set the object's unique identifier.
setIsLo
in file IsterSqlColumn.php, method IsterSqlColumn::setIsLo()
setLimitFunction
in file IsterSqlPager.php, method IsterSqlPager::setLimitFunction()
    Set the SQL function to execute a limited query.
setLink
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::setLink()
    Set the current connection resource.
setLink
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::setLink()
    Set the current connection resource.
setLink
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::setLink()
    Set the current connection resource.
setLookupFunction
in file IsterSqlFunction.php, method IsterSqlFunction::setLookupFunction()
    Set an SQL function to lookup a function in a function table stored in a database table.
setMaxlen
in file IsterSqlColumn.php, method IsterSqlColumn::setMaxlen()
setName
in file IsterSqlDataObject.php, method IsterSqlDataObject::setName()
    Set a unique name of the object.
setQuery
in file IsterSqlPager.php, method IsterSqlPager::setQuery()
    Set the query or function to get a result set.
setRowsPP
in file IsterSqlPager.php, method IsterSqlPager::setRowsPP()
    Set the number of rows per page.
setSqlFunction
in file IsterSqlDataObject.php, method IsterSqlDataObject::setSqlFunction()
    Set the object's IsterSqlFunction object.
setTable
in file IsterSqlColumn.php, method IsterSqlColumn::setTable()
setType
in file IsterSqlColumn.php, method IsterSqlColumn::setType()
setValue
in file IsterSqlColumn.php, method IsterSqlColumn::setValue()
setWindowSize
in file IsterSqlPager.php, method IsterSqlPager::setWindowSize()
    Set the window size.
top

u

unescape
in file IsterSqlDataObject.php, method IsterSqlDataObject::unescape()
    Unescape a string.
unescapeString
in file IsterSqlDriverPostgresql.php, method IsterSqlDriverPostgresql::unescapeString()
    Unescape a previously escaped string.
unescapeString
in file IsterSqlQuery.php, method IsterSqlQuery::unescapeString()
    Unescape a previously escaped string.
unescapeString
in file IsterSqlDriverMysql.php, method IsterSqlDriverMysql::unescapeString()
    Unescape a string.
unescapeString
in file IsterSqlDriverDbx.php, method IsterSqlDriverDbx::unescapeString()
    Unescape a string.
unsetFunction
in file IsterSqlFunction.php, method IsterSqlFunction::unsetFunction()
    Unset a function of the function table
update
in file IsterSqlDataObject.php, method IsterSqlDataObject::update()
    Update database with object's data.
top

Documentation generated on Tue, 20 Dec 2005 11:20:16 +0100 by phpDocumentor 1.3.0RC4