How to access array value of count

Question

How do I access the value of the array of COUNT(*)? I get the error Cannot use object of type stdClass as array when i tried to use $availableRooms[3]['COUNT(*)']

Array
(
    [0] => stdClass Object
        (
            [category] => king
            [COUNT(*)] => 3
        )

    [1] => stdClass Object
        (
            [category] => family
            [COUNT(*)] => 7
        )

    [2] => stdClass Object
        (
            [category] => quad
            [COUNT(*)] => 8
        )

    [3] => stdClass Object
        (
            [category] => standard
            [COUNT(*)] => 7
        )

)

I need to get the value of count. In this case when i use $availableRooms[3]['COUNT(*)'] it should output 7

**EDIT**

Query

$availableRooms = DB::select("SELECT
      category, COUNT(*)
      FROM available_rooms
      WHERE NOT EXISTS (
          -- room is booked on the requested dates (...not)
          SELECT 1
          FROM room_reserveds
          JOIN bookings ON room_reserveds.bookingID = bookings.bookingID
          WHERE room_reserveds.roomID = available_rooms.roomID
          AND $checkOutDate > checkIndate
          AND $checkInDate < checkOutDate
      )
      GROUP BY category");

Objects and array use different notation to access values: -> for objects [] for arrays — online Thomas
– online Thomas, Commented Feb 8, 2019 at 10:45

Jerodev · Accepted Answer · 2019-02-08 10:47:07Z

1

The array contains objects, so you can't use the array notation to get these properties. And because it's a special key, you can get the property by placing the name between {} as a string.

$availableRooms[3]->{'COUNT(*)'};

I suppose this results comes from a database query. A better solution would be to give this result an alias that can be referenced directly.

// SQL: 
SELECT COUNT(*) AS count FROM ...

// PHP:
$availableRooms[3]->count;

answered Feb 8, 2019 at 10:47

Jerodev

33.3k11 gold badges96 silver badges113 bronze badges

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

Collectives™ on Stack Overflow

How to access array value of count

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related