为什么我的值不被识别在数组中？

Question

I'm trying to check if a date string is in an array of dates from a WordPress database. Currently, there is only one value in the array: 2019-01-02

If I print the array I get this:

Array ( [0] => stdClass Object ( [date] => 2019-01-02 ) )

Why is the value not recognized to be in the array?

<?php
    $sql = "SELECT date FROM wp_table";
    $result = $wpdb->get_results($sql);
    if (in_array('2019-01-02', $result)) {
        echo "Yes, the date is in the array!";
    }
    print_r($result);
?>

The there is no result from the above.

Any help is very much appreciated.

Kresten

Answer 1

It's not working because in_array is not suited to an associative (key, value) array.

If you had the following array:

array("2019-01-01", "banana", "dog)

...it would work. But it won't work with the keys.

If you are only ever looking for one specific 'key', in this case date, you can amend your scope to be only that 'column':

$dates = array_column( $result, 'date' );

in your code:

<?php
    $sql = "SELECT date FROM wp_table";
    $result = $wpdb->get_results($sql);
    $dates = array_column( $result, 'date' );

    if (in_array('2019-01-02', $dates)) {
        echo "Yes, the date is in the array!";
    }
    print_r($result);
?>