lundi 21 novembre 2016

how to create select join multiple condition in laravel 5.3

how to create select join multiple condition in laravel 5.3

SQL SELECT Statement.

SELECT  table_1.column_1
        ,table_2.column_1
        ,table_3.column_1
FROM    table_1
LEFT JOIN   table_2
ON  table_1.column_1 = table_2.column_1
LEFT JOIN   table_3
ON  table_1.column_2 = table_3.column_2
AND table_3.column_3 <= NOW()
AND (   table_3.column_4 >= NOW()
        OR table_3.column_4 = 0
    )
WHERE   table_1.column_1 = '0000000001'

I want to convert SQL Statement to laravel select. I try.

$result = DB::table('table_1')
          ->select('table_1.column_1', 'table_2.column_1', 'table_3.column_1')
          ->leftJoin('table_1', 'table_1.column_1', '=', 'table_2.column_1')
          ->leftJoin('table_3', 'table_1.column_2', '=', 'table_3.column_2')
          ->where('table_1', $_POST['id'])
          ->get();



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire