Search code examples
phpmysqlsql-likesql-search

How to using LIKE operator which data saved in variable?

I need to search data in the database table.

I save data in a variable, then I want to display the data using it LIKE an operator when the data is called.

This is my code :

 $data_input_user = $inFilter;
 $data_input_user = mysql_real_escape_string($inFilter);
 $sqlGetFreq = "SELECT * FROM termfrequency WHERE keyword LIKE 
 CONCAT("%",$inFilter,"%") ";
 $freqResult = mysql_query($sqlGetFreq) or die(mysql_error());

Beside that i was trying this sql query 

$sqlGetFreq = "SELECT keyword, frequency FROM termfrequency WHERE keyword LIKE '%$inFilter%' ";
$freqResult = mysql_query($sqlGetFreq) or die(mysql_error());

I was trying that code, but it failed.

Any idea please?

Thanks.

Solution

  • Try this

       $sqlGetFreq = "SELECT keyword, frequency FROM termfrequency WHERE keyword LIKE '%".$inFilter."%' ";

    Also please set the following to track any possible error.

    ini_set("display_errors", "1");
error_reporting(E_ALL);