Database: ezcQuerySqliteFunctions
[ ]
[ Oracle setup ]
[ ]
[ ]
[ ]
[ ]
Class: ezcQuerySqliteFunctions
|
The ezcQueryExpressionSqlite class is used to create SQL expression for SQLite. [
source]
This class reimplements the methods that have a different syntax in SQLite (substr) and contains PHP implementations of functions that are registered with SQLite with it's PDO::sqliteRegisterFunction() method.
Method Summary
|
public static integer |
ceilImpl(
$number )
Returns the next highest integer value from the number |
|
public static string |
concatImpl(
)
Returns a concattenation of the data that SQLite's concat() function receives. |
|
public static integer |
floorImpl(
$number )
Returns the next lowest integer value from the number |
|
public static string |
md5Impl(
$data )
Returns the md5 sum of the data that SQLite's md5() function receives. |
|
public static string |
modImpl(
$dividend, $divisor )
Returns the modules of the data that SQLite's mod() function receives. |
|
public static integer |
positionImpl(
$substr, $value )
Returns the SQL to locate the position of the first occurrence of a substring |
Methods
ceilImpl
integer ceilImpl(
numeric
$number )
Returns the next highest integer value from the number
Parameters
| Name |
Type |
Description |
$number |
numeric |
|
concatImpl
string concatImpl(
)
Returns a concattenation of the data that SQLite's concat() function receives.
floorImpl
integer floorImpl(
numeric
$number )
Returns the next lowest integer value from the number
Parameters
| Name |
Type |
Description |
$number |
numeric |
|
md5Impl
string md5Impl(
string
$data )
Returns the md5 sum of the data that SQLite's md5() function receives.
Parameters
| Name |
Type |
Description |
$data |
string |
|
modImpl
string modImpl(
numeric
$dividend, numeric
$divisor )
Returns the modules of the data that SQLite's mod() function receives.
Parameters
| Name |
Type |
Description |
$dividend |
numeric |
|
$divisor |
numeric |
|
positionImpl
integer positionImpl(
string
$substr, string
$value )
Returns the SQL to locate the position of the first occurrence of a substring
Parameters
| Name |
Type |
Description |
$substr |
string |
|
$value |
string |
|
Last updated: Wed, 28 Nov 2007
