111 lines
5.1 KiB
PHP
111 lines
5.1 KiB
PHP
<?php
|
|
session_start();
|
|
require_once 'db/config.php';
|
|
require_once 'includes/flash_messages.php';
|
|
|
|
// Fetch posts
|
|
$posts = [];
|
|
try {
|
|
$pdo = db();
|
|
$stmt = $pdo->query('
|
|
SELECT
|
|
posts.id,
|
|
posts.content,
|
|
posts.created_at,
|
|
users.display_name,
|
|
users.id as user_id,
|
|
(SELECT COUNT(*) FROM post_votes WHERE post_id = posts.id AND vote = 1) as likes,
|
|
(SELECT COUNT(*) FROM post_votes WHERE post_id = posts.id AND vote = -1) as dislikes
|
|
FROM posts
|
|
JOIN users ON posts.user_id = users.id
|
|
ORDER BY posts.created_at DESC
|
|
');
|
|
$posts = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
} catch (PDOException $e) {
|
|
// Handle database errors gracefully
|
|
error_log("DB Error: " . $e->getMessage());
|
|
}
|
|
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>Welcome to Our Social Platform</title>
|
|
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
|
|
<link rel="stylesheet" href="assets/css/custom.css?v=<?php echo time(); ?>">
|
|
</head>
|
|
<body>
|
|
|
|
<nav class="navbar">
|
|
<a class="navbar-brand" href="index.php">Social Platform</a>
|
|
<div class="nav-links">
|
|
<?php if (isset($_SESSION['user_id'])): ?>
|
|
<a href="profile.php?id=<?php echo $_SESSION['user_id']; ?>">My Profile</a>
|
|
<a href="logout.php">Logout</a>
|
|
<?php else: ?>
|
|
<a href="login.php">Login</a>
|
|
<a href="signup.php">Sign Up</a>
|
|
<?php endif; ?>
|
|
</div>
|
|
</nav>
|
|
|
|
<div class="container">
|
|
<?php display_flash_message(); ?>
|
|
<?php if (isset($_SESSION['user_id'])): ?>
|
|
<div class="card">
|
|
<div class="card-body">
|
|
<h5 class="card-title">Create a Post</h5>
|
|
<form action="handle_create_post.php" method="POST">
|
|
<textarea class="form-control" name="content" placeholder="What's on your mind?"></textarea>
|
|
<button type="submit" class="btn btn-primary">Post</button>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
|
|
<h2 class="mb-4">Feed</h2>
|
|
<?php if (empty($posts)): ?>
|
|
<div class="card text-center text-muted">No posts yet. Be the first to share!</div>
|
|
<?php else: ?>
|
|
<?php foreach ($posts as $post): ?>
|
|
<div class="card">
|
|
<div class="card-header">
|
|
<a href="profile.php?id=<?= $post['user_id'] ?>"><?php echo htmlspecialchars($post['display_name']); ?></a>
|
|
<small class="card-meta">Posted on <?php echo date("F j, Y, g:i a", strtotime($post['created_at'])); ?></small>
|
|
</div>
|
|
<div class="card-body">
|
|
<p><?php echo htmlspecialchars($post['content']); ?></p>
|
|
</div>
|
|
<div class="card-footer vote-buttons">
|
|
<a href="handle_like.php?post_id=<?= $post['id'] ?>&action=like" class="like-button">
|
|
<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"><path d="M7 10v12"/><path d="M15 5.88 14 10h5.83a2 2 0 0 1 1.92 2.56l-2.33 8A2 2 0 0 1 18.5 22H4a2 2 0 0 1-2-2v-8a2 2 0 0 1 2-2h3z"/></svg>
|
|
<span><?= $post['likes'] ?></span>
|
|
</a>
|
|
<a href="handle_like.php?post_id=<?= $post['id'] ?>&action=dislike" class="dislike-button">
|
|
<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"><path d="M7 14V2"/><path d="M15 18.12 14 14H8.17a2 2 0 0 1-1.92-2.56l2.33-8A2 2 0 0 1 10.5 2H20a2 2 0 0 1 2 2v8a2 2 0 0 1-2 2h-3z"/></svg>
|
|
<span><?= $post['dislikes'] ?></span>
|
|
</a>
|
|
</div>
|
|
</div>
|
|
<?php endforeach; ?>
|
|
<?php endif; ?>
|
|
|
|
<?php else: ?>
|
|
<div class="hero">
|
|
<h1>Connect and Share</h1>
|
|
<p>Join our community to connect with friends, share your thoughts, and discover new things.</p>
|
|
<a href="signup.php" class="btn btn-custom-primary">Get Started</a>
|
|
<a href="login.php" class="btn btn-custom-secondary">Have an account? Login</a>
|
|
</div>
|
|
<?php endif; ?>
|
|
</div>
|
|
|
|
<footer class="footer">
|
|
<p>© <?php echo date("Y"); ?> Social Platform. All rights reserved.</p>
|
|
</footer>
|
|
|
|
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>
|
|
<script src="assets/js/main.js?v=<?php echo time(); ?>"></script>
|
|
</body>
|
|
</html>
|