Laravel 5查询生成器中的多个select() [英] Laravel 5 multiple select() in query builder

问题描述

在laravel 5.1中，我想做

In laravel 5.1, I want to do like

$myTable = MyTable->select('firstField');

if ($somethingTrue) {
    $myTable->select('secondField');
}

$myTable->get();

我想同时在firstfield&要选择的secondField.
当然，上面的代码不起作用，即最后只选择了secondField.

查询构建器类提供的任何功能都可以完全满足我的要求吗?

where I want both firstField & secondField to be selected.
Of course the code above is not working, i.e. only the secondField is selected in the end.

Is there any function provided by query builder class that can do exactly what I want?

推荐答案

是的，您可以使用addSelect()

在选择"下的查询生成器文档中:

如果您已经具有查询生成器实例，并且希望将列添加到其现有的select子句中，则可以使用addSelect方法:

If you already have a query builder instance and you wish to add a column to its existing select clause, you may use the addSelect method:

$query = DB::table('users')->select('name');
$users = $query->addSelect('age')->get();

此外， API文档(视情况而定)书面文档)还可以进一步说明核心类上可用的功能.

Additionally, the API documentation (as apposed to the written documentation) can also shed additional light on what functions are available on core classes.

这篇关于Laravel 5查询生成器中的多个select()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！