Element index for package DB_QueryTool
[ a ]
[ c ]
[ d ]
[ e ]
[ f ]
[ g ]
[ h ]
[ m ]
[ n ]
[ o ]
[ p ]
[ q ]
[ r ]
[ s ]
[ t ]
[ u ]
[ w ]
[ _ ]
top
a
- add
- in file Query.php, method DB_QueryTool_Query::add()
add a new member in the DB
- addHaving
- in file Query.php, method DB_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 DB_QueryTool_Query::addJoin()
adds a table and a where clause that shall be used for the join
- addLeftJoin
- in file Query.php, method DB_QueryTool_Query::addLeftJoin()
add a LEFT JOIN clause
- addMultiple
- in file Query.php, method DB_QueryTool_Query::addMultiple()
adds multiple new members in the DB
- addOrder
- in file Query.php, method DB_QueryTool_Query::addOrder()
Add a ORDER BY parameter to the query.
- addSelect
- in file Query.php, method DB_QueryTool_Query::addSelect()
add a string to the select part of the query 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 DB_QueryTool_Query::addWhere()
only adds a string to the WHERE clause
- addWhereSearch
- in file Query.php, method DB_QueryTool_Query::addWhereSearch()
add a WHERE-LIKE clause which works like a search for the given string
- autoJoin
- in file EasyJoin.php, method DB_QueryTool_EasyJoin::autoJoin()
Join the given tables, using the column names, to find out how to join the tables; i.e., if table1 has a column named "table2_id", this method will join "WHERE table1.table2_id=table2.id".
top
top
d
- $db
- in file Query.php, variable DB_QueryTool_Query::$db
- DB_QueryTool
- in file QueryTool.php, class DB_QueryTool
MDB_QueryTool class
- DB_QueryTool
- in file QueryTool.php, method DB_QueryTool::DB_QueryTool()
Call parent constructor
- DB_QueryTool_EasyJoin
- in file EasyJoin.php, class DB_QueryTool_EasyJoin
DB_QueryTool_EasyJoin class
- DB_QueryTool_Query
- in file Query.php, method DB_QueryTool_Query::DB_QueryTool_Query()
Constructor
- DB_QueryTool_Query
- in file Query.php, class DB_QueryTool_Query
DB_QueryTool_Query class
- DB_QueryTool_Result
- in file Result.php, method DB_QueryTool_Result::DB_QueryTool_Result()
create a new instance of result with the data returned by the query
- DB_QueryTool_Result
- in file Result.php, class DB_QueryTool_Result
DB_QueryTool_Result class
- DB_QueryTool_Result_Object
- in file Object.php, class DB_QueryTool_Result_Object
DB_QueryTool_Result_Object class
- DB_QueryTool_Result_Row
- in file Object.php, method DB_QueryTool_Result_Row::DB_QueryTool_Result_Row()
create object properties from the array
- DB_QueryTool_Result_Row
- in file Object.php, class DB_QueryTool_Result_Row
DB_QueryTool_Result_Row class
- debug
- in file Query.php, method DB_QueryTool_Query::debug()
overwrite this method and i.e. print the query $string to see the final query
top
top
top
g
- get
- in file Query.php, method DB_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 DB_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 DB_QueryTool_Query::getCol()
this method only returns one column, so the result will be a one dimensional array
- getCount
- in file Query.php, method DB_QueryTool_Query::getCount()
get the number of entries
- getCount
- in file Result.php, method DB_QueryTool_Result::getCount()
return the number of rows returned
- getData
- in file Result.php, method DB_QueryTool_Result::getData()
get all the data returned
- getDbInstance
- in file Query.php, method DB_QueryTool_Query::getDbInstance()
Get the current DB instance
- getDefaultValues
- in file Query.php, method DB_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 DB_QueryTool_Query::getDontSelect()
Get the column(s) to be ignored
- getEmptyElement
- in file Query.php, method DB_QueryTool_Query::getEmptyElement()
this is just for BC
- getFirst
- in file Result.php, method DB_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
- getGroup
- in file Query.php, method DB_QueryTool_Query::getGroup()
gets the group condition which is used for the current instance
- getHaving
- in file Query.php, method DB_QueryTool_Query::getHaving()
gets the HAVING definition which is used for the current instance
- getIndex
- in file Query.php, method DB_QueryTool_Query::getIndex()
Get the index
- getJoin
- in file Query.php, method DB_QueryTool_Query::getJoin()
gets the join-condition
- getLimit
- in file Query.php, method DB_QueryTool_Query::getLimit()
gets query limits
- getMultiple
- in file Query.php, method DB_QueryTool_Query::getMultiple()
gets the data of the given ids
- getNext
- in file Result.php, method DB_QueryTool_Result::getNext()
Get next result set. If getFirst() has never been called before, it calls that method.
- getOne
- in file Query.php, method DB_QueryTool_Query::getOne()
get the first value of the first row
- getOption
- in file Query.php, method DB_QueryTool_Query::getOption()
Get the option value
- getOrder
- in file Query.php, method DB_QueryTool_Query::getOrder()
gets the ORDER BY condition which is used for the current instance
- getQueryString
- in file Query.php, method DB_QueryTool_Query::getQueryString()
Render the current query and return it as a string.
- getSelect
- in file Query.php, method DB_QueryTool_Query::getSelect()
Get the SELECT clause
- getTable
- in file Query.php, method DB_QueryTool_Query::getTable()
gets the table this class is currently working on
- getTableShortName
- in file Query.php, method DB_QueryTool_Query::getTableShortName()
Gets the short name for a table
- getTableSpec
- in file Query.php, method DB_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 DB_QueryTool_Query::getWhere()
gets the WHERE condition which is used for the current instance
top
top
top
top
top
top
top
top
s
- $sequenceName
- in file Query.php, variable DB_QueryTool_Query::$sequenceName
- save
- in file Query.php, method DB_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 DB_QueryTool_Query::setDbInstance()
Setup using an existing connection.
- setDontSelect
- in file Query.php, method DB_QueryTool_Query::setDontSelect()
Do not select the given column
- setErrorCallback
- in file Query.php, method DB_QueryTool_Query::setErrorCallback()
set both callbacks
- setErrorLogCallback
- in file Query.php, method DB_QueryTool_Query::setErrorLogCallback()
Set the name of the error log callback function
- setErrorSetCallback
- in file Query.php, method DB_QueryTool_Query::setErrorSetCallback()
Set the name of the error log callback function
- setGroup
- in file Query.php, method DB_QueryTool_Query::setGroup()
sets the group-by condition
- setHaving
- in file Query.php, method DB_QueryTool_Query::setHaving()
sets the HAVING definition
- setIndex
- in file Query.php, method DB_QueryTool_Query::setIndex()
format the result to be indexed by $key
- setJoin
- in file Query.php, method DB_QueryTool_Query::setJoin()
sets a join-condition
- setLeftJoin
- in file Query.php, method DB_QueryTool_Query::setLeftJoin()
if you do a left join on $this->table you will get all entries
- setLimit
- in file Query.php, method DB_QueryTool_Query::setLimit()
sets query limits
- setOption
- in file Query.php, method DB_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 DB_QueryTool_Query::setOrder()
sets the ORDER BY condition which is used for the current instance
- setRightJoin
- in file Query.php, method DB_QueryTool_Query::setRightJoin()
see setLeftJoin for further explaination on what a left/right join is NOTE: be sure to only use either a right or a left join //FIXXME check if the above sentence is necessary and if sql doesn't allow the use of both
- setSelect
- in file Query.php, method DB_QueryTool_Query::setSelect()
limit the result to return only the columns given in $what
- setTable
- in file Query.php, method DB_QueryTool_Query::setTable()
sets the table this class is currently working on
- setWhere
- in file Query.php, method DB_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 DB_QueryTool_Query::$table
- $tableSpec
- in file Query.php, variable DB_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
top
top
Documentation generated on Mon, 11 Mar 2019 15:14:41 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.
|
|