Skip to content
woosoo2 edited this page Mar 7, 2014 · 2 revisions

###ID에따른 조건검색 미추가(추후 로그인 구현후 넣긔)

<?php
//print $_GET["tId"];
$con=mysql_connect("localhost","tv11","imtv11");
$sql = "select cid,cname from closet"; // ".$_GET["tId"]."";
// 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["closet"][$i]=array();
	$resultArray["closet"][$i]["cid"]=$row["cid"];
	$resultArray["closet"][$i]["cname"]=$row["cname"];
	$i++;
}
echo "". json_encode($resultArray,JSON_UNESCAPED_UNICODE) . "";
mysql_close($con);

?>
'''

Clone this wiki locally