My database contains fields with special characters. How can I read these characters?

Asked Apr 19 '17 at 15:57

Active Apr 19 '17 at 15:57

Viewed 29 times

My database contains fields with special characters. How can I read these characters? With the next code, Ma?? (Maçã) is returned. Do I have this code:

$nome=$_POST['nome'];

$sql=mysqli_query($con, "SELECT idalimento, nome_pt FROM alimento WHERE 
nome_en= '$nome'");

while($exibe = mysqli_fetch_assoc($sql)){
echo $exibe["nome_pt"]."<br>";
}
?>

Can someone help me? Thanks

asked Apr 19 '17 at 15:57

Flavio Melo

You have a SQL injection vulnerability. – SLaks Apr 19 '17 at 15:58
```echo utf8_encode($exibe["nome_pt"]), "
";``` might do the trick – Ben Guest Apr 19 '17 at 15:59
How can i solve this? – Flavio Melo Apr 19 '17 at 16:00
your fields and your database in what encoding they are? – Dimitrios Desyllas Apr 19 '17 at 16:00
@BenGuest Finally it works! Thank you so much. For the next time, I'll ask right here. I've had a long time here. Thanks for your help :) – Flavio Melo Apr 19 '17 at 16:11

My database contains fields with **special characters**. How can I read these characters?

0 Answers0

My database contains fields with special characters. How can I read these characters?