1#@!#!123s

: / proc / self / root / proc / self / root / home / markniuj / .vscode-server / data / User / History / 1be325bb /
Filename : s5EQ.php
back
<?php include "../config.php"; ?>

<!DOCTYPE html>
<html>
<head>
    <title>marquee Gallery</title>
    <link href="table.css" rel="stylesheet">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.10.0/css/all.min.css" rel="stylesheet">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.4.1/font/bootstrap-icons.css" rel="stylesheet">
        <meta content="width=device-width, initial-scale=1.0" name="viewport">
            <link href="css.css" rel="stylesheet">
    <style>
    p{
font-size: 13px; font-family: Arial, Helvetica, sans-serif;"
    }
        .thumbnail {
            width: 250px;
            height: 400px;
        }

        .marquee-container {
            overflow: hidden;
        }

        .marquee {
            white-space: nowrap;
            animation: marquee 20s linear infinite;
        }

        .marquee:hover {
            animation-play-state: paused;
        }

        @keyframes marquee {
            0% {
                transform: translateX(100%);
            }
            100% {
                transform: translateX(-100%);
            }
        }
        .pdf-item {
    position: relative;
    display: inline-block;
    margin: 10px;
    text-decoration: none;
}

.pdf-details {
    position: absolute;
    top: 0;
    left: 0;
    background: rgba(0, 0, 0, 0.7);
    color: #fff;
    padding: 5px;
    width: 100%;
    opacity: 0;
    transition: opacity 0.3s;
}

.pdf-item:hover .pdf-details {
    opacity: 1;
}

.book-title {
    font-weight: bold;
    margin: 0;
}

.book-description {
    margin: 0;
}

    </style>
</head>
<body>
    <h1>PDF Gallery</h1>

    <!-- Link to upload PDF -->
    <a href="upload.php">Upload PDF</a>
    <br>
    <a href="slider.php">Slider</a>
    <br>
      <a href="index.php">index</a>
    <br>

    <a href="gallery.php">gallery</a>
    <br>


    <!-- Bootstrap container -->
    <div class="container">
        <div class="row">
            <div class="col-md-4 marquee-container">
                <div class="marquee">
                    <?php
                    
                    // SQL query to retrieve PDF information from the database
                    $sql = "SELECT * FROM pdf_books ORDER BY upload_date DESC";
                    $result = $conn->query($sql);

   if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                echo "<div class='pdf-item'>";
                echo "<a href='pdf_download.php?file={$row['pdf_filename']}'><img class='thumbnail' src='title_covers/{$row['title_cover']}' alt='Title Cover'></a>";
                echo "<div class='pdf-details'>";
                echo "<p><strong>Book Name:</strong> {$row['book_name']}</p>";
                echo "<p><strong>Book Author:</strong> {$row['book_author']}</p>";
                echo "<p><strong>Description:</strong> {$row['description']}</p>";
                echo "<h3><strong>Click Here:</strong> <a href='pdf_download.php?file={$row['pdf_filename']}'><i class='fa fa-download'></i> Download</a></h3>";
                echo "</div>";
                echo "</div>";
    }
} else {
    echo "<tr><td colspan='6'>No PDFs found in the database.</td></tr>";
}

// Your existing code for closing the database connection and formatting file size
?>
   <!-- Add a link to the full gallery at the end of the marquee -->
   
                </div>
            </div>
           <a href="gallery.php">View Full Gallery</a>
</body>
</html>