코디셋.php

http://www.finfra.com/~tv11/codyset.php?cId=

<?php
//print $_GET["tId"];
$con=mysql_connect("localhost","tv11","imtv11");
$sql = "select c.*,s.csname from ccgrp c join codyset s on c.csid=s.csid where cid=".$_GET["cId"]."";
// Check connection
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("tv11", $con);
$result = mysql_query($sql);
$resultArray = array();
$i=0;
while($row = mysql_fetch_array($result)){
	$resultArray["codyset"][$i]=array();
	$resultArray["codyset"][$i]["cid"]=$row["cid"];
	$resultArray["codyset"][$i]["csid"]=$row["csid"];
	$resultArray["codyset"][$i]["csname"]=$row["csname"];
	$resultArray["codyset"][$i]["tid"]=$row["tid"];
	$resultArray["codyset"][$i]["bid"]=$row["bid"];
	$i++;
}
echo "". json_encode($resultArray,JSON_UNESCAPED_UNICODE) . "";
mysql_close($con);

?>

---

리턴 되는 JSON은 다음과 같다.

{
    "codyset": [
        {
            "cid": "",
            "csid": "",
            "csname": "",
            "tid": "",
            "bid": ""
        },
         .
         .
         .
    ]
}