CODEWITHSUNDEEP
phpmysql
ron
ron

Reputation: 41

Display all related data when searchkeyword

This is part of my php file.

if(preg_match("/^[   a-zA-Z]+/", $_POST['searchName']))
{ 
    $name=$_POST['searchName']; 

    $con=mysql_connect ("localhost", "root",  "");

    $mydb=mysql_select_db("food",$con); 

    $result=mysql_query("SELECT Name, Price FROM info WHERE Name='$name'"); 

    while($row=mysql_fetch_array($result))
    { 
        echo $row['Name'];
        echo $row['Price'];
    } 
} 
else
{ 
    echo  "<p>Please enter a search query</p>"; 
}

The problem for me now is for example I want to search for chicken pizza but it will only display the information when I type to full sentence which is chicken pizza. How can I make if I type chicken or other keyword and it will display to corresponding data related to chicken like chicken pie, chicken wings? Thanks for advicing.

Note:I will change it to mysqli after I solved this problem

Upvotes: 0

Views: 28

Answers (2)

Murad Hasan
Murad Hasan

Reputation: 9583

You need to use the LIKE operator here. LIKE comes with varieties of ways. You can use % before the keyword, after the keyword, and both before and after the keyword.

Example: 

"SELECT Name, Price FROM info WHERE Name LIKE '%$name%'"

Tip: The "%" sign is used to define wildcards (missing letters) both before and after the pattern.

And Stop using mysql_*, start with mysqli_* OR PDO.

Upvotes: 0

Alex
Alex

Reputation: 17289

SELECT Name, Price FROM info WHERE Name LIKE 'chicken%'

Upvotes: 1

Related Questions