Laravel select where/count query

Question

There are two Mysql tables:

1.reservations(id,screening_id,reserved). the reserved is a boolean its value "1".

table seat_reserveds(id,screening_id,reservation_id,seat_id).

I want the following: 1.get the reservation id select id from reservation where screening_id = id and reserved = 1 In laravel looks like:

 $reservation_id = DB::table('reservations')->select('id')- >where('screening_id',$id)->where('reserved','1')->get();

Then I want to count how many seats are reserved

Select count(id) from seat_resrveds where where screening_id = id and reservtain_id = id. In laravel looks like:

 $reservedtickets = DB::table('seat_reseverds')- >where('screening_id',$id)->where('reservation_id',$reservation_id)->count('id');

I think the problam is that I get "id":number from $reservation_id so cant use it at the $reservedtitckets query because I only need a number. How can I write these querys.

Paul Spiegel · Accepted Answer · 2018-07-14 13:20:38Z

1

Use ->value('id') to get a single value from a query:

$reservation_id = DB::table('reservations') ->where('screening_id',$id) ->where('reserved','1') ->value('id');

answered Jul 14, 2018 at 13:20

Paul Spiegel

31.9k5 gold badges48 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Paul Spiegel Over a year ago

@Blasanka - It's not even "eloquent" - It's just the query builder.

Arun Code · Accepted Answer · 2018-07-14 13:56:42Z

Update the query to the following.

 $reservation = DB::table('reservations') ->where('screening_id',$id) ->where('reserved', 1) ->first();

Then the $reservation_id should be as below.

$reservation_id = $reservation->id;

You can pass this parameter to your next query for $reservedtickets.

Collectives™ on Stack Overflow

Laravel select where/count query

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related