source: Search.php

main
Last change on this file was 75f74d9, checked in by Vlado 222039 <vlado.popovski@…>, 2 months ago

Initial commit: Adding Book Tracker code
  • Property mode set to 100644
File size: 3.9 KB
Line 
1<?php
2session_start();
3require 'connect.php';
4
5$search = isset($_GET['search']) ? trim($_GET['search']) : '';
6
7if ($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>
Note: See TracBrowser for help on using the repository browser.