Lines Matching refs:statement
13 /** @var array (alias -> statement */
15 /** @var array (alias -> statement) */
37 * If the alias already exists, the current statement for that alias will be overwritten.
53 * Add a new column selection statement
55 * Basically the same as @param string $statement
57 * @see addSelectColumn() but accepts any statement. This is useful to
61 * If the alias already exists, the current statement for that alias will be overwritten.
64 public function addSelectStatement($statement, $alias)
66 $this->select[$alias] = $statement;
70 * Return an already defined column selection statement based on the alias
86 * Adds the the table to the FROM statement part
102 * Adds a LEFT JOIN clause to the FROM statement part, sorted at the correct spot
120 $statement = "LEFT OUTER JOIN $righttable AS $rightalias ON $onclause";
121 $this->from = $this->arrayInsert($this->from, [$rightalias => $statement], $pos + 1);
162 * Like @param string $statement a single grouping clause
163 * @see addGroupByColumn but accepts an arbitrary statement
166 public function addGroupByStatement($statement)
168 $this->groupby[] = $statement;
172 * Adds a value to the statement
174 * This function returns the name of the placeholder you have to use in your statement, so whenever
175 * you need to use a user value in a statement, call this first, then add the statement through the
205 * Returns the complete SQL statement and the values to apply
213 foreach ($this->from as $alias => $statement) {
220 $from .= $statement;