Page 180 - 완) I MDP 프로젝트 작품 보고서(전체과 1학년)1.6

나. 웹 서버 프로그램 소스

- getdata2.php
<?php

$con=mysqli_connect("localhost","root","root","doll");

if(mysqli_connect_errno($con))

{
echo "Failed to connect to MySQL: ". mysqli_connect_error();

}

mysqli_set_charset($con,"utf8");

$uid = $_POST['uid'];

$res = mysqli_query($con,"select * from card");

$result = array();

while($row = mysqli_fetch_array($res)){
array_push($result,

array('uid'=>$row[0],'balance'=>$row[1]
));

}

echo json_encode(array("result"=>$result));

mysqli_close($con);

?>

- 173 -