Class P4A_DB_Source

Description

P4A - PHP For Applications.

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2 as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

To contact the authors write to:
CreaLabs
Via Medail, 32
10144 Torino (Italy)
Web: http://www.crealabs.it
E-mail: info@crealabs.it

The latest version of p4a can be obtained from: http://p4a.sourceforge.net

Located in /p4a/objects/data_sources/db_source.php (line 39)

P4A_Object
   |
   --P4A_Data_Source
      |
      --P4A_DB_Source
Variable Summary
 mixed $_DSN
 mixed $_filters
 mixed $_group
 mixed $_join
 mixed $_order
 mixed $_pk
 mixed $_query
 mixed $_select
 mixed $_table
 mixed $_where
Method Summary
 P4A_DB_Source P4A_DB_Source (mixed $name)
 void addFilter (mixed $filter, mixed &$obj)
 void addGroup (mixed $group)
 void addJoin (mixed $table, mixed $clausole, [mixed $type = "INNER"])
 void addMultivalueField (mixed $fieldname, mixed $table, [mixed $fk = NULL], [mixed $fk_field = NULL])
 void addOrder (mixed $field, [mixed $direction = P4A_ORDER_ASCENDING])
 void deleteRow ()
 void dropFilter (mixed $filter)
 void dropOrder ([mixed $field = null])
 void getAll (mixed $from, mixed $count)
 void getDSN ()
 void getFieldName (mixed $field)
 void getFields ()
 void getFilters ()
 void getGroup ()
 void getJoin ()
 void getNumRows ()
 void getOrder ()
 void getPkRow (mixed $pk)
 void getQuery ()
 void getRowPosition ()
 void getSelect ()
 void getTable ()
 void getWhere ()
 void hasOrder ()
 void isReadOnly ([mixed $value = NULL])
 void isSortable ([mixed $value = NULL])
 void load ()
 void resetNumRows ()
 void row ([mixed $num_row = null], [mixed $move_pointer = true])
 void saveRow ([mixed $fields_values = array()], [mixed $pk_values = array()])
 void setDSN (mixed $DSN)
 void setFields (mixed $fields)
 void setGroup (mixed $group)
 void setLimitQuery (mixed $query, mixed $limit, mixed $offset)
 void setOrder (mixed $field, [mixed $direction = P4A_ORDER_ASCENDING])
 void setQuery (mixed $query)
 void setSelect (mixed $select)
 void setTable (mixed $table)
 void setWhere (mixed $where)
 void _composeOrderPart ([mixed $order = array()])
 void _composeSelectPkQuery (mixed $pk_value)
 void __sleep ()
Variables
mixed $_DSN = "" (line 41)
mixed $_filters = array() (line 58)
mixed $_group = array() (line 49)
mixed $_join = array() (line 47)
mixed $_multivalue_fields = array() (line 56)
mixed $_order = array() (line 50)
mixed $_pk = NULL (line 43)

Redefinition of:
P4A_Data_Source::$_pk
mixed $_query = "" (line 52)
mixed $_select = "" (line 45)
mixed $_table = "" (line 46)
mixed $_use_fields_aliases = FALSE (line 54)
mixed $_where = "" (line 48)

Inherited Variables

Inherited from P4A_Data_Source

P4A_Data_Source::$fields
P4A_Data_Source::$_fields
P4A_Data_Source::$_is_read_only
P4A_Data_Source::$_is_sortable
P4A_Data_Source::$_limit
P4A_Data_Source::$_num_pages
P4A_Data_Source::$_num_rows
P4A_Data_Source::$_offset
P4A_Data_Source::$_page_limit
P4A_Data_Source::$_pointer

Inherited from P4A_Object

P4A_Object::$_id
P4A_Object::$_map_actions
P4A_Object::$_name
P4A_Object::$_objects
P4A_Object::$_parent_id
Methods
Constructor P4A_DB_Source (line 61)
P4A_DB_Source P4A_DB_Source (mixed $name)
addFilter (line 227)
void addFilter (mixed $filter, mixed &$obj)
addGroup (line 141)
void addGroup (mixed $group)
addJoin (line 120)
void addJoin (mixed $table, mixed $clausole, [mixed $type = "INNER"])
addMultivalueField (line 886)
void addMultivalueField (mixed $fieldname, mixed $table, [mixed $fk = NULL], [mixed $fk_field = NULL])
addOrder (line 163)
void addOrder (mixed $field, [mixed $direction = P4A_ORDER_ASCENDING])
deleteRow (line 641)
void deleteRow ()

Redefinition of:
P4A_Data_Source::deleteRow()
dropFilter (line 233)
void dropFilter (mixed $filter)
dropOrder (line 197)
void dropOrder ([mixed $field = null])
getAll (line 676)
void getAll (mixed $from, mixed $count)

Redefinition of:
P4A_Data_Source::getAll()
getDSN (line 72)
void getDSN ()
getFieldName (line 363)
void getFieldName (mixed $field)
getFields (line 101)
void getFields ()
getFilters (line 241)
void getFilters ()
getGroup (line 158)
void getGroup ()
getJoin (line 125)
void getJoin ()
getNumRows (line 471)
void getNumRows ()

Redefinition of:
P4A_Data_Source::getNumRows()
getOrder (line 174)
void getOrder ()
getPkRow (line 405)
void getPkRow (mixed $pk)

Redefinition of:
P4A_Data_Source::getPkRow()
getQuery (line 222)
void getQuery ()
getRowPosition (line 483)
void getRowPosition ()
getSelect (line 115)
void getSelect ()
getTable (line 82)
void getTable ()
getWhere (line 136)
void getWhere ()
hasOrder (line 192)
void hasOrder ()
isReadOnly (line 385)
void isReadOnly ([mixed $value = NULL])
isSortable (line 397)
void isSortable ([mixed $value = NULL])
load (line 265)
void load ()

Redefinition of:
P4A_Data_Source::load()
resetNumRows (line 881)
void resetNumRows ()
row (line 412)
void row ([mixed $num_row = null], [mixed $move_pointer = true])

Redefinition of:
P4A_Data_Source::row()
saveRow (line 544)
void saveRow ([mixed $fields_values = array()], [mixed $pk_values = array()])
setDSN (line 67)
void setDSN (mixed $DSN)
setFields (line 87)
void setFields (mixed $fields)
setGroup (line 146)
void setGroup (mixed $group)
setLimitQuery (line 213)
void setLimitQuery (mixed $query, mixed $limit, mixed $offset)
setOrder (line 168)
void setOrder (mixed $field, [mixed $direction = P4A_ORDER_ASCENDING])
setQuery (line 206)
void setQuery (mixed $query)
setSelect (line 106)
void setSelect (mixed $select)
setTable (line 77)
void setTable (mixed $table)
setWhere (line 130)
void setWhere (mixed $where)
updateRowPosition (line 539)
void updateRowPosition ()
_composeFromPart (line 810)
void _composeFromPart ()
_composeGroupPart (line 836)
void _composeGroupPart ()
_composeOrderPart (line 845)
void _composeOrderPart ([mixed $order = array()])
_composePkString (line 863)
void _composePkString ()
_composeSelectCountPart (line 804)
void _composeSelectCountPart ()
_composeSelectCountQuery (line 702)
void _composeSelectCountQuery ()
_composeSelectPart (line 777)
void _composeSelectPart ()
_composeSelectPkQuery (line 746)
void _composeSelectPkQuery (mixed $pk_value)
_composeSelectQuery (line 731)
void _composeSelectQuery ()
_composeSelectStructureQuery (line 717)
void _composeSelectStructureQuery ()
_composeWherePart (line 820)
void _composeWherePart ()
__sleep (line 919)
void __sleep ()

Inherited Methods

Inherited From P4A_Data_Source

 P4A_Data_Source::P4A_Data_Source()
 P4A_Data_Source::deleteRow()
 P4A_Data_Source::exportAsCSV()
 P4A_Data_Source::exportToCSV()
 P4A_Data_Source::firstPage()
 P4A_Data_Source::firstRow()
 P4A_Data_Source::getAll()
 P4A_Data_Source::getAsCSV()
 P4A_Data_Source::getNumPage()
 P4A_Data_Source::getNumPages()
 P4A_Data_Source::getNumRows()
 P4A_Data_Source::getOffset()
 P4A_Data_Source::getPageLimit()
 P4A_Data_Source::getPk()
 P4A_Data_Source::getPkRow()
 P4A_Data_Source::getPkValues()
 P4A_Data_Source::getRowNumber()
 P4A_Data_Source::isNew()
 P4A_Data_Source::lastPage()
 P4A_Data_Source::lastRow()
 P4A_Data_Source::load()
 P4A_Data_Source::newRow()
 P4A_Data_Source::nextPage()
 P4A_Data_Source::nextRow()
 P4A_Data_Source::page()
 P4A_Data_Source::prevPage()
 P4A_Data_Source::prevRow()
 P4A_Data_Source::row()
 P4A_Data_Source::setPageLimit()
 P4A_Data_Source::setPk()

Inherited From P4A_Object

 P4A_Object::actionHandler()
 P4A_Object::build()
 P4A_Object::destroy()
 P4A_Object::errorHandler()
 P4A_Object::getId()
 P4A_Object::getName()
 P4A_Object::getObjectType()
 P4A_Object::getParentID()
 P4A_Object::implementMethod()
 P4A_Object::intercept()
 P4A_Object::isActionTriggered()
 P4A_Object::p4a_object()
 P4A_Object::setName()
 P4A_Object::setParentID()
 P4A_Object::void()

Documentation generated on Fri, 26 May 2006 12:43:07 +0200 by phpDocumentor 1.3.0RC5