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


Classes:
MDB2_BufferedResult_mssql
MDB2_Driver_Datatype_mssql
MDB2_Driver_Function_mssql
MDB2_Driver_Manager_mssql
MDB2_Driver_mssql
MDB2_Driver_Native_mssql
MDB2_Driver_Reverse_mssql
MDB2_Result_mssql
MDB2_Statement_mssql
Files:
mssql.php
mssql.php
mssql.php
mssql.php
mssql.php
mssql.php

Class: MDB2_Driver_Function_mssql

Source Location: /MDB2_Driver_mssql-1.5.0b4/MDB2/Driver/Function/mssql.php

Class Overview

MDB2_Driver_Function_Common
   |
   --MDB2_Driver_Function_mssql

MDB2 MSSQL driver for the function modules


Author(s):

Methods

Inherited Variables

Inherited Methods

Class Details

[line 58]
MDB2 MSSQL driver for the function modules


[ Top ]

Method Detail

concat   [line 155]

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 74]

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 ]

guid   [line 185]

string guid( )

Returns global unique identifier
  • Return: to get global unique identifier
  • Access: public

[ Top ]

length   [line 171]

return length( string $expression)

return string to call a function to get the length of a string expression
  • Return: string to get the string expression length
  • Access: public

Parameters:

string   $expression   — 

[ Top ]

now   [line 99]

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 ]

substring   [line 135]

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 ]

unixtimestamp   [line 121]

string unixtimestamp( string $expression)

return string to call a function to get the unix timestamp from a iso timestamp
  • Return: to call a variable with the timestamp
  • Access: public

Parameters:

string   $expression   — 

[ Top ]
Documentation generated on Mon, 11 Mar 2019 15:51:10 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.