{"id":677,"date":"2020-03-24T13:59:45","date_gmt":"2020-03-24T04:59:45","guid":{"rendered":"https:\/\/developer.worldspan.co.kr\/?page_id=677"},"modified":"2020-09-21T16:06:53","modified_gmt":"2020-09-21T07:06:53","slug":"%ec%8a%a4%ed%83%80%ec%9d%bc-%ec%8b%9c%ed%8a%b8-%ec%8b%a4%ec%a0%84-5%ec%9d%bc","status":"publish","type":"page","link":"https:\/\/developer.worldspan.co.kr\/?page_id=677","title":{"rendered":"\uc2a4\ud0c0\uc77c \uc2dc\ud2b8 \uc2e4\uc804 5\uc77c"},"content":{"rendered":"<blockquote>\n<ul>\n<li>\uc774\uc2dc\uac04\uc740 \uae30\ucd08\ub514\ube44\ub97c \uc138\ud305 \ud558\uace0 \uac04\ub2e8\ud55c \uc6f9\uc11c\ube44\uc2a4\ub85c \ud56d\uacf5\uc0ac \uacf5\ud56d\ucf54\ub4dc\ub97c \ud638\ucd9c\ud574\ubcf4\uc790.<br \/>\n\ub514\ube44\ub294 mysql\ub85c \uc6f9\uc11c\ube44\uc2a4\ub294 php \ub85c \ub9cc\ub4e4\uc5b4 \ubcf8\ub2e4.<br \/>\n\ub2e4\ub978 \ub514\ube44\ub098 \uc5b4\ub5a4 \uc6f9\uc5b8\uc5b4\ub85c \ud574\ub3c4 \uc804\ud600 \uc0c1\uad00\uc774 \uc5c6\ub2e4. \uae30\ucd08 \ub514\ube44\uc640 \ucf54\ub4dc\ud638\ucd9c \uc6f9\uc11c\ube44\uc2a4\ub97c \ub9cc\ub4e4\uc5b4 \ub193\uc73c\uba74<br \/>\n\ub450\uace0\ub450\uace0 \uc798 \uc368\uba39\uc744 \uc218 \uc788\ub2e4.<\/li>\n<\/ul>\n<\/blockquote>\n<h5>1.Mysql \ub85c \ub514\ube44\ub97c \uad6c\uc131 \ud558\uace0 \ub370\uc774\ud0c0\ub97c \ub364\ud504\ud574\uc11c \ub123\ub294\ub2e4.<\/h5>\n<p><a href=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Database.jpg\"><img loading=\"lazy\" class=\"alignnone wp-image-673\" src=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Database.jpg\" alt=\"\" width=\"624\" height=\"488\" srcset=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Database.jpg 912w, https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Database-300x235.jpg 300w, https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Database-768x600.jpg 768w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<h5>2. PHP \uc5d0\uc11c \ud56d\uacf5\uc0ac\/\uacf5\ud56d\ucf54\ub4dc\ub97c \ubc1b\uc544 \ub514\ucf54\ub529 \uac12\uc744 \ub9ac\ud134\ud558\uac8c \uc6f9\uc744 \ub9cc\ub4e0\ub2e4.<\/h5>\n<pre class=\"lang:php decode:true \" title=\"config.php\">&lt;?php\r\n\r\n  $_host = \"localhost\";\r\n  $_db = \"IBE\";\r\n  $_user = \"****\";\r\n  $_pass = \"**********\";\r\n\r\n  $_dbconn_sc = mysqli_connect($_host, $_user, $_pass); \r\n\r\nmysqli_query($_dbconn_sc,\"set session character_set_connection=utf8;\");\r\nmysqli_query($_dbconn_sc,\"set session character_set_results=utf8;\");\r\nmysqli_query($_dbconn_sc,\"set session character_set_client=utf8;\");\r\n\r\n?&gt;<\/pre>\n<pre class=\"lang:default decode:true \" title=\"airline.php\">&lt;?php\r\n\/\/error_reporting(E_ALL);\r\n\/\/ini_set('display_errors', TRUE);\r\n\/\/ini_set('display_startup_errors', TRUE);\r\n\r\nrequire('config.php'); \/\/Open DB\r\n\r\n$code = $_GET['code'];\r\n\r\nif (strlen($code)==2){\r\n\t$squery = \"SELECT airline_english,airline_korean FROM IBE.Airlines where airline_code = '$code'\";\r\n\t$res = mysqli_query($_dbconn_sc, $squery);\r\n\r\n\tif($data = mysqli_fetch_array($res,MYSQLI_ASSOC)){\r\n\t\techo $data['airline_korean'];\r\n\t}\r\n\telse\r\n\t{\r\n\t\techo $code;\r\n\t}\r\n}\r\nelse\r\n{\r\n\techo $code;\r\n}\r\n\r\nmysqli_close($_dbconn_sc);  \/\/Close DB\r\n\r\n?&gt;<\/pre>\n<pre class=\"lang:php decode:true \" title=\"airport.php\">&lt;?php\r\n\/\/error_reporting(E_ALL);\r\n\/\/ini_set('display_errors', TRUE);\r\n\/\/ini_set('display_startup_errors', TRUE);\r\n\r\nrequire('config.php'); \/\/Open DB\r\n\r\n$code = $_GET['code'];\r\n\r\nif (strlen($code)==3){\r\n\t$squery = \"SELECT airport_english,airport_korean FROM IBE.Airport where airport_code = '$code'\";\r\n\t$res = mysqli_query($_dbconn_sc, $squery);\r\n\r\n\tif($data = mysqli_fetch_array($res,MYSQLI_ASSOC)){\r\n\t\techo $data['airport_korean'];\r\n\t}\r\n\telse\r\n\t{\r\n\t\techo $code;\r\n\t}\r\n}\r\nelse\r\n{\r\n\techo $code;\r\n}\r\n\r\nmysqli_close($_dbconn_sc);  \/\/Close DB\r\n\r\n?&gt;<\/pre>\n<h5>3. \uc6f9 \ud638\ucd9c\uc774 \uc798\ub418\ub294\uc9c0 \ud655\uc778\ud574 \ubcf8\ub2e4.<\/h5>\n<p><a href=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airline.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-674\" src=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airline.jpg\" alt=\"\" width=\"679\" height=\"219\" srcset=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airline.jpg 679w, https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airline-300x97.jpg 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><br \/>\n<a href=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airport.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-675\" src=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airport.jpg\" alt=\"\" width=\"682\" height=\"219\" srcset=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airport.jpg 682w, https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airport-300x96.jpg 300w, https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_airport-678x219.jpg 678w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/a><\/p>\n<h5>4. xslt\ud30c\uc77c\uc5d0 \uc790\ubc14\uc2a4\ud06c\ub9bd\ud2b8\ub85c \ud568\uc218\ub97c \ub9cc\ub4e4\uace0 \ud638\ucd9c\ud55c\ub2e4.<\/h5>\n<pre class=\"lang:xhtml decode:true  \">:: \uc911\ub7b5 ::\r\n\/\/\ud56d\uacf5\uc0ac \ub514\ucf54\ub529 \uc790\ubc14 \uc2a4\ud06c\ub9bd\ud2b8\r\nfunction airline(code) { \r\n    \r\n\tvar decode = code;\r\n\t\r\n\tvar xmlHttp = new ActiveXObject(\"Msxml2.ServerXMLHTTP.6.0\");\t\t\/\/explorer version 6.0\r\n\t\r\n    xmlHttp.open( \"GET\", \"https:\/\/data.auctionpro.co.kr\/airline.php?code=\" + code, false ); \r\n    xmlHttp.send( null );\r\n    decode =  xmlHttp.responseText;\r\n\t\r\n\treturn decode;\r\n}\r\n\r\n\/\/\uacf5\ud56d \ub514\ucf54\ub529 \r\nfunction airport(code) { \r\n    \r\n\tvar decode = code;\r\n\r\n\tvar xmlHttp = new ActiveXObject(\"Msxml2.ServerXMLHTTP.6.0\");\t\t\/\/explorer version 6.0\r\n    \r\n    xmlHttp.open( \"GET\", \"https:\/\/data.auctionpro.co.kr\/airport.php?code=\" + code, false ); \r\n    xmlHttp.send( null );\r\n    decode =  xmlHttp.responseText;\r\n\t\r\n\tdecode = decode.replace(\"\uacf5\ud56d\",\"\"); \/\/\uae38\uc5b4\uc11c \uacf5\ud56d \uc81c\uac70 \r\n\t\r\n\treturn decode;\r\n}\r\n\r\n::\uc911\ub7b5:: \r\n\r\n&lt;!-- \ud56d\uacf5\uc0ac \ub514\ucf54\ub529 \uc801\uc6a9--&gt;\r\n&lt;xsl:value-of select=\"js:airline(string($PlatingCarrier))\"\/&gt;\r\n\r\n&lt;!-- \ucd9c\ubc1c\uacf5\ud56d --&gt;\r\n&lt;xsl:value-of select=\"js:airport(string(@Origin))\"\/&gt;\r\n\r\n&lt;!-- \ub3c4\ucc29\uacf5\ud56d --&gt;\r\n&lt;xsl:value-of select=\"js:airport(string(@Destination))\"\/&gt;\r\n\r\n:: \uc911\ub7b5 ::<\/pre>\n<blockquote><p>\uc790\ubc14\uc2a4\ud06c\ub9bd\uc5d0\uc11c \uc798 \uc4f0\uc774\ub294 \ucf54\ub4dc \ub370\uc774\ud0c0\ub97c \ubc14\ub85c DB\ub85c \uc811\uc18d\ud558\uc9c0 \uc54a\uace0 \ubc14\ub85c \ub9ac\ud134\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \ud558\uba74 DB \ubd80\ub2f4\ub3c4 \uc801\ub3c4 \uc18d\ub3c4\ub3c4 \ube60\ub97c \uac83\uc73c\ub85c \uae30\ub300\ub41c\ub2e4.<br \/>\n\uc9c0\uae08\ub3c4 \ucf54\ub4dc\uac00 \uac04\uacb0\ud558\uc9c0 \uc54a\uc740\uac00?<br \/>\n\uacf5\uc6a9 \ud568\uc218\ub97c \ubb36\uc5b4 \ub2e4\ub978 \ud30c\uc77c\ub85c \uad00\ub9ac \ud574\ub3c4 \ucf54\ub4dc\uac00 \ud720\uc52c \uac00\uacb0\ud574\uc9c8 \uac83\uc774\ub2e4.<br \/>\n\ubc30\uc5f4\uc744 \uc368\uc11c \ubcf5\uc7a1\ud55c \ucf54\ub529\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\ubcf4\ub2e4 \uc2a4\ud0c0\uc77c\uc2dc\ud2b8\ub85c \ucf54\ub4dc\uc758 \uac04\uacb0\ud568\uc744 \uacbd\ud5d8\ud574 \ubcf4\uc790.<\/p><\/blockquote>\n<h5>5. Tester \ub85c \uc798 \ub098\uc624\ub294\uc9c0 \ud655\uc778 \ud55c\ub2e4.<\/h5>\n<p><a href=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Decode.jpg\"><img loading=\"lazy\" class=\"alignnone wp-image-676\" src=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Decode-1024x915.jpg\" alt=\"\" width=\"879\" height=\"785\" srcset=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Decode-1024x915.jpg 1024w, https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Decode-300x268.jpg 300w, https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Decode-768x686.jpg 768w, https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/IBE_Decode.jpg 1026w\" sizes=\"(max-width: 879px) 100vw, 879px\" \/><\/a><\/p>\n<p>\uc5ec\uae30\uae4c\uc9c0 \uc801\uc6a9\uc18c\uc2a4 \ub2e4\uc6b4\ub85c\ub4dc : <a href=\"https:\/\/developer.worldspan.co.kr\/wp-content\/uploads\/2020\/03\/lowfare_05.zip\">lowfare_05<\/a><\/p>\n<blockquote><p>\uac04\ub2e8\ud55c \ubc29\uc2dd\uc73c\ub85c \ub514\ucf54\ub529 \ud574\ubd24\ub2e4.<br \/>\n\uc6d0\ubcf8 Xml\uc5d0\uc11c attribute \uc5d0 decode \ub123\ub294 \ubc29\ubc95\ub3c4 \uc788\ub2e4. \uc774 \ubc29\ubc95\ub3c4 \uc88b\uc740 \ubc29\ubc95\uc774\ub2e4. \ub364\uc73c\ub85c \uc5ec\ub7ec \uac12\ub4e4\uc744 \ub123\uc5b4 transformation\uc73c\ub85c \uc5ec\ub7ec \ub370\uc774\ud0c0\ub97c \ubcf4\uc5ec\uc904 \uc218\ub3c4 \uc788\ub2e4.<br \/>\n6\uc77c\ucc28\uc5d0\uc120 \uc5b4\ub5bb\uac8c transformation \ud558\uace0 \uc6f9\uc11c\ube44\uc2a4\ub85c \uc804\ub2ec\ud558\uace0 \ud30c\uc2f1\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uacf5\ubd80\ud574 \ubcf4\uc790.<\/p><\/blockquote>\n<p><a href=\"https:\/\/developer.worldspan.co.kr\/?page_id=705\">\uc2a4\ud0c0\uc77c \uc2dc\ud2b8 \uc2e4\uc804 6\uc77c<\/a> \ub85c \uac00\uae30<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc774\uc2dc\uac04\uc740 \uae30\ucd08\ub514\ube44\ub97c \uc138\ud305 \ud558\uace0 \uac04\ub2e8\ud55c \uc6f9\uc11c\ube44\uc2a4\ub85c \ud56d\uacf5\uc0ac \uacf5\ud56d\ucf54\ub4dc\ub97c \ud638\ucd9c\ud574\ubcf4\uc790. \ub514\ube44\ub294 mysql\ub85c \uc6f9\uc11c\ube44\uc2a4\ub294 php \ub85c \ub9cc\ub4e4\uc5b4 \ubcf8\ub2e4. \ub2e4\ub978 \ub514\ube44\ub098 \uc5b4\ub5a4 \uc6f9\uc5b8\uc5b4\ub85c \ud574\ub3c4 \uc804\ud600 \uc0c1\uad00\uc774 \uc5c6\ub2e4. \uae30\ucd08 \ub514\ube44\uc640 \ucf54\ub4dc\ud638\ucd9c \uc6f9\uc11c\ube44\uc2a4\ub97c \ub9cc\ub4e4\uc5b4 \ub193\uc73c\uba74 \ub450\uace0\ub450\uace0 \uc798 \uc368\uba39\uc744 \uc218 \uc788\ub2e4. 1.Mysql \ub85c \ub514\ube44\ub97c \uad6c\uc131 \ud558\uace0 \ub370\uc774\ud0c0\ub97c \ub364\ud504\ud574\uc11c \ub123\ub294\ub2e4. 2. PHP \uc5d0\uc11c \ud56d\uacf5\uc0ac\/\uacf5\ud56d\ucf54\ub4dc\ub97c \ubc1b\uc544 \ub514\ucf54\ub529 \uac12\uc744 \ub9ac\ud134\ud558\uac8c \uc6f9\uc744 \ub9cc\ub4e0\ub2e4. &lt;?php $_host\u2026 <span class=\"read-more\"><a href=\"https:\/\/developer.worldspan.co.kr\/?page_id=677\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/developer.worldspan.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/677"}],"collection":[{"href":"https:\/\/developer.worldspan.co.kr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/developer.worldspan.co.kr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/developer.worldspan.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/developer.worldspan.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=677"}],"version-history":[{"count":16,"href":"https:\/\/developer.worldspan.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/677\/revisions"}],"predecessor-version":[{"id":909,"href":"https:\/\/developer.worldspan.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/677\/revisions\/909"}],"wp:attachment":[{"href":"https:\/\/developer.worldspan.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}