| [75f74d9] | 1 | <?php
|
|---|
| 2 | session_start();
|
|---|
| 3 | require 'connect.php';
|
|---|
| 4 |
|
|---|
| 5 | $search = isset($_GET['search']) ? trim($_GET['search']) : '';
|
|---|
| 6 |
|
|---|
| 7 | if ($search) {
|
|---|
| 8 | $sql = "SELECT DISTINCT book.bookid, book.title, book.isbn, book.genre, book.publishedyear, book.description,
|
|---|
| 9 | book.coverimage, author.firstname, author.lastname
|
|---|
| 10 | FROM book
|
|---|
| 11 | INNER JOIN book_author ON book.bookid = book_author.bookid
|
|---|
| 12 | INNER JOIN author ON book_author.authorid = author.authorid
|
|---|
| 13 | WHERE LOWER(book.title) LIKE LOWER(:search)
|
|---|
| 14 | OR LOWER(CONCAT(author.firstname, ' ', author.lastname)) LIKE LOWER(:search)
|
|---|
| 15 | OR LOWER(book.isbn) LIKE LOWER(:search)
|
|---|
| 16 | OR LOWER(book.genre) LIKE LOWER(:search)
|
|---|
| 17 | OR LOWER(book.description) LIKE LOWER(:search)
|
|---|
| 18 | ORDER BY book.title ASC";
|
|---|
| 19 |
|
|---|
| 20 | try {
|
|---|
| 21 | $stmt = $conn->prepare($sql);
|
|---|
| 22 | $searchPattern = "%{$search}%";
|
|---|
| 23 | $stmt->bindParam(':search', $searchPattern, PDO::PARAM_STR);
|
|---|
| 24 | $stmt->execute();
|
|---|
| 25 | $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|---|
| 26 | } catch(PDOException $e) {
|
|---|
| 27 | die("Search failed: " . $e->getMessage());
|
|---|
| 28 | }
|
|---|
| 29 | }
|
|---|
| 30 |
|
|---|
| 31 |
|
|---|
| 32 | ?>
|
|---|
| 33 |
|
|---|
| 34 |
|
|---|
| 35 | <!DOCTYPE html>
|
|---|
| 36 | <html lang="en">
|
|---|
| 37 | <head>
|
|---|
| 38 | <meta charset="UTF-8">
|
|---|
| 39 | <meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|---|
| 40 | <title>Search Results - Library Management System</title>
|
|---|
| 41 | <style>
|
|---|
| 42 | .search-results {
|
|---|
| 43 | max-width: 1200px;
|
|---|
| 44 | margin: 20px auto;
|
|---|
| 45 | padding: 0 20px;
|
|---|
| 46 | }
|
|---|
| 47 |
|
|---|
| 48 | .search-grid {
|
|---|
| 49 | display: grid;
|
|---|
| 50 | grid-template-columns: repeat(auto-fill, minmax(200px, 1fr));
|
|---|
| 51 | gap: 20px;
|
|---|
| 52 | margin-top: 20px;
|
|---|
| 53 | }
|
|---|
| 54 |
|
|---|
| 55 | .book-card {
|
|---|
| 56 | border: 1px solid #ddd;
|
|---|
| 57 | padding: 10px;
|
|---|
| 58 | border-radius: 5px;
|
|---|
| 59 | text-align: center;
|
|---|
| 60 | }
|
|---|
| 61 |
|
|---|
| 62 | .book-card img {
|
|---|
| 63 | max-width: 150px;
|
|---|
| 64 | height: auto;
|
|---|
| 65 | margin-bottom: 10px;
|
|---|
| 66 | }
|
|---|
| 67 |
|
|---|
| 68 | .book-card h3 {
|
|---|
| 69 | margin: 5px 0;
|
|---|
| 70 | font-size: 1.1em;
|
|---|
| 71 | }
|
|---|
| 72 |
|
|---|
| 73 | .book-card p {
|
|---|
| 74 | margin: 5px 0;
|
|---|
| 75 | color: #666;
|
|---|
| 76 | }
|
|---|
| 77 |
|
|---|
| 78 | .search-header {
|
|---|
| 79 | margin-bottom: 20px;
|
|---|
| 80 | }
|
|---|
| 81 |
|
|---|
| 82 | .no-results {
|
|---|
| 83 | text-align: center;
|
|---|
| 84 | padding: 40px;
|
|---|
| 85 | color: #666;
|
|---|
| 86 | }
|
|---|
| 87 | </style>
|
|---|
| 88 | </head>
|
|---|
| 89 | <body>
|
|---|
| 90 | <?php include 'Components/Header.html'; ?>
|
|---|
| 91 |
|
|---|
| 92 | <div class="search-results">
|
|---|
| 93 | <div class="search-header">
|
|---|
| 94 | <h1>Search Results</h1>
|
|---|
| 95 | <p>Showing results for: "<?php echo htmlspecialchars($search); ?>"</p>
|
|---|
| 96 | </div>
|
|---|
| 97 |
|
|---|
| 98 | <?php if (isset($results) && !empty($results)): ?>
|
|---|
| 99 | <div class="search-grid">
|
|---|
| 100 | <?php foreach ($results as $book): ?>
|
|---|
| 101 | <div class="book-card">
|
|---|
| 102 | <a href="BookView.php?bookid=<?php echo $book['bookid']; ?>">
|
|---|
| 103 | <img src="./BookImages/<?php echo htmlspecialchars($book['coverimage']); ?>"
|
|---|
| 104 | alt="<?php echo htmlspecialchars($book['title']); ?>">
|
|---|
| 105 | </a>
|
|---|
| 106 | <h3>
|
|---|
| 107 | <a href="BookView.php?bookid=<?php echo $book['bookid']; ?>"
|
|---|
| 108 | style="text-decoration: none; color: green;">
|
|---|
| 109 | <?php echo htmlspecialchars($book['title']); ?>
|
|---|
| 110 | </a>
|
|---|
| 111 | </h3>
|
|---|
| 112 | <p><?php echo htmlspecialchars($book['firstname'] . ' ' . $book['lastname']); ?></p>
|
|---|
| 113 | <p><?php echo htmlspecialchars($book['genre']); ?></p>
|
|---|
| 114 | </div>
|
|---|
| 115 | <?php endforeach; ?>
|
|---|
| 116 | </div>
|
|---|
| 117 | <?php else: ?>
|
|---|
| 118 | <div class="no-results">
|
|---|
| 119 | <h2>No results found</h2>
|
|---|
| 120 | <p>Try different keywords or check your spelling</p>
|
|---|
| 121 | </div>
|
|---|
| 122 | <?php endif; ?>
|
|---|
| 123 | </div>
|
|---|
| 124 |
|
|---|
| 125 | <?php include 'Components/Footer.html'; ?>
|
|---|
| 126 | </body>
|
|---|
| 127 | </html> |
|---|
