Laravel DB::Raw snippets

example-getting-one-column-from-a-db-table-with-lists.md

        $ids = DB::table('service')
                ->select(DB::raw('DISTINCT label_id AS cat_label_id'))
                ->whereNull('deleted_date')
                ->lists('cat_label_id');

$ids will be an array.

example-try-catch-für-db-raw.md

    $sSelect   = '
        SELECT DISTINCT label_id
        FROM service
        WHERE flag_deleted = 0
    ';

    try {
        $ids = DB::select(DB::raw($sSelect));

    } catch (Exception $e) {
        \Log::error(__METHOD__ ." Error: ".$e->getMessage());
        throw new HttpException(500, 'detected an internal error in: '.__METHOD__ );
    }