Interface UpdateQueryInterface

Description
Description | Methods (details)

An UpdateQuery interface provides the tools to build an SQL UPDATE query.

  • version: $Id: UpdateQuery.interface.php,v 1.7 2007/09/05 21:38:59 adamfranco Exp $
  • license: GNU General Public License (GPL)
  • copyright: Copyright © 2005, Middlebury College

Located in /harmoni/core/DBHandler/UpdateQuery.interface.php (line 26) 

Query
   |
   --UpdateQueryInterface
Method Summary
Description | Methods (details)
void addWhere (string $condition, [integer $logicalOperation = _AND])
void setColumns (mixed $columns, array $table)
void setTable (string $table)
void setValues (array $values)
void setWhere (string $condition)
Methods
Description | Methods (details)
addWhere (line 75)

Adds a new condition in the WHERE clause.

The query will execute only on rows that fulfil the condition. If this method is never called, then the WHERE clause will not be included.

  • access: public
void addWhere (string $condition, [integer $logicalOperation = _AND])
  • string $condition: condition The WHERE clause condition to add.
  • integer $logicalOperation: logicalOperation The logical operation to use to connect this WHERE condition with the previous WHERE conditions. Allowed values: 
    1. _AND
      2.
    and 
    1. _OR
      2.
    .
setColumns (line 42)

Sets the columns to update in the table.

  • access: public
void setColumns (mixed $columns, array $table)
  • array $table: The columns to update in the table.
setTable (line 35)

Sets the table to update.

  • access: public
void setTable (string $table)
  • string $table: The table to update.
setValues (line 50)

Specifies the values that the will be assigned to the columns specified with setColumns().

  • access: public
void setValues (array $values)
  • array $values: The values that the will be assigned to the columns specified with setColumns().
setWhere (line 61)

*Deprecated* Specifies the condition in the WHERE clause.

The query will execute only on rows that fulfil the condition. If this method is never called, then the WHERE clause will not be included.

  • deprecated: July 09, 2003 - Use addWhere() instead.
  • access: public
void setWhere (string $condition)
  • string $condition: The WHERE clause condition.

Inherited Methods

Inherited From Query

Query::getType()
Query::reset()

Documentation generated on Wed, 19 Sep 2007 10:27:37 -0400 by phpDocumentor 1.3.0RC3