CODEWITHSUNDEEP
phpmysqlsql-likesql-search
zordon_tri
zordon_tri

Reputation: 3

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.

Upvotes: -1

Views: 135

Answers (1)

Sehdev
Sehdev

Reputation: 5672

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

Upvotes: -2

Related Questions