query($sql); while($msg=$db->fetch_array($res)){ $pic="../attachments/scene/".$msg["scenePic"].".jpg"; // $hotstr=""; $sql2="select * from web_scene_hotspots where sid='".$msg["id"]."'"; $res2=$db->query($sql2); while($msg2=$db->fetch_array($res2)){ if($msg2["hot_type"]=="info"){ $tmp_kh=get_db_msg("select id from web_kh where no='".$msg2["khno"]."'"); $khid=$tmp_kh["id"]?$tmp_kh["id"]:"0"; $hotstr.="{\"id\":\"".$khid."\",\"pitch\":\"".$msg2["hot_pitch"]."\",\"yaw\":\"".$msg2["hot_yaw"]."\",\"type\":\"".$msg2["hot_type"]."\",\"text\":\"".$msg2["khno"]."\",\"sceneId\":\"".$msg2["hot_sceneId"]."\"},"; }else{ $hotstr.="{\"pitch\":\"".$msg2["hot_pitch"]."\",\"yaw\":\"".$msg2["hot_yaw"]."\",\"type\":\"".$msg2["hot_type"]."\",\"text\":\"".$msg2["hot_title"]."\",\"sceneId\":\"".$msg2["hot_sceneId"]."\"},"; } } $str.="\"".$msg["sceneName"]."\":{\"type\":\"equirectangular\",\"title1\":\"".$msg["sceneTitle"]."\",\"panorama\":\"".$pic."\",\"hotSpots\":[".substr($hotstr,0,-1)."]},"; } $json_data.="\"code\":0,\"data\":{".substr($str,0,-1)."},"; break; } $json_data=substr($json_data,0,-1)."}"; echo $json_data; ?>