Register and Get ₹100- Quick CLICK HERE!

HomeCodding

Questions By
Dwimalu Basumatary
OFFER ₹0

Eight words php search engine script for mysqli database


Hello everyone, I want to create eight words php search engine script for mysqli database.
 
Generally I know how to create a search script with php and mysqli but I was able to create only one word searching search engine.
 
But I want to create minimum eight words or more than it like google search engine, which does best searching every sentences.
 
So guys, I had search in google about such scripts but I didn't find what I want.

So guys, if anyone know how to create eight words php search engine script for mysqli database then please answer me, it will help me a lot. Thank you.
06-04-2018, Total 2 Ans Best Answered , 110 views


BEST ANSWER
Hei guys finally I had found the solution ..  
And here is the code for eight words php search engine script for mysqli database .. 
suppose $searchquery="How to create something";
 
 $querys=explode(",", $searchquery);
    $query0=$querys[0];
    //$query1
    if(isset($querys[1])){$query1=$querys[1];}
    //$query2
    if(isset($querys[2])){$query2=$querys[2];}
    //$query3
    if(isset($querys[3])){$query2=$querys[3];}
    //$query4
    if(isset($querys[4])){$query2=$querys[4];}
    //$query5
    if(isset($querys[5])){$query2=$querys[5];}
    //$query6
    if(isset($querys[6])){$query2=$querys[6];}
    //$query7
    if(isset($querys[7])){$query2=$querys[7];}

    ?>
    <div class="rowa"> 
    <?php
     //query0
    $sql0=mysqli_query($db_photos,"SELECT * FROM photos WHERE title LIKE '%$query0%' OR description LIKE '%$query0%' OR tags LIKE '%$query0%' LIMIT 0,4");
    if(mysqli_num_rows($sql0)==0){
        //query1
        $sql0=mysqli_query($db_photos,"SELECT * FROM photos WHERE title LIKE '%$query1%' OR description LIKE '%$query1%' OR tags LIKE '%$query0%' LIMIT 0,4");
        if(mysqli_num_rows($sql0)==0){
            //query2
            $sql0=mysqli_query($db_photos,"SELECT * FROM photos WHERE title LIKE '%$query2%' OR description LIKE '%$query2%' OR tags LIKE '%$query0%' LIMIT 0,4");
            if(mysqli_num_rows($sql0)==0){
                //query3
                $sql0=mysqli_query($db_photos,"SELECT * FROM photos WHERE title LIKE '%$query3%' OR description LIKE '%$query3%' OR tags LIKE '%$query0%' LIMIT 0,4");
                if(mysqli_num_rows($sql0)==0){
                    //query4
                    $sql0=mysqli_query($db_photos,"SELECT * FROM photos WHERE title LIKE '%$query4%' OR description LIKE '%$query4%' OR tags LIKE '%$query0%' LIMIT 0,4");
                    if(mysqli_num_rows($sql0)==0){
                        //query5
                        $sql0=mysqli_query($db_photos,"SELECT * FROM photos WHERE title LIKE '%$query5%' OR description LIKE '%$query5%' OR tags LIKE '%$query0%' LIMIT 0,4");
                        if(mysqli_num_rows($sql0)==0){
                            //query6
                            $sql0=mysqli_query($db_photos,"SELECT * FROM photos WHERE title LIKE '%$query6%' OR description LIKE '%$query6%' OR tags LIKE '%$query0%' LIMIT 0,4");
                            if(mysqli_num_rows($sql0)==0){
                                //query7
                                $sql0=mysqli_query($db_photos,"SELECT * FROM photos WHERE title LIKE '%$query7%' OR description LIKE '%$query7%' OR tags LIKE '%$query0%' LIMIT 0,4");
                            }
                        }
                    }
                }
            }
        }
    }
 Hop this answers helps someone else..
 
Dwimalu Basumatary
06-04-2018

OTHER ANSWERS

Here is also some php search engine codes, hop this may also helps you, watch it here https://owlcation.com/stem/Simple-search-PHP-MySQL 
 

Dwimalu Basumatary
07-04-2018

Please LOGIN to Answer

OTHER CATEGORIES

Politics/Govt

Total: 5

Music/Movies

Total: 2

News

Total: 0

Sports/Games

Total: 6

Educations

Total: 0

Codding

Total: 42

Science/Tech

Total: 5

Softwares

Total: 3

Hardwares

Total: 1

Websites

Total: 1

SEO

Total: 1

Foods

Total: 0

Health/Fitness

Total: 0

Business/Earnings

Total: 6

Jobs

Total: 0

Cars/Vehicals

Total: 0

Travels

Total: 0

Beauty/Fashions

Total: 0

Lifestyles

Total: 3

Gods/Religious

Total: 4

Others

Total: 0

Recently Asked Questions

Does Google Adsense pays for viewing on our own website?
Ans(1) ₹0

I got this image about SEO improvement strategies, so can anyone explain to me about it?
Ans(1) ₹0

Should we trust such Shadus like Shad Guru to make donation for Kaveri river?
Ans(0) ₹0

Can I get rank on Google without Backlinks? Is there any other ways?
Ans(1) ₹0

How to post the link in perfect way for increasing backlinks and traffics for my website?
Ans(3) ₹0

What is sdfasd? Does it have any meaning?
Ans(1) ₹0

How to track my own computer on Google Analytics so that I know my own views on my site?
Ans(3) ₹0

What is La Liga?
Ans(0) ₹0

javscript check if the variable has value, if not then take action
Ans(2) ₹0

Getting the last string of the url after slash javascript
Ans(3) ₹0




Related Ques

Getting the last string of the url after slash javascript
Ans(3) ₹0

PHP get url last string - How to get last part string of the url using php
Ans(2) ₹0

Develop physical health in village area
Ans(3) ₹0

I got this image about SEO improvement strategies, so can anyone explain to me about it?
Ans(1) ₹0

How to get the values from url using Javascript, I mean from GET values from url
Ans(3) ₹0

Eliminate render-blocking JavaScript and CSS in above-the-fold content, google speed test
Ans(1) ₹0

How to get the value of php variable and use it on Javascript
Ans(3) ₹0

How to get the present full url using PHP
Ans(2) ₹0

I need lists of all the exeCommand() and how to use it, Javascript
Ans(0) ₹0

How to replace the KeyCode or typing key whenever I type inside iFrame, Javascript
Ans(0) ₹0

How to get the ID of elements inside iFrame, JavaScript
Ans(0) ₹0

How to get the url of page from where we had just now redirected with PHP?
Ans(1) ₹0

jquery detect scroll to bottom of page and display the div else hide
Ans(2) ₹0

Can I get rank on Google without Backlinks? Is there any other ways?
Ans(1) ₹0

Animate scroll to bottom when clicked on a button -javascript or jquery
Ans(3) ₹0

cannot modify header information - headers already sent
Ans(2) ₹0

How to get the body tag inside iFrame, using Javascript
Ans(0) ₹0

Where to get the Admit Card of HSSC exam Haryana, 2019, I heard it was realeased.
Ans(4) ₹0

How to remove all the codes and show only strings using PHP
Ans(3) ₹0

Does anybody have the picture of Hans Christian Gram? Wana see him.
Ans(2) ₹0

Who is Hans Christian Gram and why he is so much popular?
Ans(3) ₹0

Morning joging vs Afternoon jogging which is the best?
Ans(1) ₹0

Oh! nice way to earn money for Idiot Gurus Like Shad Guru or what? Earn money by taking name of kaveri river.
Ans(2) ₹0

How to replace all the similar letters on a words with javascript
Ans(0) ₹0

Which is the best martial art they really works on the street?
Ans(0) ₹0

Which is the most realistic working martial art, that works on Modern warfare?
Ans(1) ₹0

Which is the most played sports in the world?
Ans(1) ₹0

Reduce server response times (TTFB), How to solve this issue
Ans(0) ₹0

How to check the errors of PHP? Is there any software or codes that will help me in finding errors?
Ans(1) ₹0

Does Psychic Training really work? Should I practice that?
Ans(1) ₹0

free software website vs website from scratch using html
Ans(3) ₹0

html css center horizontal list, menu system
Ans(2) ₹0

Is it possible that goat standing on two legs
Ans(1) ₹0

Create social share buttons for facebook,twitter,google plus,etc.
Ans(2) ₹0

What is the response time of PHP $post variable?
Ans(2) ₹0

Does the hosting providers really gives unlimited hosting plans?
Ans(2) ₹0

How much Humanoid robots is developed till today? I need lists
Ans(1) ₹0

Free Solar Panel Apply - whatsApp message, fake or true
Ans(2) ₹0

I heard in news that xvideos were band india, but lots of desi website were available, what is happening?
Ans(2) ₹0

convert numbers into words in php
Ans(2) ₹0

I need the lists of websites for testing my website\'s speed
Ans(1) ₹0

create own cdn like jquery cdn link, bootstrap cdn link,etc.
Ans(1) ₹0

How is the Realme XT phone new launched in India? Should I buy it?
Ans(4) ₹0

How was the Gang Leader Movie\'s Story and Roles, who were the actors?
Ans(3) ₹0

javscript check if the variable has value, if not then take action
Ans(2) ₹0

php count variable values separated with comma
Ans(2) ₹0

How to post the link in perfect way for increasing backlinks and traffics for my website?
Ans(3) ₹0

Eight words php search engine script for mysqli database
Ans(2) ₹0

error timezone php or set time php timezone
Ans(1) ₹0

what are the present topics going on this 2019 September? For bloggers and YouTubers.
Ans(2) ₹0

Kicking vs Punching, which is the most working defence or attacking tactics on the street fighting?
Ans(0) ₹0

The test asking
Ans(0) ₹0

Can anyone earn money with fake clicks on Adsense ads? Does anyone successful in doing that?
Ans(1) ₹0

Does Pakistan had power to have a war with India at this time? why they were shouting so much?
Ans(2) ₹0

As Global warming arises, can Human being will be able to repair all those destroyed nature again?
Ans(1) ₹0

Why is my sitemap still pending? I know there is no mistake in my sitemap codes.
Ans(2) ₹0

I heard the South Indian calls North Indian as a Foreigner, Is that true? what is the reason?
Ans(2) ₹0

How to use perfect Javscript Fetch Api, for one website to another website data transfer?
Ans(2) ₹0

How to transfer data from one website to another?
Ans(2) ₹0

Why not functions set inside iFrame body not working?
Ans(0) ₹0

How to get the copied content inside iFrame
Ans(0) ₹0

While bordering the tag, the border seem overflowing
Ans(2) ₹0

How to maintain times as a blogger, to become perfect blogger?
Ans(2) ₹0

What is La Liga?
Ans(0) ₹0

How to write ourl url for SEO on href attribute
Ans(2) ₹0

How to run addEventListener inside iFrame, using Javscript
Ans(0) ₹0

How to show codes on html page, I want to suggest codes for my viewers
Ans(0) ₹0


Feedback Help Contact Terms&Condition Privacy Policy About us

170

Total users

46

Active users

166

Active Earners

Location

India, Assam, Bodoland, Gossaigaon, 783360
[email protected]

Find Us on

74+ Downloads

Download our Android Apps and Get Everything on your Mobile.

Copyright ©2017-19 mritunjoy.com,All Rights Reserved