getArray (line 82)

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 if the column starts with a ~ a like condition is created else column=slashedvalue(value) is added to the query

• access: public

• 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 125)

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

• string $table: name of the table to insert
• array $valueArr: key=>value array
• boolean $debug: show debug information
• string $idFld

qs_getSlashedValue (line 186)

returns $aValue with slashes to use to create query strings

• access: public

• string $aValue

replaceArray (line 143)

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

• string $table: name of the DBTABLE
• array $valueArr: value array with FIELDNAME as Index
• boolean $debug: show debug information
• &$valueArr

updateArray (line 158)

updates $values in $aTable where $conditions

• return: number of effekted rows
• version: pk-08-04-07

• string $aTable
• array $conditions
• array $values
• int $limit
• boolean $debug