[ 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
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
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
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
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
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
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
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.
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'.
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
in file Query.php, method MDB_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
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.