Laravel Tips & Tricks

View (Template)

1. How to show the data in the blade template (like var_dump function)?
   Solution:
   
   @foreach($booking as $item) {{ dd($item->toArray()) }} @endfor

   1 2 3

   @foreach($booking as $item)     {{ dd($item->toArray()) }} @endfor

   
   use ‘dd’ instead of var_dump. but var_dump also can be used to replace dd!
2. How to concatenate strings?
   Solution: Use ‘.’ like in PHP
   
   $item->customer->first_name.' '.$item->customer->last_name

   1	$item->customer->first_name.' '.$item->customer->last_name

3. How to check if variable is empty (null)?
   Solution: Use ‘is_null()’ like in PHP
   
   @if(is_null($item->customer)){{ $item->customer_id }}@else{{$item->customer->first_name.' '.$item->customer->last_name}}@endif

   1	@if(is_null($item->customer)){{ $item->customer_id }}@else{{$item->customer->first_name.' '.$item->customer->last_name}}@endif

   
    
4. How to find out the array key/index in foreach loop
   Solution:
   
   @foreach($select_cities as $idx=>$item) <div class="chk_city">{!! Form::checkbox('city[]', $idx, null, ['class' => 'field']) !!} <span>{!! $item !!}</span></div> @endforeach

   1 2 3

   @foreach($select_cities as $idx=>$item)     <div class="chk_city">{!! Form::checkbox('city[]', $idx, null, ['class' => 'field']) !!} <span>{!! $item !!}</span></div> @endforeach

   
   Use ‘key=>value’ pair in foreach loop
5. How to link to the css files in /public/css/ directory?
   Solution: Use ‘URL:asset()’ like this
   
   <link href="{{ URL::asset('css/style.css') }}" rel="stylesheet">

   1	<link href="{{ URL::asset('css/style.css') }}" rel="stylesheet">

   
    

Model

Controller

1. How to use Eloquent Query (select, join, group by, etc)
   Solution: Use ‘DB::table’
   To use specific command like ‘GROUP_CONCAT’, use ‘DB::raw()’
   Don’t put ‘get()’ at the end of the query if the blade template use ‘render’ but use ‘paginate()’ instead
   
   $cleaner = DB::table('cleaners') ->join('cleaner_cities','cleaners.id','=','cleaner_cities.cleaner_id') ->join('cities','cleaner_cities.city_id','=','cities.id') ->select('cleaners.id','cleaners.first_name','cleaners.last_name','cleaners.quality_score',DB::raw('(GROUP_CONCAT(cities.city_name)) AS city')) ->groupBy('cleaners.id','cleaners.first_name','cleaners.last_name','cleaners.quality_score') ->paginate(25); return view('admin.cleaner.index', compact('cleaner'));

   1 2 3 4 5 6 7 8

   $cleaner = DB::table('cleaners')                 ->join('cleaner_cities','cleaners.id','=','cleaner_cities.cleaner_id')                 ->join('cities','cleaner_cities.city_id','=','cities.id')                 ->select('cleaners.id','cleaners.first_name','cleaners.last_name','cleaners.quality_score',DB::raw('(GROUP_CONCAT(cities.city_name)) AS city'))                 ->groupBy('cleaners.id','cleaners.first_name','cleaners.last_name','cleaners.quality_score')                 ->paginate(25);   return view('admin.cleaner.index', compact('cleaner'));