How To Create Your Own Search Engine On Your Website.

1 Create a search form on your website.
2 connect to your database with config.php file
3 create new page searh.php for show search results.

//                                     code for search form                                           //


<?php

?>
<form action="serch.php" method="GET">
 <input type="text" name="query" placeholder="search Your Room According To Your Prefered location like sardarpura, basni.." />
 
    <input type="submit" value="search" />
 
   
</form>

//                                       Code for show search results on search.php page          //

<?php

include"config.php";

$query = $_GET['query']; 

// gets value sent over search form

$min_length = 3;

// you can set minimum length of the query if you want

if(strlen($query) >= $min_length){ // if query length is more or equal minimum length then

$query = htmlspecialchars($query); 

// changes characters used in html to their equivalents, for example: < to &gt;

$query = mysql_real_escape_string($query);

// makes sure nobody uses SQL injection

$raw_results = mysql_query("SELECT * FROM room_listing

WHERE (`location` LIKE '%".$query."%') OR (`rent` LIKE '%".$query."%')") or die(mysql_error());

// * means that it selects all fields, you can also write: `id`, `title`, `text`

// articles is the name of our table

// '%$query%' is what we're looking for, % means anything, for example if $query is Hello

// it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query'

// or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query'

if(mysql_num_rows($raw_results) > 0){ // if one or more rows are returned do following

while($results = mysql_fetch_array($raw_results)){

// $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop

$type=$results['type'];

 $location=$results['location'];

 $mobile=$results['mobile'];

 $rent=$results['rent'];

 $description=$results['description'];

 $date=$results['date'];

"<p><h3>".$results['location']."</h3>".$results['rent']."</p>";

// posts results gotten from database(title and text) you can also show id ($results['id'])

?>

//                                                                             //                                        //