34762-vm/index.php

<?php
require_once 'db/config.php';
include 'partials/header.php';

$pdo = db();
$search = $_GET['search'] ?? '';
$papers_per_page = 6;
$current_page = isset($_GET['page']) && is_numeric($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($current_page - 1) * $papers_per_page;

// Get total number of papers for pagination
if ($search) {
    $count_stmt = $pdo->prepare("SELECT COUNT(*) FROM papers WHERE title LIKE :search OR authors LIKE :search OR publication LIKE :search");
    $count_stmt->execute(['search' => "%$search%"]);
} else {
    $count_stmt = $pdo->query("SELECT COUNT(*) FROM papers");
}
$total_papers = $count_stmt->fetchColumn();
$total_pages = ceil($total_papers / $papers_per_page);

// Get papers for the current page
if ($search) {
    $stmt = $pdo->prepare("SELECT * FROM papers WHERE title LIKE :search OR authors LIKE :search OR publication LIKE :search ORDER BY created_at DESC LIMIT :limit OFFSET :offset");
    $stmt->bindValue(':search', "%$search%", PDO::PARAM_STR);
    $stmt->bindValue(':limit', $papers_per_page, PDO::PARAM_INT);
    $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
    $stmt->execute();
} else {
    $stmt = $pdo->prepare("SELECT * FROM papers ORDER BY created_at DESC LIMIT :limit OFFSET :offset");
    $stmt->bindValue(':limit', $papers_per_page, PDO::PARAM_INT);
    $stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
    $stmt->execute();
}

$papers = $stmt->fetchAll();
?>

<div class="hero">
    <div class="container">
        <h1>Your Paper Collection</h1>
        <p class="lead">A central place to manage all your academic papers.</p>
        <a href="add_paper.php" class="btn btn-primary btn-lg">Add a New Paper</a>
    </div>
</div>

<div class="container mt-5">
    <?php
    $feedback = [];
    if (isset($_GET['success'])) {
        if ($_GET['success'] === 'deleted') {
            $feedback = ['type' => 'success', 'message' => 'Paper deleted successfully.'];
        }
        if ($_GET['success'] === 'updated') {
            $feedback = ['type' => 'success', 'message' => 'Paper updated successfully.'];
        }
    }
    if (isset($_GET['error'])) {
        if ($_GET['error'] === 'notfound') {
            $feedback = ['type' => 'danger', 'message' => 'Paper not found.'];
        }
        if ($_GET['error'] === 'deletfailed') {
            $feedback = ['type' => 'danger', 'message' => 'Error deleting paper.'];
        }
    }
    ?>
    <?php if (!empty($feedback)): ?>
        <div class="alert alert-<?= $feedback['type'] ?> alert-dismissible fade show" role="alert">
            <?= htmlspecialchars($feedback['message']) ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        </div>
    <?php endif; ?>

    <div class="mb-4">
        <form action="index.php" method="get" class="d-flex">
            <input type="text" name="search" class="form-control me-2" placeholder="Search by title, author, or publication..." value="<?= htmlspecialchars($search) ?>">
            <button type="submit" class="btn btn-primary">Search</button>
        </form>
    </div>

    <h2 class="mb-4">Recently Added</h2>
    <div class="row">
        <?php if (empty($papers)): ?>
            <div class="col">
                <p>No papers added yet. <a href="add_paper.php">Add your first one!</a></p>
            </div>
        <?php else: ?>
            <?php foreach ($papers as $paper): ?>
                <div class="col-md-6 col-lg-4 mb-4">
                    <div class="card h-100">
                        <div class="card-body d-flex flex-column">
                            <h5 class="card-title"><?= htmlspecialchars($paper['title']) ?></h5>
                            <h6 class="card-subtitle mb-2 text-muted"><?= htmlspecialchars($paper['authors']) ?></h6>
                            <p class="card-text flex-grow-1">
                                <?php if ($paper['publication']): ?>
                                    <strong>Publication:</strong> <?= htmlspecialchars($paper['publication']) ?><br>
                                <?php endif; ?>
                                <?php if ($paper['year']): ?>
                                    <strong>Year:</strong> <?= htmlspecialchars($paper['year']) ?><br>
                                <?php endif; ?>
                                <?php if ($paper['notes']): ?>
                                    <strong>Notes:</strong> <?= nl2br(htmlspecialchars(substr($paper['notes'], 0, 100))) . (strlen($paper['notes']) > 100 ? '...' : '') ?><br>
                                <?php endif; ?>
                            </p>
                            <div class="mt-auto">
                                <a href="edit_paper.php?id=<?= $paper['id'] ?>" class="btn btn-sm btn-outline-primary">Edit</a>
                                <a href="delete_paper.php?id=<?= $paper['id'] ?>" class="btn btn-sm btn-outline-danger" onclick="return confirm('Are you sure you want to delete this paper?');">Delete</a>
                            </div>
                        </div>
                    </div>
                </div>
            <?php endforeach; ?>
        <?php endif; ?>
    </div>

    <!-- Pagination -->
    <?php if ($total_pages > 1): ?>
    <nav aria-label="Page navigation">
        <ul class="pagination justify-content-center">
            <?php if ($current_page > 1): ?>
                <li class="page-item"><a class="page-link" href="?page=<?= $current_page - 1 ?>&search=<?= htmlspecialchars($search) ?>">Previous</a></li>
            <?php endif; ?>

            <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                <li class="page-item <?php if ($i === $current_page) echo 'active'; ?>"><a class="page-link" href="?page=<?= $i ?>&search=<?= htmlspecialchars($search) ?>"><?= $i ?></a></li>
            <?php endfor; ?>

            <?php if ($current_page < $total_pages): ?>
                <li class="page-item"><a class="page-link" href="?page=<?= $current_page + 1 ?>&search=<?= htmlspecialchars($search) ?>">Next</a></li>
            <?php endif; ?>
        </ul>
    </nav>
    <?php endif; ?>
</div>

<?php include 'partials/footer.php'; ?>