Laravel 5 Eloquent CheatSheet #laravel #eloquent

eloquent-cheatsheet.php

Model::
  /*Select*/
  ->select('col1','col2')
  ->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating'))  
  
  /*Query*/
  ->where('column','value')
  ->where('column','LIKE','%'.$value.'%')
  ->orWhere('column','!=', 'value')
  ->whereIn('column',[1,2,3])
  ->whereRaw('age > ? and votes = 100', array(25))
  ->whereNotIn('id', function($query){
    $query->select('city_id')
    ->from('addresses')
    ->groupBy('addresses.city_id');
	})
  ->whereRaw(DB::raw("id in (select city_id from addresses GROUP BY addresses.city_id)"))
  ->whereExists(function($query)
  {
  	$query->select(DB::raw(1))
        ->from('business_language')
        ->whereRaw('business_language.language_id = languages.id')
        ->groupBy('business_language.language_id')
        ->havingRaw("COUNT(*) > 0");
  })
  
  /*Joins*/
  ->join('business_category','business_category.business_id','=','businesses.id')
  ->leftJoin('reviews','reviews.business_id', '=', 'businesses.id')
  ->join('business_category',function($join) use($cats) {
    $join->on('business_category.business_id', '=', 'businesses.id')
    ->on('business_category.id', '=', $cats, 'and', true);
  })
  ->join(DB::raw('(SELECT *, ROUND(AVG(rating),2) avg FROM reviews_movie WHERE rating!=0 GROUP BY item_id ) T' ), function($join){
  	$join->on('genre_relation.movie_id', '=', 'T.id')
  })
  
  /*Eager Loading */
  ->with('table1','table2')
  ->with(array('table1','table2','table1.nestedtable3'))
  ->with(array('posts' => function($query) use($name){
    $query->where('title', 'like', '%'.$name.'%')
      ->orderBy('created_at', 'desc');
  }))
  
  
  /*Grouping*/
  ->groupBy('state_id','locality')
  ->havingRaw('count > 1 ')
  ->having('items.name','LIKE',"%$keyword%")
  ->orHavingRaw('brand LIKE ?',array("%$keyword%"))
				
  /*Cache*/
  ->remember($minutes)
  ->rememberForever()
    
  /*Offset & Limit & Order*/
  ->take(10)
  ->limit(10)
  ->skip(10)
  ->orderBy('id','DESC')
  
  /*Getters*/
  ->find($id)
  ->findOrFail($id)
  ->first()
  ->firstOrFail()
  ->all()
  ->get() 
  ->lists('id','name')
  ->paginate(10)
  ->simplePaginate(10)
  ->count()
  ->count(DB::raw('distinct businesses.id'));

Very helpful, thanks!!

Thanks! Bookmarked!

Thanks, but that one is more complete: http://cheats.jesse-obrien.ca/

orWhereNotNull doesn't existe in laravel 5.5 !!

@MisterDuval your link is not valid, can you post a new one?