PHP Help with WordPress Page Template

<?php/*
Template Name: All posts
*/
?>
<?php
$debut = 0; //The first article to be displayed
?>
<?php while(have_posts()) : the_post(); ?>
<h2><?php the_title(); ?></h2>
<ul>
<?php
$myposts = get_posts('numberposts=-1&offset=$debut');
foreach($myposts as $post) :
?>
<li><?php the_time('d/m/y') ?>: <a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></li>
<?php endforeach; ?>
</ul>

<?php endwhile; ?>

<?php
#Get yesterday 24 hours ago
$yesterday = time() - (24 * 60 * 60);
$ydate = getdate($yesterday);

$the_query = new WP_Query(array(
    'date_query' => array(
        'after' => array(
            'year' => $ydate['year'],
            'month' => $ydate['mon'],
            'day' => $ydate['mday'],
            'hour' => $ydate['hours']        )
    )
));
#I copied and pasted this next part directly from wordpress codex, you can customize what data you want displayed from each post below
if ( $the_query->have_posts() ) : ?>

    <!-- pagination here -->

    <!-- the loop -->
    <?php while ( $the_query->have_posts() ) : $the_query->the_post(); ?>
        <h2><?php the_title(); ?></h2>
    <?php endwhile; ?>
    <!-- end of the loop -->

    <!-- pagination here -->

    <?php wp_reset_postdata(); ?>

<?php else : ?>
    <p><?php _e( 'Sorry, no posts matched your criteria.' ); ?></p>
<?php endif; ?>