Module_Database_QueryBuilder::select

select(c1, c2, c3,......)

如果查询是SELECT * 则不需要设置，系统会自动处理

 $db->select('id', 'username')->from('members')->get()->as_array();
 echo $db->last_query();     //SELECT `id`, `username` FROM `members`;

 $db->select('db1.id', 'db2.username')->from('members as db1')->join('mydb as db2')->on('db1.id', 'db2.mid')->get()->as_array();
 echo $db->last_query();     //SELECT `db1`.`id`, `db2`.`username` FROM `members` AS `db1` JOIN ON `db1`.`id` = `db2`.`mid`;

 // 使用Database::expr_value()方法可以传入一个不被解析的字符串
 $db->select(Database::expr_value('SUM("id") as `id`'))->from('members')->get()->as_array();
 echo $db->last_query();     //SELECT SUM("id") as `id` FROM `members`;

Database Module_Database_QueryBuilder::select( mixed $columns )

参数列表

参数类型描述默认值

$columns mixed Column name or array($column, $alias) or object

参数	类型	描述	默认值
`$columns`	`mixed`	Column name or array($column, $alias) or object

返回值

Database

File: ./modules/database/querybuilder.class.php

public function select($columns)
{
    if (func_num_args() > 1)
    {
        $columns = func_get_args();
    }
    elseif (is_string($columns))
    {
        $columns = explode(',', $columns);
    }
    elseif (!is_array($columns))
    {
        $columns = array($columns);
    }

    $this->_builder['select'] = array_merge($this->_builder['select'], $columns);

    return $this;
}