Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('error_reporting', E_ALL);
- ini_set('display_errors', 1);
- ini_set('display_startup_errors', 1);
- $connect = mysqli_connect("localhost", "root", "", "search") or die("Error");
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Поиск</title>
- </head>
- <body>
- <form method="post">
- <input type="text" name="search" class="search"><input type="submit" name="submit" value="Поиск">
- </form>
- <hr>
- <?php
- if(isset($_POST['submit'])) {
- $search = $_POST['search'];
- $query = "SELECT * FROM 'test' WHERE 'title' LIKE '%$search%' OR 'text' LIKE '%$search%' ");
- $result = mysqli_query($connect, $query);
- while($row = $result->fetch_assoc()) {
- foreach($row as $value) echo "<h1>".$row['title']."</h1><p>".$row['text']."</p><br>";
- }
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement