php - How to get ID of the first table in a join table

I am able to get the id of the table books using the code below but how should I get the id of my fist table which is named reservation.

$data=reservation::where('user_id',$id)
                ->join('books','reservations.books_id','=', 'books.id')
                ->get();
Copy code

This is how I display the value of both table. I am able to get and display data from both table.

@foreach($data as $data)
<tr>
    <td align="center">{{$data->borrowed_books}}</td>
    <td align="center">{{$data->price}}</td>
    <td align="center">{{$data->reserved_qty}}</td>
    <td align="center">{{$data->books_fee}}</td>
    <td><a href="{{url('/deletemenu',$data->id)}}">CANCEL</a></td>
</tr>
@endforeach
Copy code

The problem is, every time I click cancel to delete it from database the id that it gets is from the books table but I want the id of reservation table. What should I do to delete the id of reservation table instead of books table.

public function deletemenu($id)
{
    $data=reservation::find($id); //it used to be $data=books::find($id);
    $data->delete();
    return redirect()->back();

}
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.