Skip to content

Instantly share code, notes, and snippets.

@amardeep18

amardeep18/multi-search-index.php

Created July 19, 2020 05:35
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amardeep18/75b82f1d55b7f33e741486b799dd8bf8 to your computer and use it in GitHub Desktop.
Save amardeep18/75b82f1d55b7f33e741486b799dd8bf8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
multi-search-index.php
<?php
$connect = mysqli_connect("localhost", "root", "", "auto_refresh");
if(isset($_POST["submit"]))
{
if(!empty($_POST["search"]))
{
$query = str_replace(" ", "+", $_POST["search"]);
header("location:index.php?search=" . $query);
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Search multiple words at a time in Mysql php</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
</head>
<body>
<br /><br />
<div class="container" style="width:500px;">
<h3 align="center">Search multiple words at a time in Mysql php</h3><br />
<form method="post">
<label>Enter Search Text</label>
<input type="text" name="search" class="form-control" value="<?php if(isset($_GET["search"])) echo $_GET["search"]; ?>" />
<br />
<input type="submit" name="submit" class="btn btn-info" value="Search" />
</form>
<br /><br />
<div class="table-responsive">
<table class="table table-bordered">
<?php
if(isset($_GET["search"]))
{
$condition = '';
$query = explode(" ", $_GET["search"]);
foreach($query as $text)
{
$condition .= "blog_title LIKE '%".mysqli_real_escape_string($connect, $text)."%' OR ";
}
$condition = substr($condition, 0, -4);
$sql_query = "SELECT * FROM tbl_blog WHERE " . $condition;
$result = mysqli_query($connect, $sql_query);
if(mysqli_num_rows($result) > 0)
{
while($row = mysqli_fetch_array($result))
{
echo '<tr><td>'.$row["blog_title"].'</td></tr>';
}
}
else
{
echo '<label>Data not Found</label>';
}
}
?>
</table>
</div>
</div>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment