<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Поиск</title>
</head>
<body>
<form action="gg.php">
<input type="text" name="search"><input type="submit" name="submit" value="Поиск">
<?php
$link = mysqli_connect('localhost', 'root', '','кинопрокат') or die("ERROR");
if(isset($_POST['search'])){
$search = $_POST["search"];
$query = mysqli_query($link,"SELECT * FROM `фильмы` WHERE `Название` = '%search%' || `Год` = '%search%'|| `Жанр` = '%search%' || `Страна` = '%search%'");
while ($row = mysqli_fetch_assoc($query)) {
echo "<h1>".$row['Название'];
}
}
?>
</form>
</body>
</html>
