SQL
SQL
Joins a sql statement. Implements chaining-interface.
$_db : \Fuman_Db_Abstract
__construct(\Fuman_Db_Abstract $db) : \Fuman_Db_SqlJoin
Constructor
| \Fuman_Db_Abstract | $db |
addSql(string $sql) : \Fuman_Db_SqlJoin
Add Sql to query.
| string | $sql |
addTable(string $tableName, null|string $aliasName = null) : \Fuman_Db_SqlJoin
Add table-name to query. If a alias-name is given, the "AS" statment will be created as well.
| string | $tableName | |
| null|string | $aliasName |
addColumn(string $columnName, string|null $tableName = null) : \Fuman_Db_SqlJoin
Adds column
| string | $columnName | |
| string|null | $tableName |
addColumns() : \Fuman_Db_SqlJoin
Add column-name(s) to query. Column-names can be appended as arguments.
addOrder( $column, string $direction = 'ASC', null $tableName = null) : \Fuman_Db_SqlJoin
Add order column sql
| $column | ||
| string | $direction | |
| null | $tableName |
addTableColumns(string $tableName, array|null $columnNames = null) : \Fuman_Db_SqlJoin
Adds a list of columnNames.
| string | $tableName | |
| array|null | $columnNames | (or param list) |