How to get posts from a current post's month?

Question

I want to display the titles of the post of the same month as the blog post. I tried this ..

<?php $year = the_date('Y')?>
<?php $month = the_date('M')?>

      <?php  $theids = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' AND MONTH(post_date)= '".$month."' AND YEAR(post_date) = '".$year."' ORDER BY post_date ASC");
       foreach ($theids as $theid): ?>
        <?php echo $theid->post_title; ?>

       <?php endforeach; ?>

but it's returning nothing. How can I make it work? Thanks.

Answer 1

There is date_query which can handle this and an SQL query is not a good practice when you can take advantage of WordPress Query API:

$pid = 1; // post ID here

$args = array(
    'posts_per_page' => -1,
    'post_type' => 'post',
    'date_query' => array(
        array(
            'year'  => get_the_date('Y', $pid),
            'month' => get_the_date('m', $pid)
        ),
    ),
);

$posts = get_posts( $args );

print_r( $posts );

Hope that helps.