[PHP] DB -> JSON 형식 출력 (유니코드 변환)

<?php
 
 
 
 
$host = "localhost";
$user = "id";
$pw = "pw";
$db = "db";
 
 
$conn = mysqli_connect($host,$user,$pw,$db);
 
if(mysqli_connect_errno($conn))
{
echo "Connect Fail";
}
else
{
$result = mysqli_query($conn,"SELECT * FROM table1 $where");
 
$arset = array();
 
while($row = mysqli_fetch_array($result))
{
array_push($arset , array('column1'=>$row[0],'column2'=>$row[1],'column3'=>$row[2],'column4'=>$row[3],'column5'=>$row[4]));
}
 
$json = my_json_encode(array("result"=>$arset));
 
echo $json;
 
}
 
 
mysqli_close($con);
 
 
//json unicode encoding
function my_json_encode($arr) 
{ 
         //convmap since 0x80 char codes so it takes all multibyte codes (above ASCII 127). So such characters are being "hidden" from normal json_encoding 
         array_walk_recursive($arr, function (&$item, $key) { if (is_string($item)) $item = mb_encode_numericentity($item, array (0x80, 0xffff, 0, 0xffff), 'UTF-8'); }); 
         return mb_decode_numericentity(json_encode($arr), array (0x80, 0xffff, 0, 0xffff), 'UTF-8'); 
} 
 
?>