how to query mysql containing special character (è, d', è) in php?

Question

I have a file containing French words, and I encoded the file as "Latin-1" (uft-8 didn't work), loaded the file to a table in MySQL. I need to $_POST input ("name") from a web page and use the "name" to query from MySQL. My code is as follows:

$name = "d' évaluation perfomance académique";
$sql = "SELECT * FROM application WHERE `Description` = '".$name."'";

For normal "name", it can work. But can't work if the "name" containing (è, d', è).

Any suggestions?

Thanks!

Please try `URLEncoder.encode("é", "UTF-8")` and tell me what it produces. — AStopher, May 19 '15 at 15:58
The php iconv() function will translate one character set to another. — Octopus, May 19 '15 at 15:58
possible duplicate of [Android - Sending POST with Spaces to PHP Server](http://stackoverflow.com/questions/29097627/android-sending-post-with-spaces-to-php-server). (duplicate as it details *how* PHP handles the characters to the database, it needs to pre-process the characters first). — AStopher, May 19 '15 at 15:59
By using urlenocde("é", "UTF-8"), "é" is coded as "%C3%A9" ...?@cybermonkey — Jason, May 19 '15 at 16:39

score 0 · Answer 1 · answered May 19 '15 at 16:01

0

Assuming your PHP file is in UTF-8, I believe the following will work:

$name = "d' évaluation perfomance académique";
$sql = "SELECT * FROM application WHERE `Description` = '".$name."'";
$sql_latin1 = iconv("UTF-8","ISO-8859-1",$sql);

answered May 19 '15 at 16:01

Octopus

8,075
5
46
66

Please don't answer duplicate questions. – AStopher May 19 '15 at 16:01
This solution was not included in that so called duplicate. – Octopus May 19 '15 at 16:08
My answer answers this question. While your answer *does* answer this question, it's frowned upon to answer duplicate questions. Both questions deal with character encoding, and both answers are correct. – AStopher May 19 '15 at 16:10
Thank you for your advice. But it still can't work. $name = "d' évaluation perfomance académique"; $name_code = iconv("UTF-8","ISO-8859-1",$name); $sql = "SELECT * FROM application WHERE `Description` = '".$name."'"; Still can't get the right result. – Jason May 19 '15 at 16:41

how to query mysql containing special character (è, d', è) in php?

1 Answers1