PHP 싱클퀘테이션(‘) 및 특수 문자 처리

Remark : 특수 문자 때문에 쿼리 오류가 발생한다.


$nation = "Lao, People's Dem. Rep.";

$query = "SELECT * FROM CITY where country_english ='$nation'";

# ERR

$nation = "Lao, People's Dem. Rep.";

$query = "SELECT * FROM CITY where country_english ='$nation'";

# ERR

addslashes()


$nation = "Lao, People's Dem. Rep.";

$nation = addslashes($nation);

$query = "SELECT * FROM CITY where country_english ='$nation'";

# OK

$nation = "Lao, People's Dem. Rep.";

$nation = addslashes($nation);

$query = "SELECT * FROM CITY where country_english ='$nation'";

# OK


$string = "I'am a boy";
$a = addslashes($string);
print $a;
$b = stripslashes($a);
print $b;

$string = "I'am a boy";

$a = addslashes($string);

print $a;

$b = stripslashes($a);

print $b;