search php and mysql

0

I have a search engine with a normal form and everything, but in my bd I have some words with ñ and others without ñ in case the client enters it wrong.

The problem is that let's say I look for the word "estreñimiento" does not find anything even though this is the word in the database.

This is my query:

$sql = "SELECT * 
       FROM productos
       WHERE nombre LIKE '%$buscar%'
         OR descripcion LIKE '%$buscar%'
         OR observaciones LIKE '%$buscar%' 
         OR palabras_clave LIKE '%$buscar%'";
$result = $conn->query($sql);

Will anyone have a solution?

    
asked by Marcos 09.01.2018 в 16:40
source

0 answers