Advertisement
Guest User

Untitled

a guest
Oct 6th, 2015
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. <?php
  2. include "menu.php";
  3. function search($words){
  4. $words = htmlspecialchars($words);
  5. if ($words === " ") return false;
  6. $query_search ="";
  7.  
  8. $areaywords = explode(" ", $words);
  9. print_r($areaywords);
  10. foreach ($areaywords as $key => $value){
  11. if (isset($areaywords[$key - 1]))
  12. $query_search .= ' OR ';
  13. $query_search .='`title` LIKE "%'.$value.'%" OR `text_article` LIKE "%'.$value.'%"';
  14. }
  15. //$query = "SELECT * FROM content WHERE $query_search";
  16. $query = "SELECT * FROM content";
  17. echo $query;
  18. $mysqli = new mysqli("localhost", "root", "", "anastasiya");
  19. $result_set = $mysqli->query($query);
  20.  
  21.  
  22. if ($mysqli->connect_errno) { die('Ошибка соединения: ' . $mysqli->connect_error); } else{echo 'Connect true';}
  23. $i = 0;
  24. while ($row = $result_set->fetch_assoc()){
  25. $results[$i] = $row;
  26. $i++;
  27. }
  28. return $results;
  29. $mysqli -> close();
  30.  
  31. }
  32. if (isset ($_POST['bcearch'])){
  33. $words = $_POST['words'];
  34. $results = search($words);
  35.  
  36. }
  37. ?>
  38. <div id="info-right">
  39. <h2>Поиск по сайту</h2>
  40. <form name="search" action="search.php" method="post" placeholder="Поиск по сайту">
  41. <input type="search" name="words"/>
  42. <input type="submit" name="bcearch" value="Поиск"/>
  43. </form>
  44. </div>
  45. <div class="blok">
  46. </div>
  47. </div>
  48. </div>
  49. <div id="footer">
  50.  
  51. </div>
  52.  
  53. </body>
  54. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement