eZ Components 1.0.1

Getting Started

Components

Archive (1.0.1)
Base (1.0)
Cache (1.0.1)
Configuration (1.0.1)
ConsoleTools (1.0)
Database (1.0.1)
Debug (1.0)
EventLog (1.0)
EventLogDatabaseTiein (1.0)
Execution (1.0)
ImageAnalysis (1.0.1)
ImageConversion (1.0.1)
Mail (1.0.1)
PersistentObject (1.0.1)
PhpGenerator (1.0)
Translation (1.0)
TranslationCacheTiein (1.0)
UserInput (1.0)

Database: ezcQueryExpressionSqlite

[ Tutorial ] [ Class tree ] [ Element index ] [ ChangeLog ] [ Credits ]

Class: ezcQueryExpressionSqlite

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.

Parents

ezcQueryExpression
   |
   --ezcQueryExpressionSqlite

Method Summary

public string

subString(
$value, $from, [$len = null] )

Returns part of a string.

Inherited Methods

From ezcQueryExpression :

public ezcQueryExpression	`ezcQueryExpression::__construct()` Constructs an empty ezcQueryExpression
public string	`ezcQueryExpression::add()` Returns the SQL to add values or expressions together.
public string	`ezcQueryExpression::avg()` Returns the average value of a column
public string	`ezcQueryExpression::between()` Returns SQL that checks if an expression evaluates to a value between two values.
public void	`ezcQueryExpression::concat()` Returns a series of strings concatinated
public string	`ezcQueryExpression::count()` Returns the number of rows (without a NULL value) of a column
public string	`ezcQueryExpression::div()` Returns the SQL to divide values or expressions by eachother.
public string	`ezcQueryExpression::eq()` Returns the SQL to check if two values are equal.
protected string	`ezcQueryExpression::getIdentifier()` Returns the correct identifier for the alias $alias.
protected array(string)	`ezcQueryExpression::getIdentifiers()` Returns the correct identifiers for the aliases found in $aliases.
public string	`ezcQueryExpression::gt()` Returns the SQL to check if one value is greater than another value.
public string	`ezcQueryExpression::gte()` Returns the SQL to check if one value is greater than or equal to another value.
public bool	`ezcQueryExpression::hasAliases()` Returns true if this object has aliases.
public string	`ezcQueryExpression::in()` Returns the SQL to check if a value is one in a set of given values..
public string	`ezcQueryExpression::isNull()` Returns SQL that checks if a expression is null.
public string	`ezcQueryExpression::lAnd()` Returns the SQL to bind logical expressions together using a logical and.
public string	`ezcQueryExpression::length()` Returns the length of a text field.
public void	`ezcQueryExpression::like()` Match a partial string in a column.
public string	`ezcQueryExpression::lOr()` Returns the SQL to bind logical expressions together using a logical or.
public string	`ezcQueryExpression::lt()` Returns the SQL to check if one value is less than another value.
public string	`ezcQueryExpression::lte()` Returns the SQL to check if one value is less than or equal to another value.
public string	`ezcQueryExpression::max()` Returns the highest value of a column
public string	`ezcQueryExpression::md5()` Returns the md5 sum of a field.
public string	`ezcQueryExpression::min()` Returns the lowest value of a column
public string	`ezcQueryExpression::mod()` Returns the remainder of the division operation $expression1 / $expression2.
public string	`ezcQueryExpression::mul()` Returns the SQL to multiply values or expressions by eachother.
public string	`ezcQueryExpression::neq()` Returns the SQL to check if two values are unequal.
public string	`ezcQueryExpression::not()` Returns the SQL for a logical not.
public string	`ezcQueryExpression::now()` Returns the current system date.
public string	`ezcQueryExpression::round()` Rounds a numeric field to the number of decimals specified.
public void	`ezcQueryExpression::setAliases()` Sets the aliases $aliases for this object.
public string	`ezcQueryExpression::sub()` Returns the SQL to subtract values or expressions from eachother.
public string	`ezcQueryExpression::subString()` Returns part of a string.
public string	`ezcQueryExpression::sum()` Returns the total sum of a column

Methods

subString

string subString( string $value, int $from, [int $len = null] )

Returns part of a string.

Note: Not SQL92, but common functionality. SQLite only supports the 3 parameter variant of this function, so we are using 2^30-1 as artificial length in that case.

Parameters

Name	Type	Description
`$value`	string	the target $value the string or the string column.
`$from`	int	extract from this characeter.
`$len`	int	extract this amount of characters.

Redefinition of

Method	Description
`ezcQueryExpression::subString()`	Returns part of a string.

Last updated: Fri, 02 Nov 2007

eZ Components

User menu

Path