Advertisement
Guest User

Untitled

a guest
Nov 20th, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. <?php session_start(); ?>
  2.  
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <title> Search result page </title>
  7. <?php include 'parts/head.php'; ?>
  8. <link rel="stylesheet" style="text/css" href="css/search_result_page.css" />
  9. <?php
  10. $servername = "localhost";
  11. $username = "root";
  12. $password = "";
  13. $dbname = "tickifydb";
  14.  
  15. $conn = mysqli_connect($servername, $username, $password, $dbname);
  16.  
  17. if (!$conn) {
  18. die("Connection failed: " . mysqli_connect_error());
  19. }
  20. ?>
  21. </head>
  22. <body>
  23. <div class="background"></div>
  24. <main>
  25. <?php include 'parts/header.php'; ?>
  26. <?php include 'parts/nav.php'; ?>
  27.  
  28. <!-- Unique for every page -->
  29.  
  30. <section>
  31. <p class="details2"><strong><u>Search result: </u></strong></p> <br /><br /><br />
  32.  
  33. <?php
  34.  
  35. if(!isset($_GET['Search'])) {
  36. $sql = "SELECT Name, Description FROM event";
  37. } else {
  38. $sql = "SELECT Name, Description FROM event WHERE Description LIKE " . $_GET['Search'];
  39. }
  40.  
  41. $result = mysqli_query($conn, $sql);
  42. if (!$result) {
  43. printf("Error: %s\n", mysqli_error($conn));
  44. exit();
  45. }
  46.  
  47. if (mysqli_num_rows($result)>0)
  48. {
  49. while($row = mysqli_fetch_assoc($result)) {
  50. ?>
  51. <div class="view">1</div><a href="event_details.php"><div class="view2"><?php echo $row["Name"] ?></div></a><img class="view3" src="img/background.jpg" /><div class="view4"><?php echo $row["Description"] ?></div><br/><br/><br/>
  52. <?php
  53. }
  54. }
  55.  
  56. ?>
  57. </section>
  58.  
  59. <?php include 'parts/footer.php'; ?>
  60. </main>
  61. </body>
  62. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement