Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include "menu.php";
- function search($words){
- $words = htmlspecialchars($words);
- if ($words === " ") return false;
- $query_search ="";
- $areaywords = explode(" ", $words);
- print_r($areaywords);
- foreach ($areaywords as $key => $value){
- if (isset($areaywords[$key - 1]))
- $query_search .= ' OR ';
- $query_search .='`title` LIKE "%'.$value.'%" OR `text_article` LIKE "%'.$value.'%"';
- }
- //$query = "SELECT * FROM content WHERE $query_search";
- $query = "SELECT * FROM content";
- echo $query;
- $mysqli = new mysqli("localhost", "root", "", "anastasiya");
- $result_set = $mysqli->query($query);
- if ($mysqli->connect_errno) { die('Ошибка соединения: ' . $mysqli->connect_error); } else{echo 'Connect true';}
- $i = 0;
- while ($row = $result_set->fetch_assoc()){
- $results[$i] = $row;
- $i++;
- }
- return $results;
- $mysqli -> close();
- }
- if (isset ($_POST['bcearch'])){
- $words = $_POST['words'];
- $results = search($words);
- }
- ?>
- <div id="info-right">
- <h2>Поиск по сайту</h2>
- <form name="search" action="search.php" method="post" placeholder="Поиск по сайту">
- <input type="search" name="words"/>
- <input type="submit" name="bcearch" value="Поиск"/>
- </form>
- </div>
- <div class="blok">
- </div>
- </div>
- </div>
- <div id="footer">
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement