Forum arrow_forward_ios Codding

Questions By
Monjoti Mondol
card_giftcard ₹0

question_answer 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 , 24 views


check_circle_outline 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..
 
Monjoti Mondol
06-04-2018

more_horiz 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 
 

Monjoti Mondol
07-04-2018

Please lock LOGIN to Answer

announcement Recently Asked

question_answer


announcement Related Ques

question_answer
question_answer
question_answer
How many countries Twilio can send SMS?
Ans(2) ₹0 check_circle_outline
question_answer
question_answer
question_answer
I want to register SENDER ID for my SNS SMS, on AWS.
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
question_answer
question_answer
question_answer
What is SKU in shiprocket? From where I can get it?
Ans(1) ₹0 check_circle_outline
question_answer
PHP SDK - Delete Object not working on s3 - error \
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
question_answer
question_answer
How much tables one Mysql database can have?
Ans(1) ₹0 check_circle_outline
question_answer
What is the amount of withdrawn in RazorPay?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
Need codes to send SMS using AWS SNS in PHP.
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
Multiple database vs single database on mysql?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
Is this PMEGP Loan works Offline also?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
Can I create live straming videos using cloudfront?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
question_answer
question_answer
question_answer
question_answer
question_answer
What is La Liga?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
question_answer
question_answer
html css center horizontal list, menu system
Ans(2) ₹0 check_circle_outline
question_answer
php count variable values separated with comma
Ans(2) ₹0 check_circle_outline
question_answer
question_answer
question_answer
question_answer
question_answer
question_answer
How to properly get Pre Signed URL from s3 Bucket?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
How to get date of every after 30 days using PHP?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
question_answer
How much is the Margin Money of PMEGP Loan fo ST?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
Which is the right time to get EDP Training?
Ans(1) ₹0 check_circle_outline
question_answer
What were the documents required for PMEGP Loan?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
multiple aws s3 bucket vs one aws s3 bucket?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
Linux repeated Keyword problems.. how to solve it?
Ans(1) ₹0 check_circle_outline
question_answer
question_answer
question_answer
question_answer
question_answer
question_answer
How to get the present full url using PHP
Ans(2) ₹0 check_circle_outline
question_answer
question_answer
question_answer
PHP code to get the token of Shiprocket.
Ans(1) ₹0 check_circle_outline
question_answer
How to get the nested Array Data using PHP?
Ans(1) ₹0 check_circle_outline
question_answer

WelCome to the World of Digital Expression

Transform your Works into Digital and Makes your life more easier.

121

Total users

121

Active users

5

Active Earners

location_on BTR,Assam,INDIA
(Bodoland)
email [email protected]
call +91 8486866741
rss_feed

Copyright ©2019-20 mritunjoy.com,All Rights Reserved