Class: I2CE Util: Difference between revisions
No edit summary |
No edit summary |
||
Line 9: | Line 9: | ||
*Signature: static public function array_unique($arr) | *Signature: static public function array_unique($arr) | ||
*Parameters: | *Parameters: | ||
*$arr | **$arr | ||
===convertLikeToRegExp()=== | ===convertLikeToRegExp()=== | ||
Convers a sql like statement to a regular expression | Convers a sql like statement to a regular expression | ||
Line 23: | Line 23: | ||
*Parameters: | *Parameters: | ||
** [http://www.php.net/manual/en/language.types.string.php string ] $sql <br/>a nuch of sql queries | ** [http://www.php.net/manual/en/language.types.string.php string ] $sql <br/>a nuch of sql queries | ||
*$db | **$db | ||
** [http://www.php.net/manual/en/language.types.boolean.php boolean ] $transact <br/>defaults to true meaning that the whole script is executed in a transaction. If a string, it is the name of a savepoint to rollback to/release @param MDB2 connection $db | ** [http://www.php.net/manual/en/language.types.boolean.php boolean ] $transact <br/>defaults to true meaning that the whole script is executed in a transaction. If a string, it is the name of a savepoint to rollback to/release @param MDB2 connection $db | ||
***Default Value: true | ***Default Value: true |
Revision as of 12:08, 17 October 2009
This article desrcibes the class I2CE_Util.
- Location: Part of the module I2CE in the package I2CE
- Source: Defined in the file lib/I2CE_Util.php
- Author: Carl Leitner <litlfred@ibiblio.org>
I2CE_Util @todo Better documentation
Methods
array_unique()
array unique which respects multi-dimensional arrays from: the link http://us.php.net/manual/en/function.array-unique.php#84750 sda
- Signature: static public function array_unique($arr)
- Parameters:
- $arr
convertLikeToRegExp()
Convers a sql like statement to a regular expression
- Signature: static public function convertLikeToRegExp($like,$escape)
- Parameters:
- Returns: string
explodeAndExecuteSQLQueries()
Explode and execute a
- Signature: static public function explodeAndExecuteSQLQueries($sql,$db,$transact,$delimiter)
- Parameters:
- string $sql
a nuch of sql queries - $db
- boolean $transact
defaults to true meaning that the whole script is executed in a transaction. If a string, it is the name of a savepoint to rollback to/release @param MDB2 connection $db- Default Value: true
- string $delimiter
Defaults to ';'. Needs to be exactly one character- Default Value: ';'
- string $sql
- Returns: boolean
true on sucess or false
flattenVariables()
Flatten variables. Transforms an array of variables of a nested array ['key1']['key2']['key3'] to an array with keys of the form 'key1:key2:key3'
- Signature: static public function flattenVariables($vars,$flat,$encode,$skip_empty,$prefix)
- Parameters:
- array $vars
the variables to flatten. - array &$flat
The array to store the falttened variables in - boolean $encode
Set to true (default) if we should urlencode the values- Default Value: true
- boolean $skip_empty
Set to true (default) skip empty values- Default Value: true
- string $prefix
Defaults to ;- Default Value:
- array $vars
merge_recursive()
Performs a recursive array merge which _overwrites_ values, not appends them ( the behaviour of array_merge_recursive). Warning: This is not a symmetric operation. Any multi-index that exists in $a and in $b will result that the value in $a will be overwritten by the value in $a
- Signature: static public function merge_recursive($a,$b,$addNew,$addEmpty)
- Parameters:
runSQLScript()
Executes a script
- Signature: static public function runSQLScript($file,$database,$transact,$dsn,$delimiter)
- Parameters:
- string $file
The SQL file to execute -- it must lie in the fileSearch's SQL category (this is ensured by addinging it to a <path name='sql'> node in the configuration XML - string $database
If non-null it will connect to the named database.- Default Value: null
- mixed $transact
defaults to true meaning that the whole script is executed in a transaction. If a string, it is the name of a save point to use (assumes you are already in a transaction)- Default Value: true
- string $dsn
An option DSN to connect on. If set $database is ignored. it will use whatever database is refered to by the MDB2::singleton()- Default Value: null
- string $delimiter
Defaults to ';' Needs to be exactly one character- Default Value: ';'
- string $file
- Returns: boolean
true on sucess, false on failure
transformVariables()
Transforms an array of variables with keys of the form 'key1:key2:key3' into a nested array ['key1']['key2']['key3']