如何使用LIKE运算符将哪些数据保存在变量中？

Question

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.

Answer 1

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);