How to fix Unknown column 'CONCAT' in laravel

Question

Work in the native query but when I turn into laravel code there is some error

I confused because my CONCAT is considered as column

$query = DB::table('bonus_produksi')
            ->join('bonus_areas', 'bonus_produksi.area', '=', 'bonus_areas.id')
            ->select('bonus_produksi.area',
                     'CONCAT(\'Rp.\',frupiah(bonus_produksi.besaran)',
                     'bonus_areas.nama_area')->get();

Unknown column 'CONCAT('Rp.',frupiah(bonus_produksi.besaran),',00')'

if you are using RAW sql in your select function, you need to tell it you are. laravel.com/docs/5.7/queries#raw-expressions — Petay87
– Petay87, Commented Aug 29, 2019 at 7:28

Petay87 · Accepted Answer · 2019-08-29 07:31:46Z

3

Inform the query builder you are using a RAW statement.

$query = DB::table('bonus_produksi')
            ->join('bonus_areas', 'bonus_produksi.area', '=', 'bonus_areas.id')
            ->select('bonus_produksi.area',
                     DB::raw("CONCAT(\'Rp.\',frupiah(bonus_produksi.besaran) as column_name"),
                     'bonus_areas.nama_area')->get();

Be sure to also include this at the top:

use DB;

answered Aug 29, 2019 at 7:31

Petay87

1,7735 gold badges25 silver badges39 bronze badges

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

Comments

Sandeep Sudhakaran · Accepted Answer · 2019-08-29 07:30:23Z

0

Try the below answer

$query = DB::table('bonus_produksi')
        ->join('bonus_areas', 'bonus_produksi.area', '=', 'bonus_areas.id')
        ->selectRaw("bonus_produksi.area,
                 CONCAT('Rp.',frupiah(bonus_produksi.besaran),
                 bonus_areas.nama_area")->get();

answered Aug 29, 2019 at 7:30

Sandeep Sudhakaran

1,0982 gold badges10 silver badges23 bronze badges

2 Comments

Ragil Pratama Over a year ago

i try your answer but i get {"draw":1,"recordsTotal":2,"recordsFiltered":0,"data":[],"error":"Exception Message:\n\nUndefined property: stdClass::$id"}

Sandeep Sudhakaran Over a year ago

you have to add id in your selectRaw string. dont forget to add a comma seperator

Collectives™ on Stack Overflow

How to fix Unknown column 'CONCAT' in laravel

2 Answers 2

Inform the query builder you are using a RAW statement.

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Inform the query builder you are using a RAW statement.

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related