Hide past event messages based on custom date field

Question

I want to hide past events based on a custom date field that I set.

<?php 
the_post();
// Get 'events' posts
$events_posts = get_posts( array(
'post_type' => 'events',
'posts_per_page' => -4, // Unlimited posts
'orderby' => 'meta_value',
'meta_key' => 'event_date',
'order' => 'ASC'
) );

if ( $events_posts ):
?>

This code currently shows my events in order, but I want to hide events older than today's date?

Answer 1

If you want to filter the data by custom field posts, you should use meta_queryfor this

Here is a working example:

$args = [
    'post_type' => 'events',
    'posts_per_page' => -1, // Unlimited posts
    'orderby' => 'meta_value',
    'meta_key' => 'event_date',
    'order' => 'ASC',
    'meta_query' => [
        'relation' => 'AND',
        [
            'key' => 'event_date',
            'value' => date('Y-m-d'), //<-- replace this with your correct date format
            'compare' => '>',
            'type' => 'DATE'
        ],
    ],
];

$queryEvent = new WP_Query($args);
if ($queryEvent->have_posts()) :
    /* Start the Loop */
    while ($queryEvent->have_posts()) : 
    $queryEvent->the_post();

    //you post

    endwhile;
endif;

Hope this helps!

Related answer: fooobar.com/questions/1016413 / ...

Answer 2

, $event_posts, , ", ". , . MySQL , , NOW(). event_date DATETIME, , , "event_date" , NOW().

    "SELECT events WHERE event_date >NOW()"