MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]
Packages:
MDB2
apidoc


Classes:
MDB2
MDB2_BufferedIterator
MDB2_Date
MDB2_Driver_Common
MDB2_Driver_Datatype_Common
MDB2_Driver_Function_Common
MDB2_Driver_Manager_Common
MDB2_Driver_Native_Common
MDB2_Driver_Reverse_Common
MDB2_Error
MDB2_Extended
MDB2_Iterator
MDB2_LOB
MDB2_Module_Common
MDB2_Result
MDB2_Result_Common
MDB2_Row
MDB2_Statement_Common
Files:
clitest.php
Common.php
Common.php
Common.php
Common.php
Common.php
config.php
Console_TestListener.php
Date.php
example.php
Extended.php
HTML_TestListener.php
import.schema.php
Iterator.php
LOB.php
MDB2.php
MDB2_api_testcase.php
MDB2_bugs_testcase.php
MDB2_Connect_Test.php
MDB2_datatype_testcase.php
MDB2_extended_testcase.php
MDB2_function_testcase.php
MDB2_internals_testcase.php
MDB2_manager_testcase.php
MDB2_native_testcase.php
MDB2_nonstandard.php
MDB2_nonstandard_ibase.php
MDB2_nonstandard_mssql.php
MDB2_nonstandard_mysql.php
MDB2_nonstandard_mysqli.php
MDB2_nonstandard_oci8.php
MDB2_nonstandard_pgsql.php
MDB2_nonstandard_sqlite.php
MDB2_reverse_testcase.php
MDB2_testcase.php
MDB2_usage_testcase.php
test.php
testchoose.php
testUtils.php

Class: MDB2_Driver_Function_Common

Source Location: /MDB2-2.4.0/MDB2/Driver/Function/Common.php

Class Overview

MDB2_Module_Common
   |
   --MDB2_Driver_Function_Common

Base class for the function modules that is extended by each MDB2 driver


Author(s):

Methods

Inherited Variables

Class: MDB2_Module_Common

MDB2_Module_Common::$db_index

Inherited Methods

Class: MDB2_Module_Common

MDB2_Module_Common::__construct()
Constructor
MDB2_Module_Common::MDB2_Module_Common()
PHP 4 Constructor
MDB2_Module_Common::getDBInstance()
Get the instance of MDB2 associated with the module instance

Class Details

[line 61]
Base class for the function modules that is extended by each MDB2 driver


[ Top ]

Method Detail

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 ]
Documentation generated on Tue, 13 Mar 2007 17:00:19 -0500 by phpDocumentor 1.3.0. PEAR Logo Copyright © PHP Group 2004.