I wasn't to make a link go to a specific search but I cant seem to make it work, I would appreciate any help here!
Here is a part of the main page:
Categories
</a>
<div class="dropdown-menu" style="background-color: black;" aria-labelledby="navbarDropdown">
<a style="color: green;" class="dropdown-item" href="search.php?search=action">Action</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=comedy">Comedy</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=drama">Drama</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=fantasy">Fantasy</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=horror">Horror</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=mistery">Mistery</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=romance">Romance</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=thriller">Thriller</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=western">Western</a>
<a style="color: green;" class="dropdown-item" href="search.php?search=scifi">SciFi</a>
</div>
</li>
And here is the search.php:
<?php
include("db.php");
include("header.php");
include("footer.php");
?>
<div class="row">
<?php
if(isset($_POST['submit'])){
$search = $_POST['search'];
$searchpreg = preg_replace("#[^0-9a-z]#i", "", $search);
$query = "SELECT * FROM movie WHERE name LIKE '%$search%' or genre LIKE '%$search%'";
$run = mysqli_query($con,$query);
$count = mysqli_num_rows($run);
if($count == 0){
echo "<div style='text-align:center;'><h1>No Movie Found</h1>".$search."</div>";
}
else{
while($row = mysqli_fetch_assoc($run)){
?>
<div class="col">
<div class="card border border-success background-color:" style="width:200px; text-align:center; background-color:#343a40;">
<a href="viewmovie.php?id=<?php echo $row['id']; ?>"><?php echo "<img height='180px' width='180' src='admin12312/thumb/".$row['imgpath']."'>"; ?></a>
<p style="color: green;"><?php echo $row['name']; ?></p>
</div>
</div>
<?php
}
}
}
?>
</div>