Home > Net >  How to use DB:: from helper class
How to use DB:: from helper class

Time:03-04

I have a helper class name common.php in App\Helpers folder. I want to use DB:: facade here to use some db table. In helper method My code is -

<?php

use DB;
function ref_number()
{
    $last_row = DB::table('model_table')->latest('id')->first();
    if($last_row) {
        $ref = explode('-', $last_row->ref);

        if($ref[0] === date('y')) {
            // if running year
            $ref = $ref[1]   1;
            $ref = date('y') .'-'. $ref;
        }
        else{
            $ref = date('y') .'-'. 1; // if new year
        }
    }
    else{
        $ref = date('y') .'-'. 1; // if first data
    }

    return $ref;
}

But this not working. Following error has been arrived.

Following error has been arrived.

So how can i solve this?

CodePudding user response:

Change your using to: Illuminate\Support\Facades\DB;

  • Related