Delete or update one record from has many relation

@vincent15000

Invitation
'category', 'description', 'number', 'minimum_score', 'date', 'round_invitation_id'

Round_invitation
'name', 'description', 'img', 'provinces', 'type', 'federal'

and in Round Invitation Model

  public function invitations()
  {
    return $this->hasMany(Invitation::class);
  }

@vincent15000

 Call to undefined method Illuminate\Database\Eloquent\Relations\HasMany::detach() 

@tykus

Invitation has round_invitation_id,

and Round invitation has many Invitations,

so i want to delete one invitation from round invitations ,

@MahmoudAdelAli does not answer the question... what happens to the invitations record in the database?

@MahmoudAdelAli You need to set the foreign key to null.

@tykus

  public function inviteDestroy(Round_invitation $invitation, $id)
  {

    $invitation->invitations()->whereId($id)->delete();
    return back()->with('success', "Invitation Has Been Deleted");
  }

and this code should work but i redirect back with success and nothing happen

@MahmoudAdelAli so you want to delete the invitations record in the database?

@tykus i don't know how to explain this so i'll put the table columns better , the father is

Round_invitation  ( This Is Separated table not pivot or relation between round and invitation)

'name', 
'description', 
'img',
 'provinces',
 'type',
 'federal'

The Child is

Invitation
    'category', 'description', 'number', 'minimum_score', 'date', 'round_invitation_id'

so why i need to set invitation to null i want to delete invitation from round of invitations

@tykus and i know the name not right but it' should be (rounds of invitations ) so i named it Round_invitations inside database

@MahmoudAdelAli am I not being clear about the question???

What should happen to the Invitation record in the database?

@tykus the question is clear but i think i talk different language :D the answer is : deleted whole this question cause i want to delete record from relation and detach not work ! so i use where

 $rounds->invitations()->whereId($id)->delete();

and it not works too .

@MahmoudAdelAli ok, finally!

Is the Route Model binding working correctly - what is dd($rounds) ? And does the Invitation actually belong to the Round_invitation

Of course, you also have the option to delete like this:

Invitation::where('id', $id)->where('round_invitation_id', $rounds)->delete();

@tykus

App\Models\Round_invitation {#2152 ▼
  #connection: null
  #table: null
  #primaryKey: "id"
  #keyType: "int"
  +incrementing: true
  #with: []
  #withCount: []
  +preventsLazyLoading: false
  #perPage: 15
  +exists: false
  +wasRecentlyCreated: false
  #escapeWhenCastingToString: false
  #attributes: []
  #original: []
  #changes: []
  #casts: []
  #classCastCache: []
  #attributeCastCache: []
  #dates: []
  #dateFormat: null
  #appends: []
  #dispatchesEvents: []
  #observables: []
  #relations: []
  #touches: []
  +timestamps: true
  #hidden: []
  #visible: []
  #fillable: array:6 [▶]
  #guarded: array:1 [▶]

And Model is

class Round_invitation extends Model
{
  protected $fillable = [
    'name', 'description', 'img', 'provinces', 'type', 'federal'
  ];

  public function province()
  {
    return !is_null($this->img) || !empty($this->img) ? asset('storage/' . $this->img) : default_avatar();
  }

  public function invitations()
  {
    return $this->hasMany(Invitation::class);
  }
}

The Route-Model binding is not working correctly because : +exists: false - you are just getting a new instance of Round_invitation (which has no id).

Make sure that the route URL wildcard {round} matches the controller action parameter $round:

Route::delete('/round/{round}', [WhateverController::class, 'inviteDestroy']);

 public function inviteDestroy(Round_invitation $round, $id)

@tykus thank you, now it's worked with

 $rounds->invitations()->whereId($nvitation)->delete();

so i'll use this way instead the detach right ?

@MahmoudAdelAli no worries, mark the thread closed in that case.

detach is not an option since this is a hasMany relation

@tykus thank you for helping and your patience , but i have a little question in update case i call the direct Model for invitation to update

  public function inviteUpdate(InvitationUpdateRequest $request, Invitation $invitation)
  {
    $attributes = $request->validated();
    $invitation->update($attributes);
    return back()->with('success', "Invitation Has Been Updated");
  }

this right way or there's way with relationship ?

@MahmoudAdelAli where would the relation be used here - there is only the Invitation model in scope?

You could check out scoped model bindings to ensure that the Invitation belongs to the Round_invitation, and then update directly on the Invitation instance as normal.