Class for SQL SELECT fragments.

This class simply holds a string, so that fragments of SQL statements can be distinguished from identifiers and values that should be implicitly quoted when interpolated into SQL statements.

For example, when specifying a primary key value when inserting into a new row, some RDBMS brands may require you to use an expression to generate the new value of a sequence. If this expression is treated as an identifier, it will be quoted and the expression will not be evaluated. Another example is that you can use Zend_Db_Expr in the Zend_Db_Select::order() method to order by an expression instead of simply a column name.

The way this works is that in each context in which a column name can be specified to methods of Zend_Db classes, if the value is an instance of Zend_Db_Expr instead of a plain string, then the expression is not quoted. If it is a plain string, it is assumed to be a plain column name.

category Zend
package Zend_Db
subpackage Expr
copyright Copyright (c) 2005-2015 Zend Technologies USA Inc. (http://www.zend.com)
license New BSD License

 Methods

Instantiate an expression, which is just a string stored as an instance member variable.

__construct(string $expression) 

Parameters

$expression

string

The string containing a SQL expression.

__toString()

__toString() : string

Returns

stringThe string of the SQL expression stored in this object.

 Properties

 

Storage for the SQL expression.

$_expression : string

Default