laravel create many code example

Example 1: laravel where has

use Illuminate\Database\Eloquent\Builder;

// Retrieve posts with at least one comment containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'foo%');
})->get();

// Retrieve posts with at least ten comments containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'foo%');
}, '>=', 10)->get();

Example 2: one to many laravel

For example, a blog post may have an infinite number of comments. And a single
comment belongs to only a single post  

class Post extends Model
{
    public function comments()
    {
        return $this->hasMany('App\Models\Comment');
    }
}

class Comment extends Model
{
    public function post()
    {
        return $this->belongsTo('App\Models\Post');
    }
}

Example 3: laravel detach

// Detach a single role from the user...
$user->roles()->detach($roleId);

// Detach all roles from the user...
$user->roles()->detach();

Example 4: laravel model::query

// Eloquent's Model::query() returns the query builder

Model::where()->get();
// Is the same as 
Model::query()->where()->get();

Model::query();
// Can be useful to add query conditions based on certain requirements

// See https://stackoverflow.com/questions/51517203/what-is-the-meaning-of-eloquents-modelquery

Example 5: add data to laravel many to many relationship

1. $user->roles()->attach($roleId);

2. you may also pass an array of additional data to be inserted 
$user->roles()->attach($roleId, ['expires' => $expires]);

3. // Detach a single role from the user...
$user->roles()->detach($roleId);

4. // Detach all roles from the user...
$user->roles()->detach();

5. Any IDs that are not in the given array will be removed from the intermediate
	table
$user->roles()->sync([1, 2, 3]);

6. If you need to update an existing row in your pivot table, you may use 
  updateExistingPivot method. This method accepts the pivot record foreign 
  key and an array of attributes to update:

$user->roles()->updateExistingPivot($roleId, $attributes);

Tags:

Recent Posts