ClassInterface INFA_DBMS_DBOBJ

Description

interface to handle a database connection object

Located in /db/INFA_DBMS_DBOBJ.phpclass (line 26)


	
			
Method Summary
 bool deleteArray (string $table,  &$valueArr, [boolean $debug = FALSE], array $valueArr)
 array getArray (string $aTable, [array $conditions = NULL], [int $offset = 0], [int $limit = 0], [string $orderBy = ""], [boolean $debug = FALSE])
 int insertArray (string $table, array $valueArr, [boolean $debug = FALSE], [string $idFld = ""])
 bool replaceArray (string $table,  &$valueArr, [boolean $debug = FALSE], array $valueArr)
 bool updateArray (string $table,  &$valueArr, [boolean $debug = FALSE], array $valueArr)
Methods
deleteArray (line 119)

deletes an existing row where $valueArr are conditions

  • return: TRUE on success FALSE in case of error
  • access: public
bool deleteArray (string $table,  &$valueArr, [boolean $debug = FALSE], array $valueArr)
  • string $table: name of the DBTABLE
  • array $valueArr: value array with FIELDNAME as Index
  • boolean $debug: show debug information
  • &$valueArr
getArray (line 55)

generates a query and returns an array of the resultset

limit <> a multidimensional array is returned (see queryArray) if limit = 1 a single array is returned (see quickQuery)

conditions: if the column starts with a ? the value is assumed to be an sql statement else column=slashedvalue(value) is added to the query

  • access: public
array getArray (string $aTable, [array $conditions = NULL], [int $offset = 0], [int $limit = 0], [string $orderBy = ""], [boolean $debug = FALSE])
  • string $aTable: (the table name)
  • array $conditions: (array(COLUMN => VALUE)) if VALUE does not starts with a '¿' t
  • int $offset
  • int $limit: (0 is unlimeted)
  • string $orderBy: (comma seperated list of fields to order)
  • boolean $debug
insertArray (line 77)

inserts a valueArr into the table

inserts a new row out of an array returns the value of the auto_increment field or TRUE in case of an error it returns FALSE

  • return: key of auto-key or TRUE on success FALSE in case of error
  • access: public
int insertArray (string $table, array $valueArr, [boolean $debug = FALSE], [string $idFld = ""])
  • string $table: name of the table to insert
  • array $valueArr: key=>value array
  • boolean $debug: show debug information
  • string $idFld
replaceArray (line 95)

replace existing row or insert now if not exists

inserts a row or update an existing row all existing values not in $valueArr (assoc) will be handeld by db spezifaction see mysql Doc: http://www.mysql.com/doc/en/REPLACE.html

  • return: TRUE on success FALSE in case of error
  • access: public
bool replaceArray (string $table,  &$valueArr, [boolean $debug = FALSE], array $valueArr)
  • string $table: name of the DBTABLE
  • array $valueArr: value array with FIELDNAME as Index
  • boolean $debug: show debug information
  • &$valueArr
updateArray (line 107)

updates an existing row

  • return: TRUE on success FALSE in case of error
  • access: public
bool updateArray (string $table,  &$valueArr, [boolean $debug = FALSE], array $valueArr)
  • string $table: name of the DBTABLE
  • array $valueArr: value array with FIELDNAME as Index
  • boolean $debug: show debug information
  • &$valueArr

Documentation generated on Thu, 08 Jan 2009 17:44:26 +0100 by phpDocumentor 1.4.0a2