## 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

- author: Andrea Giardina <andrea.giardina@crealabs.it>
- author: Fabrizio Balliano <fabrizio.balliano@crealabs.it>
- license: GNU General Public License
- copyright: CreaLabs
- link: http://www.crealabs.it
- link: mailto:info@crealabs.it info@crealabs.it
- link: 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 $_multivalue_fields
mixed $_order
mixed $_pk
mixed $_query
mixed $_select
mixed $_table
mixed $_use_fields_aliases
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 updateRowPosition ()
void _composeFromPart ()
void _composeGroupPart ()
void _composeOrderPart ([mixed $order = array()])
void _composePkString ()
void _composeSelectCountPart ()
void _composeSelectCountQuery ()
void _composeSelectPart ()
void _composeSelectPkQuery (mixed $pk_value)
void _composeSelectQuery ()
void _composeSelectStructureQuery ()
void _composeWherePart ()
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