Programming/Php

[PHP] 한글 깨짐 방지

gl2ep 2014. 5. 15. 14:24


DB 입력 할 때 (insert)

$memo = addslashes(iconv("UTF-8","euc-kr",$memo)); 


$sql = "insert into 테이블명 (memo) values ('$memo')" ;

mysql_query($sql, $connect);




DB 출력 할 때 (select)


$detail_sql = "select memo from 테이블명 where no=$no";

$list= mysql_query($detail_sql, $connect);

mysql_data_seek($list, 0);

$result= mysql_fetch_array($list);

$result[memo] = nl2br($result[memo]);

$memo =  iconv("euc-kr","UTF-8",$result[memo]);