403WebShell

403Webshell
Server IP : 51.79.149.130 / Your IP : 216.73.216.210
Web Server : LiteSpeed
System : Linux linux.firevps.net 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64
User : digit4868 ( 1088)
PHP Version : 8.2.30
Disable Function : NONE
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON
Directory : /home/digitallibrary.astgd.com/public_html/
Upload File :
[ Back ]
Current File : /home/digitallibrary.astgd.com/public_html/books.php
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Books - Digital Library</title>
    <link rel="icon" href="https://digitallibrary.astgd.com/images/digital-library-favicon.png" type="image/png">
    <link rel="shortcut icon" href="https://digitallibrary.astgd.com/images/digital-library-favicon.png" type="image/png">
    <link rel="stylesheet" href="css/bootstrap.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
    <link rel="stylesheet" href="css/styles.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
    <style>
      .book-search-table {
        display: flex;
    align-items: center;
    justify-content: space-around;
    background-color: #ffffff;
    padding: 30px;
    border-radius: 8px;
    border: 1px solid #eeeeee;
      }
      .book-search-row {
        display: flex ;
        flex-direction: row;
       justify-content: center;
        align-items: center;
      }
      .views {
      border: 1px solid #e5e4e4;
    background-color: #ffffff;
    width: fit-content;
    padding: 5px 8px;
    border-radius: 8px;
      }
        /* DataTables custom styling */
        .dataTables_wrapper .dataTables_filter,
        .dataTables_wrapper .dataTables_length {
            margin-bottom: 20px;
        }
      .bold-own {
      font-weight:600;
      }
        /* Book card styling */
        .book-card {
            width: 300px;
            height: 100%;
            transition: transform 0.3s;
          border: 1px solid #eaeaea !important;
          box-shadow: rgba(0, 0, 0, 0.1) 0px 10px 25px 0px;
 
        }
.book-card:hover {
            transform: translateY(-5px);
            
        }

        .card-title {
            font-weight: 600;
            margin-bottom: 10px;
            font-size: 1.1rem;
        }

        .card-text.author {
            color: #555;
            font-style: italic;
            margin-bottom: 5px;
        }

        .card-text.category {
            color: #777;
            margin-bottom: 15px;
            font-size: 0.9rem;
        }

        /* Card grid container */
        #bookGrid {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(250px, 1fr));
            gap: 20px;
            margin-top: 20px;
        }

        /* Hide pagination controls temporarily until DataTable loads */
        .dataTables_paginate {
            margin-top: 20px !important;
        }

        #books-table_paginate {
            display: flex;
            justify-content: center;
            align-items: center;
            gap: 8px;
            flex-wrap: wrap;
            font-family: 'Segoe UI', sans-serif;
            cursor: pointer;
        }

        #books-table_paginate a.paginate_button {
            padding: 8px 14px;
            margin: 2px;
            border-radius: 25px;
            background-color: #f1f1f1;
            color: #4e73df;
            text-decoration: none;
            font-weight: 500;
            border: 1px solid #ddd;
            transition: all 0.2s ease;
        }

        #books-table_paginate a.paginate_button:hover:not(.disabled):not(.current) {
            background-color: #e0e7ff;
            border-color: #4e73df;
            color: #2e59d9;
        }

        #books-table_paginate a.paginate_button.current {
            background-color: #4e73df;
            color: #fff;
            border-color: #4e73df;
            cursor: default;
        }

        #books-table_paginate a.paginate_button.disabled {
            opacity: 0.5;
            cursor: not-allowed;
            background-color: #eaeaea;
            color: #888;
        }

        #books-table_previous,
        #books-table_next {
            font-weight: bold;
        }
      .card-body-sideber {
      background-color:#ffffff;
       padding:1rem;
      }
      .list-group-item a {
      color:#474747;
      text-decoration: none;
      }
      [type=search] {
    padding: 8px;
    border-radius: 8px;
    width: 300px;
    border: 1px solid #c7c4c4;
    margin-left: 10px;
}
      .card-footer:last-child {
    background-color: #ffffff;
            padding: 15px 0px !important;
}
      .list-group-item {
        border-bottom:1px solid #f7f6f6;
      }
      
    </style>
</head>

<body>
    <?php
    require_once 'includes/config.php';

    // Get category filter
    $category_id = isset($_GET['category']) ? (int)$_GET['category'] : null;

    // Get author filter
    $author_id = isset($_GET['author']) ? (int)$_GET['author'] : null;

    // Get books based on filters
    if ($category_id) {
        $books = getBooksByCategory($category_id);
        $category = getCategoryById($category_id);
        $title = "Books in " . $category['name'];
    } elseif ($author_id) {
        $books = getBooksByAuthor($author_id);
        $author = getAuthorById($author_id);
        $title = "Books by " . $author['name'];
    } else {
        $books = getAllBooks();
        $title = "All Books";
    }

    // Get popular categories for sidebar
    $popularCategories = getPopularCategories(6); // Limit to 6 for the sidebar

    // Get popular authors for sidebar
    $popularAuthors = getPopularAuthors(5); // Limit to 5 for the sidebar

    // Get record book views
    if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['book_id'])) {
        $book_id = (int)$_POST['book_id'];
        $ip = $_SERVER['REMOTE_ADDR'];
        $user_agent = $_SERVER['HTTP_USER_AGENT'];

        $stmt = $conn->prepare("INSERT INTO book_views (book_id, ip_address, user_agent) VALUES (?, ?, ?)");
        $stmt->bind_param("iss", $book_id, $ip, $user_agent);
        $stmt->execute();

        echo json_encode(['success' => true]);
        exit; // Important: Stop script after AJAX response
    }
    ?>

    <header>
        <?php include 'includes/header.php'; ?>
    </header>

    <main>
        <div class="row">
            <div class="col-12">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                        <li class="breadcrumb-item active" aria-current="page"><?php echo $title; ?></li>
                    </ol>
                </nav>
            </div>
        </div>

      <div class="container my-4">
        <div class="row">
            <!-- Sidebar -->
            <div class="col-md-3">
                <!-- Popular Categories -->
                <div class="card mb-4">
                    <div class="card-header bg-primary text-white">
                        <h5 class="mb-0">Popular Categories</h5>
                    </div>
                    <div class="card-body-sideber">
                        <ul class="list-group list-group-flush">
                            <?php if (empty($popularCategories)): ?>
                                <li class="list-group-item">No popular categories to display.</li>
                            <?php else: ?>
                                <?php foreach ($popularCategories as $cat): ?>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <a href="books.php?category=<?php echo htmlspecialchars($cat['id']); ?>"><?php echo htmlspecialchars($cat['name']); ?></a>
                                        <span class="badge badge-primary badge-pill"><?php echo htmlspecialchars($cat['book_count']); ?></span>
                                    </li>
                                <?php endforeach; ?>
                            <?php endif; ?>
                        </ul>
                    </div>
                    <div class="card-footer text-center">
                        <a href="categories.php" class="btn btn-sm btn-outline-primary">View All Categories</a>
                    </div>
                </div>

                <!-- Popular Authors -->
                <div class="card">
                    <div class="card-header bg-primary text-white">
                        <h5 class="mb-0">Popular Authors</h5>
                    </div>
                    <div class="card-body-sideber">
                        <ul class="list-group list-group-flush">
                            <?php if (empty($popularAuthors)): ?>
                                <li class="list-group-item">No popular authors to display.</li>
                            <?php else: ?>
                                <?php foreach ($popularAuthors as $auth): ?>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        <a href="books.php?author=<?php echo htmlspecialchars($auth['id']); ?>"><?php echo htmlspecialchars($auth['name']); ?></a>
                                        <span class="badge badge-primary badge-pill"><?php echo htmlspecialchars($auth['book_count']); ?></span>
                                    </li>
                                <?php endforeach; ?>
                            <?php endif; ?>
                        </ul>
                    </div>
                    <div class="card-footer text-center">
                        <a href="authors.php" class="btn btn-sm btn-outline-primary">View All Authors</a>
                    </div>
                </div>
            </div>

            <!-- Main Content -->
            <div class="col-md-9">
                <h1 class="mb-4"><?php echo $title; ?></h1>

                <?php if (empty($books)): ?>
                    <div class="alert alert-info">
                        No books found.
                    </div>
                <?php else: ?>
                    <!-- DataTables Controls -->
                    <div class="book-search-table mb-4">
                        <div class="book-search-row">
                            <div class="col-md-6">
                                <div id="book-length" class="book-length-wrapper"></div>
                            </div>
                            <div class="col-md-6">
                                <div id="book-search" class="text-md-right"></div>
                            </div>
                        </div>
                    </div>

                    <!-- Hidden table for DataTables -->
                    <table id="books-table" class="display" style="width:100%; display: none;">
                        <thead>
                            <tr>
                                <th>Cover</th>
                                <th>Title</th>
                                <th>Author</th>
                                <th>Category</th>
                                <th>Views</th>
                                <th>ID</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($books as $book): ?>
                                <tr>
                                    <td>
                                        <?php
                                        $imageName = $book['cover_image'] ?? '';
                                        $serverPath = __DIR__ . '/uploads/books/' . $imageName;
                                        $webPath = 'uploads/books/' . $imageName;
                                        $defaultImage = 'images/default-book-image.svg';
                                        $imageToUse = (!empty($imageName) && file_exists($serverPath)) ? $webPath : $defaultImage;
                                        ?>
                                        <img src="<?php echo htmlspecialchars($imageToUse); ?>"
                                            alt="<?php echo htmlspecialchars($book['title']); ?>"
                                            class="card-img-top">
                                    </td>
                                    <td><?php echo htmlspecialchars($book['title']); ?></td>
                                    <td><?php
                                        $author_display = $book['author_name'] ?? $book['author']; // Use fetched author_name if available
                                        $parts = explode('-', $author_display);
                                        $displayName = (count($parts) > 1 && is_numeric(trim($parts[0]))) ? trim($parts[1]) : trim($author_display);
                                        echo htmlspecialchars($displayName);
                                        ?>
                                    </td>
                                    <td><?php echo htmlspecialchars($book['category_name']); ?></td>
                                    <td><?php echo (int)$book['views']; ?></td> <!-- ADD THIS DATA CELL -->
                                    <td><?php echo $book['id']; ?></td>
                                </tr>
                            <?php endforeach; ?>
                        </tbody>
                    </table>

                    <!-- Book Grid for Card View -->
                    <div id="bookGrid"></div>

                    <!-- Pagination Container -->
                    <div id="book-pagination" class="m-4"></div>
                <?php endif; ?>
            </div>
        </div>
      </div>  
    </main>

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

    <script src="js/jquery.min.js"></script>
    <script src="js/popper.min.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <script src="js/main.js"></script>
    <script type="text/javascript" src="//cdn.jsdelivr.net/npm/slick-carousel@1.8.1/slick/slick.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/swiper@11/swiper-bundle.min.js"></script>
    <script>
        $(document).ready(function() {
            var table = $('#books-table').DataTable({
                dom: 'lfrtp',
                pageLength: 6,
                lengthMenu: [
                    [3, 6, 9, 12, -1],
                    [3, 6, 9, 12, "All"]
                ]
            });

            $('#book-length').html($('.dataTables_length'));
            $('#book-search').html($('.dataTables_filter'));
            $('#book-pagination').html($('.dataTables_paginate'));

            function recordView(bookId) {
                $.post('ajax/record-view.php', {
                        book_id: bookId
                    })
                    .done(function(response) {
                        console.log('View recorded for book ' + bookId + ':', response);
                        return 0;
                    })
                    .fail(function() {
                        // console.error('Failed to record view for book ' + bookId);
                    });
            }

            function refreshBookGrid() {
                var bookGrid = $('#bookGrid'); // Cache the selector
                bookGrid.empty().addClass('row');

                table.rows({
                    page: 'current'
                }).every(function() {
                    var data = this.data();
                    var coverHtml = data[0];
                    var title = data[1];
                    var author = data[2];
                    var category = data[3];
                    var views = data[4];
                    var id = data[5];

                    var card = `
                <div class="col-lg-4 col-md-6 mb-4">
                    <div class="book-card card h-100" data-id="${id}" style="cursor:pointer">
                        ${coverHtml}
                        <div class="card-body d-flex flex-column">
                            <h5 class="card-title">${title}</h5>
                            <p class="card-text author"><small class="text-muted"><span class="bold-own">By:</span> ${author}</small></p>
                            <p class="card-text category"><small class="text-muted"><span class="bold-own">Category:</span> ${category}</small></p>
                            <p class="card-text views mt-auto"><small class="text-muted"><i class="fas fa-eye"></i> Views: ${views}</small></p>
                        </div>
                    </div>
                </div>
            `;
                    bookGrid.append(card);
                });
            }

            // Bind the click event ONCE to the static parent #bookGrid
            // This will handle clicks on .book-card elements even if they are added later
            $('#bookGrid').on('click', '.book-card', function() {
                const bookId = $(this).data('id');
                window.location.href = `book-detail.php?id=${bookId}`;
            });

            table.on('draw', refreshBookGrid);
            refreshBookGrid(); // Initial draw
        });
    </script>

</body>

</html>
Youez - 2016 - github.com/yon3zu
LinuXploit