How to manipulate the laravel query builder output data using php

Question

Assume I have a simple laravel query builder.

$data = DB::table('users')->get();

(I want to use only query builder and not eloquent since the query will be very complex in reality)

and the table fields are userid, firstname, lastname, gender

before I pass the $data to my view I would like to modify the output data using PHP

Say I wanted to add the prefix Mr or Miss to firstname depending on the gender column or something like that.. (please don't suggest a pure sql solution since the complexity of the condition will be much more complex that just adding a prefix.. I had given this as a simple use case only)

Is it possible ?

If you decided to use Eloquent, accessors would be great solution for this - laravel.com/docs/4.2/eloquent#accessors-and-mutators — Marcin Nabiałek
– Marcin Nabiałek, Commented Oct 19, 2014 at 9:12

worldask · Accepted Answer · 2014-10-19 08:20:18Z

1

just iterate the result

foreach ($data as $key => $value) {
  if ($value->gender === 1) {
    $value->lastname = 'Mr ' . $value->lastname;
  } else if ($value->gender === 0) {
    $value->lastname = 'Miss ' . $value->lastname;
  }
}

answered Oct 19, 2014 at 8:20

worldask

1,8373 gold badges22 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shanthi Over a year ago

forgot the obvious :)

Collectives™ on Stack Overflow

How to manipulate the laravel query builder output data using php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related