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

Element index for package MDB_QueryTool

[ a ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ m ] [ n ] [ o ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ w ] [ _ ]

_

_checkColumns
in file Query.php, method MDB_QueryTool_Query::_checkColumns()
    checks if the columns which are given as the array's indexes really exist if not it will be unset anyway
_makeIndexed
in file Query.php, method MDB_QueryTool_Query::_makeIndexed()
    Make data indexed
_returnRowOrValue
in file Result.php, method MDB_QueryTool_Result::_returnRowOrValue()
    Check if the row is a single value with a numeric index.
__construct
in file EasyJoin.php, method MDB_QueryTool_EasyJoin::__construct()
    call parent constructor
top

a

add
in file Query.php, method MDB_QueryTool_Query::add()
    add a new member in the DB
addHaving
in file Query.php, method MDB_QueryTool_Query::addHaving()
    Extend the current HAVING clause. This is very useful, when you are building this clause from different places and don't want to overwrite the currently set HAVING clause, but extend it.
addJoin
in file Query.php, method MDB_QueryTool_Query::addJoin()
    adds a table and a where clause that shall be used for the join
addLeftJoin
in file Query.php, method MDB_QueryTool_Query::addLeftJoin()
    Add a LEFT JOIN clause
addMultiple
in file Query.php, method MDB_QueryTool_Query::addMultiple()
    adds multiple new members in the DB
addOrder
in file Query.php, method MDB_QueryTool_Query::addOrder()
    Add a ORDER BY parameter to the query.
addSelect
in file Query.php, method MDB_QueryTool_Query::addSelect()
    add a string to the select-part of the query and connects it to an existing string using the $connectString, which by default is a comma.
addWhere
in file Query.php, method MDB_QueryTool_Query::addWhere()
    Only adds a string to the WHERE clause
addWhereSearch
in file Query.php, method MDB_QueryTool_Query::addWhereSearch()
    add a WHERE-LIKE clause which works like a search for the given string
autoJoin
in file EasyJoin.php, method MDB_QueryTool_EasyJoin::autoJoin()
    join the tables given, using the column names, to find out how to join
top

c

connect
in file Query.php, method MDB_QueryTool_Query::connect()
    use this method if you want to connect manually
top

d

$db
in file Query.php, variable MDB_QueryTool_Query::$db
debug
in file Query.php, method MDB_QueryTool_Query::debug()
    overwrite this method and i.e. print the query $string to see the final query
top

e

execute
in file Query.php, method MDB_QueryTool_Query::execute()
    Execute the query
example.php
procedural page example.php
EasyJoin.php
procedural page EasyJoin.php
top

f

fetchRow
in file Result.php, method MDB_QueryTool_Result::fetchRow()
    This function emulates PEAR_MDB fetchRow() method.
fetchRow
in file Object.php, method MDB_QueryTool_Result_Object::fetchRow()
    This function emulates PEAR::MDB fetchRow() method With this function MDB_QueryTool can transparently replace PEAR::MDB
top

g

get
in file Query.php, method MDB_QueryTool_Query::get()
    get the data of a single entry if the second parameter is only one column the result will be returned directly not as an array!
getAll
in file Query.php, method MDB_QueryTool_Query::getAll()
    get all entries from the DB for sorting use setOrder!!!, the last 2 parameters are deprecated
getCol
in file Query.php, method MDB_QueryTool_Query::getCol()
    this method only returns one column, so the result will be a one dimensional array
getCount
in file Result.php, method MDB_QueryTool_Result::getCount()
    return the number of rows returned
getCount
in file Query.php, method MDB_QueryTool_Query::getCount()
    get the number of entries
getData
in file Result.php, method MDB_QueryTool_Result::getData()
    get all the data returned
getDbInstance
in file Query.php, method MDB_QueryTool_Query::getDbInstance()
    Get a MDB[2] object instance
getDefaultValues
in file Query.php, method MDB_QueryTool_Query::getDefaultValues()
    return an empty element where all the array elements do already exist corresponding to the columns in the DB
getDontSelect
in file Query.php, method MDB_QueryTool_Query::getDontSelect()
    Get the columns that shall not be selected
getEmptyElement
in file Query.php, method MDB_QueryTool_Query::getEmptyElement()
    this is just for BC
getFirst
in file Result.php, method MDB_QueryTool_Result::getFirst()
    get the first result set we are not using next, current, and reset, since those ignore keys which are empty or 0
getFirst
in file Object.php, method MDB_QueryTool_Result_Object::getFirst()
    get the first result set
getGroup
in file Query.php, method MDB_QueryTool_Query::getGroup()
    gets the group condition which is used for the current instance
getHaving
in file Query.php, method MDB_QueryTool_Query::getHaving()
    gets the HAVING definition which is used for the current instance
getIndex
in file Query.php, method MDB_QueryTool_Query::getIndex()
    get index
getJoin
in file Query.php, method MDB_QueryTool_Query::getJoin()
    gets the join-condition
getLimit
in file Query.php, method MDB_QueryTool_Query::getLimit()
    gets query limits
getMultiple
in file Query.php, method MDB_QueryTool_Query::getMultiple()
    gets the data of the given ids
getNext
in file Result.php, method MDB_QueryTool_Result::getNext()
    Get next result set. If getFirst() has never been called before, it calls that method.
getNext
in file Object.php, method MDB_QueryTool_Result_Object::getNext()
    Alias for fetchRow()
getOne
in file Query.php, method MDB_QueryTool_Query::getOne()
    get the first value of the first row
getOption
in file Query.php, method MDB_QueryTool_Query::getOption()
    Get the given option
getOrder
in file Query.php, method MDB_QueryTool_Query::getOrder()
    gets the ORDER BY condition which is used for the current instance
getQueryString
in file Query.php, method MDB_QueryTool_Query::getQueryString()
    Render the current query and return it as a string.
getSelect
in file Query.php, method MDB_QueryTool_Query::getSelect()
    Get the SELECT clause
getTable
in file Query.php, method MDB_QueryTool_Query::getTable()
    gets the table this class is currently working on
getTableShortName
in file Query.php, method MDB_QueryTool_Query::getTableShortName()
    Gets the short name for a table
getTableSpec
in file Query.php, method MDB_QueryTool_Query::getTableSpec()
    gets the tableSpec either indexed by the short name or the name returns the array for the tables given as parameter or if no parameter given for all tables that exist in the tableSpec
getWhere
in file Query.php, method MDB_QueryTool_Query::getWhere()
    Gets the WHERE condition which is used for the current instance
top

h

hasMore
in file Result.php, method MDB_QueryTool_Result::hasMore()
    check if there are other rows
hasMore
in file Object.php, method MDB_QueryTool_Result_Object::hasMore()
    check if there are other rows
headline
in file example.php, function headline()
top

m

MDB_QueryTool
in file QueryTool.php, class MDB_QueryTool
    MDB_QueryTool class
MDB_QueryTool
in file QueryTool.php, method MDB_QueryTool::MDB_QueryTool()
    call parent constructor
MDB_QueryTool_EasyJoin
in file EasyJoin.php, class MDB_QueryTool_EasyJoin
    MDB_QueryTool_EasyJoin class
MDB_QueryTool_Query
in file Query.php, method MDB_QueryTool_Query::MDB_QueryTool_Query()
    Constructor
MDB_QueryTool_Query
in file Query.php, class MDB_QueryTool_Query
    MDB_QueryTool_Query class
MDB_QueryTool_Result
in file Result.php, class MDB_QueryTool_Result
    MDB_QueryTool_Result class
MDB_QueryTool_Result
in file Result.php, method MDB_QueryTool_Result::MDB_QueryTool_Result()
    create a new instance of result with the data returned by the query
MDB_QueryTool_Result_Object
in file Object.php, class MDB_QueryTool_Result_Object
    MDB_QueryTool_Result_Object class
MDB_QueryTool_Result_Object
in file Object.php, method MDB_QueryTool_Result_Object::MDB_QueryTool_Result_Object()
    Constructor
MDB_QueryTool_Result_Row
in file Object.php, class MDB_QueryTool_Result_Row
    MDB_QueryTool_Result_Row class
MDB_QueryTool_Result_Row
in file Object.php, method MDB_QueryTool_Result_Row::MDB_QueryTool_Result_Row()
    create object properties from the array
metadata
in file Query.php, method MDB_QueryTool_Query::metadata()
    !!!! query COPIED FROM db_oci8.inc - from PHPLIB !!!!
myPrint
in file example.php, function myPrint()
top

n

newEntity
in file Query.php, method MDB_QueryTool_Query::newEntity()
    Returns a new entity including an instance to QueryTool
numRows
in file Result.php, method MDB_QueryTool_Result::numRows()
    return the number of rows returned. This is an alias for getCount().
top

o

Object.php
procedural page Object.php
top

p

$primaryCol
in file Query.php, variable MDB_QueryTool_Query::$primaryCol
$primaryCol
in file example.php, variable user::$primaryCol
top

q

Query.php
procedural page Query.php
QueryTool.php
procedural page QueryTool.php
top

r

Result.php
procedural page Result.php
remove
in file Query.php, method MDB_QueryTool_Query::remove()
    removes a member from the DB
remove
in file Object.php, method MDB_QueryTool_Result_Row::remove()
    Removes the entity
removeAll
in file Query.php, method MDB_QueryTool_Query::removeAll()
    empty a table
removeMultiple
in file Query.php, method MDB_QueryTool_Query::removeMultiple()
    remove the datasets with the given IDs
removePrimary
in file Query.php, method MDB_QueryTool_Query::removePrimary()
    removes a member from the DB and calls the remove methods of the given objects so all rows in another table that refer to this table are erased too
reset
in file Query.php, method MDB_QueryTool_Query::reset()
    reset all the set* settings; with no parameter given, it resets them all.
returnResult
in file Query.php, method MDB_QueryTool_Query::returnResult()
    Return the chosen result type
top

s

$sequenceName
in file Query.php, variable MDB_QueryTool_Query::$sequenceName
save
in file Object.php, method MDB_QueryTool_Result_Row::save()
    save data, calls either update or add
save
in file Query.php, method MDB_QueryTool_Query::save()
    save data, calls either update or add if the primaryCol is given in the data this method knows that the data passed to it are meant to be updated (call 'update'), otherwise it will call the method 'add'.
setDbInstance
in file Query.php, method MDB_QueryTool_Query::setDbInstance()
    Setup using an existing connection.
setDontSelect
in file Query.php, method MDB_QueryTool_Query::setDontSelect()
    Set the columns that shall not be selected
setErrorCallback
in file Query.php, method MDB_QueryTool_Query::setErrorCallback()
    set both callbacks
setErrorLogCallback
in file Query.php, method MDB_QueryTool_Query::setErrorLogCallback()
    set error log callback
setErrorSetCallback
in file Query.php, method MDB_QueryTool_Query::setErrorSetCallback()
    set error set callback
setGroup
in file Query.php, method MDB_QueryTool_Query::setGroup()
    sets the group-by condition
setHaving
in file Query.php, method MDB_QueryTool_Query::setHaving()
    sets the HAVING definition
setIndex
in file Query.php, method MDB_QueryTool_Query::setIndex()
    format the result to be indexed by $key
setJoin
in file Query.php, method MDB_QueryTool_Query::setJoin()
    sets a join-condition
setLeftJoin
in file Query.php, method MDB_QueryTool_Query::setLeftJoin()
    if you do a left join on $this->table you will get all entries
setLimit
in file Query.php, method MDB_QueryTool_Query::setLimit()
    sets query limits
setOption
in file Query.php, method MDB_QueryTool_Query::setOption()
    set mode the class shall work in currently we have the modes: 'raw' does not quote the data before building the query
setOrder
in file Query.php, method MDB_QueryTool_Query::setOrder()
    sets the ORDER BY condition which is used for the current instance
setReturnClass
in file Query.php, method MDB_QueryTool_Query::setReturnClass()
    Sets the name of the class to use as result object
setRightJoin
in file Query.php, method MDB_QueryTool_Query::setRightJoin()
    see setLeftJoin for further explaination on what a left/right join is
setSelect
in file Query.php, method MDB_QueryTool_Query::setSelect()
    limit the result to return only the columns given in $what
setTable
in file Query.php, method MDB_QueryTool_Query::setTable()
    sets the table this class is currently working on
setWhere
in file Query.php, method MDB_QueryTool_Query::setWhere()
    Sets the WHERE condition which is used for the current instance
$sequenceName
in file example.php, variable user::$sequenceName
top

t

$table
in file Query.php, variable MDB_QueryTool_Query::$table
$tableSpec
in file Query.php, variable MDB_QueryTool_Query::$tableSpec
    this array contains information about the tables those are
  • 'name' => the real table name
  • 'shortName' => the short name used, so that when moving the table i.e.
TABLE_TIME
in file example.php, constant TABLE_TIME
TABLE_USER
in file example.php, constant TABLE_USER
$table
in file example.php, variable user::$table
$tableSpec
in file example.php, variable user::$tableSpec
    this table spec assigns a short name to a table name
top

u

update
in file Query.php, method MDB_QueryTool_Query::update()
    update the member data of a data set
useResult
in file Query.php, method MDB_QueryTool_Query::useResult()
    Choose the type of the returned result
user
in file example.php, class user
    MDB_QueryTool class
top

w

writeLog
in file Query.php, method MDB_QueryTool_Query::writeLog()
    Write events to the logfile.
top

Documentation generated on Wed, 11 Apr 2012 22:30:03 +0000 by phpDocumentor 1.4.3. PEAR Logo Copyright © PHP Group 2004.