Docs For Class MDB2_Driver_Function

concat [line 158]

string concat(
string
$value1, string
$value2, string
$values...)

Returns string to concatenate two or more string parameters

Return: to concatenate two strings
Access: public

Parameters:

string	`$value1`	—
string	`$value2`	—
string	`$values...`	—

[ Top ]

executeStoredProc [line 77]

mixed &executeStoredProc(
string
$name, [mixed
$params = null], [mixed
$types = null], [mixed
$result_class = true], [mixed
$result_wrap_class = false])

Execute a stored procedure and return any results

Return: a result handle or MDB2_OK on success, a MDB2 error on failure
Access: public

Parameters:

string	`$name`	—	string that identifies the function to execute
mixed	`$params`	—	array that contains the paramaters to pass the stored proc
mixed	`$types`	—	array that contains the types of the columns in the result set
mixed	`$result_class`	—	string which specifies which result class to use
mixed	`$result_wrap_class`	—	string which specifies which class to wrap results in

[ Top ]

functionTable [line 98]

string functionTable(
)

return string for internal table used when calling only a function

Return: for internal table used when calling only a function
Access: public

[ Top ]

guid [line 217]

string guid(
)

Returns global unique identifier

Return: to get global unique identifier
Access: public

[ Top ]

lower [line 188]

return lower(
string
$expression)

return string to call a function to lower the case of an expression

Return: string to lower case of an expression
Access: public

Parameters:

string $expression —

[ Top ]

now [line 116]

string now(
[
$type = 'timestamp'])

Return string to call a variable with the current timestamp inside an SQL statement

There are three special variables for current date and time:

CURRENT_TIMESTAMP (date and time, TIMESTAMP type)
CURRENT_DATE (date, DATE type)
CURRENT_TIME (time, TIME type)

Return: to call a variable with the current timestamp
Access: public

Parameters:

$type —

[ Top ]

random [line 173]

return random(
)

return string to call a function to get random value inside an SQL statement

Return: string to generate float between 0 and 1
Access: public

[ Top ]

substring [line 138]

string substring(

$value, [
$position = 1], [
$length = null])

return string to call a function to get a substring inside an SQL statement

Return: to call a function to get a substring
Access: public

Parameters:

	`$value`	—
	`$position`	—
	`$length`	—

[ Top ]

upper [line 203]

return upper(
string
$expression)

return string to call a function to upper the case of an expression

Return: string to upper case of an expression
Access: public

Parameters:

string $expression —

[ Top ]

Class: MDB2_Driver_Function_Common

Class Overview

Author(s):

Methods

Inherited Variables

Class: MDB2_Module_Common

Inherited Methods

Class: MDB2_Module_Common

Class Details

Method Detail

concat [line 158]

Parameters:

executeStoredProc [line 77]

Parameters:

functionTable [line 98]

guid [line 217]

lower [line 188]

Parameters:

now [line 116]

Parameters:

random [line 173]

substring [line 138]

Parameters:

upper [line 203]

Parameters: