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

0

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.

answered Jul 14, 2018 at 13:56

Arun Code

1,6381 gold badge15 silver badges20 bronze badges

Collectives™ on Stack Overflow

Laravel select where/count query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related