{"id":1500,"date":"2017-01-13T10:05:16","date_gmt":"2017-01-13T10:05:16","guid":{"rendered":"http:\/\/myprojects.advchaweb.com\/?p=1500"},"modified":"2017-01-16T06:32:19","modified_gmt":"2017-01-16T06:32:19","slug":"laravel-tips-tricks","status":"publish","type":"post","link":"https:\/\/myprojects.advchaweb.com\/index.php\/2017\/01\/13\/laravel-tips-tricks\/","title":{"rendered":"Laravel Tips & Tricks"},"content":{"rendered":"

View (Template)<\/span><\/p>\n

    \n
  1. How to show the data in the blade template (like var_dump function)?
    \nSolution:<\/p>\n
    @foreach($booking as $item)\r\n    {{ dd($item->toArray()) }}\r\n@endfor<\/pre>\n
    use ‘dd’ instead of var_dump. but var_dump also can be used to replace dd!<\/li>\n
  2. How to concatenate strings?
    \nSolution: Use ‘.’ like in PHP<\/p>\n
    $item->customer->first_name.' '.$item->customer->last_name<\/pre>\n<\/li>\n
  3. How to check if variable is empty (null)?
    \nSolution: Use ‘is_null()’ like in PHP<\/p>\n
    @if(is_null($item->customer)){{ $item->customer_id }}@else{{$item->customer->first_name.' '.$item->customer->last_name}}@endif<\/pre>\n
     <\/li>\n
  4. How to find out the array key\/index in foreach loop
    \nSolution:<\/p>\n
    @foreach($select_cities as $idx=>$item)\r\n    <div class=\"chk_city\">{!! Form::checkbox('city[]', $idx, null, ['class' => 'field']) !!} <span>{!! $item !!}<\/span><\/div>\r\n@endforeach<\/pre>\n
    Use ‘key=>value’ pair in foreach loop<\/li>\n
  5. How to link to the css files in \/public\/css\/ directory?
    \nSolution: Use ‘URL:asset()’ like this<\/p>\n
    <link href=\"{{ URL::asset('css\/style.css') }}\" rel=\"stylesheet\"><\/pre>\n
     <\/li>\n<\/ol>\n
    Model<\/span><\/p>\n
    Controller<\/span><\/p>\n
      \n
    1. How to use Eloquent Query (select, join, group by, etc)
      \nSolution: Use ‘DB::table’
      \nTo use specific command like ‘GROUP_CONCAT’, use ‘DB::raw()’
      \nDon’t put ‘get()’ at the end of the query if the blade template use ‘render’ but use ‘paginate()’ instead<\/p>\n
      $cleaner = DB::table('cleaners')\r\n                ->join('cleaner_cities','cleaners.id','=','cleaner_cities.cleaner_id')\r\n                ->join('cities','cleaner_cities.city_id','=','cities.id')\r\n                ->select('cleaners.id','cleaners.first_name','cleaners.last_name','cleaners.quality_score',DB::raw('(GROUP_CONCAT(cities.city_name)) AS city'))\r\n                ->groupBy('cleaners.id','cleaners.first_name','cleaners.last_name','cleaners.quality_score')\r\n                ->paginate(25);\r\n\r\nreturn view('admin.cleaner.index', compact('cleaner'));<\/pre>\n
       <\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
      View (Template) How to show the data in the blade template (like var_dump function)? Solution: @foreach($booking as $item) {{ dd($item->toArray()) }} @endfor use ‘dd’ instead of var_dump. but var_dump also can be used to replace dd! How to concatenate strings? Solution: Use ‘.’ like in PHP $item->customer->first_name.’ ‘.$item->customer->last_name How to check if variable is empty … Continue reading “Laravel Tips & Tricks”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,13],"tags":[],"class_list":["post-1500","post","type-post","status-publish","format-standard","hentry","category-laravel","category-tutorial"],"_links":{"self":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/comments?post=1500"}],"version-history":[{"count":7,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1500\/revisions"}],"predecessor-version":[{"id":1525,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1500\/revisions\/1525"}],"wp:attachment":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/media?parent=1500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/categories?post=1500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/tags?post=1500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}