Zeta Components - high quality PHP components

Zeta Components Manual :: Docs For Class ezcQueryInsert

Database::ezcQueryInsert

Class ezcQueryInsert

Class to create select database independent INSERT queries.

Note that this class creates queries that are syntactically independant of database. Semantically the queries still differ and so the same query may produce different results on different databases. Such differences are noted throughout the documentation of this class.

This class implements SQL92. If your database differs from the SQL92 implementation extend this class and reimplement the methods that produce different results. Some methods implemented in ezcQuery are not defined by SQL92. These methods are marked and ezcQuery will return MySQL syntax for these cases.

The examples show the SQL generated by this class. Database specific implementations may produce different results.

Example:

$q = ezcDbInstance::get()->createInsertQuery();
$q->insertInto( 'legends' )
->set( 'name', $q->bindValue( 'Gretzky' ) )
->set( 'year', $q->bindValue( 1961 ) );
$stmt = $q->prepare();
$stmt->execute();

Source for this file: /Database/src/sqlabstraction/query_insert.php

ezcQuery
   |
   --ezcQueryInsert

Version:

//autogentag//

Member Variables

protected array(string=>mixed)


              $values
               = array()

Holds the columns and the values that should inserted into the the table.

Format array('column'=>value)

Inherited Member Variables

From ezcQuery
protected	`ezcQuery::$db`
public	`ezcQuery::$expr`

Method Summary

public ezcQueryInsert	`__construct( $db , [ $aliases = array()] )` Constructs a new ezcQueryInsert that works on the database $db and with the aliases $aliases.
public string	`getQuery( )` Returns the query string for this query object.
public ezcQueryInsert	`insertInto( $table )` Opens the query and sets the target table to $table.
public ezcQueryInsert	`set( $column , $expression )` The insert query will set the column $column to the value $expression.

Inherited Methods

From ezcQuery
public ezcQuery	`ezcQuery::__construct()` Constructs a new ezcQuery that works on the database $db and with the aliases $aliases.
public static array	`ezcQuery::arrayFlatten()` Returns all the elements in $array as one large single dimensional array.
public string	`ezcQuery::bindParam()` Binds the parameter $param to the specified variable name $placeHolder..
public string	`ezcQuery::bindValue()` Binds the value $value to the specified variable name $placeHolder.
public void	`ezcQuery::doBind()` Performs binding of variables bound with bindValue and bindParam on the statement $stmt.
protected string	`ezcQuery::getIdentifier()` Returns the correct identifier for the alias $alias.
protected array(string)	`ezcQuery::getIdentifiers()` Returns the correct identifiers for the aliases found in $aliases.
public abstract string	`ezcQuery::getQuery()` Returns the query string for this query object.
public bool	`ezcQuery::hasAliases()` Returns true if this object has aliases.
public PDOStatement	`ezcQuery::prepare()` Returns a prepared statement from this query which can be used for execution.
protected void	`ezcQuery::resetBinds()` Resets the bound values and parameters to empty.
public void	`ezcQuery::setAliases()` Sets the aliases $aliases for this object.
public ezcQuerySubSelect	`ezcQuery::subSelect()` Returns the ezcQuerySubSelect query object.
public string	`ezcQuery::__toString()` Return SQL string for query.

Methods

__construct

ezcQueryInsert __construct( $db , [ $aliases = array()] )

Constructs a new ezcQueryInsert that works on the database $db and with the aliases $aliases.

The parameters are passed directly to ezcQuery.

Parameters:

Name	Type	Description
`$db`	PDO
`$aliases`	array(string=>string)

Redefinition of:

Method	Description
`ezcQuery::__construct()`	Constructs a new ezcQuery that works on the database $db and with the aliases $aliases.

getQuery

string getQuery( )

Returns the query string for this query object.

Exceptions:

Type	Description
`ezcQueryInvalidException`	if no table or no values have been set.

Redefinition of:

Method	Description
`ezcQuery::getQuery()`	Returns the query string for this query object.

insertInto

ezcQueryInsert insertInto( string $table )

Opens the query and sets the target table to $table.

insertInto() returns a pointer to $this.

Parameters:

Name	Type	Description
`$table`	string

set

ezcQueryInsert set( string $column , string $expression )

The insert query will set the column $column to the value $expression.

set() returns a pointer to $this.

Parameters:

Name	Type	Description
`$column`	string
`$expression`	string

Documentation generated by phpDocumentor 1.4.3