[ Index ]

Source Code Reference for V1.00

title

Body

[close]

/classes/ -> query.class.php (summary)

(no description)

File Size: 1648 lines (45 kb)
Included or required: 7 times
Referenced: 0 times
Includes or requires: 2 files
 lib/adodb/adodb-xmlschema.inc.php
 lib/adodb/adodb.inc.php

Defines 1 class

DBQuery:: (73 methods):
  DBQuery()
  clear()
  clearQuery()
  concat()
  ifNull()
  addMap()
  addTable()
  addClause()
  addQuery()
  addInsert()
  addInsertSelect()
  addReplace()
  addUpdate()
  createTable()
  createDatabase()
  DDcreateTable()
  DDcreateIndex()
  createTemp()
  dropTable()
  dropTemp()
  alterTable()
  addField()
  alterField()
  dropField()
  addIndex()
  dropIndex()
  dropPrimary()
  createDefinition()
  setDelete()
  addWhere()
  addJoin()
  leftJoin()
  rightJoin()
  innerJoin()
  addOrder()
  addGroup()
  addHaving()
  setLimit()
  includeCount()
  setPageLimit()
  prepare()
  prepareSelect()
  prepareUpdate()
  prepareInsert()
  prepareInsertSelect()
  prepareReplace()
  prepareDelete()
  prepareAlter()
  exec()
  fetchRow()
  loadList()
  loadHashList()
  loadHash()
  loadArrayList()
  loadColumn()
  loadObject()
  bindHashToObject()
  execXML()
  loadResult()
  make_where_clause()
  make_order_clause()
  make_group_clause()
  make_join()
  make_having_clause()
  make_limit_clause()
  foundRows()
  quote()
  quote_db()
  insertArray()
  updateArray()
  insertObject()
  updateObject()
  duplicate()


Class: DBQuery  - X-Ref

Database query class

Container for creating prefix-safe queries.  Allows build up of
a select statement by adding components one at a time.

DBQuery($prefix = null, $query_db = null)   X-Ref
No description

clear()   X-Ref
No description

clearQuery()   X-Ref
No description

concat()   X-Ref
No description

ifNull($field, $nullReplacementValue)   X-Ref
No description

addMap($varname, $name, $id)   X-Ref
No description

addTable($name, $id = null)   X-Ref
No description

addClause($clause, $value, $check_array = true)   X-Ref
No description

addQuery($query)   X-Ref
No description

addInsert($field, $value = null, $set = false, $func = false)   X-Ref
No description

addInsertSelect($table)   X-Ref
No description

addReplace($field, $value, $set = false, $func = false)   X-Ref
No description

addUpdate($field, $value = null, $set = false)   X-Ref
No description

createTable($table, $def = null)   X-Ref
No description

createDatabase($database)   X-Ref
No description

DDcreateTable($table, $def, $opts)   X-Ref
No description

DDcreateIndex($name, $table, $cols, $opts)   X-Ref
No description

createTemp($table)   X-Ref
No description

dropTable($table)   X-Ref
No description

dropTemp($table)   X-Ref
No description

alterTable($table)   X-Ref
No description

addField($name, $type)   X-Ref
No description

alterField($name, $type)   X-Ref
Alter a field definition for usage with table alteration

param: $name The name of the field
param: $type The type of the field

dropField($name)   X-Ref
No description

addIndex($name, $type)   X-Ref
No description

dropIndex($name)   X-Ref
No description

dropPrimary()   X-Ref
No description

createDefinition($def)   X-Ref
No description

setDelete($table)   X-Ref
No description

addWhere($query)   X-Ref
No description

addJoin($table, $alias, $join, $type = 'left')   X-Ref
No description

leftJoin($table, $alias, $join)   X-Ref
No description

rightJoin($table, $alias, $join)   X-Ref
No description

innerJoin($table, $alias, $join)   X-Ref
No description

addOrder($order)   X-Ref
No description

addGroup($group)   X-Ref
No description

addHaving($query)   X-Ref
No description

setLimit($limit, $start = -1)   X-Ref
No description

includeCount()   X-Ref
Set include count feature, grabs the count of rows that
would have been returned had no limit been set.


setPageLimit($page = 0, $pagesize = 0)   X-Ref
No description

prepare($clear = false)   X-Ref
No description

prepareSelect()   X-Ref
No description

prepareUpdate()   X-Ref
No description

prepareInsert()   X-Ref
No description

prepareInsertSelect()   X-Ref
No description

prepareReplace()   X-Ref
No description

prepareDelete()   X-Ref
No description

prepareAlter()   X-Ref
No description

exec($style = ADODB_FETCH_BOTH, $debug = false)   X-Ref
No description

fetchRow()   X-Ref
No description

loadList($maxrows = null)   X-Ref
No description

loadHashList($index = null)   X-Ref
No description

loadHash()   X-Ref
No description

loadArrayList($index = 0)   X-Ref
No description

loadColumn()   X-Ref
No description

loadObject(&$object, $bindAll = false, $strip = true)   X-Ref
No description

bindHashToObject($hash, &$obj, $prefix = null, $checkSlashes = true, $bindAll = false)   X-Ref
No description

execXML($xml, $mode = 'REPLACE')   X-Ref
No description

loadResult()   X-Ref
No description

make_where_clause($where_clause)   X-Ref
No description

make_order_clause($order_clause)   X-Ref
No description

make_group_clause($group_clause)   X-Ref
No description

make_join($join_clause)   X-Ref
No description

make_having_clause($having_clause)   X-Ref
No description

make_limit_clause($limit, $offset)   X-Ref
No description

foundRows()   X-Ref
No description

quote($string)   X-Ref
No description

quote_db($string)   X-Ref
No description

insertArray($table, &$hash, $verbose = false)   X-Ref
Document::insertArray()

{ Description }

param: [type] $verbose

updateArray($table, &$hash, $keyName, $verbose = false)   X-Ref
Document::updateArray()

{ Description }

param: [type] $verbose

insertObject($table, &$object, $keyName = null, $verbose = false)   X-Ref
Document::insertObject()

{ Description }

param: [type] $keyName
param: [type] $verbose

updateObject($table, &$object, $keyName, $updateNulls = true)   X-Ref
Document::updateObject()

{ Description }

param: [type] $updateNulls

duplicate()   X-Ref
Clone the current query

return: object    The new record object or null if error



Generated: Sat Jul 17 03:00:04 2010 Cross-referenced by PHPXref 0.7