Check if value exists in JSON associative array

Question

I have an array that looks like this:

[
    {
        "date":"2015-07-10",
        "count":"1"
    },{
        "date":"2015-07-11",
        "count":"3"
    }
]

Which is given by the following Eloquent query:

$posts = Post::select(array(
        DB::raw('DATE(`created_at`) as `date`'),
        DB::raw('COUNT(*) as `count`')
    ))
    ->where('created_at', '>', Carbon::today()->subWeek())
    ->groupBy('date')
    ->orderBy('date', 'DESC')
    ->get()
    ->toArray();

How can I check if a certain date is already in the array? I've tried the following, but it returns false (i.e. that the value isn't in the array, even though it is):

return in_array("2015-07-10", $posts);

Sougata Bose · Accepted Answer · 2015-07-20 05:09:00Z

7

You can use array_column in this case.

return in_array("2015-07-10", array_column($posts, 'date'));

DOCS

answered Jul 20, 2015 at 5:09

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

2 Comments

asd651asd Over a year ago

That did it, thanks! I'll mark it as the answer when I can (10 minutes).

Moses Ndeda Over a year ago

Awesome answer!

Collectives™ on Stack Overflow

Check if value exists in JSON associative array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related