27 lines
906 B
PHP
27 lines
906 B
PHP
<?php
|
|
require_once 'db/config.php';
|
|
require_once 'db/setup.php';
|
|
|
|
$page_title = 'Home - Clean Blog';
|
|
include 'header.php';
|
|
|
|
$pdo = db();
|
|
$stmt = $pdo->query("SELECT * FROM posts ORDER BY created_at DESC");
|
|
$posts = $stmt->fetchAll();
|
|
?>
|
|
|
|
<div class="row">
|
|
<?php foreach ($posts as $post): ?>
|
|
<div class="col-md-4 mb-4">
|
|
<div class="card post-card h-100">
|
|
<div class="card-body d-flex flex-column">
|
|
<h5 class="card-title post-title"><?php echo htmlspecialchars($post['title']); ?></h5>
|
|
<p class="card-text flex-grow-1"><?php echo htmlspecialchars(substr($post['content'], 0, 100)); ?>...</p>
|
|
<a href="post.php?id=<?php echo $post['id']; ?>" class="btn btn-primary mt-auto">Read More</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<?php endforeach; ?>
|
|
</div>
|
|
|
|
<?php include 'footer.php'; ?>
|