deletes an existing row where $valueArr are conditions
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
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
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
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
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
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
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
updates an existing row
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