Laravel DB::select not return value as expected

Question

I'm having problem to view data using db::select.

Here is my full sql statement [Tested and return value as expected on mysql]

SELECT tugasan_kontrak.*,sejarah.tkh_wujud AS tkh_wujud ,sejarah.id_tindakan AS id_tindakan 
FROM tugasan_kontrak 
LEFT JOIN sejarah ON(
tugasan_kontrak.id_tugasan = sejarah.id_tugasan AND 
jenis_tugasan='k' AND 
sejarah.id_tindakan !='99' AND
id_sejarah = (SELECT MAX(id_sejarah) FROM sejarah WHERE 
    tugasan_kontrak.id_tugasan = sejarah.id_tugasan AND jenis_tugasan='k') 
)
WHERE pegawai_tugas='890911105098' AND id_tindakan IS NOT NULL

Result

But when I try to apply this statement using db::select, no record were view.

Here the function I use to test

public function getPenggunaTindakan($value='890911105098')
{
    $kontrak = DB::select("select tugasan_kontrak.*,sejarah.tkh_wujud as tkh_wujud ,sejarah.id_tindakan as id_tindakan 
            from tugasan_kontrak left join sejarah on(tugasan_kontrak.id_tugasan = sejarah.id_tugasan and jenis_tugasan='k' and sejarah.id_tindakan !='99' and
                id_sejarah = (select max(id_sejarah) from sejarah where tugasan_kontrak.id_tugasan = sejarah.id_tugasan and jenis_tugasan='k'))
        where pegawai_tugas=:nokp and id_tindakan is not null ",['nokp' => $value]);

    dd($kontrak);
}

What did I do wrong?

Maybe this will help you: stackoverflow.com/questions/36331289/… — Onix
– Onix, Commented Mar 9, 2017 at 9:58

Muthu17 · Accepted Answer · 2017-03-09 12:14:18Z

1

Try the following :

DB::select(DB::raw("select tugasan_kontrak.*,sejarah.tkh_wujud as tkh_wujud ,sejarah.id_tindakan as id_tindakan 
            from tugasan_kontrak left join sejarah on(tugasan_kontrak.id_tugasan = sejarah.id_tugasan and jenis_tugasan='k' and sejarah.id_tindakan !='99' and
                id_sejarah = (select max(id_sejarah) from sejarah where tugasan_kontrak.id_tugasan = sejarah.id_tugasan and jenis_tugasan='k'))
        where pegawai_tugas=:nokp and id_tindakan is not null "),['nokp' => $value]);

If you want to inject sql query, you have to use DB::raw in laravel

edited Mar 9, 2017 at 12:14

answered Mar 9, 2017 at 10:47

Muthu17

1,54112 silver badges20 bronze badges

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

2 Comments

user3875285 Over a year ago

thank its working. but need to fix the ) should put before is not null") ...thanks a lot ...u save my day ^_^

moses toh Over a year ago

@Muthu17 Maybe you can help me. Look at this : stackoverflow.com/questions/51838922/…

Collectives™ on Stack Overflow

Laravel DB::select not return value as expected

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related