Lines Matching +defs:table +defs:column

17     /** @var array (alias -> "table"|"join") keeps how tables were added, as table or join */
35      * Adds a column to select
39      * @param string $tablealias The table to select from
40      * @param string $column The column to select
41      * @param string $alias Under whichname to slect the column. blank for column name
43     public function addSelectColumn($tablealias, $column, $alias = '')
45         if ($alias === '') $alias = $column;
49         $this->select[$alias] = "$tablealias.$column";
53      * Add a new column selection statement
70      * Return an already defined column selection statement based on the alias
86      * Adds the the table to the FROM statement part
88      * @param string $table the table to add
89      * @param string $alias alias for the table, blank for table name
91     public function addTable($table, $alias = '')
93         if ($alias === '') $alias = $table;
97         $this->from[$alias] = "$table AS $alias";
98         $this->type[$alias] = 'table';
104      * @param string $leftalias the alias of the left table you're joining on, has to exist already
105      * @param string $righttable the right table to be joined
106      * @param string $rightalias an alias for the right table, blank for table name
149      * @param string $column
151     public function addGroupByColumn($tablealias, $column)
156         $this->groupby[] = "$tablealias.$column";
192      * Creates a new table alias that has not been used before
214             if ($this->type[$alias] == 'table' && $from) {