<commit_before><?

//Retrieve data from database
$q = mysqli_query($db, "SELECT * FROM posts NATURAL JOIN authors");
while ($row = mysqli_fetch_assoc($q)) {
    $posts[] = $row;
}

?>


<!-- Page Header -->
<!-- Set your background image for this header on the line below. -->
<header class="intro-header" style="background-image: url('img/home-bg.jpg')">
    <div class="container">
        <div class="row">
            <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">
                <div class="site-heading">
                    <h1>Clean Blog</h1>
                    <hr class="small">
                    <span class="subheading">A Clean Blog Theme by Start Bootstrap</span>
                </div>
            </div>
        </div>
    </div>
</header>

<!-- Main Content -->
<div class="container">
    <div class="row">
        <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">

            <? foreach ($posts as $post): ?>

                <div class="post-preview">

                    <a href="post.php">
                        <h2 class="post-title"><?= $post['post_title'] ?></h2>

                        <h3 class="post-subtitle"><?= $post['post_description'] ?></h3>
                    </a>

                    <p class="post-meta">Posted by <a href="#"><?= $post['author_name'] ?></a>
                        on <?= $post['post_created'] ?>></p>

                </div>

                <hr>

            <? endforeach ?>

            <!-- Pager -->
            <ul class="pager">
                <li class="next">
                    <a href="#">Older Posts &rarr;</a>
                </li>
            </ul>
        </div>
    </div>
</div>
<hr><commit_msg>Esilehel tehtud korda postituse lingid<commit_after><?

//Retrieve data from database
$q = mysqli_query($db, "SELECT * FROM posts NATURAL JOIN authors");
while ($row = mysqli_fetch_assoc($q)) {
    $posts[] = $row;
}

?>


<!-- Page Header -->
<!-- Set your background image for this header on the line below. -->
<header class="intro-header" style="background-image: url('img/home-bg.jpg')">
    <div class="container">
        <div class="row">
            <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">
                <div class="site-heading">
                    <h1>Clean Blog</h1>
                    <hr class="small">
                    <span class="subheading">A Clean Blog Theme by Start Bootstrap</span>
                </div>
            </div>
        </div>
    </div>
</header>

<!-- Main Content -->
<div class="container">
    <div class="row">
        <div class="col-lg-8 col-lg-offset-2 col-md-10 col-md-offset-1">

            <? foreach ($posts as $post): ?>

                <div class="post-preview">

                    <a href="?page=post&id=<?= $post['post_id'] ?>">
                        <h2 class="post-title"><?= $post['post_title'] ?></h2>

                        <h3 class="post-subtitle"><?= $post['post_description'] ?></h3>
                    </a>

                    <p class="post-meta">Posted by <a href="#"><?= $post['author_name'] ?></a>
                        on <?= $post['post_created'] ?>></p>

                </div>

                <hr>

            <? endforeach ?>

            <!-- Pager -->
            <ul class="pager">
                <li class="next">
                    <a href="#">Older Posts &rarr;</a>
                </li>
            </ul>
        </div>
    </div>
</div>
<hr>
{'fraction_non_alphanumeric': 0.18649425287356322, 'fraction_numerical': 0.009195402298850575, 'mean_word_length': 1.5445906432748537, 'pattern_counts': {'":': 0, '<': 108, '<?xml version=': 0, '>': 110, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5674039', 'n_tokens_mistral': 1093, 'n_tokens_neox': 1030, 'n_words': 242}