Advertisement
Guest User

Untitled

a guest
May 27th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. <?php
  2.  
  3. ini_set('error_reporting', E_ALL);
  4. ini_set('display_errors', 1);
  5. ini_set('display_startup_errors', 1);
  6.  
  7. $connect = mysqli_connect("localhost", "root", "", "search") or die("Error");
  8.  
  9.  
  10. ?>
  11.  
  12. <!DOCTYPE html>
  13. <html>
  14. <head>
  15. <title>Поиск</title>
  16. </head>
  17. <body>
  18. <form method="post">
  19. <input type="text" name="search" class="search"><input type="submit" name="submit" value="Поиск">
  20.  
  21.  
  22. </form>
  23. <hr>
  24. <?php
  25. if(isset($_POST['submit'])) {
  26. $search = $_POST['search'];
  27. $query = "SELECT * FROM 'test' WHERE 'title' LIKE '%$search%' OR 'text' LIKE '%$search%' ");
  28. $result = mysqli_query($connect, $query);
  29. while($row = $result->fetch_assoc()) {
  30. foreach($row as $value) echo "<h1>".$row['title']."</h1><p>".$row['text']."</p><br>";
  31. }
  32. }
  33. ?>
  34. </body>
  35. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement