Laravel concat in query

Question

I am trying to concatinate 2 tables for the blog using laravel, however i can't seem to get it working and i have no clue as to why..

if i use selectRaw i can see the concat but i lose all the blog content and i only see the author and nothing else.

I have tried to switch to raw and if i do the concat doesn't work but everything else works.

Here is the php code i am using:

 $app->get('/', function() use ($app) {

    $blog = $app->blog->selectRaw('CONCAT(users.first_name, " ", users.last_name) as author')->join('users', 'blog.user_id', '=', 'users.id')->get();

    $app->render('home.php', [
        'blog' => $blog
    ]);
})->name('home');

Scott Anderson · Accepted Answer · 2015-07-22 00:59:57Z

0

You can use the Eloquent join function to achieve this.

For example

DB::table('blog')
            ->join('users', 'blog.user_id', '=', 'users.id')
            ->select('blog.*', 'CONCAT(users.first_name, " ", users.last_name) as author')
            ->get();

answered Jul 22, 2015 at 0:59

Scott Anderson

1,3711 gold badge10 silver badges21 bronze badges

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

3 Comments

darkvergus Over a year ago

well i did give it a try but that doesn't work, since class DB is not found

Scott Anderson Over a year ago

Try putting a `\` in front of it. See details stackoverflow.com/a/25787734/170539

darkvergus Over a year ago

hold on let me edit the code section, thats how i currently have it since the other options don't work for this case

Collectives™ on Stack Overflow

Laravel concat in query

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related