Class QueryHelper

Description

Utility class for anydB

This class provides methods to generate sql queries.

Don't instanciate this class.
Use 'QueryHelper::methodName()' instead.

Located in /core/anyDB/addon/QueryHelper.php (line 27)

UtilityClass
   |
   --QueryHelper
Method Summary
String delete (String $table, [String $where = ''], [String $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''])
String insert (String $table, Mixed $values, [String $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''])
String replace (String $table, Mixed $values, [String $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''])
String select (Mixed $columns, mixed $tables, [String $where = ''], [String $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''], String $table)
String update (String $table, Mixed $values, [String $where = ''], [mixed $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''])
Methods
delete (line 221)

Returns an sql DELETE query

  • return: sql query
  • access: public
String delete (String $table, [String $where = ''], [String $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''])
  • String $table: the table
  • String $where: where clause
  • String $smartQuotes: wrap Strings in quotes?
  • String $addon: inserted at the end
  • String $statementAddon: inserted after the DELETE keyword
insert (line 110)

Returns an sql INSERT query

  • return: sql query
  • access: public
String insert (String $table, Mixed $values, [String $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''])
  • String $table: the table
  • Mixed $values: the values to be changed as an associative array as a string
  • String $smartQuotes: wrap Strings in quotes?
  • String $addon: inserted at the end
  • String $statementAddon: inserted after the INSERT keyword
replace (line 153)

Returns an sql REPLACE query

  • return: sql query
  • access: public
String replace (String $table, Mixed $values, [String $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''])
  • String $table: the table
  • Mixed $values: the values to be changed as an associative array as a string
  • String $smartQuotes: wrap Strings in quotes?
  • String $addon: inserted at the end
  • String $statementAddon: inserted after the REPLACE keyword
select (line 196)

Returns an sql SELECT query

  • return: sql query
  • access: public
String select (Mixed $columns, mixed $tables, [String $where = ''], [String $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''], String $table)
  • Mixed $columns: the columns
  • String $table: the table
  • String $where: where clause
  • String $smartQuotes: wrap Strings in quotes?
  • String $addon: inserted at the end
  • String $statementAddon: inserted after the SELECT keyword
update (line 68)

Returns an sql UPDATE query

  • return: sql query
  • access: public
String update (String $table, Mixed $values, [String $where = ''], [mixed $smartQuotes = true], [String $addon = ''], [String $statementAddon = ''])
  • String $table: the table
  • Mixed $values: the values to be changed as an associative array as a string
  • String $where: where clause
  • String $addon: inserted at the end
  • String $statementAddon: inserted after the UPDATE keyword

Inherited Methods

Inherited From UtilityClass

UtilityClass::UtilityClass()

Documentation generated on Tue, 4 Oct 2005 21:59:30 -0700 by phpDocumentor 1.3.0RC3