In laravel 5.1, I want to do like
$myTable = MyTable->select('firstField');
if ($somethingTrue) {
$myTable->select('secondField');
}
$myTable->get();
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?
Yes, you can use addSelect()
From the Query Builder documentation under "Selects":
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();
Additionally, the API documentation (as apposed to the written documentation) can also shed additional light on what functions are available on core classes.
Accepted answer is probably more elegant, but you could also just use an array of fields for your select clause.
$fields = ['firstField'];
if ($someCondition) {
$fields[] = 'secondField';
}
$result = DB::table('users')->select($fields)->get();
mwallisch's answer is better than accepted one because, if you have multiple places where you are defining selects then addSelect wont work.
For instance, following code will throw error:
$myTable = MyTable->select('firstField');
if ($somethingTrue) {
$myTable->addSelect('secondField');
}
if ($somethingElseTrue) {
$myTable->addSelect('thirdField');
}
$myTable->get();
while it can be done as:
$fields = ['firstField'];
if ($somethingTrue) {
$fields[] = 'secondField';
}
if ($somethingElseTrue) {
$fields[] = 'thirdField';
}
$result = DB::table('users')->select($fields)->get();
selectRawis automatically appended