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 $_pk
 mixed $_query
 mixed $_select
 mixed $_table
 mixed $_where
Method Summary
 P4A_DB_Source P4A_DB_Source ( $name)
 void addFilter ( $filter,  &$obj)
 void addGroup ( $group)
 void addJoin ( $table,  $clausole, [ $type = "INNER"])
 void addMultivalueField ( $fieldname, [ $table = NULL], [ $fk = NULL], [ $fk_field = NULL])
 void deleteRow ()
 void dropFilter ( $filter)
 void getAll ([ $from = 0], [ $count = 0])
 void getDSN ()
 void getFieldName ( $field)
 void getFields ()
 void getFilters ()
 void getGroup ()
 void getJoin ()
 void getNumRows ()
 void getPkRow ( $pk)
 void getQuery ()
 void getRowPosition ([ $row = null])
 void getSelect ()
 void getTable ()
 void getWhere ()
 void isReadOnly ([ $value = null])
 void load ()
 void resetNumRows ()
 void row ([ $num_row = null], [ $move_pointer = true])
 void rowByPk ( $pk)
 void saveRow ([ $fields_values = array()], [ $pk_values = array()])
 void setDSN ( $DSN)
 void setFields ( $fields)
 void setGroup ( $group)
 void setLimitQuery ( $query,  $limit, [ $offset = 0])
 void setQuery ( $query)
 void setSelect ( $select)
 void setTable ( $table)
 void setWhere ( $where)
 void _composeOrderPart ([ $order = array()])
 void _composePkString ([ $pk_values = array()])
 void _composeSelectPkQuery ( $pk_value)
 void __sleep ()
Variables
mixed $_DSN = "" (line 41)
mixed $_filters = array() (line 58)
mixed $_group = array() (line 49)
mixed $_is_sortable = true (line 50)

Redefinition of:
P4A_Data_Source::$_is_sortable
mixed $_join = array() (line 47)
mixed $_multivalue_fields = array() (line 56)
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::$_limit
P4A_Data_Source::$_num_pages
P4A_Data_Source::$_num_rows
P4A_Data_Source::$_offset
P4A_Data_Source::$_order
P4A_Data_Source::$_page_limit
P4A_Data_Source::$_pointer

Inherited from P4A_Object

P4A_Object::$_helpers
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 ( $name)
  • $name
addFilter (line 183)
void addFilter ( $filter,  &$obj)
  • $filter
  • &$obj
addGroup (line 140)
void addGroup ( $group)
  • $group
addJoin (line 119)
void addJoin ( $table,  $clausole, [ $type = "INNER"])
  • $table
  • $clausole
  • $type
addMultivalueField (line 903)
void addMultivalueField ( $fieldname, [ $table = NULL], [ $fk = NULL], [ $fk_field = NULL])
  • $fieldname
  • $table
  • $fk
  • $fk_field
deleteRow (line 647)
void deleteRow ()

Redefinition of:
P4A_Data_Source::deleteRow()
dropFilter (line 189)
void dropFilter ( $filter)
  • $filter
getAll (line 680)
void getAll ([ $from = 0], [ $count = 0])
  • $from
  • $count

Redefinition of:
P4A_Data_Source::getAll()
getDSN (line 71)
void getDSN ()
getFieldName (line 329)
void getFieldName ( $field)
  • $field
getFields (line 100)
void getFields ()
getFilters (line 197)
void getFilters ()
getGroup (line 157)
void getGroup ()
getJoin (line 124)
void getJoin ()
getNumRows (line 442)
void getNumRows ()

Redefinition of:
P4A_Data_Source::getNumRows()
getPkRow (line 364)
void getPkRow ( $pk)
  • $pk

Redefinition of:
P4A_Data_Source::getPkRow()
getQuery (line 178)
void getQuery ()
getRowPosition (line 474)
void getRowPosition ([ $row = null])
  • $row
getSelect (line 114)
void getSelect ()
getTable (line 81)
void getTable ()
getWhere (line 135)
void getWhere ()
isReadOnly (line 351)
void isReadOnly ([ $value = null])
  • $value
load (line 223)
void load ()

Redefinition of:
P4A_Data_Source::load()
resetNumRows (line 898)
void resetNumRows ()
row (line 378)
void row ([ $num_row = null], [ $move_pointer = true])
  • $num_row
  • $move_pointer

Redefinition of:
P4A_Data_Source::row()
rowByPk (line 435)
void rowByPk ( $pk)
  • $pk
saveRow (line 548)
void saveRow ([ $fields_values = array()], [ $pk_values = array()])
  • $fields_values
  • $pk_values
setDSN (line 66)
void setDSN ( $DSN)
  • $DSN
setFields (line 86)
void setFields ( $fields)
  • $fields
setGroup (line 145)
void setGroup ( $group)
  • $group
setLimitQuery (line 169)
void setLimitQuery ( $query,  $limit, [ $offset = 0])
  • $query
  • $limit
  • $offset
setQuery (line 162)
void setQuery ( $query)
  • $query
setSelect (line 105)
void setSelect ( $select)
  • $select
setTable (line 76)
void setTable ( $table)
  • $table
setWhere (line 129)
void setWhere ( $where)
  • $where
updateRowPosition (line 543)
void updateRowPosition ()

Redefinition of:
P4A_Data_Source::updateRowPosition()
_composeFromPart (line 825)
void _composeFromPart ()
_composeGroupPart (line 851)
void _composeGroupPart ()
_composeOrderPart (line 860)
void _composeOrderPart ([ $order = array()])
  • $order
_composePkString (line 878)
void _composePkString ([ $pk_values = array()])
  • $pk_values
_composeSelectCountPart (line 819)
void _composeSelectCountPart ()
_composeSelectCountQuery (line 714)
void _composeSelectCountQuery ()
_composeSelectPart (line 792)
void _composeSelectPart ()
_composeSelectPkQuery (line 758)
void _composeSelectPkQuery ( $pk_value)
  • $pk_value
_composeSelectQuery (line 743)
void _composeSelectQuery ()
_composeSelectStructureQuery (line 729)
void _composeSelectStructureQuery ()
_composeWherePart (line 835)
void _composeWherePart ()
__sleep (line 936)
void __sleep ()

Inherited Methods

Inherited From P4A_Data_Source

 P4A_Data_Source::P4A_Data_Source()
 P4A_Data_Source::addOrder()
 P4A_Data_Source::deleteRow()
 P4A_Data_Source::dropOrder()
 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::getOrder()
 P4A_Data_Source::getPageLimit()
 P4A_Data_Source::getPk()
 P4A_Data_Source::getPkRow()
 P4A_Data_Source::getPkValues()
 P4A_Data_Source::getRowNumber()
 P4A_Data_Source::hasOrder()
 P4A_Data_Source::isNew()
 P4A_Data_Source::isSortable()
 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::setOrder()
 P4A_Data_Source::setPageLimit()
 P4A_Data_Source::setPk()
 P4A_Data_Source::updateRowPosition()

Inherited From P4A_Object

 P4A_Object::actionHandler()
 P4A_Object::build()
 P4A_Object::destroy()
 P4A_Object::dropIntercept()
 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()
 P4A_Object::_loadHelper()
 P4A_Object::__call()

Documentation generated on Mon, 07 Jan 2008 11:29:17 +0100 by phpDocumentor 1.4.0