| <?php | |
| // Create an empty array for storage | |
| $post_data = array(); | |
| // Set arguments for your query | |
| $args = array( | |
| 'post_type' => 'trips', | |
| 'posts_per_page' => 999 | |
| ); | |
| // Do our query with any arguments from above | |
| $query = new WP_Query( $args ); | |
| if ( $query->have_posts() ) | |
| { | |
| while ( $query->have_posts() ) | |
| { | |
| $query->the_post(); | |
| // Setup our repeater | |
| if( have_rows('trip_info') ): | |
| while ( have_rows('trip_info') ) : the_row(); | |
| // Optional - Only get posts that match a true false within our repeater | |
| if ( get_sub_field('featured_trip') ) | |
| { | |
| // Build our array with the data we need using key => value | |
| $post_data[] = array( | |
| 'title' => get_the_title(), | |
| 'date' => get_sub_field('trip_date') | |
| ); | |
| } | |
| endwhile; | |
| endif; | |
| } | |
| } | |
| // Custom function to use in our sort to list the items by date | |
| function subval_sort( $a, $b ) | |
| { | |
| if ( $a['date'] == $b['date'] ) | |
| return 0; | |
| return $a['date'] < $b['date'] ? -1 : 1; | |
| } | |
| // Sort our multidimensional array by sub array value | |
| usort( $post_data, 'subval_sort' ); | |
| // We can now work our data normally through easy to access methods | |
| foreach ( $post_data as $post ) | |
| { | |
| echo $post['title'] . ' ' ; | |
| echo $post['date']; | |
| echo '<br/>'; | |
| } |
This code is also exactly what I was looking for to display all my events in a calendar. By the way, you can also put -1 behind post per page to show everything. Thanks a lot!!
This code is also exactly what I was looking for to display all my events in a calendar. By the way, you can also put -1 behind post per page to show everything. Thanks a lot!!
No problem! it's best to set a very high number instead though. -1 will results in a HUGE query depending on your hosting/database size and structure. Probably fine in most cases but good practice is to just shoot high on the number.
good tip! I've noticed the code does not account for years but only looks at day and month am I correct?
Just found out that I had set the return format wrong, I now went for the Ymd value (e.g. 20210727) and got it to work with years too. See below how I displayed it different on the site.
I made the calendar as such that it only displays upcoming events.
`$query = new WP_Query( $args );
if ( $query->have_posts() ) {
while ( $query->have_posts() ) {
$query->the_post();
if ( have_rows( 'events' ) ):
while ( have_rows( 'events' ) ) : the_row();
$today = date("Ymd");
$date = get_sub_field( 'date' );
if ( $date >= $today ):
// Build our array with the data we need using key => value
$post_data[] = array(
'url' => get_the_permalink(),
'title' => get_the_title(),
'date' => get_sub_field( 'date' ),
'location' => get_sub_field( 'location' ),
);
endif;
endwhile;
endif;
}
} `
- For anyone interested I then displayed the date in European format.
`<?php $format_in = 'Ymd';
// the format your value is saved in ( set in the field options )
$format_out = 'd M ‘y';
// the format you want to end up with
$date = DateTime::createFromFormat( $format_in, $post['date'] );
echo $date->format( $format_out ) . ' ' ;
?>
`
The only additional thing I would be interested in is having a function that can limit the results. If I want to have a more compact calendar showing only the 10 upcoming events on the homepage for example.
Found a solution! By adding a counter I was able to limit the rows.
If anyone is interested, add the counter after the while statement.
<?php $i = 0; ?>
And then add this with your own value after the first row in the for each statement:
<?php $i++; if( $i > 2 ) { break; } ?>
Thanks for this I'm using this to sort events (with multiple dates as acf repeater field) by date. Is there any easy way to add the shared event date as a header with all posts sharing same date beneath it? In essence event listings by day?
Hello,
This code is totally what i was looking for. Thanks a lot !
I have a post object "place" in a the repeater field.
And i don't know how to extract it like this way : 'place' => get_sub_field('place')
Any idea ?
Thanks