{"id":19634,"date":"2020-04-20T21:18:33","date_gmt":"2020-04-20T12:18:33","guid":{"rendered":"https:\/\/kimassi.net\/zak\/?p=19634"},"modified":"2022-09-08T05:03:08","modified_gmt":"2022-09-07T20:03:08","slug":"%e5%ae%bf%e6%b3%8a%e6%83%85%e5%a0%b1%e3%81%ae%e6%a5%bd%e5%a4%a9api%e3%82%92%e5%88%a9%e7%94%a8%e3%81%97%e3%81%a6php%e3%81%a7%e5%87%a6%e7%90%86","status":"publish","type":"post","link":"https:\/\/kimassi.net\/zak\/?p=19634","title":{"rendered":"\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u7a7a\u5ba4\u691c\u7d22API\u3092\u4f7f\u3063\u3066PHP\u3067\u5bbf\u6cca\u60c5\u5831\u306e\u8868\u793a"},"content":{"rendered":"

2019\u5e743\u67083\u65e5<\/strong><\/span><\/p>\n

\u697d\u5929API\u3092\u5229\u7528\u3057\u3066\u5546\u54c1\u691c\u7d22\u3057\u3066\u8868\u793a\u3059\u308bPHP\u30d7\u30ed\u30b0\u30e9\u30e0<\/a>\u304c\u52d5\u4f5c\u3057\u305f\u306e\u3067\u3001\u30a2\u30d5\u30a3\u30ea\u30a8\u30a4\u30c8\u306b\u3082\u5f79\u7acb\u3066\u3088\u3046\u3068\u3001\u697d\u5929API\u3092\u5229\u7528\u3057\u305f\u5bbf\u6cca\u60c5\u5831\u306e\u8868\u793a\u306b\u30c8\u30e9\u30a4\u3059\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u697d\u5929API\u306e\u4e00\u89a7\u3067\u4f7f\u3044\u305f\u3044API\u3092\u9078\u3093\u3067\u304a\u304d\u307e\u3059\u3002\u4f7f\u3046\u306e\u306f\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u7a7a\u5ba4\u691c\u7d22API\u3067\u3059\u3002<\/span>
\nhttps:\/\/webservice.rakuten.co.jp\/document\/<\/span>
\n\u65b0\u898f\u30a2\u30d7\u30ea\u767b\u9332\u3092\u3057\u3066\u3001\u697d\u5929\u306e\u30c7\u30d9\u30ed\u30c3\u30d1\u30fcID\u3068\u30a2\u30d5\u30a3\u30ea\u30a8\u30a4\u30c8ID\u3092\u53d6\u5f97\u3059\u308b\u306e\u306f\u540c\u69d8\u3067\u3059\u3002<\/span>
\nhttps:\/\/webservice.rakuten.co.jp\/<\/span>
\n\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u30e1\u30e2\u3057\u3066\u304a\u3044\u305f\u65b9\u304c\u826f\u3044\u3067\u3059\u3002<\/span><\/p>\n

\u65e5\u4ed8\u6307\u5b9a\u3092\u3057\u3066\u901a\u5e38\u6761\u4ef6\u3067\u6700\u5b89\u5024\u3092\u8868\u793a\u3059\u308b\u306e\u304c\u5f53\u5ea7\u306e\u76ee\u6a19\u3067\u3059\u3002<\/span>
\n\u6700\u8fd1\u3001\u6700\u5b89\u5024\u3067\u691c\u7d22\u3057\u305f\u6642\u306b\u4e0a\u4f4d\u306b\u8868\u793a\u3055\u308c\u3066\u76ee\u7acb\u3064\u3088\u3046\u306b\u30d0\u30fc\u30b9\u30c7\u30fc\u306e\u5ba2\u9650\u5b9a\u3067\u7279\u5225\u4fa1\u683c\u3092\u8a2d\u5b9a\u3057\u3066\u305f\u308a\u3059\u308b\u306e\u3067\u672c\u5f53\u306b\u8ab0\u3082\u304c\u5229\u7528\u3067\u304d\u308b\u6700\u5b89\u5024\u3092\u691c\u7d22\u3059\u308b\u306e\u306f\u96e3\u3057\u3044\u3067\u3059\u3002<\/span>
\n\u6700\u7d42\u7684\u306b\u306f\u30d0\u30fc\u30b9\u30c7\u30fc\u30d7\u30e9\u30f3\u3092\u63a1\u7528\u3057\u3066\u3044\u308b\u30db\u30c6\u30eb\u306f\u9664\u5916\u3059\u308b\u3088\u3046\u306b\u3057\u3088\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/span><\/p>\n

https:\/\/webservice.rakuten.co.jp\/explorer\/api\/Travel\/VacantHotelSearch\/<\/span>
\n\u3067\u6761\u4ef6\u3092\u8a2d\u5b9a\u3057\u305f\u5834\u5408\u306e\u3001\u51fa\u529b\u4f8b\u3092\u898b\u308b\u4e8b\u304c\u51fa\u6765\u307e\u3059\u3002
\n\u4e0a\u8a18\u30b5\u30a4\u30c8\u3067\u3001+\u30ab\u30b9\u30bf\u30e0\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u6761\u4ef6\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002
\n\u5730\u57df\u3092smallClassCode\u3067\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u3001largeClassCode\u3001middleClassCod\u3001smallClassCode\u306e\u3059\u3079\u3066\u3092\u6307\u5b9a\u3057\u306a\u3044\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002
\n<\/span>\u65e5\u4ed8\u6307\u5b9a\u3057\u3066\u3001\u91d1\u6ca2\u3067\u30011\u4eba\u3001\uff12\uff10\uff10\uff10\u5186\u4ee5\u4e0a\uff08\u30d0\u30fc\u30b9\u30c7\u30fc\u9650\u5b9a\u306a\u3069\u306e\u7279\u6b8a\u6761\u4ef6\u3067\u306e\u7279\u5225\u6599\u91d1\u3092\u5916\u3059\u305f\u3081\u306b\u6975\u7aef\u306a\u5b89\u5024\u306f\u9664\u5916\uff09\u3001\u6700\u5b89\u5024\u3092\uff11\u30da\u30fc\u30b8\u30fb\uff11\u30c7\u30fc\u30bf\u3067\u4fa1\u683c\u306e\u307f\u8868\u793a\u3068\u3044\u3046\u6761\u4ef6\u8a2d\u5b9a\u3060\u3068\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002
\n<\/span>
\nhttps:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=json&checkinDate=2019-04-06&checkoutDate=2019-04-07&adultNum=1&minCharge=2000&sort=%2BroomCharge&hits=1&page=1&largeClassCode=japan&middleClassCode=ishikawa&smallClassCode=kanazawa&applicationId=9b81e09ff42f1ed91429120194392379<\/p>\n

\u51fa\u529b\u4f8b\u3067\u306f\u3001\u304d\u3061\u3093\u3068\u6761\u4ef6\u306b\u5408\u3063\u305f\u5bbf\u306e\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u5b9f\u969b\u306b\u30d6\u30e9\u30a6\u30b6\u3092\u7acb\u3061\u4e0a\u3052\u3066\u3001\u30a2\u30c9\u30ec\u30b9\u6b04\u306b\u305d\u306e\u307e\u307e\u5165\u529b\u3059\u308b\u3068\u30a8\u30e9\u30fc\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/span>
\n\u30d6\u30e9\u30a6\u30b6\u4e0a\u3067\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u3069\u306e\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3055\u305b\u308b\u304b\uff08elements=\uff09\u6307\u5b9a\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3088\u3046\u3067\u3059<\/span>\u3002<\/p>\n

\u305d\u306e\u4ed6\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u306f
\nhttps:\/\/webservice.rakuten.co.jp\/api\/vacanthotelsearch\/
\n\u3067\u8abf\u3079\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

\u90e8\u5c4b\u306f\u30b7\u30f3\u30b0\u30eb\u306e\u5834\u5408\u306ff_rm_bed=single\u3092\u52a0\u3048\u307e\u3059\u3002\u90e8\u5c4b\u304c\u30c4\u30a4\u30f3\u306e\u5834\u5408\u306ff_rm_bed=twin\u3001\u90e8\u5c4b\u306b\u62d8\u3089\u306a\u3044\u5834\u5408\u306ff_rm_bed=*\u3067\u3059\u3002<\/span>
\n\u8868\u793a\u3092\u30db\u30c6\u30eb\u540d\u306b\u3059\u308b\u5834\u5408\u306felements=hotelName<\/span>
\n\u30db\u30c6\u30eb\u540d\u3068\u6599\u91d1\u306e\u7dcf\u984d\u3092\u8868\u793a\u3059\u308b\u5834\u5408\u306felements=hotelName,total<\/span><\/p>\n

https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=jsor&checkinDate=2019-04-06&checkoutDate=2019-04-07&smallClassCode=kanazawa&adultNum=1&f_rm_bed=single&hits=1&page=1&sort=%2BroomCharge&largeClassCode=japan&middleClassCode=ishikawa&minCharge=2000&elements=hotelName&applicationId=1089363386770913344<\/p>\n

\u30d6\u30e9\u30a6\u30b6\u306e\u30a2\u30c9\u30ec\u30b9\u6b04\u306b\u5165\u529b\u3059\u308b\u3068<\/span><\/p>\n

{“hotels”:[{“hotel”:[{“hotelBasicInfo”:{“hotelName”:”\u30b2\u30b9\u30c8\u30cf\u30a6\u30b9\u3000\u548c\u3093\u3067”}}]}]}<\/span><\/p>\n

\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/span><\/p>\n

https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=jsor&checkinDate=2019-04-06&checkoutDate=2019-04-07&smallClassCode=kanazawa&adultNum=1&f_rm_bed=single&hits=1&page=1&sort=%2BroomCharge&largeClassCode=japan&middleClassCode=ishikawa&minCharge=2000&elements=hotelName,total&applicationId=1089363386770913344<\/p>\n

\u30d6\u30e9\u30a6\u30b6\u306e\u30a2\u30c9\u30ec\u30b9\u6b04\u306b\u5165\u529b\u3059\u308b\u3068<\/span><\/p>\n

{“hotels”:[{“hotel”:[{“hotelBasicInfo”:{“hotelName”:”\u30b2\u30b9\u30c8\u30cf\u30a6\u30b9\u3000\u548c\u3093\u3067”}},{“roomInfo”:[{“dailyCharge”:{“total”:2000}}]},{“roomInfo”:[{“dailyCharge”:{“total”:2000}}]},{“roomInfo”:[{“dailyCharge”:{“total”:3500}}]}]}]}<\/span><\/p>\n

\u3068\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\u6599\u91d1\u3082\u8868\u793a\u3059\u308b\u3068\u3001\u3059\u3079\u3066\u306e\u8a72\u5f53\u3059\u308b\u30d7\u30e9\u30f3\u5168\u90e8\u306e\u6599\u91d1\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/span><\/p>\n

\u3068\u308a\u3042\u3048\u305a\u65bd\u8a2d\u540d\u3060\u3051\u3092\u8868\u793a\u3055\u305b\u306a\u3044\u3044\u3051\u307e\u305b\u3093\u3002<\/span><\/p>\n

\u516c\u958bAPI\u6d3b\u7528\u30ac\u30a4\u30c9 ZAPA\u8457\u3092\u53c2\u8003\u306b\u65e5\u4ed8\u6307\u5b9a\u3057\u305f\u6642\u306e\u6700\u5b89\u5024\u306e\u5bbf\u6cca\u65bd\u8a2d\u540d\u3092\u8868\u793a\u3059\u308bPHP\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f\u3002<\/span>
\nhttps:\/\/www.pahoo.org\/e-soul\/webtech\/php06\/php06-45-01.shtm<\/a><\/span>
\n\u3082\u53c2\u8003\u306b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u30c1\u30a7\u30c3\u30af\u30a4\u30f32019-04-05\u3001\u30c1\u30a7\u30c3\u30af\u30a2\u30a6\u30c82019-04-06\u3001\u91d1\u6ca2\u3067\u3001\u90e8\u5c4b\u306f\u30b7\u30f3\u30b0\u30eb\u30011\u4eba\u3001\uff12\uff10\uff10\uff10\u5186\u4ee5\u4e0a\uff08\u7279\u6b8a\u6761\u4ef6\u3067\u306e\u7279\u5225\u6599\u91d1\u3092\u5916\u3059\u305f\u3081\u306b\u6975\u7aef\u306a\u5b89\u5024\u306f\u9664\u5916\uff09\u3001\u5bbf\u6cca\u65bd\u8a2d\u540d\u3092\uff11\u30da\u30fc\u30b8\u30fb\uff11\u30c7\u30fc\u30bf\u3067\u8868\u793a\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f\u3002\u30d5\u30a1\u30a4\u30eb\u540d\u306frakuten4.php\u3068\u3057\u307e\u3057\u305f\u3002<\/span>
\n\uff33\uff28\uff21\uff31\u3000\uff22\uff29\uff27\uff28\uff2f\uff35\uff33\uff25\u3000\u3068\u5bbf\u6cca\u65bd\u8a2d\u540d\u3060\u3051\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002\u6210\u529f\u3067\u3059\u3002<\/span>
\n\u5f8c\u306f\u3001\u65e5\u4ed8\u3084\u305d\u306e\u4ed6\u306e\u6761\u4ef6\u3092\u5909\u66f4\u3057\u3066\u4e00\u89a7\u3092\u8868\u793a\u3059\u308c\u3070\u76ee\u7684\u3092\u679c\u305f\u305b\u307e\u3059\u3002<\/span><\/p>\n

<?php<\/p>\n

\/\/\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u304b\u3089\u5bbf\u3092\u691c\u7d22\u3057\u3066HTML\u30bf\u30b0\u3092\u8fd4\u3059\u95a2\u6570
\nfunction yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘**************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘*************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=1’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.
\n‘&f_rm_bed=’.$f_rm_bed ;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;<\/p>\n

return $Items;
\n}
\n?>
\n<?php
\n$checkinDate = “2019-04-05”;
\n$checkoutDate = “2019-04-06”;
\n$minCharge = “2000”;
\n$adultNum = “1”;
\n$f_rm_bed = “single”;<\/p>\n

echo yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed);
\n?>
\n
\n2019\u5e743\u67084\u65e5<\/strong><\/p>\n

\u6700\u5b89\u5024\u306e\u5bbf\u6cca\u65bd\u8a2d\u540d\u3092\u53d6\u308a\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u305f\u306e\u3067\u3059\u304c\u3001\uff13\uff10\u65e5\u5206\u306e\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3057\u305f\u3044\u306e\u3067\u3001\u65e5\u4ed8\u306e\u8a2d\u5b9a\u3068\u66dc\u65e5\u5165\u308a\u306e\u65e5\u4ed8\u3092\u8868\u793a\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/span><\/p>\n

\u691c\u7d22\u306e\u305f\u3081\u306e\u65e5\u4ed8<\/span>
\n<?php
\n$day = date(“Y-m-d”);
\necho $day;
\n?><\/p>\n

\u8868\u793a\u306e\u305f\u3081\u306e\u66dc\u65e5\u4ed8\u306e\u65e5\u4ed8<\/span>
\n<?php
\n$day = date(“Y-m-d”);
\n$w = date(“w”);
\n$week_name = array(“\u65e5”, “\u6708”, “\u706b”, “\u6c34”, “\u6728”, “\u91d1”, “\u571f”);
\n$day2= date(“Y-m-d”).'(‘.$week_name[$w].’)’;
\necho $day2;
\n?><\/p>\n

\uff11\u65e5\u5f8c\u306e\u65e5\u4ed8<\/span>
\n<?php
\n$day = date(“Y-m-d”,strtotime(‘+ 1 day’));
\necho $day;
\n?><\/p>\n

\u5f8c\u306f\u5909\u6570\u3092\u914d\u5217\u306b\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9SQL\u306b\u4fdd\u5b58\u3059\u308c\u3070\u601d\u3063\u3066\u3044\u305f\u30da\u30fc\u30b8\u304c\u3067\u304d\u307e\u3059\u3002<\/span>
\n\u5f53\u65e5\u306e\u30b7\u30f3\u30b0\u30eb\uff11\u4eba\u30fb\u30c4\u30a4\u30f3\uff12\u4eba\u30fb\u3059\u3079\u3066\u306e\u90e8\u5c4b\u3092\u5bfe\u8c61\u306b\u3057\u305f\uff11\u4eba\u3000\u3067\u306e\u5bbf\u6cca\u306e\u6700\u5b89\u306e\u65bd\u8a2d\u540d<\/span>
\n\u660e\u65e5\u306e\u30b7\u30f3\u30b0\u30eb\uff11\u4eba\u30fb\u30c4\u30a4\u30f3\uff12\u4eba\u30fb\u3059\u3079\u3066\u306e\u90e8\u5c4b\u3092\u5bfe\u8c61\u306b\u3057\u305f\uff11\u4eba\u3000\u3067\u306e\u5bbf\u6cca\u306e\u6700\u5b89\u306e\u5bbf\u6cca\u540d<\/span>
\n\u660e\u5f8c\u65e5\u306e\u30b7\u30f3\u30b0\u30eb\uff11\u4eba\u30fb\u30c4\u30a4\u30f3\uff12\u4eba\u30fb\u3059\u3079\u3066\u306e\u90e8\u5c4b\u3092\u5bfe\u8c61\u306b\u3057\u305f\uff11\u4eba\u3000\u3067\u306e\u5bbf\u6cca\u306e\u6700\u5b89\u306e\u5bbf\u6cca\u540d<\/span>
\n\uff13\u65e5\u5f8c\u306e\u30b7\u30f3\u30b0\u30eb\uff11\u4eba\u30fb\u30c4\u30a4\u30f3\uff12\u4eba\u30fb\u3059\u3079\u3066\u306e\u90e8\u5c4b\u3092\u5bfe\u8c61\u306b\u3057\u305f\uff11\u4eba\u3000\u3067\u306e\u5bbf\u6cca\u306e\u6700\u5b89\u306e\u5bbf\u6cca\u540d<\/span>
\n\uff12\uff19\u65e5\u5f8c\u306e\u30b7\u30f3\u30b0\u30eb\uff11\u4eba\u30fb\u30c4\u30a4\u30f3\uff12\u4eba\u30fb\u3059\u3079\u3066\u306e\u90e8\u5c4b\u3092\u5bfe\u8c61\u306b\u3057\u305f\uff11\u4eba\u3000\u3067\u306e\u5bbf\u6cca\u306e\u6700\u5b89\u306e\u5bbf\u6cca\u540d<\/span><\/p>\n

2019\u5e743\u67089\u65e5<\/strong><\/span><\/p>\n

\u3059\u3079\u3066\u306e\u90e8\u5c4b\u3092\u5bfe\u8c61\u306b\u3057\u305f\uff11\u4eba\u30fb\u30b7\u30f3\u30b0\u30eb\u30eb\u30fc\u30e0\uff11\u4eba\u30fb\u30c4\u30a4\u30f3\u30eb\u30fc\u30e0\uff12\u4eba\u3067\u306e\u5bbf\u6cca\u4e88\u7d04\u306e\u6700\u5b89\u5024\u306e\u65bd\u8a2d\u3092\u8868\u793a\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/span>
\n\u9ad8\u5e74\u9f62\u306e\u4eba\u3092\u5bfe\u8c61\u306b\u3057\u305f\u8a95\u751f\u65e5\u3060\u3051\u306e\u9650\u5b9a\u6fc0\u5b89\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u30db\u30c6\u30eb\u30ea\u30d6\u30de\u30c3\u30af\u30b9\u91d1\u6ca2\u533b\u5927\u524d\uff08153335\uff09\u3001\u30db\u30c6\u30eb\u30ea\u30d6\u30de\u30c3\u30af\u30b9\u91d1\u6ca2\u99c5\u524d\uff08165677\uff09\u3001\u3086\u306b\u308d\u30fc\u305a\u91d1\u6ca2TS\u5e97(136975\uff09\u3001\u30db\u30c6\u30eb\u30c8\u30ec\u30f3\u30c9\u91d1\u6ca2\u99c5\u524d\uff08171908\uff09\u3001\uff28\uff2f\uff34\uff25\uff2c\u82b1\uff29\uff43\uff48\uff49\uff32\uff49\uff4e\uff2b\uff21\uff2e\uff21\uff3a\uff21\uff37\uff21\uff08160759\uff09\u306e\u5bbf\u6cca\u65bd\u8a2dID\u306f\u7701\u304f\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002<\/span>
\n\u5f53\u65e5\u304b\u308930\u65e5\u9593\u306e<\/span>
\n\u5e74\u6708\u65e5\uff08\u66dc\u65e5\uff09\u3000\u6700\u5b89\u5024\u306e\u5bbf\u6cca\u65bd\u8a2d\u540d<\/span>
\n\u3092\u8868\u793a\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u3059\u3002<\/span><\/p>\n

<?php<\/p>\n

\/\/\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u304b\u3089\u5bbf\u3092\u691c\u7d22\u3057\u3066HTML\u30bf\u30b0\u3092\u8fd4\u3059\u95a2\u6570
\nfunction yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘1089363386770913344’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘15040cf4.7d33bce5.15040cf5.078e12d9’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=1’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.
\n‘&f_rm_bed=’.$f_rm_bed ;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;
\n$hotelNo = $xml->hotels->hotel->hotelBasicInfo->hotelNo;
\nif ($hotelNo ==’153335′ or $hotelNo ==’136975′ or $hotelNo ==’171908′ or $hotelNo ==’160759′ or $hotelNo ==’171908′){$Items=”\u8868\u793a\u3057\u306a\u3044”;}
\nreturn $Items;
\n}
\n?>
\n<?php<\/p>\n

echo ‘\u5927\u4eba1\u4eba\u3067\u5bbf\u6cca’;print “<br>\\n”;
\nfor($n=0;$n<30;$n++)
\n{$n1=$n+1;
\n$n2=’+’.$n.’ day’;
\n$n3=’+’.$n1.’ day’;
\n$checkinDate = date(“Y-m-d”,strtotime(“$n2”));
\n$checkoutDate = date(“Y-m-d”,strtotime(“$n3”));
\n$minCharge = “1500”;
\n$adultNum = “1”;
\n$f_rm_bed = “*”;
\n$w=date(“w”,strtotime(“$n2”));
\n$week_name = array(“\u65e5”,”\u6708”, “\u706b”,”\u6c34”,”\u6728”,”\u91d1”,”\u571f”);
\n$day2=date(“Y-m-d”,strtotime(“$n2”)).'(‘.$week_name[$w].’)’;
\necho $day2;
\necho yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed);
\nprint “<br>\\n”;
\n}
\n?>
\n<?php
\nprint “<br>\\n”;
\necho ‘\u5927\u4eba1\u4eba\u3067\u30b7\u30f3\u30b0\u30eb\u30eb\u30fc\u30e0\u3067\u306e\u5bbf\u6cca’;print “<br>\\n”;
\nfor($n=0;$n<30;$n++)
\n{$n1=$n+1;
\n$n2=’+’.$n.’ day’;
\n$n3=’+’.$n1.’ day’;
\n$checkinDate = date(“Y-m-d”,strtotime(“$n2”));
\n$checkoutDate = date(“Y-m-d”,strtotime(“$n3”));
\n$minCharge = “2000”;
\n$adultNum = “1”;
\n$f_rm_bed = “single”;
\n$w=date(“w”,strtotime(“$n2”));
\n$week_name = array(“\u65e5”,”\u6708”, “\u706b”,”\u6c34”,”\u6728”,”\u91d1”,”\u571f”);
\n$day2=date(“Y-m-d”,strtotime(“$n2”)).'(‘.$week_name[$w].’)’;
\necho $day2;
\necho yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed);
\nprint “<br>\\n”;
\n}
\n?>
\n<?php
\nprint “<br>\\n”;
\necho ‘\u5927\u4eba\uff12\u4eba\u3067\u30c4\u30a4\u30f3\u30eb\u30fc\u30e0\u3067\u306e\u5bbf\u6cca’;print “<br>\\n”;
\nfor($n=0;$n<30;$n++)
\n{$n1=$n+1;
\n$n2=’+’.$n.’ day’;
\n$n3=’+’.$n1.’ day’;
\n$checkinDate = date(“Y-m-d”,strtotime(“$n2”));
\n$checkoutDate = date(“Y-m-d”,strtotime(“$n3”));
\n$minCharge = “3000”;
\n$adultNum = “\uff12”;
\n$f_rm_bed = “twin”;
\n$w=date(“w”,strtotime(“$n2”));
\n$week_name = array(“\u65e5”,”\u6708”, “\u706b”,”\u6c34”,”\u6728”,”\u91d1”,”\u571f”);
\n$day2=date(“Y-m-d”,strtotime(“$n2”)).'(‘.$week_name[$w].’)’;
\necho $day2;
\necho yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed);
\nprint “<br>\\n”;
\n}
\n?><\/p>\n

2019\u5e743\u670810\u65e5<\/strong><\/span><\/p>\n

\u90e8\u5c4b\u306e\u7a2e\u985e\u3054\u3068\u306b\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3057\u3066\u521d\u3081\u3066\u6c17\u3065\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u90e8\u5c4b\u306e\u7a2e\u985e\u306e\u6307\u5b9a\u304c\u52b9\u3044\u3066\u3044\u306a\u3044\u3088\u3046\u3067\u3059\u3002<\/span><\/p>\n

$f_rm_bed = “twin”;\u3000\u304c\u7121\u52b9\u306a\u3088\u3046\u3067\u3059\u3002<\/span>
\n$roomClass = “twin”;\u3000\u306b\u3057\u3066\u3082\u30c0\u30e1\u3067\u3059\u3002<\/span><\/p>\n

\u6c17\u5408\u3092\u5165\u308c\u3066\u8abf\u3079\u305f\u306e\u3067\u3059\u304c\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u7a7a\u5ba4\u691c\u7d22API\u3067\u306f\u90e8\u5c4b\u306e\u7a2e\u985e\u306e\u6307\u5b9a\u304c\u3067\u304d\u306a\u3044\u3088\u3046\u3067\u3059\u3002\u4e2d\u9014\u534a\u7aef\u3060\u306a\u3042\u30fb\u30fb\u30fb\u30fb<\/span><\/p>\n

\u8868\u793a\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u914d\u5217\u306b\u767b\u9332\u3057\u3066\u307f\u307e\u3057\u305f\u304c\u3001\u767b\u9332\u3057\u3066\u6b21\u306e\u914d\u5217\u306b\u51e6\u7406\u304c\u9032\u3080\u3068\u3001\u524d\u306e\u914d\u5217\u306e\u30c7\u30fc\u30bf\u304c\u6d88\u3048\u307e\u3059\u3002\u4f55\u304c\u60aa\u3044\u306e\u304b\u306a\u3042\uff1f<\/span>
\n\u6700\u5f8c\u306eecho $data[30];\u306f\u8868\u793a\u3055\u308c\u308b\u306e\u306becho $data[29];\u306f\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

<?php<\/p>\n

\/\/\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u304b\u3089\u5bbf\u3092\u691c\u7d22\u3057\u3066HTML\u30bf\u30b0\u3092\u8fd4\u3059\u95a2\u6570
\nfunction yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘***************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘****************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=1’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.”;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;
\n$hotelNo = $xml->hotels->hotel->hotelBasicInfo->hotelNo;
\nif ($hotelNo ==’153335′ or $hotelNo ==’136975′ or $hotelNo ==’171908′ or $hotelNo ==’165677′ or $hotelNo ==’160759′){$Items=”\u8868\u793a\u3057\u306a\u3044”;}
\nreturn $Items;
\n}
\n?>
\n<?php
\necho ‘\u5927\u4eba1\u4eba\u3067\u306e\u5bbf\u6cca’;print “<br>\\n”;
\nfor($n=0;$n<30;$n++)
\n{$n1=$n+1;
\n$n2=’+’.$n.’ day’;
\n$n3=’+’.$n1.’ day’;
\n$checkinDate = date(“Y-m-d”,strtotime(“$n2”));
\n$checkoutDate = date(“Y-m-d”,strtotime(“$n3”));
\n$minCharge = “2000”;
\n$adultNum = “1”;
\n$w=date(“w”,strtotime(“$n2”));
\n$week_name = array(“\u65e5”,”\u6708”, “\u706b”,”\u6c34”,”\u6728”,”\u91d1”,”\u571f”);
\n$day2=date(“Y-m-d”,strtotime(“$n2”)).'(‘.$week_name[$w].’)’;
\necho $day2;
\necho yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge);
\nprint “<br>\\n”;
\n$yado=yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge);
\n$data = [$n =>$yado];
\necho $data[$n];
\nprint “<br>\\n”;
\n}
\n?>
\n<?php
\necho $data[29];
\necho $data[30];
\n?><\/p>\n

\u914d\u5217\u306f\u3084\u3081\u3066\u3001\u4e00\u6c17\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u767b\u9332\u3059\u308b\u4e8b\u306b\u3057\u307e\u3057\u305f\u3002<\/span>
\n\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u306fid\u3001No\u3001date\u3001yadomei\u306b\u3057\u307e\u3057\u305f\u3002<\/span>
\ndate\u306f\u3001\u66dc\u65e5\u4ed8\u306e\u5e74\u6708\u65e5\u3092\u6587\u5b57\u5217\uff08\u4f8b\u3048\u30702019-03-10(\u65e5)\uff09\u3068\u3057\u3066\u767b\u9332\u3057\u307e\u3059\u3002<\/span>
\n\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3059\u6642\u306b\u306f\u51e6\u7406\u3092\u3057\u306a\u3044\u3067\u6e08\u3080\u3068\u3044\u3046\u4f5c\u6226\u3067\u3059\u3002<\/span>
\n\u3068\u308a\u3042\u3048\u305a30\u4ef6\u5206\u306e\u30c7\u30fc\u30bf\u3092\u624b\u52d5\u3067\u5165\u529b\u3057\u307e\u3057\u305f\u3002\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u540d\u306fyasuiyado\u306b\u3059\u308b\u3064\u3082\u308a\u304c\u9593\u9055\u3048\u3066ysuiyado\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002<\/span><\/p>\n

2019\u5e743\u670811\u65e5<\/strong><\/span><\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u4e00\u6319\u306b\u66f4\u65b0\u3059\u308b\u4e8b\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002<\/span>
\n\u6b8b\u308a\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3057\u3066\u5bbf\u306e\u30da\u30fc\u30b8\u3067\u8868\u793a\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/span><\/p>\n

<?php
\ntry {
\n$db = new PDO(‘mysql:dbname=ysuiyado;host=127.0.0.1;charset=utf8’, ‘root’, ”);
\n} catch (PDOException $e) {
\necho ‘DB\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a ‘ . $e->getMessage();
\n}
\n?><\/p>\n

<?php<\/p>\n

\/\/\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u304b\u3089\u5bbf\u3092\u691c\u7d22\u3057\u3066HTML\u30bf\u30b0\u3092\u8fd4\u3059\u95a2\u6570
\nfunction yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘***********’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘**************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=1’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.”;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;
\n$hotelNo = $xml->hotels->hotel->hotelBasicInfo->hotelNo;
\nif ($hotelNo ==’153335′ or $hotelNo ==’136975′ or $hotelNo ==’171908′ or $hotelNo ==’165677′ or $hotelNo ==’160759′){$Items=”\u8868\u793a\u3057\u306a\u3044”;}
\nreturn $Items;
\n}
\n?>
\n<?php
\necho ‘\u5927\u4eba1\u4eba\u3067\u306e\u5bbf\u6cca’;print “<br>\\n”;
\nfor($n=0;$n<30;$n++)
\n{$n1=$n+1;
\n$n2=’+’.$n.’ day’;
\n$n3=’+’.$n1.’ day’;
\n$checkinDate = date(“Y-m-d”,strtotime(“$n2”));
\n$checkoutDate = date(“Y-m-d”,strtotime(“$n3”));
\n$minCharge = “2000”;
\n$adultNum = “1”;
\n$w=date(“w”,strtotime(“$n2”));
\n$week_name = array(“\u65e5”,”\u6708”, “\u706b”,”\u6c34”,”\u6728”,”\u91d1”,”\u571f”);
\n$day2=date(“Y-m-d”,strtotime(“$n2”)).'(‘.$week_name[$w].’)’;
\necho $day2;
\necho yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge);
\nprint “<br>\\n”;
\n$yado=yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge);
\n$sql=’UPDATE yasuiyado SET yadomei=\\”.$yado.’\\’,date=\\”.$day2.’\\’ WHERE id=’.$n1;
\n$prepare = $db->prepare($sql);
\n$prepare->execute();
\nprint “<br>\\n”;
\n}
\n?><\/p>\n

2019\u5e743\u670812\u65e5<\/strong><\/span><\/p>\n

\u4eca\u307e\u3067\u3001\u53c2\u8003\u66f8\u901a\u308a\u3067MySQL\u3092\u64cd\u4f5c\u3057\u3066\u3044\u308b\u6642\u306b\u306f\u30c7\u30fc\u30bf\u306e\u5909\u66f4\u304c\u753b\u9762\u3092\u898b\u306a\u304c\u3089\u7de8\u96c6\u3067\u304d\u305f\u306e\u3067\u3059\u304c\u3001\u81ea\u5206\u3067\u30d7\u30ed\u30b0\u30e9\u30e0\u4f5c\u3063\u3066\u30c7\u30fc\u30bf\u3092\u633f\u5165\u3059\u308b\u3068\u3001\u753b\u9762\u3067\u306e\u7de8\u96c6\u304c\u51fa\u6765\u306a\u304f\u306a\u3063\u3066\u3044\u307e\u3057\u305f\u3002\u7de8\u96c6\u304c\u3067\u304d\u306a\u3044\u3068\u8a00\u3046\u3088\u308a\u5148\u306b\u3001\u7de8\u96c6\u3001\u30b3\u30d4\u30fc\u3001\u524a\u9664\u306e\u30dc\u30bf\u30f3\u81ea\u4f53\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/span>
\n\u3053\u308c\u3067\u306f\u90fd\u5408\u304c\u60aa\u3044\u3068\u3044\u3046\u4e8b\u3067\u8abf\u3079\u305f\u3089\u3001<\/span>
\nCurrent selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.<\/span>
\n\u3068\u3044\u3046\u8868\u793a\u304c\u51fa\u3066\u3044\u307e\u3057\u305f\u3002<\/span>
\n\u65e5\u672c\u8a9e\u306b\u8a33\u3059\u3068\u300c\u73fe\u5728\u306e\u9078\u629e\u306b\u306f\u4e00\u610f\u306e\u5217\u306f\u542b\u307e\u308c\u3066\u3044\u307e\u305b\u3093\u3002\u30b0\u30ea\u30c3\u30c9\u7de8\u96c6\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3001\u7de8\u96c6\u3001\u30b3\u30d4\u30fc\u3001\u524a\u9664\u6a5f\u80fd\u306f\u5229\u7528\u3067\u304d\u307e\u305b\u3093\u300d\u3068\u3044\u3046\u3053\u3068\u306e\u3088\u3046\u3067\u3059\u3002<\/span>
\n\u5bfe\u51e6\u3068\u3057\u3066\u306f\u3001\u300c\u30e6\u30cb\u30fc\u30af\u30ad\u30fc\u306a\u3069\u306e\u30e6\u30cb\u30fc\u30af\u306a\u30ab\u30e9\u30e0\u3092\u4f5c\u6210\u3057\u306a\u3055\u3044\u300d\u3068\u3044\u3046\u3053\u3068\u306e\u3088\u3046\u3067\u3001id\u306e\u30ab\u30e9\u30e0\u3092\u9078\u629e\u3057\u3001\u30e6\u30cb\u30fc\u30af\u30ad\u30fc\u306e\u8a2d\u5b9a\uff08\u4e3b\u306e\u9375\u3092\u30af\u30ea\u30c3\u30af\uff09\u3092\u3057\u305f\u3089\u7de8\u96c6\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u3068\u308a\u3042\u3048\u305a\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066\u8868\u793a\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/span>
\nphp\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002<\/span><\/p>\n

<!DOCTYPE html>
\n<html lang=”ja”>
\n<\/head>
\n<meta charaset=”UTF-8″>
\n<title>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/title>
\n<\/head>
\n<body>
\n<div><\/p>\n

<?php
\ntry {
\n$db = new PDO(‘mysql:dbname=ysuiyado;host=127.0.0.1;charset=utf8’, ‘root’, ”);
\n} catch (PDOException $e) {
\necho ‘DB\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a ‘ . $e->getMessage();
\n}
\n?>
\n<?php
\n$sql=’SELECT * FROM yasuiyado’;
\n$prepare = $db->prepare($sql);
\n$prepare->execute();
\necho ‘<pre>’;
\n$result = $prepare->fetchAll(PDO::FETCH_ASSOC);
\nprint_r($result);
\necho ‘<\/pre>’;
\n?>
\n<\/div>
\n<\/body>
\n<\/html><\/p>\n

\u4e0b\u8a18\u306e\u3088\u3046\u306b\u8868\u793a\u3057\u307e\u3057\u305f\uff08\uff12\u3064\u306e\u30c7\u30fc\u30bf\u306e\u307f\u63b2\u8f09\u3057\u3066\u3044\u307e\u3059\uff09\u3002<\/span>
\n\u3053\u308c\u304b\u3089\u3001\u3053\u306e\u30c7\u30fc\u30bf\u3092\u898b\u6804\u3048\u3088\u304f\u8868\u793a\u3057\u306a\u3051\u308c\u3070\u3044\u3051\u307e\u305b\u3093\u3002<\/span><\/p>\n

Array<\/span>
\n(<\/span>
\n[0] => Array<\/span>
\n(<\/span>
\n[id] => 1<\/span>
\n[no] => 1<\/span>
\n[date] => 2019-03-12(\u706b)<\/span>
\n[yadomei] => \uff33\uff28\uff21\uff31\u3000\uff22\uff29\uff27\uff28\uff2f\uff35\uff33\uff25<\/span>
\n)<\/span><\/p>\n

[1] => Array<\/span>
\n(<\/span>
\n[id] => 2<\/span>
\n[no] => 2<\/span>
\n[date] => 2019-03-13(\u6c34)<\/span>
\n[yadomei] => \uff34\uff28\uff25\u3000\uff33\uff28\uff21\uff32\uff25\u3000\uff28\uff2f\uff34\uff25\uff2c\uff33\u3000\uff28\uff21\uff34\uff23\uff28\uff49\u3000\u91d1\u6ca2<\/span>
\n)<\/span><\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u8868\u306b\u3057\u3066\u51fa\u529b\u3057\u307e\u3057\u305f\u3002\u3053\u308c\u3060\u3051\u3067\u304d\u308c\u3070\u5f8c\u306f\u306a\u3093\u3068\u304b\u306a\u308a\u305d\u3046\u3067\u3059\u3002<\/span><\/p>\n

<!DOCTYPE html>
\n<html lang=”ja”><\/p>\n

<head>
\n<meta charaset=”UTF-8″>
\n<STYLE>
\n<!–
\n.gyou{
\nline-height: 18pt ; padding-left:10pt ; padding-right:10pt;
\n}
\n–>
\n<\/STYLE>
\n<title>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/title>
\n<\/head>
\n<body>
\n<div><\/p>\n

<?php
\ntry {
\n$db = new PDO(‘mysql:dbname=ysuiyado;host=127.0.0.1;charset=utf8’, ‘root’, ”);
\n} catch (PDOException $e) {
\necho ‘DB\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a ‘ . $e->getMessage();
\n}
\n?>
\n<?php
\n$sql=’SELECT * FROM yasuiyado’;
\n$stmt = $db->query( $sql );<\/p>\n

echo “<table bgcolor=\\”#fbe48c\\”>\\n”;
\nwhile( $result = $stmt->fetch( PDO::FETCH_ASSOC ) ){
\necho “\\t<tr>\\n”;
\necho “\\t\\t<td bgcolor=\\”#ffffff\\” class=\\”gyou\\”>{$result[‘date’]}<\/td>\\n”;
\necho “\\t\\t<td bgcolor=\\”#ffffff\\” class=\\”gyou\\”>{$result[‘yadomei’]}<\/td>\\n”;
\necho “\\t<\/tr>\\n”;
\n}
\necho “<\/table>\\n”;<\/p>\n

?>
\n<\/div>
\n<\/body>
\n<\/html><\/p>\n

2019\u5e743\u670814\u65e5<\/strong><\/span><\/p>\n

\u5927\u4eba1\u4eba\u3067\u6cca\u307e\u3063\u305f\u5834\u5408\u306e\u6700\u5b89\u5024\u306e\u5bbf\u6cca\u65bd\u8a2d\u3068\u5927\u4eba\uff12\u4eba\u3067\u6cca\u307e\u3063\u305f\u5834\u5408\u306e\u6700\u5b89\u5024\u306e\u5bbf\u6cca\u65bd\u8a2d\u3092\u5225\u306e\u8868\u3067\u51fa\u529b\u3059\u308b\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

<!DOCTYPE html>
\n<html lang=”ja”>
\n<head>
\n<meta charaset=”UTF-8″>
\n<STYLE>
\n<!–
\n.gyou{
\nline-height: 18pt ; padding-left:10pt ; padding-right:10pt;
\n}
\n–>
\n<\/STYLE>
\n<title>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/title>
\n<\/head>
\n<body>
\n<div>
\n<?php
\ntry {
\n$db = new PDO(‘mysql:dbname=ysuiyado;host=127.0.0.1;charset=utf8’, ‘root’, ”);
\n} catch (PDOException $e) {
\necho ‘DB\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a ‘ . $e->getMessage();
\n}
\n?>
\n<?php
\necho ‘\u5927\u4eba\uff11\u4eba\u3067\u306e\u5bbf\u6cca’;print “<br>\\n”;
\necho “<table bgcolor=\\”#fbe48c\\”>\\n”;
\nfor($n=1;$n<30;$n++){
\n$stmt =$db->query(“SELECT * FROM yasuiyado where id=$n”);
\n$result = $stmt->fetch();
\necho “\\t<tr>\\n”;
\necho “\\t\\t<td bgcolor=\\”#ffffff\\” class=\\”gyou\\”>{$result[‘date’]}<\/td>\\n”; echo “\\t\\t<td bgcolor=\\”#ffffff\\” class=\\”gyou\\”>{$result[‘yadomei’]}<\/td>\\n”;
\necho “\\t<\/tr>\\n”;
\n}
\necho “<\/table>\\n”;
\n?>
\n<?php
\necho ‘\u5927\u4eba\uff12\u4eba\u3067\u306e\u5bbf\u6cca’;print “<br>\\n”;
\necho “<table bgcolor=\\”#fbe48c\\”>\\n”;
\nfor($n=31;$n<60;$n++){
\n$stmt =$db->query(“SELECT * FROM yasuiyado where id=$n”);
\n$result = $stmt->fetch();
\necho “\\t<tr>\\n”;
\necho “\\t\\t<td bgcolor=\\”#ffffff\\” class=\\”gyou\\”>{$result[‘date’]}<\/td>\\n”; echo “\\t\\t<td bgcolor=\\”#ffffff\\” class=\\”gyou\\”>{$result[‘yadomei’]}<\/td>\\n”;
\necho “\\t<\/tr>\\n”;
\n}
\necho “<\/table>\\n”;
\n?>
\n<\/div>
\n<\/body>
\n<\/html><\/p>\n

\u6b21\u306b1\u4eba\u3067\u306e\u5bbf\u6cca\u306b\u3064\u3044\u3066\u3001\u5168\u3066\u306e\u90e8\u5c4b\u306e\u7a2e\u985e\u3067\u306e\u6700\u5b89\u5024\u3068\u30b7\u30f3\u30b0\u30eb\u3067\u306e\u6700\u5b89\u5024\u306e\u65bd\u8a2d\u3092\u691c\u7d22\u3059\u308b\u30dc\u30bf\u30f3\u3068\u3001\uff12\u4eba\u3067\u306e\u5bbf\u6cca\u306b\u3064\u3044\u3066\u3001\u5168\u3066\u306e\u90e8\u5c4b\u306e\u7a2e\u985e\u3068\u30c4\u30a4\u30f3\u306b\u9650\u5b9a\u3057\u3066\u306e\u6700\u5b89\u5024\u306e\u65bd\u8a2d\u3092\u691c\u7d22\u3059\u308b\u30dc\u30bf\u30f3\u3092\u8a2d\u7f6e\u3057\u307e\u3059\u3002<\/span>
\n\u3055\u3059\u304c\u306b60\u65e5\u5206\u306e\u4e00\u89a7\u306f\u9577\u3059\u304e\u308b\u306e\u3067\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306f1\u4eba\u3067\u306e\u5bbf\u6cca\u306b\u3057\u3066\u3001\u30dc\u30bf\u30f3\u30672\u4eba\u3067\u306e\u5bbf\u6cca\u306b\u5207\u308a\u66ff\u3048\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/span>
\n\u305d\u306e\u6b21\u306f\u6700\u5b89\u5024\u306e\u5bbf\u6cca\u65bd\u8a2d\u306e\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3057\u3066\u30da\u30fc\u30b8\u3092\u30ea\u30ed\u30fc\u30c9\u3059\u308b\u30dc\u30bf\u30f3\u3082\u8a2d\u7f6e\u3057\u307e\u3059\u3002\u81ea\u5206\u3067\u3082\u6bce\u671d\u66f4\u65b0\u3057\u307e\u3059\u304c\u3001\u30da\u30fc\u30b8\u3092\u898b\u3066\u3044\u308b\u4eba\u3082\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308c\u3070\u66f4\u65b0\u983b\u5ea6\u3082\u5897\u3059\u3068\u3044\u3046\u4f5c\u6226\u3067\u3059\u3002<\/span>
\n\u3042\u3068\u306f\u30e2\u30d0\u30a4\u30eb\u5bfe\u5fdc\u306b\u6574\u5f62\u3057\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30b5\u30fc\u30d0\u30fc\u4e0a\u306eMySQL\u306b\u5909\u66f4\u3059\u308c\u3070\u5b8c\u6210\u3067\u3059\u3002<\/span><\/p>\n

<?php
\n$rel = $_GET[‘reload’];
\nif ($rel == ‘true’) {
\nheader(“Location: ” . $_SERVER[‘PHP_SELF’]);
\n}
\n?><\/p>\n

2019\u5e743\u670816\u65e5<\/strong><\/span><\/p>\n

1\u4eba\u7528\u306e\u6700\u5b89\u5024\u65bd\u8a2d\u4e00\u89a7\u30682\u4eba\u7528\u6700\u5b89\u5024\u65bd\u8a2d\u4e00\u89a7\u306e\u30da\u30fc\u30b8\u304b\u3089\u66f4\u65b0\u30da\u30fc\u30b8\u306b\u98db\u3093\u3060\u6642\u306b\u3001\u51e6\u7406\u304c\u7d42\u308f\u3063\u305f\u3089\u5143\u306e\u30da\u30fc\u30b8\u306b\u623b\u308b\u51e6\u7406\u304c\u5fc5\u8981\u3067\u3059\u3002<\/span>
\n\u305d\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u304c\u4e0b\u8a18\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

<?php
\nheader(‘HTTP\/1.1 303 See Other’);
\nheader(“location:”.$_SERVER[‘HTTP_REFERER’]);
\nexit();
\n?><\/p>\n

1\u4eba\u3067\u306e\u5bbf\u6cca\u306b\u3064\u3044\u3066\u3001\u5168\u3066\u306e\u90e8\u5c4b\u306e\u7a2e\u985e\u3067\u306e\u6700\u5b89\u5024\u3068\u30b7\u30f3\u30b0\u30eb\u3067\u306e\u6700\u5b89\u5024\u306e\u65bd\u8a2d\u3092\u691c\u7d22\u3059\u308b\u30dc\u30bf\u30f3\u3068\u3001\uff12\u4eba\u3067\u306e\u5bbf\u6cca\u306b\u3064\u3044\u3066\u3001\u5168\u3066\u306e\u90e8\u5c4b\u306e\u7a2e\u985e\u3068\u30c4\u30a4\u30f3\u306b\u9650\u5b9a\u3057\u3066\u306e\u6700\u5b89\u5024\u306e\u65bd\u8a2d\u3092\u691c\u7d22\u3059\u308b\u30dc\u30bf\u30f3\u3092\u8a2d\u7f6e\u3057\u307e\u3057\u305f\u3002<\/span>
\n60\u65e5\u5206\u306e\u4e00\u89a7\u306f\u9577\u3059\u304e\u308b\u306e\u3067\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306f1\u4eba\u3067\u306e\u5bbf\u6cca\u306b\u3057\u3066\u30012\u4eba\u3067\u306e\u5bbf\u6cca\u306b\u5207\u308a\u66ff\u3048\u308b\u4e8b\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002<\/span>
\n\u6700\u5b89\u5024\u306e\u5bbf\u6cca\u65bd\u8a2d\u306e\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3057\u3066\u51e6\u7406\u5f8c\u306b\u5143\u306e\u30da\u30fc\u30b8\u306b\u623b\u308b\u30ea\u30f3\u30af\u3092\u8a2d\u7f6e\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

2019\u5e743\u670817\u65e5<\/strong><\/span><\/p>\n

\u30e2\u30d0\u30a4\u30eb\u5bfe\u5fdc\u3078\u306e\u6574\u5f62\u304c\u3046\u307e\u304f\u3044\u304d\u307e\u3057\u305f\u3002<\/span>
\n\u5f8c\u306f\u3001\u30b5\u30fc\u30d0\u30fc\u306eMySQL\u306b\u63a5\u7d9a\u3057\u3066\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u4e0a\u306b\u516c\u958b\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/span><\/p>\n

\u307e\u305a\u306fXAMPP\u306ephpMyAdmin\u306e\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u307e\u3057\u305f\u3002\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u306e\u30d5\u30a1\u30a4\u30eb\u306fyasuiyado.sql\u3067\u3059\u3002<\/span>
\nyasuiyado.sql\u3092FTP\u3067\u30b5\u30fc\u30d0\u30fc\u306e_db_dump\u30d5\u30a9\u30eb\u30c0\uff08public_html\u3068\u540c\u3058\u968e\u5c64\u306e\u30d5\u30a9\u30eb\u30c0\uff09\u306b\u30b3\u30d4\u30fc\u3002<\/span>
\nCORESERVER.JP\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001\u65b0\u3057\u3044MySQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8ffd\u52a0\u3057\u307e\u3057\u305f\u3002<\/span>
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306fkimassi_yado\u306b\u3057\u307e\u3057\u305f\u3002\u6587\u5b57\u30b3\u30fc\u30c9\u306fUNICODE\u306b\u9078\u629e\u3057\u307e\u3057\u305f\u3002<\/span>
\n\u65b0\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\u306e\u8868\u793a\u304b\u3089\u3001MySQL\u4e00\u89a7\u3067\u65b0\u3057\u304f\u4f5c\u6210\u3057\u305fkimassi_yado\u306e\u30a2\u30af\u30b7\u30e7\u30f3\u306e\u9805\u76ee\u304b\u3089DB\u30ea\u30b9\u30c8\u30a2\u306e\u30de\u30fc\u30af\u3092\u30af\u30ea\u30c3\u30af\uff08\u4e0d\u8981\u306a\u64cd\u4f5c\u304b\u3082\uff09\u3057\u3066\u3001kimassi_yado\u306e\u30a2\u30af\u30b7\u30e7\u30f3\u306e\u9805\u76ee\u306ephpMyAdmin\u306e\u30de\u30fc\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3057\u305f\u3002<\/span>
\nphpMyAdmin\u306e\u753b\u9762\u306b\u5165\u308c\u307e\u3059\u306e\u3067\u3001\u30a4\u30f3\u30dd\u30fc\u30c8\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066yasuiyado.sql\u3092\u9078\u629e\u3057\u5b9f\u884c\u3067\u3059\u3002<\/span>
\n\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3057\u307e\u3057\u305f\u304c\u3001\u7121\u4e8b\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5f15\u8d8a\u304c\u5b8c\u4e86\u3057\u3066\u3044\u307e\u3057\u305f\u3002<\/span>
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u306fkimassi_yado\u3067\u30c6\u30fc\u30d6\u30eb\u540d\u306fyasuiyado\u3067\u3059\u3002<\/span><\/p>\n

php\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30c9\u30ec\u30b9\u95a2\u9023\u3092CORESERVER.JP\u7528\u306b\u66f8\u304d\u63db\u3048\u3066\u30d5\u30a1\u30a4\u30eb\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308c\u3070\u5b8c\u6210\u304b\u306a\uff1f<\/span><\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30ed\u30b0\u30a4\u30f3\u3059\u308bphp\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u4e0b\u8a18\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

<?php
\ntry {
\n$dsn=’mysql:host=localhost;dbname=kimassi_yado’;
\n$db = new PDO($dsn, ‘\u30e6\u30fc\u30b6\u30fc\u540d’, ’12\u6841\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b’);
\n} catch (PDOException $e) {
\necho ‘DB\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a ‘ . $e->getMessage();
\n}
\n?><\/p>\n

\u30e6\u30fc\u30b6\u30fc\u540d\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3068\u540c\u3058\u3067kimassi_yado\u306b\u306a\u308a\u307e\u3059\u3002\u672c\u6765\u306e\u30e6\u30fc\u30b6\u30fc\u540dkimassi\u3067\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9kimassi_yado\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u305b\u3093\u3002<\/span>
\nhost=localhost;\u306fhost=127.0.0.1;\u3000\u3067\u3082\u52d5\u4f5c\u3057\u307e\u3059\u3002<\/span><\/p>\n

\u3068\u3053\u308d\u304c\u5b9f\u969b\u306b\u306fPHP\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u304b\u3089\u3001\u306a\u304b\u306a\u304b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/span>
\nCORESERVER.JP\u306b\u65b0\u305f\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092MySQL\u3092\u8ffd\u52a0\u3057\u305f\u6642\u306b\u3001PhpMyAdmin\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u305f\u6642\u306b\u65b0\u305f\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53cd\u6620\u3055\u305b\u308b\u306b\u306f\u9806\u5e8f\u304c\u5927\u5207\u306a\u3088\u3046\u3067\u3059\u3002<\/span>
\nCORESERVER.JP\u306b\u65b0\u305f\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092MySQL\u3092\u8ffd\u52a0\u3057\u305f\u6642\u306b\u3001PhpMyAdmin\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30ea\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002<\/span>
\n\u6b21\u306bPhpMyAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u96a3\u63a5\u3059\u308b\u30ed\u30b0\u30a4\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<\/span>
\n\u305d\u3053\u3067\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u6c42\u3081\u3089\u308c\u307e\u3059\u3002<\/span>
\n\u3053\u3053\u3067\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u306b\u65b0\u305f\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\uff08\u81ea\u5206\u306e\u5834\u5408\u306fkimassi_yado)\u3092\u5165\u529b\u3057\u3066\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u306bCORESERVER.JP\u306e12\u6841\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/span>
\n\u3053\u308c\u3067\u3084\u3063\u3068\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff08\u81ea\u5206\u306e\u5834\u5408\u306fkimassi_yado)\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/span><\/p>\n

CORESERVER.JP\uff08\u30d0\u30ea\u30e5\u30fc\u30b5\u30fc\u30d0\u30fc\uff09\u3067\u306f\u6a19\u6e96\u306ePHP\u304c\u300cPHP5.6\uff08\u30e2\u30b8\u30e5\u30fc\u30eb\u7248\uff09\u300d\u306b\u306a\u3063\u3066\u3044\u3066PHP\u304c7.2\u3060\u3068\u52d5\u4f5c\u306b\u5236\u9650\u304c\u3042\u308b\u3088\u3046\u3067\u3059\u3002<\/span>
\n\u3067\u3082PHP\u304c7.2\u3067\u3082MySQL\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u3067\u3082\u3001\u306a\u305c\u304b\u66f4\u65b0\u30da\u30fc\u30b8\u3067\u51e6\u7406\u304c\u9014\u4e2d\u3067\u6b62\u307e\u3063\u3066\u3057\u307e\u3046\u3088\u3046\u3067\u3059\u3002\u30a8\u30e9\u30fc\u306f\u51fa\u3066\u306a\u3044\u306e\u3067\u3059\u304c\u3001\u3059\u3093\u306a\u308a\u3068\u306f\u3044\u304d\u307e\u305b\u3093\u3002<\/span><\/p>\n

2019\u5e743\u670818\u65e5<\/strong><\/span><\/p>\n

\u66f4\u65b0\u30da\u30fc\u30b8\u3067\u51e6\u7406\u304c\u9014\u4e2d\u3067\u6b62\u307e\u308b\u7406\u7531\u3092\u8abf\u3079\u3088\u3046\u3068\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5358\u7d14\u5316\u3057\u3066\u307f\u305f\u306e\u3067\u3059\u304c\u3001MySQL\u306b\u306f\u95a2\u4fc2\u306a\u304f\u3001CORESERVER.JP\uff08\u30d0\u30ea\u30e5\u30fc\u30b5\u30fc\u30d0\u30fc\uff09\u3067\u306f\u51e6\u7406\u306b\u6642\u9593\u304c\u304b\u304b\u308b\u3068\u8ca0\u8377\u306e\u5927\u304d\u3055\u306b\u95a2\u308f\u308a\u306a\u304f\u3001\u52d5\u4f5c\u3092\u30b9\u30c8\u30c3\u30d7\u3059\u308b\u4ed5\u69d8\u306b\u306a\u3063\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002<\/span>
\n\u3084\u3063\u3071\u308a\u3001XAMPP\u4e0a\u3067\u697d\u5929\u95a2\u9023\u306e\u51e6\u7406\u3092\u6e08\u307e\u305b\u3066\u3001\u305d\u306e\u5f8c\u3001\u30aa\u30f3\u30e9\u30a4\u30f3\u4e0a\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u66f4\u65b0\u3092\u3059\u308b\u3057\u304b\u306a\u3044\u3088\u3046\u3067\u3059\u3002<\/span>
\n\u73fe\u5728\u306f\u3001CORESERVER.JP\uff08\u30d0\u30ea\u30e5\u30fc\u30b5\u30fc\u30d0\u30fc\uff09\u4e0a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\uff08\u81ea\u5206\u306e\u5834\u5408\u306fkimassi_yado)\u3092\u524a\u9664\u3057\u3066\u3001XAMPP\u4e0a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff08\u81ea\u5206\u306e\u5834\u5408\u306fkimassi_yado)\u3092sql\u5f62\u5f0f\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u3001CORESERVER.JP\uff08\u30d0\u30ea\u30e5\u30fc\u30b5\u30fc\u30d0\u30fc\uff09\u4e0a\u3067sql\u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u3082\u3063\u3068\u7c21\u5358\u306a\u65b9\u6cd5\u304c\u7121\u3044\u304b\u8abf\u3079\u3066\u307f\u3088\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/span>
\n\u5ff5\u306e\u305f\u3081\u306b\u3001Value-domain\u306e\u30e6\u30fc\u30b6\u30fc\u30d5\u30a9\u30fc\u30e9\u30e0\uff1aCGI\/PHP\/DB\u95a2\u9023\u3067\u554f\u3044\u5408\u308f\u305b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

2019\u5e743\u670819\u65e5<\/strong><\/span><\/p>\n

\u3069\u3046\u3057\u3066\u3082\u5224\u3089\u306a\u304f\u3066\u56f0\u3063\u305f\u6642\u306e\u6700\u5f8c\u306e\u983c\u307f\u306fYahoo\uff01\u77e5\u6075\u888b\u3067\u3059\u3002<\/span>
\n\u4eca\u56de\u3082\u7d20\u6575\u306a\u30a2\u30c9\u30d0\u30a4\u30b9\u3092\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u306a\u3093\u3067\u3082cron \u6a5f\u80fd\u3063\u3066\u3044\u3046\u306e\u304c\u3042\u3063\u3066\u30013\u4ef6\u307e\u3067\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3059\u308b\u3088\u3046\u306a\u306e\u3067\u300120\u56de\u306e\u306b\u51e6\u7406\u3092\u5206\u5272\u3057\u3066\u6570\u5206\u304a\u304d\u306b\u5b9f\u884c\u3059\u308b\u3068\u3044\u3046\u65b9\u6cd5\u304c\u3042\u308b\u3088\u3046\u3067\u3059\u3002<\/span>
\n\u3067\u3082\u3001CORESERVER.JP\uff08\u30d0\u30ea\u30e5\u30fc\u30b5\u30fc\u30d0\u30fc\uff09\u4e0a\u306e\u4ed5\u69d8\u3067\u300ccron\u30b8\u30e7\u30d6\u306e\u6700\u77ed\u9593\u9694\u306f\uff11\u6642\u9593\u306b\uff11\u56de\u307e\u3067\u300d\u3068\u63b2\u8f09\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u3002\u3053\u308c\u3067\u306f\u4f7f\u3048\u307e\u305b\u3093\u3002<\/span>
\n\u5ff5\u306e\u305f\u3081\u306b\u3001Value-domain\u306e\u30e6\u30fc\u30b6\u30fc\u30d5\u30a9\u30fc\u30e9\u30e0\uff1aCGI\/PHP\/DB\u95a2\u9023\u3067\u554f\u3044\u5408\u308f\u305b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

2019\u5e743\u670821\u65e5<\/strong><\/span><\/p>\n

\u300c\u30ed\u30fc\u30ab\u30eb\u306exampp\u5074\u306ephp\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u8fbc\u3080\u51e6\u7406\u3092\u3057\u305f\u5f8c\u306b\u3001\u305d\u306ephp\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u5fc5\u8981\u306aSQL\u6587\uff08truncate tabele\u3057\u3066alter table\u3067auto_increment\u306e\u30ea\u30bb\u30c3\u30c8\u3082\u3057\u304f\u306fdrop table\u3057\u3066create table\u3068\u30c7\u30fc\u30bf\u3092insert\u3059\u308bSQL\u6587\uff09\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u3001coreserver\u4e0a\u306ePHP\u30d5\u30a1\u30a4\u30eb\u3067coreserver\u4e0a\u306eMySQL\u306b\u304a\u3044\u3066SQL\u30d5\u30a1\u30a4\u30eb\u3060\u3051\u5b9f\u884c\u3059\u308b\u3002\u300d<\/span>
\n\u3068\u3044\u3046\u30a2\u30a4\u30c7\u30a2\u3082\u30a2\u30c9\u30d0\u30a4\u30b9\u3057\u3066\u3044\u305f\u3060\u3051\u307e\u3057\u305f\u3002<\/span>
\n\u3067\u3082\u3001php\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u5fc5\u8981\u306aSQL\u6587\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3068\u3044\u3046\u306e\u304c\u3046\u307e\u304f\u3044\u304b\u306a\u304f\u3066\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fSQL\u6587\u3092coreserver\u4e0a\u306eMySQL\u306b\u304a\u3044\u3066\u5b9f\u884c\u3057\u305f\u3089\u52d5\u4f5c\u304c\u9577\u6642\u9593\u7d9a\u3044\u3066\u30c7\u30fc\u30bf\u306f\u524a\u9664\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002<\/span><\/p>\n

2019\u5e743\u670822\u65e5
\n<\/strong><\/span>
\nValue-domain\u306e\u30e6\u30fc\u30b6\u30fc\u30d5\u30a9\u30fc\u30e9\u30e0\uff1aCGI\/PHP\/DB\u95a2\u9023\u3067\u3082STAFF\u304b\u3089\u306e\u8fd4\u7b54\u304c\u3042\u308a\u307e\u3057\u305f\u3002<\/span>
\n\u300c\u51e6\u7406\u6642\u9593\u304c\u9577\u3044PHP\u30d7\u30ed\u30bb\u30b9\u304c\u5f37\u5236\u7d42\u4e86\u3044\u305f\u3057\u307e\u3059\u306e\u306f\u4ed5\u69d8\u3067\u3054\u3056\u3044\u307e\u3059\u3002API\u53d6\u5f97\u5148\u306e\u51e6\u7406\u6642\u9593\u304c\u9577\u304f\u306a\u308b\u5834\u5408\u306f\u3001\u904b\u7528\u304c\u82e6\u3057\u3044\u304b\u3068\u5b58\u3058\u307e\u3059\u3002\u300d\u3068\u3044\u3046\u8fd4\u7b54\u3067\u3057\u305f\u3002<\/span><\/p>\n

2019\u5e743\u670823\u65e5<\/strong><\/span><\/p>\n

\u300c\u4f5c\u696d\u7528\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u3044\u3001load data infile \u3067\u53d6\u308a\u8fbc\u3093\u3067\u672c\u756a\u30c6\u30fc\u30d6\u30eb\u3068id\u304bno\u3067JOIN\u3057\u3066update\u3059\u308b\u300d\u3068\u3044\u3046\u30a2\u30c9\u30d0\u30a4\u30b9\u3082\u3044\u305f\u3060\u3044\u3066\u3044\u307e\u3057\u305f\u3002<\/span>
\n\u5177\u4f53\u7684\u306b\u306f\u3001xampp\u4e0a\u306ePHP\u30d5\u30a1\u30a4\u30eb\u3067\u51e6\u7406\u3092\u3057\u3066\u3001\u30c7\u30fc\u30bf\u306fxampp\u4e0a\u306eMySQL\u306b\u767b\u9332\u3057\u306a\u304f\u5225\u306e\u30d5\u30a1\u30a4\u30eb\u5f62\u5f0f\u3067\u4fdd\u5b58\u3057\u3066<\/span>
\ncoreserver\u4e0a\u306ePHP\u30d5\u30a1\u30a4\u30eb\u3067\u3001\u30c7\u30fc\u30bf\u3092\u4f5c\u696d\u7528\u30c6\u30fc\u30d6\u30eb\u306bload data infile \u3067\u53d6\u308a\u8fbc\u3093\u3067\u3001<\/span>
\nupdate \u672c\u756a\u30c6\u30fc\u30d6\u30eb join \u4f5c\u696d\u7528\u30c6\u30fc\u30d6\u30eb<\/span>
\non \u672c\u756a\u30c6\u30fc\u30d6\u30eb.id = \u4f5c\u696d\u7528\u30c6\u30fc\u30d6\u30eb.id<\/span>
\nset \u672c\u756a\u30c6\u30fc\u30d6\u30eb.no = \u4f5c\u696d\u7528\u30c6\u30fc\u30d6\u30eb.no,<\/span>
\n\u672c\u756a\u30c6\u30fc\u30d6\u30eb.`date` = \u4f5c\u696d\u7528\u30c6\u30fc\u30d6\u30eb.`date`<\/span>
\n\u672c\u756a\u30c6\u30fc\u30d6\u30eb.yadomei = \u4f5c\u696d\u7528\u30c6\u30fc\u30d6\u30eb.yadomei<\/span>
\n\u3067coreserver\u4e0a\u306eMySQL\u306b\u767b\u9332\u3068\u3044\u3046\u51e6\u7406\u306e\u6d41\u308c\u306e\u3088\u3046\u3067\u3059\u3002<\/span><\/p>\n

\u3068\u308a\u3042\u3048\u305a\u306f\u3001xampp\u4e0a\u306ePHP\u30d5\u30a1\u30a4\u30eb\u3067\u51e6\u7406\u3092\u3057\u3066\u30c7\u30fc\u30bf\u3092csv\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u30d1\u30bd\u30b3\u30f3\u306b\u51fa\u529b\u3059\u308b\u4e8b\u304b\u3089\u59cb\u3081\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u4e0b\u8a18\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u958b\u304f\u547d\u4ee4\u3092\u524a\u9664\u3057\u307e\u3059\u3002<\/span><\/p>\n

<?php
\ntry {
\n$db = new PDO(‘mysql:dbname=ysuiyado;host=127.0.0.1;charset=utf8’, ‘root’, ”);
\n} catch (PDOException $e) {
\necho ‘DB\u63a5\u7d9a\u30a8\u30e9\u30fc\uff1a ‘ . $e->getMessage();
\n}
\n?><\/p>\n

\u305d\u306e\u4f4d\u7f6e\u3092\u4e0b\u8a18\u306ecsv\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u547d\u4ee4\u306b\u5165\u308c\u66ff\u3048\u307e\u3059<\/span><\/p>\n

<?php
\n# \u4fdd\u5b58\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002
\n$csvFile = ‘..\/..\/..\/data\/output\/csv-put.csv’;
\nif (! is_dir(dirname($csvFile))) {
\ndie(‘\u4fdd\u5b58\u3059\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304c\u5b58\u5728\u3057\u307e\u305b\u3093\u3002’);
\n}<\/p>\n

# \u30d5\u30a1\u30a4\u30eb\u3092\u8ffd\u8a18\u30e2\u30fc\u30c9\u3067\u958b\u304d\u307e\u3059\uff08\u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u306f\u65b0\u898f\u4f5c\u6210\uff09\u3002
\n$fp = fopen($csvFile, ‘c+’);
\nif (! is_resource($fp)) {
\ndie(‘\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3051\u307e\u305b\u3093\u3067\u3057\u305f\u3002’);
\n}<\/p>\n

# \u30d5\u30a1\u30a4\u30eb\u3092\u30ed\u30c3\u30af\u3057\u307e\u3059\uff08\u6392\u4ed6\u7684\u30ed\u30c3\u30af\uff09\u3002
\nflock($fp, LOCK_EX);<\/p>\n

# \u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u3092\u7a7a\u306b\u3057\u307e\u3059\u3002
\nftruncate($fp, 0); \/\/ \u8ffd\u8a18\u3059\u308b\u5834\u5408\u306f\u3053\u306e\u51e6\u7406\u306f\u4e0d\u8981
\n?><\/p>\n

\u4e0b\u8a18\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u7b87\u6240\u3092\u524a\u9664\u3057\u3066<\/span><\/p>\n

$sql=’UPDATE yasuiyado SET yadomei=\\”.$yado.’\\’,date=\\”.$day2.’\\’ WHERE id=’.$n1;
\n$prepare = $db->prepare($sql);
\n$prepare->execute();<\/p>\n

\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u914d\u5217\u306b\u3057\u3066CSV\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u51fa\u529b\u3059\u308b\u547d\u4ee4\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/span><\/p>\n

$data=[];
\n$data[‘id’] =$n1;
\n$data[‘no’] =$n1;
\n$data[‘date’] =$day2;
\n$data[‘yadomei’] =$yado;
\necho var_dump($data);
\nfputcsv($fp, $data);
\n}<\/p>\n

\u6700\u5f8c\u306b\u30d5\u30a1\u30a4\u30eb\u3092\u9589\u3058\u307e\u3059\u3002<\/span><\/p>\n

<?php
\n# \u30d5\u30a1\u30a4\u30eb\u306e\u30ed\u30c3\u30af\u3092\u89e3\u9664\u3057\u307e\u3059\u3002
\nfflush($fp);
\nflock($fp, LOCK_UN);<\/p>\n

# \u30d5\u30a1\u30a4\u30eb\u3092\u9589\u3058\u307e\u3059\u3002
\nfclose($fp);<\/p>\n

# \u4fdd\u5b58\u3057\u305fCSV\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u307f\u3001\u753b\u9762\u306b\u8868\u793a\u3057\u307e\u3059\u3002
\nif (file_exists($csvFile)) {
\necho ‘CSV\u30d5\u30a1\u30a4\u30eb\u306f\u4fdd\u5b58\u3055\u308c\u307e\u3057\u305f\u3002<br>’;
\necho ‘\u4ee5\u4e0b\u306f\u51fa\u529b\u3055\u308c\u305fCSV\u30d5\u30a1\u30a4\u30eb\uff08’ . $csvFile . ‘\uff09\u3067\u3059\u3002<br>’;
\n$csv = file_get_contents($csvFile);
\n} else {
\necho ‘CSV\u30d5\u30a1\u30a4\u30eb\u306f\u4fdd\u5b58\u3055\u308c\u307e\u305b\u3093\u3067\u3057\u305f\u3002’;
\n}<\/p>\n

?><\/p>\n

\u5f8c\u306f\u3001csv\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u4e0a\u306b\u53cd\u6620\u3059\u308c\u3070\u5b8c\u6210\u3067\u3059\u3002<\/span><\/p>\n

\u3067\u3082\u30d1\u30bd\u30b3\u30f3\u4e0a\u306ecsv\u30d5\u30a1\u30a4\u30eb\u306e\u30c7\u30fc\u30bf\u3092PHP\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3067coreserver\u4e0a\u306eMySQL\u306b\u767b\u9332\u3059\u308b\u306e\u306f\u96e3\u3057\u3044\u3088\u3046\u3067\u3059\u3002<\/span>
\nLOAD DATA local INFILE\u3092\u4f7f\u3048\u3070\u306a\u3093\u3068\u304b\u306a\u308b\u3068\u8003\u3048\u307e\u3057\u305f\u304c\u3001\u3046\u307e\u304f\u3044\u304d\u307e\u305b\u3093\u3002<\/span><\/p>\n

2019\u5e743\u670824\u65e5
\n<\/strong><\/span>
\n\u3053\u3053\u3067\u3001\u73fe\u5728\u306e\u51e6\u7406\u3092\u6574\u7406\u3057\u3066\u307f\u307e\u3059\u3002<\/span>
\n1.\u30ed\u30fc\u30ab\u30eb\u306exampp\u4e0a\u306eMySQL\u3092\u30b9\u30bf\u30fc\u30c8\uff08Apache\u306f\u81ea\u52d5\u7684\u306b\u30b9\u30bf\u30fc\u30c8\u3055\u308c\u308b\uff09<\/span>
\n2.\u30ed\u30fc\u30ab\u30eb\u306exampp\u4e0a\u3067\u697d\u5929API\u306e\u30c7\u30fc\u30bf\u3092xampp\u4e0a\u306eMySQL\u306b\u767b\u9332<\/span>
\nhttp:\/\/localhost\/rakuten\/rakutenyado15.php<\/span>
\n3.\u30ed\u30fc\u30ab\u30eb\u306exampp\u4e0a\u306eMySQL\u4e0a\u3067\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9kimassi_yado\u3092\u9078\u629e\u3057\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\uff08\u8a73\u7d30-\u53ef\u80fd\u306a\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u3059\u3079\u3066\u8868\u793a\u3067DROP TABLE\u3092\u30b3\u30de\u30f3\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u304b\u3089\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\uff09\u3002sql\u30d5\u30a1\u30a4\u30eb\u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30d5\u30a9\u30eb\u30c0\u306b\u51fa\u6765\u3066\u3044\u308b\u3002<\/span>
\n4.coreserver\u4e0a\u306eMySQL\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9kimassi_yado\u3092\u9078\u629e\u3057\u5148\u307b\u3069\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305fsql\u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3002<\/span><\/p>\n

\u304b\u306a\u308a\u9762\u5012\u304f\u3055\u3044\u3067\u3059\u3002<\/span>
\n\u51e6\u7406\u306e\u554f\u984c\u3067\u3001\u30ed\u30fc\u30ab\u30eb\u306exampp\u4e0a\u3067\u697d\u5929API\u306e\u30c7\u30fc\u30bf\u3092\u5f97\u308b\u306e\u306f\u52d5\u304b\u305b\u306a\u3044\u3051\u3069\u3001\u305d\u306e\u4ed6\u306e\u51e6\u7406\u3067\u7701\u529b\u5316\u3092\u56f3\u308b\u306e\u304c\u8ab2\u984c\u3067\u3059\u3002<\/span><\/p>\n

\u305d\u308c\u3067\u30ed\u30fc\u30ab\u30eb\u306exampp\u4e0a\u306eMySQL\u3092\u4f7f\u308f\u306a\u3044\u65b9\u6cd5\u3092\u8003\u3048\u307e\u3057\u305f\u3002<\/span><\/p>\n

1.\u30ed\u30fc\u30ab\u30eb\u306exampp\u4e0a\u3067\u697d\u5929API\u306e\u30c7\u30fc\u30bf\u3092csv\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u30cf\u30fc\u30c9\u30c7\u30a3\u30b9\u30af\u306b\u4fdd\u5b58<\/span>
\nhttp:\/\/localhost\/rakuten\/rakutencsv.php<\/span>
\n2.coreserver\u4e0a\u306eMySQL\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\u30c6\u30fc\u30d6\u30ebyasuiyado\u3092\u9078\u629e\u3057\u5148\u307b\u3069\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305fcsv\u30d5\u30a1\u30a4\u30eb\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3002<\/span>
\n\uff08\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u7279\u6709\u306e\u30aa\u30d7\u30b7\u30e7\u30f3Update data when duplicate keys found on import (add ON DUPLICATE KEY UPDATE)\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\uff09<\/span><\/p>\n

\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u304c\u3001\u3046\u307e\u304f\u3044\u304d\u307e\u3057\u305f\u3002<\/span>
\n\u6700\u5f8c\u306b\u5bbf\u306e\u540d\u524d\u306e\u9577\u3055\u306e\u4e0a\u9650\u3092\u8a2d\u5b9a\u3057\u3066\u53d6\u5f97\u3059\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/span><\/p>\n

$data[‘yadomei’] =$yado;<\/p>\n

\u306e\u90e8\u5206\u3092<\/span><\/p>\n

$data[‘yadomei’] =mb_substr($yado,0,34);<\/p>\n

\u306b\u5909\u66f4\u3057\u3066\u5b8c\u6210\u3067\u3059\u3002<\/span><\/p>\n

2019\u5e743\u670826\u65e5<\/strong><\/span><\/p>\n

\u4eca\u65e5\u304b\u3089PHP\u306e\u5bbf\u6cca\u60c5\u5831\u306e\u8868\u793a\u3092\u59cb\u3081\u305f\u306e\u3067\u3059\u304c\u3001\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u7a7a\u5ba4\u691c\u7d22API\u306e\u30c7\u30fc\u30bf\u3092\u53d7\u3051\u53d6\u308b\u969b\u306b\u30a8\u30e9\u30fc\u304c\u983b\u767a\u3057\u3066\u3001\u6700\u5f8c\u307e\u3067\u51e6\u7406\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/span><\/p>\n

Notice<\/b>: Trying to get property ‘hotelBasicInfo’ of non-object in\u00a0C:\\xampp\\htdocs\\rakuten\\rakutencsv.php<\/b>\u00a0on line\u00a055<\/b><\/span><\/p>\n

Notice<\/b>: Trying to get property ‘hotelName’ of non-object in\u00a0C:\\xampp\\htdocs\\rakuten\\rakutencsv.php<\/b>\u00a0on line\u00a055<\/b><\/span><\/p>\n

\u671d\u306f\u3001\u697d\u5929\u5074\u306e\u51e6\u7406\u6570\u304c\u591a\u304f\u3066\u3001\u30b5\u30fc\u30d0\u30fc\u306e\u51e6\u7406\u80fd\u529b\u304c\u843d\u3061\u3066\u3044\u308b\u306e\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/span>
\n\u3053\u308c\u3067\u306f\u4f7f\u3044\u7269\u306b\u306a\u3089\u306a\u3044\u306e\u3067\u3001\u9014\u4e2d\u3067\u5f85\u3061\u6642\u9593\u3092\u8a2d\u3051\u308b\u304b\u51e6\u7406\u901f\u5ea6\u3092\u9045\u304f\u3059\u308b\u304b\u306e\u5bfe\u5fdc\u304c\u5fc5\u8981\u3060\u3068\u611f\u3058\u307e\u3057\u305f<\/span>\u3002<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\u306e\u5f8c\u306b<\/span><\/p>\n

usleep(500000);<\/p>\n

\u3092\u633f\u5165\u3057\u307e\u3057\u305f\u3002\uff11\u3064\u306e\u30c7\u30fc\u30bf\u6bce\u306b0.5\u79d2\u5f85\u3064\u547d\u4ee4\u3067\u3059\u3002<\/span>
\n\u305d\u3057\u305f\u3089\u9014\u4e2d\u307e\u3067\u8abf\u5b50\u3088\u304f\u52d5\u4f5c\u3057\u305f\u306e\u3067\u3059\u304c\u3001<\/span><\/p>\n

Fatal error: Maximum execution time of 30 seconds exceeded<\/span><\/p>\n

\u306e\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/span>
\n\uff30\uff28\uff30\u306f\u51e6\u7406\u6642\u9593\u306e\u5236\u9650\u304c30\u79d2\u306b\u306a\u3063\u3066\u3044\u308b\u3088\u3046\u3067\u300130\u79d2\u904e\u304e\u305f\u6642\u306b\u51fa\u308b\u30a8\u30e9\u30fc\u306e\u3088\u3046\u3067\u3059\u3002<\/span><\/p>\n

set_time_limit(100);<\/p>\n

\u3092PHP\u306e\u51e6\u7406\u306e\u5148\u982d\u306b\u633f\u5165\u3057\u307e\u3057\u305f\u3002100\u79d2\u307e\u3067\u51e6\u7406\u3092\u7d9a\u3051\u308b\u3068\u3044\u3046\u547d\u4ee4\u3067\u3059\u3002<\/span><\/p>\n

\u3053\u308c\u3067\u3046\u307e\u304f\u3044\u304d\u307e\u3057\u305f\u3002\u5f8c\u306f\u3001\u6b63\u5e38\u306b\u52d5\u4f5c\u3059\u308b\u5f85\u6a5f\u306e\u6700\u77ed\u6642\u9593\u3092\u63a2\u305b\u3070\u5b8c\u6210\u304b\u306a\uff1f<\/span><\/p>\n

\uff11\u3064\u306e\u30c7\u30fc\u30bf\u6bce\u306b0.5\u79d2\u5f85\u6a5f\u3060\u3068\u6642\u3005\u5931\u6557\u3059\u308b\u3088\u3046\u306a\u306e\u30670.8\u79d2\u306b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

usleep(80000);<\/p>\n

\u51e6\u7406\u306e\u5236\u9650\u6642\u9593\u306f\u6700\u7d42\u7684\u306b80\u79d2\u306b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

4\u53f0\u306e\u30d1\u30bd\u30b3\u30f3\u306bXAMPP\u3068PHP\u306e\u74b0\u5883\u3092\u6574\u3048\u305f\u306e\u3067\u3059\u304c\u3001\u4f7f\u308f\u306a\u304f\u653e\u7f6e\u3057\u3066\u304a\u3044\u305fWindows7\u306eAOA150\uff08\u6db2\u6676\u30b5\u30a4\u30ba\uff1a8.9\u30a4\u30f3\u30c1 CPU\uff1aAtom N270\/1.6GHz\/1\u30b3\u30a2 \u30e1\u30e2\u30ea\u5bb9\u91cf\uff1a1GB\uff09\u3092\u3001\u3053\u306e\u51e6\u7406\u306e\u30e1\u30a4\u30f3\u306b\u4f7f\u304a\u3046\u3068\u601d\u3044\u307e\u3059\u3002
\n\u5bdd\u5ba4\u3067\u8d77\u304d\u305f\u6642\u306b\u64cd\u4f5c\u3057\u3088\u3046\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

2019\u5e743\u670827\u65e5<\/strong><\/span><\/p>\n

\u4f55\u6545\u304b\u671d\u65e9\u3044\u3068\u6628\u65e5\u304b\u3089\u306e\u30c7\u30fc\u30bf\u3092\u6c42\u3081\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/span><\/p>\n

<?php
\nfor($n=0;$n<30;$n++)
\n{
\n$n2=’+’.$n.’ day’;
\n$checkinDate = date(“Y-m-d”,strtotime(“$n2”));
\necho var_dump($checkinDate);<\/p>\n

}
\n?><\/p>\n

\u3067\u78ba\u8a8d\u3057\u305f\u3089\u3001\u6628\u65e5\u304b\u3089\u306e\u65e5\u4ed8\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002\u304a\u304b\u3057\u3044\u306a\u3042\u3002<\/span><\/p>\n

\u539f\u56e0\u306f\uff30\uff28\uff30\u306e\u8a2d\u5b9a\u3067\u3001php.ini\u306e2000\u884c\u3042\u305f\u308a\u3067<\/span>
\n[Date]
\ndate.timezone=Europe\/Berlin
\n\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3092<\/span>
\n[Date]
\ndate.timezone= Asia\/Tokyo
\n\u306b\u5909\u66f4\u3059\u308c\u3070\u826f\u3044\u307f\u305f\u3044\u3067\u3059\u3002\uff19\u6642\u9593\u7a0b\u5ea6\u306e\u305a\u308c\u304c\u3042\u3063\u305f\u307f\u305f\u3044\u3067\u3059\u3002<\/span><\/p>\n

2019\u5e743\u670830\u65e5<\/strong><\/span><\/p>\n

\u30d6\u30e9\u30a6\u30b6\u306e\u30a2\u30c9\u30ec\u30b9\u306bphp\u306e\u62e1\u5f35\u5b50\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u306f\u3044\u304b\u304c\u308f\u3057\u3044\u306e\u3067\u3001php\u306e\u62e1\u5f35\u5b50\u3092\u6d88\u3059\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002
\n.htaccess\u30d5\u30a1\u30a4\u30eb\u306b<\/span><\/p>\n

<IfModule mod_rewrite.c>
\nRewriteEngine On
\nRewriteCond %{REQUEST_FILENAME} !-d
\nRewriteRule ^([^\\.]+)$ $1.php [NC,L]
\n<\/IfModule><\/p>\n

\u3092\u8ffd\u52a0\u3057\u3066\u6d88\u305b\u307e\u3057\u305f\u3002
\n\u62e1\u5f35\u5b50\u306a\u3057\u306e\u30a2\u30c9\u30ec\u30b9\uff08https:\/\/kimassi.net\/yadoitiran\uff09\u3067\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001\u30d6\u30e9\u30a6\u30b6\u306e\u30d0\u30fc\u3067\u306f\u62e1\u5f35\u5b50\u306a\u3057\u306e\u30a2\u30c9\u30ec\u30b9\uff08https:\/\/kimassi.net\/yadoitiran\uff09\u3067\u8868\u793a\u3055\u308c\u308b\u3057\u3001\u62e1\u5f35\u5b50\u4ed8\u306e\u30a2\u30c9\u30ec\u30b9\uff08https:\/\/kimassi.net\/yadoitiran.php\uff09\u3067\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u3001\u30d6\u30e9\u30a6\u30b6\u306e\u30d0\u30fc\u3067\u306f\u62e1\u5f35\u5b50\u4ed8<\/span>\u306e\u30a2\u30c9\u30ec\u30b9\uff08https:\/\/kimassi.net\/yadoitiran.php\uff09\u3067\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/span><\/p>\n

\u7701\u529b\u5316\u306e\u305f\u3081\u306b\u3001\u30b9\u30bf\u30fc\u30c8\u30a2\u30c3\u30d7\u306bXAMPP ControlPanel(Apache\u306f\u81ea\u52d5\u8d77\u52d5\u306b\u8a2d\u5b9a\u6e08\uff09\u3068\u901a\u5e38\u4f7f\u308f\u306a\u3044\u30d6\u30e9\u30a6\u30b6\uff08\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u306blocalhost\/rakuten\/rakutencsv.php\u3000\u3092\u8a2d\u5b9a\u6e08\u307f\uff09\u3092\u767b\u9332\u3057\u307e\u3057\u305f\u3002<\/span>
\n\u3067\u3082\u30d6\u30e9\u30a6\u30b6\u306f\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30bd\u30d5\u30c8\u304c\u7acb\u3061\u4e0a\u304c\u3089\u306a\u3044\u3068\u8d77\u52d5\u3067\u304d\u306a\u3044\u306e\u3067\u5931\u6557\u3057\u307e\u3057\u305f\u3002
\nbat\u30d5\u30a1\u30a4\u30eb\u306e\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3092\u30b9\u30c6\u30fc\u30c8\u30a2\u30c3\u30d7\u306b\u767b\u9332\u3059\u308b\u3053\u3068\u3067\u30b9\u30bf\u30fc\u30c8\u30a2\u30c3\u30d7\u3067\u8d77\u52d5\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u8d77\u52d5\u3059\u308b\u6642\u9593\u3092\u8abf\u6574\u3067\u304d\u308b\u4e8b\u304c\u308f\u304b\u3063\u305f\u306e\u3067\u8a66\u3057\u3066\u307f\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

@echo off
\n:\u9045\u5ef6\u8d77\u52d5\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb<\/p>\n

echo \u9045\u5ef6\u8d77\u52d5\u3092\u958b\u59cb\u3057\u307e\u3059\u3002
\n:20\u79d2\u5f85\u3064
\ntimeout 20
\n:\u30d7\u30ed\u30b0\u30e9\u30e0\u5b9f\u884c(\u30ab\u30ec\u30f3\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u6307\u5b9a\u306a\u3057)
\nstart “”\u00a0“C:\\Program Files\\Mozilla Firefox\\firefox.exe”<\/p>\n

\u3046\u307e\u304f\u52d5\u4f5c\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

2019\u5e746\u67085\u65e5<\/strong><\/span><\/p>\n

\u6025\u306b\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u304c\u9014\u4e2d\u3067\u6b62\u307e\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/span>
\nset_time_limit(120);
\nusleep(100000);
\n\u30682\u7b87\u6240\u306e\u6570\u5024\u3092\u5909\u66f4\u3057\u3066\u5bfe\u51e6\u3057\u307e\u3057\u305f\u3002
\n<\/span><\/p>\n

2019\u5e746\u670830\u65e5<\/strong><\/span><\/p>\n

AOA150\u306e\u4e0d\u5177\u5408\u3092\u4fee\u6b63\u3059\u308b\u305f\u3081\u306bBIOS\u3092\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3057\u305f\u3089\u3001firefox\u306e\u8d77\u52d5\u6642\u306bXAMPP\u304c\u307e\u3060\u8d77\u52d5\u3057\u3066\u3044\u306a\u3044\u4e8b\u306b\u3088\u308b\u30a2\u30af\u30bb\u30b9\u5148\u306b\u3064\u306a\u304c\u3089\u306a\u3044\u3068\u3044\u3046\u30c8\u30e9\u30d6\u30eb\u304c\u767a\u751f\u3057\u3001\u9045\u5ef6\u8d77\u52d5\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb\u3092\u4fee\u6b63\u3057\u3001\u8d77\u52d5\u5f8c\uff115\uff10\u79d2\u5f8c\u306bfirefox\u304c\u8d77\u52d5\u3059\u308b\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

@echo off
\n:\u9045\u5ef6\u8d77\u52d5\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb
\n:10\u79d2\u5f85\u3064
\ntimeout 10
\nstart “” “C:\\xampp\\xampp-control.exe”
\necho \u9045\u5ef6\u8d77\u52d5\u3092\u958b\u59cb\u3057\u307e\u30592\u3002
\n:150\u79d2\u5f85\u3064
\ntimeout 150
\n:\u30d7\u30ed\u30b0\u30e9\u30e0\u5b9f\u884c(\u30ab\u30ec\u30f3\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u6307\u5b9a\u306a\u3057)
\nstart “” “C:\\Program Files\\Mozilla Firefox\\firefox.exe”<\/p>\n

\u6700\u521d\u306e10\u79d2\u5f85\u3061\u306f\u3001\u30d0\u30c3\u30c1\u3092\u4e2d\u6b62\u3057\u305f\u3044\u5834\u5408\u306b\u624b\u52d5\u3067\u4e2d\u6b62\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u305f\u3081\u3067\u3059\u3002<\/span>
\n\u30bd\u30d5\u30c8\u306e\u8d77\u52d5\u306b\u6642\u9593\u304c\u304b\u304b\u308b\u306e\u306f\u3001\u30a6\u30a3\u30eb\u30b9\u5bfe\u7b56\u30bd\u30d5\u30c8Avast Free Antivirus\u306e\u5f71\u97ff\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/span><\/p>\n

2019\u5e747\u670815\u65e5<\/strong><\/span><\/p>\n

\u30a6\u30a3\u30eb\u30b9\u5bfe\u7b56\u30bd\u30d5\u30c8Avast Free Antivirus\u3092\u30a2\u30f3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3089\u3001\u30bd\u30d5\u30c8\u306e\u7acb\u3061\u4e0a\u304c\u308a\u3082\u901f\u304f\u306a\u3063\u305f\u3057\u52d5\u4f5c\u3082\u5b89\u5b9a\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb\u3082<\/span><\/p>\n

@echo off
\n:\u9045\u5ef6\u8d77\u52d5\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb
\n:10\u79d2\u5f85\u3064
\ntimeout 10
\nstart “” “C:\\xampp\\xampp-control.exe”
\necho \u9045\u5ef6\u8d77\u52d5\u3092\u958b\u59cb\u3057\u307e\u30592\u3002
\n:20\u79d2\u5f85\u3064
\ntimeout 20
\n:\u30d7\u30ed\u30b0\u30e9\u30e0\u5b9f\u884c(\u30ab\u30ec\u30f3\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u6307\u5b9a\u306a\u3057)
\nstart “” “C:\\Program Files\\Mozilla Firefox\\firefox.exe”<\/p>\n

\u306b\u5909\u66f4\u3057\u307e\u3057\u305f\u3002
\n<\/span><\/p>\n

2019\u5e7411\u670820\u65e5<\/strong><\/span><\/p>\n

\u6700\u8fd1\u3001\u91d1\u6ca2\u306e\u5bbf\u6cca\u6599\u91d1\u306e\u5024\u5d29\u308c\u304c\u8d77\u304d\u3066\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001\uff11\u4eba\uff11\u6cca\u306e\u6700\u4f4e\u6599\u91d1\u30921500\u5186\u306b\u5909\u66f4\u3057\u307e\u3057\u305f\u3002
\n\u307e\u305f\u3001\u3086\u306b\u308d\u30fc\u305a\u91d1\u6ca2TS\u5e97(136975\uff09\u3001\uff28\uff2f\uff34\uff25\uff2c\u82b1\uff29\uff43\uff48\uff49\uff32\uff49\uff4e\uff2b\uff21\uff2e\uff21\uff3a\uff21\uff37\uff21\uff08160759\uff09\u306f\u30d0\u30fc\u30b9\u30c7\u30fc\u9650\u5b9a\u306a\u3069\u306e\u7279\u6b8a\u6761\u4ef6\u3067\u306e\u7279\u5225\u6599\u91d1\u306e\u8a2d\u5b9a\u306f\u7121\u304f\u306a\u3063\u305f\u3088\u3046\u306a\u306e\u3067\u3001\u9664\u5916\u65bd\u8a2d\u304b\u3089\u5916\u3057\u307e\u3057\u305f\u3002
\n<\/span><\/p>\n

2019\u5e7411\u670829\u65e5<\/strong><\/span><\/p>\n

\u6700\u8fd1\u3001\uff11\u4eba\uff11\u6cca\u306e\u6700\u4f4e\u6599\u91d1\u306e\u5bbf\u4e00\u89a7\u3067\uff2b\u2019\uff53\u3000\uff28\uff4f\uff55\uff53\uff45\u3000\uff2b\uff41\uff4e\uff41\uff5a\uff41\uff57\uff41\u304c\u7570\u5e38\u306b\u591a\u3044\u306e\u3067\u3001\u8abf\u3079\u3066\u307f\u307e\u3057\u305f\u3002
\n\uff2b\u2019\uff53\u3000\uff28\uff4f\uff55\uff53\uff45\u3000\uff2b\uff41\uff4e\uff41\uff5a\uff41\uff57\uff41\u304c\uff12\uff10\uff10\uff10\u5186\u3067\u3001\u3082\u3063\u3068\u5b89\u3044\u5bbf\u304c\u5b58\u5728\u3059\u308b\u306e\u3067\u4e0d\u601d\u8b70\u3060\u3068\u601d\u3044\u3001\u8a2d\u5b9a\u306e\u6761\u4ef6\u3092\u5909\u3048\u3066\u307f\u305f\u308a\u3057\u305f\u306e\u3067\u3059\u304c\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3057\u305f\u3002
\n\u3088\u304f\u8abf\u3079\u308b\u3068\u3001\uff2b\u2019\uff53\u3000\uff28\uff4f\uff55\uff53\uff45\u3000\uff2b\uff41\uff4e\uff41\uff5a\uff41\uff57\uff41\u306f\u697d\u5929\u30dd\u30a4\u30f3\u30c8\uff11\uff10\uff05\u3068\u3044\u3046\u30d7\u30e9\u30f3\u304c\u3042\u3063\u305f\u306e\u3067\u3001\u5b9f\u8cea\uff11\uff18\uff10\uff10\u5186\u3067\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3057\u305f\u3002
\n\u307e\u3042\u3001\u539f\u56e0\u304c\u306f\u3063\u304d\u308a\u3057\u305f\u306e\u3067\u30db\u30c3\u3068\u3057\u307e\u3057\u305f\u3002
\n<\/span><\/p>\n

2019\u5e7412\u670824\u65e5<\/strong><\/span><\/p>\n

PHP\u3067\u5bbf\u6cca\u60c5\u5831\u3092\u8868\u793a\u3057\u305f\u30da\u30fc\u30b8\u3092PHP\u30d5\u30a1\u30a4\u30eb\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u30a2\u30d5\u30a3\u30ea\u30a8\u30a4\u30c8\u306e\u53ce\u76ca\u304c\u6975\u7aef\u306b\u843d\u3061\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002PHP\u30d5\u30a1\u30a4\u30eb\u3060\u3068Google\u3067\u306e\u691c\u7d22\u9806\u4f4d\u304c\u6975\u3081\u3066\u4e0d\u5229\u306a\u3088\u3046\u3067\u3059\u3002
\n\u5bfe\u7b56\u3068\u3057\u3066\u3001\u30d5\u30a1\u30a4\u30eb\u3092html\u306b\u623b\u3057\u3066\u3001PHP\u3067\u306e\u51e6\u7406\u7d50\u679c\u306fiframe\u3092\u5229\u7528\u3057\u3066\u30d5\u30ec\u30fc\u30e0\u5185\u306b\u8868\u793a\u3059\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

<iframe src=”https:\/\/kimassi.net\/yadoitirandy.php” style=”width:100%; height:600;” frameborder=0 ><\/iframe><\/p>\n

2020\u5e744\u670817\u65e5<\/strong><\/span><\/p>\n

\u306a\u3093\u3068\u304b\u6599\u91d1\u3082\u8868\u793a\u3067\u304d\u308b\u3088\u3046\u306b\u9811\u5f35\u3063\u3066\u307f\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002
\n\u3067\u3082\u534a\u5e74\u305f\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u4f7f\u3044\u65b9\u3092\u5168\u304f\u5fd8\u308c\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n

https:\/\/webservice.rakuten.co.jp\/api\/vacanthotelsearch\/<\/a>\u3000\u3092\u898b\u308b\u3068<\/span>
\n\u4e88\u7d04\u5019\u88dc\u5185\u6700\u5b89\u5024\u306flowestCharge\u306b\u306a\u3063\u3066\u3044\u3066\u3001\u30c7\u30fc\u30bf\u306e\u4f4d\u7f6e\u306f
\nhotels->hotel->hotelReserveInfo->lowestCharge<\/span>
\n\u306b\u306a\u3063\u3066\u3044\u307e\u3059<\/span><\/p>\n

\u3068\u308a\u3042\u3048\u305a\u3001\uff12\uff10\uff12\uff10\u5e74\uff15\u6708\uff16\u65e5\u30c1\u30a7\u30c3\u30af\u30a4\u30f3\u3067\u91d1\u6ca2\u3067\u30b7\u30f3\u30b0\u30eb\u30d9\u30c3\u30c8\u3001\uff12\uff10\uff10\uff10\u5186\u4ee5\u4e0a\u3067\uff11\u4eba\u3067\u5bbf\u6cca\u3057\u305f\u5834\u5408\u306e\u6700\u4f4e\u6599\u91d1\u306f\u4e0b\u8a18\u3067\u51fa\u308b\u3088\u3046\u3067\u3059\u3002<\/span><\/p>\n

https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=jsor&checkinDate=2020-05-06&checkoutDate=2020-05-07&smallClassCode=kanazawa&adultNum=1&f_rm_bed=single&hits=1&page=1&sort=%2BroomCharge&largeClassCode=japan&middleClassCode=ishikawa&minCharge=2000&elements=hotelName,lowestCharge&applicationId=1089363386770913344&datumType=1&responseType=large&searchPattern=0<\/p>\n

\u8868\u793a\u306f
\n<\/span>
\n{“hotels”:[{“hotel”:[{“hotelBasicInfo”:{“hotelName”:”\u30b2\u30b9\u30c8\u30cf\u30a6\u30b9\u3000\u548c\u3093\u3067”}},{“hotelReserveInfo”:{“lowestCharge”:2000}}]}]}<\/span>
\n
\n\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u8a72\u5f53\u3059\u308b\u6761\u4ef6\u306e\u5168\u3066\u306e\u30d7\u30e9\u30f3\u306e\u6599\u91d1\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u7d50\u679c\u304b\u3089\u300c\u30b2\u30b9\u30c8\u30cf\u30a6\u30b9\u3000\u548c\u3093\u3067\u300d\u3068\u300c2000\u300d\u3092\u53d6\u308a\u51fa\u3059\u3053\u3068\u304c\u5fc5\u8981\u3067\u3059\u3002<\/span><\/p>\n

2020\u5e744\u670820\u65e5<\/strong><\/span><\/p>\n

PHP\u3092\u52d5\u4f5c\u3055\u305b\u308b\u65b9\u6cd5\u3059\u3089\u5fd8\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u3055\u3042\u5927\u5909\u3067\u3059\u3002<\/span><\/p>\n

\u81ea\u5206\u306e\u30d1\u30bd\u30b3\u30f3\u5185\u3067PHP\u3092\u52d5\u4f5c\u3055\u305b\u308b\u305f\u3081\u306bXAMPP\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u304b\u3089\u59cb\u3081\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u306e\u3067\u3059\u304c\u3001\u5e78\u3044\u3001\u524d\u56de\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u306a\u306e\u3067\u3001\u305d\u306e\u307e\u307e\u5229\u7528\u3059\u308b\u4e8b\u304c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

c:\/xampp\/htdocs\/ \u306b\u52d5\u4f5c\u3059\u308bPHP\u30d5\u30a1\u30a4\u30eb\uff08\u4f8b\u3048\u3070\u3000test.php)\u3092\u8a2d\u7f6e\u3057\u3066\u3042\u308c\u3070<\/span>
\nXAMPP\u3092\u8d77\u52d5\u3057\u3066\u3001 Control Panel\u3067Apache\u3068MySQL\u3092Start\u3055\u305b\u3066<\/span>
\nhttp:\/\/localhost\/test.php<\/span>
\n\u3067test.php\u3092\u52d5\u4f5c\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

PHP\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308b\u969b\u306b\u306f\u3001UTF-8\u3067\u5165\u529b\u3059\u308b\u3053\u3068\u304c\u5fc5\u8981\u3067\u3042\u308b\u3053\u3068\u306b\u6ce8\u610f\u3057\u3066\u3001\u3055\u3042\u30b9\u30bf\u30fc\u30c8\u3067\u3059\u3002<\/span><\/p>\n

<?php<\/p>\n

\/\/\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u304b\u3089\u5bbf\u3092\u691c\u7d22\u3057\u3066HTML\u30bf\u30b0\u3092\u8fd4\u3059\u95a2\u6570
\nfunction yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘*************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=1’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.
\n‘&elements=hotelName’.
\n‘&f_rm_bed=’.$f_rm_bed ;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;<\/p>\n

return $Items;
\n}
\n?>
\n<?php
\n$checkinDate = “2020-05-05”;
\n$checkoutDate = “2020-05-06”;
\n$minCharge = “2000”;
\n$adultNum = “1”;
\n$f_rm_bed = “single”;<\/p>\n

echo yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed);<\/p>\n

?><\/p>\n

\u3092\u52d5\u4f5c\u3057\u305f\u3089
\n<\/span>\u91d1\u6ca2\u5bb6<\/span>
\n\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/span><\/p>\n

$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;
\n\u3092<\/span>
\n$Items = $xml->hotels->hotel->hotelReserveInfo->lowestCharge;
\n\u306b\u5909\u66f4\u3057\u3066
\n<\/span>‘&elements=hotelName’.
\n\u3092<\/span>
\n‘&elements=lowestCharge’.
\n\u306b\u5909\u66f4\u3059\u308b\u3068<\/span><\/p>\n

Notice<\/b>: Trying to get property ‘hotelReserveInfo’ of non-object in\u00a0C:\\xampp\\htdocs\\rakuten\\rakutenyado.php<\/b>\u00a0on line\u00a035<\/b><\/span><\/p>\n

Notice<\/b>: Trying to get property ‘lowestCharge’ of non-object in\u00a0C:\\xampp\\htdocs\\rakuten\\rakutenyado.php<\/b>\u00a0on line\u00a035<\/b>
\n<\/span>
\n\u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002
\n<\/span>
\n$Items = $xml->hotels->hotel;<\/p>\n

\u306b\u5909\u66f4\u3057\u3066\u6b21\u306e\u884c\u306b
\n<\/span>
\necho var_dump($Items);<\/p>\n

\u3092\u8ffd\u52a0\u3059\u308b\u3068\u3001<\/span><\/p>\n

object(SimpleXMLElement)#4 (1) { [“hotelBasicInfo”]=> object(SimpleXMLElement)#3 (1) { [“hotelName”]=> string(9) “\u91d1\u6ca2\u5bb6” } }<\/span><\/p>\n

\u306e\u8868\u793a\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

‘&elements=lowestCharge’.<\/span><\/p>\n

\u3092\u524a\u9664\u3059\u308b\u3068<\/span><\/p>\n

object\uff08SimpleXMLElement\uff09\uff034\uff082\uff09{[“hotelBasicInfo”] => object\uff08SimpleXMLElement\uff09\uff033\uff0827\uff09{[“hotelNo”] => string\uff086\uff09 “172555” [“hotelName”] => string\uff08 9\uff09 “\u91d1\u6ca2\u5bb6” [“hotelInformationUrl”] => string\uff0867\uff09 “https:\/\/img.travel.rakuten.co.jp\/image\/tr\/api\/re\/pvonD\/?f_no=172555” [“planListUrl “] => string\uff0878\uff09” https:\/\/img.travel.rakuten.co.jp\/image\/tr\/api\/re\/vFumt\/?f_no=172555&f_flg=PLAN “[” dpPlanListUrl “] => object\uff08SimpleXMLElement \uff09\uff037\uff080\uff09{} [“reviewUrl”] => string\uff0873\uff09 “https:\/\/img.travel.rakuten.co.jp\/image\/tr\/api\/re\/gJNfM\/?f_hotel_no=172555” [ “hotelKanaName”] => string\uff0815\uff09 “\u304b\u306a\u3056\u308f\u3084” [“hotelSpecial”] => string\uff08126\uff09 “\u6577\u5730\u5185\u306e\u99d0\u8eca\u5834\uff11\uff13\u53f0\u7121\u6599\u3002\uff11\uff26\u30ab\u30d7\u30bb\u30eb\u30d9\u30c3\u30c9\uff11\uff14\u5ba4\u3001\uff12\uff26\u500b\u5ba4\uff12\u90e8\u5c4b\u3002\u591c\u666f\u3001\u666f\u8272\u304c\u826f\u3044 “[” hotelMinCharge “] => string\uff084\uff09” 2100 “[” latitude “] => string\uff089 \uff09 “131449.88” [“longitude”] => string\uff089\uff09 “491887.06” [“postalCode”] => string\uff088\uff09 “921-8154” [“address1”] => string\uff089\uff09 “\u77f3\u5ddd\u770c” [ “address2”] => string\uff0822\uff09 “\u91d1\u6ca2\u5e02\u9ad8\u5c3e\u53572-68” [“telephoneNo”] => string\uff0812\uff09 “076-298-9000” [“faxNo”] => string\uff0812\uff09 “076 -298-1221 “[” access “] => string\uff08151\uff09”\u91d1\u6ca2\u99c5\u3088\u308a\u304a\u8eca\u306b\u3066\u7d04\uff12\uff15\u5206\uff0f\u5c0f\u677e\u7a7a\u6e2f\u3088\u308a\u304a\u8eca\u306b\u3066\u7d04\uff14\uff10\u5206\u30d0\u30b9\u3054\u5229\u7528\u306e\u65b9\u306f\u9ad8\u5c3e\u5357\uff11\u4e01\u76ee\u3067\u304a\u964d\u308a\u4e0b\u3055\u3044\u3002 “[” parkingInformation “] => string\uff0844\uff09”\u6709\u308a\uff11\uff13\u53f0\u7121\u6599\u4e88\u7d04\u7121\u3057OK “[” nearestStation “] => string\uff086\uff09”\u91d1\u6ca2 “[” hotelImageUrl “] =>\u6587\u5b57\u5217\uff0862\uff09” https:\/\/img.travel.rakuten.co.jp\/share\/HOTEL\/172555\/172555.jpg “[” hotelThumbnailUrl “] =>\u6587\u5b57\u5217\uff0851\uff09” https:\/\/img.travel.rakuten.co.jp\/HIMG\/90\/172555.jpg “[” roomImageUrl “] => string\uff0867\uff09” https:\/\/img.travel.rakuten.co.jp\/share\/ HOTEL \/ 172555 \/ 172555_kan1.jpg “[” roomThumbnailUrl “] =>\u6587\u5b57\u5217\uff0857\uff09” https:\/\/img.travel.rakuten.co.jp\/HIMG\/INTERIOR\/172555.jpg “[” hotelMapImageUrl “] =>\u6587\u5b57\u5217\uff0865\uff09 “https:\/\/img.travel.rakuten.co.jp\/share\/HOTEL\/172555\/172555map.gif” [“reviewCount”] => string\uff081\uff09 “5” [“reviewAverage”] =>\u6587\u5b57\u5217\uff083\uff09 “4.5” [“userReview”] =>object\uff08SimpleXMLElement\uff09\uff038\uff080\uff09{}} [“roomInfo”] => array\uff082\uff09{[0] => object\uff08SimpleXMLElement\uff09\uff035\uff082\uff09{[“roomBasicInfo”] => object\uff08SimpleXMLElement\uff09 \uff038\uff0812\uff09{[“roomClass”] => string\uff0810\uff09 “kanazawa03” [“roomName”] => string\uff0883\uff09 “\u65b0\u54c1\u30ab\u30d7\u30bb\u30eb\u30d9\u30c3\u30c9\u5168\u5ba4\u30c6\u30ec\u30d3\u4ed8\u304d\u99d0\u8eca\u5834\u7121\u6599\u624b\u3076\u3089OK” [“planId”] => string\uff087\uff09 “4414223” [“planName”] => string\uff08134\uff09 “\u30102019\u5e74\uff11\u6708\uff11\u65e5OPEN\u3011\u2606\u65b0\u54c1\u30ab\u30d7\u30bb\u30eb\u30d9\u30c3\u30c9\u2606\u99d0\u8eca\u5834\u7121\u6599\u2606\u30bf\u30aa\u30eb\u30fb\u30a2\u30e1\u30cb\u30c6\u30a3\u7b49\u30fb\u30e9\u30f3\u30c9\u30ea\u30fc\u7121\u6599” [“pointRate “] => string\uff081\uff09” 1 “[” withDinnerFlag “] => string\uff081\uff09” 0 “[” dinnerSelectFlag “] => string\uff081\uff09” 0 “[” withBreakfastFlag “] =>string\uff081\uff09 “0” [“breakfastSelectFlag”] => string\uff081\uff09 “0” [“payment”] => string\uff081\uff09 “1” [“reserveUrl”] => string\uff08203\uff09 “https\uff1a\/ \/img.travel.rakuten.co.jp\/image\/tr\/api\/re\/IdsCY\/?f_no=172555&f_syu=kanazawa03&f_hi1=2020-05-05&f_hi2=2020-05-06&f_heya_su=1&f_otona_su=1&f_s1=0&f_s2=0&f_y1=0&f_y1=0 0\uff06f_y3 = 0\uff06f_y4 = 0\uff06f_camp_id = 4414223 “[” salesformFlag “] => string\uff081\uff09” 0 “} [” dailyCharge “] => object\uff08SimpleXMLElement\uff09\uff037\uff084\uff09{[” stayDate “] => string\uff0810 \uff09 “2020-05-05” [“rakutenCharge”] => string\uff084\uff09 “2550” [“total”] =>string\uff084\uff09 “2550” [“chargeFlag”] => string\uff081\uff09 “0”}} [1] => object\uff08SimpleXMLElement\uff09\uff036\uff082\uff09{[“roomBasicInfo”] => object\uff08SimpleXMLElement\uff09\uff03 7\uff0812\uff09{[“roomClass”] => string\uff0810\uff09 “kanazawa01” [“roomName”] => string\uff0868\uff09 “43\u578b\u30c6\u30ec\u30d3\u4ed8\u304d\u591c\u666f\u3068\u6620\u753b\u7121\u6599\u898b\u653e\u984c\uff12\uff10\uff11\u53f7\u5ba4” [“planId”] = > string\uff087\uff09 “4416178” [“planName”] => string\uff08132\uff09 “\u3086\u3063\u305f\u308a\u3068\u3057\u305f\u30bb\u30df\u30c0\u30d6\u30eb\u30d9\u30c3\u30c9\uff12\u53f0\u3010Netflix\u6620\u753b\u7121\u6599\u898b\u653e\u984c\u3011\u2606\u99d0\u8eca\u5834\u7121\u6599\u2606\u624b\u3076\u3089OK\u7981\u7159” [“pointRate”] => string\uff081\uff09 “1” [“withDinnerFlag”] => string\uff081\uff09 “0” [“dinnerSelectFlag”] => string\uff081\uff09 “0” [“withBreakfastFlag “] => string\uff081\uff09” 0 “[” breakfastSelectFlag “] => string\uff081\uff09” 0 “[” payment “] => string\uff081\uff09” 1 “[” reserveUrl “] => string\uff08203 \uff09 “https:\/\/img.travel.rakuten.co.jp\/image\/tr\/api\/re\/IdsCY\/?f_no=172555&f_syu=kanazawa01&f_hi1=2020-05-05&f_hi2=2020-05-06&f_heya_su=1&f_otona_su=1&f_s1=0&f_s2 = 0\uff06f_y1 = 0\uff06f_y2 = 0\uff06f_y3 = 0\uff06f_y4 = 0\uff06f_camp_id = 4416178 “[” salesformFlag “] => string\uff081\uff09” 0 “} [” dailyCharge “] => object\uff08SimpleXMLElement\uff09\uff038\uff084\uff09{[” stayDate “] => string\uff0810\uff09 “2020-05-05” [“rakutenCharge”] => string\uff084\uff09 “2900” [“\u5408\u8a08 “] => string\uff084\uff09” 2900 “[” chargeFlag “] => string\uff081\uff09” 0 “}}}}<\/span><\/p>\n

\u3068\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u3061\u3083\u3093\u3068\u6599\u91d1\u3082\u30c7\u30fc\u30bf\u3068\u3057\u3066\u51fa\u529b\u3055\u308c\u3066\u3044\u308b\u4e8b\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n

$Items = $xml->hotels->hotel->hotelBasicInfo;
\necho var_dump($Items);<\/p>\n

\u306b\u3059\u308b\u3068\u3001\u6599\u91d1\u306a\u3069\u306e\u4e88\u7d04\u60c5\u5831\u306f\u8868\u793a\u3055\u308c\u306a\u304f\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

$Items = $xml->hotels->hotel->hotelReserveInfo;
\necho var_dump($Items);<\/p>\n

\u306b\u3059\u308b\u3068\u3001<\/span><\/p>\n

\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff08SimpleXMLElement\uff09\uff033\uff080\uff09{}<\/span><\/p>\n

\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

$Items = $xml->hotels->hotel->dailyCharge;
\necho var_dump($Items);<\/p>\n

\u306b\u3057\u3066\u3082\u3001<\/span><\/p>\n

\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff08SimpleXMLElement\uff09\uff033\uff080\uff09{}<\/span><\/p>\n

\u306b\u306a\u308a\u307e\u3059\u3002\u3084\u3063\u3071\u308a\u30c7\u30fc\u30bf\u304c\u7121\u3044\u3088\u3046\u3067\u3059\u3002<\/span><\/p>\n

$Items = $xml->hotels->hotel;
\n‘&elements=rakutenCharge’.
\necho var_dump($Items);<\/p>\n

\u306b\u3057\u305f\u3089\u3001<\/span><\/p>\n

object\uff08SimpleXMLElement\uff09\uff034\uff081\uff09{[“roomInfo”] => array\uff082\uff09{[0] => object\uff08SimpleXMLElement\uff09\uff033\uff081\uff09{[“dailyCharge”] => object\uff08SimpleXMLElement\uff09\uff036 \uff081\uff09{[“rakutenCharge”] => string\uff084\uff09 “2550”}} [1] => object\uff08SimpleXMLElement\uff09\uff035\uff081\uff09{[“dailyCharge”] => object\uff08SimpleXMLElement\uff09\uff036\uff081 \uff09{[“rakutenCharge”] => string\uff084\uff09 “2900”}}}}<\/span><\/p>\n

\u306b\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

echo var_dump($Items);<\/p>\n

\u3092\u524a\u9664\u3057\u305f\u3089\u4f55\u3082\u8868\u793a\u3057\u306a\u304f\u306a\u308a\u307e\u3059\u3002\u305d\u306e\u307e\u307e<\/span><\/p>\n

$Items = $xml->hotels->hotel;
\n‘&elements=’hotelName.<\/p>\n

\u306b\u3057\u3066\u3082\u4f55\u3082\u8868\u793a\u3055\u308c\u307e\u305b\u3093\u3002<\/span><\/p>\n

$Items = $xml->hotels->hotel->hotelName;
\n‘&elements=’hotelName.<\/p>\n

\u306b\u3057\u3066\u3082\u4f55\u3082\u8868\u793a\u3055\u308c\u307e\u305b\u3093\u3002\u3084\u3063\u3071\u308a<\/span><\/p>\n

$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;
\n‘&elements=’hotelName.<\/p>\n

\u306e\u3088\u3046\u306b\u3057\u3063\u304b\u308a\u3068\u6307\u5b9a\u3057\u306a\u3044\u3068\u30c7\u30fc\u30bf\u3068\u3057\u3066\u53d6\u5f97\u51fa\u6765\u306a\u3044\u3088\u3046\u3067\u3059\u3002
\n\u3044\u308d\u3044\u308d\u8a66\u884c\u932f\u8aa4\u3057\u3066\u3001<\/span><\/p>\n

$Items = $xml->hotels->hotel->roomInfo->dailyCharge->rakutenCharge;
\n‘&elements=rakutenCharge’.<\/p>\n

\u3067\u6599\u91d1\u3092\u53d6\u308a\u51fa\u305b\u308b\u4e8b\u306b\u6c17\u3065\u304d\u307e\u3057\u305f\u3002\u4e00\u6319\u306b\u524d\u9032\u3067\u3059\u3002<\/span><\/p>\n

<?php<\/p>\n

\/\/\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u304b\u3089\u5bbf\u3092\u691c\u7d22\u3057\u3066HTML\u30bf\u30b0\u3092\u8fd4\u3059\u95a2\u6570
\nfunction yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘**************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘***************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=1’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.
\n‘&elements=hotelName’.
\n‘&f_rm_bed=’.$f_rm_bed ;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;<\/p>\n

return $Items;
\n}<\/p>\n

function yado_rakuten2($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘**************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘**************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=1’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.
\n‘&elements=rakutenCharge’.
\n‘&f_rm_bed=’.$f_rm_bed ;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$Items2 = $xml->hotels->hotel->roomInfo->dailyCharge->rakutenCharge;<\/p>\n

return $Items2;
\n}
\n?><\/p>\n

<?php
\n$checkinDate = “2020-05-05”;
\n$checkoutDate = “2020-05-06”;
\n$minCharge = “2000”;
\n$adultNum = “1”;
\n$f_rm_bed = “single”;<\/p>\n

echo yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed);
\necho yado_rakuten2($checkinDate,$checkoutDate,$adultNum,$minCharge,$f_rm_bed);
\n?><\/p>\n

\u3067\u5bbf\u540d\u3068\u6599\u91d1\u3092\u51fa\u529b\u3067\u304d\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u91d1\u6ca2\u5bb62550<\/span><\/p>\n

\u3053\u308c\u3092\u5229\u7528\u3057\u3066\u3001csv\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3059\u308bPHP\u30d7\u30ed\u30b0\u30e9\u30e0\u3082\u7121\u4e8b\u52d5\u4f5c\u3057\u307e\u3057\u305f\u3002
\n\u5f8c\u306f\u3001\u30b5\u30fc\u30d0\u30fc\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u3092\u5909\u66f4\u3057\u3066\u3001\u4f5c\u6210\u3057\u305fcsv\u30d5\u30a1\u30a4\u30eb\u3092\u9001\u3063\u3066\u3001\u30da\u30fc\u30b8\u306e\u8868\u793a\u90e8\u5206\u3092\u5c11\u3057\u5909\u66f4\u3059\u308b\u3060\u3051\u3067\u3059\u3002
\n\u3068\u306f\u8a00\u3048\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u64cd\u4f5c\u65b9\u6cd5\u3082\u5b8c\u5168\u306b\u5fd8\u308c\u3066\u3044\u307e\u3059\uff08\u82e6\u7b11\uff01\uff09
\n<\/span><\/p>\n

http:\/\/kimassi.****.coreserver.jp\/log\/phpmyadmin\/<\/span>
\n\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066<\/span>
\n\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u3000kimassi_yado\u3092\u4f5c\u6210<\/span><\/p>\n

\u30e6\u30fc\u30b6\u30fc\u540d\u3000\u3000\u3000kimassi_yado\u3067\u30ed\u30b0\u30a4\u30f3<\/span>
\n\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u3000kimassi_yado\u3092\u9078\u629e\u3057\u3066<\/span><\/p>\n

\u30c6\u30fc\u30d6\u30eb\u3000\u3000\u3000\u3000yasuiyado2 \u3092\u4f5c\u6210<\/span>
\nid\u3000 \u4e3b\u3000\u3000int(11) \u3000AUTO_INCREMENT\uff08AI)<\/span>
\nno \u3000\u3000\u3000\u00a0 int(11)<\/span>
\ndate\u3000\u3000\u3000text\u3000\u3000\u3000 \u7167\u5408\u9806\u4f4d\u306futf8_unicode_ci<\/span>
\nyadomei \u3000text \u3000\u3000\u3000\u7167\u5408\u9806\u4f4d\u306futf8_unicode_ci<\/span>
\nryoukin \u3000int(11)<\/span><\/p>\n

\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3000\u3000\u3000PRIMARY\u3000\u3000BTREE\u3000\u3000\u30e6\u30cb\u30fc\u30af \u306f\u3044 \u3000\u30ab\u30e9\u30e0 id \u3000\u7167\u5408\u9806\u5e8f A<\/span>
\nID\u3000\u3000 \u3000\u3000\u3000BTREE\u3000\u3000\u30e6\u30cb\u30fc\u30af \u3044\u3044\u3048\u3000\u30ab\u30e9\u30e0 id \u3000\u7167\u5408\u9806\u5e8f A<\/span><\/p>\n

\u4f5c\u6210\u3057\u305fcsv\u30d5\u30a1\u30a4\u30eb\u3092yasuiyado2 \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u66f4\u65b0\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/span><\/p>\n

2020\u5e745\u67081\u65e5<\/strong><\/span><\/p>\n

\u9078\u3093\u3060\u6761\u4ef6\u306b\u3088\u3063\u3066\u518d\u5b89\u5024\u306e\u5bbf\u540d\u3067\u3001\u5bbf\u6cca\u8005\u306e\u6761\u4ef6\u3092\u9650\u5b9a\u3057\u305f\u5834\u5408\u306f\u5bbf\u540d\u3092\u300c\u8868\u793a\u3057\u306a\u3044\u300d\u3068\u8868\u793a\u3057\u3066\u3044\u308b\u306e\u3067\u3059\u304c\u3001\u300c\u8868\u793a\u3057\u306a\u3044\u300d\u304c\u5927\u91cf\u306b\u4e26\u3076\u3068\u898b\u6804\u3048\u304c\u60aa\u3044\u306e\u3067\u3001\uff12\u756a\u76ee\u306b\u5b89\u3044\u5bbf\u540d\u3092\u8868\u793a\u3059\u308b\u306e\u306b\u5909\u66f4\u3057\u3088\u3046\u3068\u8a66\u307f\u3066\u3044\u308b\u306e\u3067\u3059\u304c\u3001\u96e3\u3057\u3044\u3067\u3059\u3002\u6761\u4ef6\u5f0f\u3092\u4f7f\u3063\u3066\u306a\u3093\u3068\u304b\u9664\u5916\u5bfe\u8c61\u3067\u306a\u3044\u6700\u5b89\u5024\u306e\u5bbf\u540d\u3092\u8868\u793a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/span><\/p>\n

<?php<\/p>\n

\/\/\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u304b\u3089\u5bbf\u3092\u691c\u7d22\u3057\u3066HTML\u30bf\u30b0\u3092\u8fd4\u3059\u95a2\u6570
\nfunction yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘***************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘*************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=5’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.
\n‘&elements=hotelName,hotelNo’;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

$Items = $xml->hotels->hotel->hotelBasicInfo->hotelName;
\n$hotelNo = $xml->hotels->hotel->hotelBasicInfo->hotelNo;
\n$Items2 = $xml->xpath(‘hotels\/hotel\/hotelBasicInfo\/hotelName’);
\n$hotelNo2 = $xml->xpath(‘hotels\/hotel\/hotelBasicInfo\/hotelNo’);
\nforeach($hotelNo2 as $hotelNo3){
\nif (($hotelNo3 <>’153335′) && ($hotelNo3 <>’171908′) && ($hotelNo3 <>’165677′) && ($hotelNo3 <>’177472′)){
\n$Items=$hotelNo3;break;}
\nelse {}<\/p>\n

}<\/p>\n

return $Items;
\n}<\/p>\n

\/\/\u697d\u5929\u30c8\u30e9\u30d9\u30eb\u304b\u3089\u5bbf\u3092\u691c\u7d22\u3057\u3066HTML\u30bf\u30b0\u3092\u8fd4\u3059\u95a2\u6570
\nfunction yado_rakuten2($checkinDate,$checkoutDate,$adultNum,$minCharge,$Items){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘**************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘***************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hotelNo=’.$Items.
\n‘&hits=5’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.
\n‘&elements=hotelName,hotelNo’;
\n\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);<\/p>\n

\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

$Items2 = $xml->hotels->hotel->hotelBasicInfo->hotelName;<\/p>\n

return $Items2;<\/p>\n

}<\/p>\n

function yado_rakuten3($checkinDate,$checkoutDate,$adultNum,$minCharge,$Items){
\n\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘*****************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘****************‘;<\/span><\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hotelNo=’.$Items.
\n‘&hits=5’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.”;
\n‘&elements=total’;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);
\n\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);
\n\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$Items3 = $xml->hotels->hotel->roomInfo->dailyCharge->total;<\/p>\n

return $Items3;
\n}<\/p>\n

?>
\n<?php
\n$checkinDate = “2020-05-20”;
\n$checkoutDate = “2020-05-21”;
\n$minCharge = “2000”;
\n$adultNum = “2”;
\n$Items = yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge);<\/p>\n

echo yado_rakuten($checkinDate,$checkoutDate,$adultNum,$minCharge);
\necho yado_rakuten2($checkinDate,$checkoutDate,$adultNum,$minCharge,$Items);
\necho yado_rakuten3($checkinDate,$checkoutDate,$adultNum,$minCharge,$Items);
\n?><\/p>\n

2020\u5e745\u670813\u65e5<\/strong><\/span><\/p>\n

\u3042\u307e\u308a\u306b\u3082\u91d1\u6ca2\u4e2d\u5fc3\u8857\u304b\u3089\u96e2\u308c\u3066\u3044\u308b\u5bbf\u3092\u9664\u5916\u3057\u3066\u3001\u5834\u5916\u5bfe\u8c61\u3092\u5897\u3084\u3057\u305f\u3089\u6700\u5b89\u5024\uff15\u4f4d\u307e\u3067\u306e\u3059\u3079\u3066\u306e\u5bbf\u304c\u5834\u5916\u5bfe\u8c61\u306b\u306a\u3063\u3066\u30c7\u30fc\u30bf\u3092\u53d6\u308c\u306a\u304f\u306a\u3063\u305f\u306e\u3067\u3001\u53d6\u5f97\u30c7\u30fc\u30bf\u3092\uff15\u8ed2\u304b\u3089\uff18\u8ed2\u306b\u5897\u3084\u3057\u305f\u3002<\/span><\/p>\n

‘&hits=8’.<\/p>\n

\u73fe\u6642\u70b9\u306e\u8a72\u5f53\u65e5\u306e\u5b89\u5024\u4e00\u89a7\u3092\u8868\u793a\u30dc\u30bf\u30f3\u3092\u8a2d\u7f6e\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u65e5\u4ed8\u304c\u5909\u308f\u3063\u3066\u304b\u3089\u3001\u7fcc\u671d\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u307e\u3067\u306e\u6642\u9593\u5e2f\u3067\uff11\u65e5\u306e\u305a\u308c\u304c\u751f\u3058\u308b\u3053\u3068\u306b\u6c17\u3065\u3044\u305f\u3002\u306a\u3093\u3068\u304b\u3057\u306a\u3044\u3068\u3044\u3051\u307e\u305b\u3093\u3002<\/span><\/p>\n

2020\u5e745\u670814\u65e5<\/strong><\/span><\/p>\n

\u30c6\u30fc\u30d6\u30eb\u306e\u9805\u76ee\u3092\uff11\u3064\u5897\u3084\u3057\u3066\u30c1\u30a7\u30c3\u30af\u30a4\u30f3\u65e5\u3092\u767b\u9332\u3057\u3066\u8868\u793a\u3055\u305b\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

http:\/\/kimassi.****.coreserver.jp\/log\/phpmyadmin\/<\/span>
\n\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066
\n<\/span>
\n\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u3000kimassi_yado\u3092\u4f5c\u6210<\/span><\/p>\n

\u30e6\u30fc\u30b6\u30fc\u540d\u3000\u3000\u3000kimassi_yado\u3067\u30ed\u30b0\u30a4\u30f3<\/span>
\n\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u3000kimassi_yado\u3092\u9078\u629e\u3057\u3066<\/span><\/p>\n

\u30c6\u30fc\u30d6\u30eb\u3000\u3000\u3000\u3000yasuiyado3 \u3092\u4f5c\u6210<\/span>
\nid\u3000 \u4e3b\u3000\u3000int(11) \u3000AUTO_INCREMENT\uff08AI)<\/span>
\nno \u3000\u3000\u3000\u00a0 int(11)<\/span>
\ndate\u3000\u3000\u3000text\u3000\u3000\u3000 \u7167\u5408\u9806\u4f4d\u306futf8_unicode_ci
\ncheck\u3000\u3000DATE
\n<\/span>yadomei \u3000text \u3000\u3000\u3000\u7167\u5408\u9806\u4f4d\u306futf8_unicode_ci<\/span>
\nryoukin \u3000int(11)<\/span><\/p>\n

\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3000\u3000\u3000PRIMARY\u3000\u3000BTREE\u3000\u3000\u30e6\u30cb\u30fc\u30af \u306f\u3044 \u3000\u30ab\u30e9\u30e0 id \u3000\u7167\u5408\u9806\u5e8f A<\/span>
\nID\u3000\u3000 \u3000\u3000\u3000BTREE\u3000\u3000\u30e6\u30cb\u30fc\u30af \u3044\u3044\u3048\u3000\u30ab\u30e9\u30e0 id \u3000\u7167\u5408\u9806\u5e8f A<\/span><\/p>\n

\u30c1\u30a7\u30c3\u30af\u30a4\u30f3\u65e5\u3068\u7fcc\u65e5\u306e\u5e74\u3001\u6708\u3001\u65e5\u3092\u53d6\u5f97\u3059\u308b\u306e\u306f\u4e0b\u8a18\u3067\u3067\u304d\u307e\u3057\u305f\u3002<\/span>
\n\u7fcc\u65e5\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308bstrtotime\u306e\u95a2\u6570\u306e\u66f8\u5f0f\u304c\u3001PHP\u3092\u8aac\u660e\u3059\u308b\u30b5\u30a4\u30c8\u306b\u3088\u3063\u3066\u307e\u3061\u307e\u3061\u3067\u7d71\u4e00\u3055\u308c\u3066\u3044\u306a\u304f\u3066\u52d5\u4f5c\u3057\u306a\u304b\u3063\u305f\u308a\u3057\u307e\u3059\u3002\u66f8\u5f0f\u304c\u7d4c\u5e74\u7684\u306b\u5909\u5316\u3057\u3066\u3044\u308b\u306e\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/span><\/p>\n

<?php
\nfor($n=1;$n<30;$n++){
\n$stmt =$db->query(“SELECT * FROM yasuiyado2 where id=$n”);
\n$result = $stmt->fetch();
\n$n2 = $result[‘check’];
\n$y1 = date(“Y”,strtotime(“$n2”));
\n$m1 = date(“m”,strtotime(“$n2”));
\n$d1 = date(“d”,strtotime(“$n2”));
\n$y2 = date(“Y”,strtotime($n2.”+1 day”));
\n$m2 = date(“m”,strtotime($n2.”+1 day”));
\n$d2 = date(“d”,strtotime($n2.”+1 day”));
\n}
\n?><\/p>\n

2020\u5e745\u670823\u65e5<\/strong><\/span><\/p>\n

\u6700\u8fd1\u3001\uff11\uff12\uff10\u79d2\u4ee5\u5185\u306b\u51e6\u7406\u3067\u304d\u306a\u3044\u4e8b\u304c\u5897\u3048\u3066\u304d\u3066\u3001\u51e6\u7406\u6642\u9593\u306e\u77ed\u7e2e\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3057\u305f\u3002
\nfunction \u95a2\u6570\u3092\u4f7f\u3046\u306e\u3092\u3084\u3081\u307e\u3057\u305f\u3002
\n\u3064\u3044\u3067\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306bhotelNo\u3082\u767b\u9332\u3059\u308b\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

<?php
\nset_time_limit(120);
\nfor($n=0;$n<30;$n++)
\n{$n1=$n+1;
\n$n2=’+’.$n.’ day’;
\n$n3=’+’.$n1.’ day’;
\n$checkinDate = date(“Y-m-d”,strtotime(“$n2”));
\n$checkoutDate = date(“Y-m-d”,strtotime(“$n3”));
\n$minCharge = “1500”;
\n$adultNum = “1”;
\n$w=date(“w”,strtotime(“$n2”));
\n$week_name = array(“\u65e5”,”\u6708”, “\u706b”,”\u6c34”,”\u6728”,”\u91d1”,”\u571f”);
\n$day2=date(“m-d”,strtotime(“$n2″)).'(‘.$week_name[$w].’)’;<\/p>\n

\/\/developerId\u3092\u8a2d\u5b9a\u3059\u308b
\n$applicationId = ‘****************’;<\/p>\n

\/\/affiliateId\u3092\u8a2d\u5b9a\u3059\u308b
\n$affiliateId = ‘****************’;<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hits=8’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.
\n‘&elements=hotelNo’;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);
\nusleep(160000);
\n\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);<\/p>\n

$hotelNo2 = $xml->xpath(‘hotels\/hotel\/hotelBasicInfo\/hotelNo’);
\nforeach($hotelNo2 as $hotelNo3){
\nif (($hotelNo3 <>’153335′) && ($hotelNo3 <>’171908′) && ($hotelNo3 <>’165677′) && ($hotelNo3 <>’177472′) && ($hotelNo3 <>’160759′) && ($hotelNo3 <>’172555′) && ($hotelNo3 <>’151419′)&& ($hotelNo3 <>’147855′)){
\n$Items=$hotelNo3;break;}
\nelse {}<\/p>\n

}<\/p>\n

\/\/URL\u3092\u751f\u6210\u3059\u308b
\n$url = ‘https:\/\/app.rakuten.co.jp\/services\/api\/Travel\/VacantHotelSearch\/20170426?format=xml’.
\n‘&applicationId=’.$applicationId.
\n‘&largeClassCode=japan’.
\n‘&middleClassCode=ishikawa’.
\n‘&smallClassCode=kanazawa’.
\n‘&checkinDate=’.$checkinDate.
\n‘&checkoutDate=’.$checkoutDate.
\n‘&adultNum=’.$adultNum.
\n‘&minCharge=’.$minCharge.
\n‘&hotelNo=’.$Items.
\n‘&hits=1’.
\n‘&page=1’.
\n‘&sort=+roomCharge’.”;
\n‘&elements=hotelName,total’;<\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);
\n\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);
\n\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$yado2 = $xml->hotels->hotel->roomInfo->dailyCharge->total;<\/p>\n

$yado = $xml->hotels->hotel->hotelBasicInfo->hotelName;<\/p>\n

usleep(140000);
\n$data=[];
\n$data[‘id’] =$n1;
\n$data[‘no’] =$n1;
\n$data[‘date’] =$day2;
\n$data[‘check’] =$checkinDate;
\n$data[‘hotelNo’] =$Items;
\n$data[‘yadomei’] =mb_substr($yado,0,34);
\n$data[‘ryoukin’] =$yado2;
\necho var_dump($data);
\nfputcsv($fp, $data);<\/p>\n

}
\n?><\/p>\n

\u5b8c\u6210\u3057\u305f\u30da\u30fc\u30b8\u306f\u3053\u3061\u3089\u3067\u3059<\/strong><\/a><\/p>\n

2020\u5e7411\u67081\u65e5<\/strong><\/span><\/p>\n

\u691c\u7d22\u65e5\u306b\u7a7a\u304d\u5ba4\u304c\u5168\u304f\u306a\u3044\u5834\u5408\u306b\u3001\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u306a\u304f\u3066\u51e6\u7406\u304c\u30a8\u30e9\u30fc\u306b\u306a\u308b\u4e8b\u614b\u306b\u9665\u308a\u307e\u3057\u305f\u3002
\n\u9014\u4e2d\u3067\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u3068\u3001\u30c7\u30fc\u30bf\u304c\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3055\u308c\u306a\u3044\u306e\u3067\u5168\u304f\u66f4\u65b0\u3067\u304d\u306a\u304f\u306a\u308a\u307e\u3059\u3002<\/span><\/p>\n

$hotelNo2 = $xml->xpath(‘hotels\/hotel\/hotelBasicInfo\/hotelNo’);<\/p>\n

\u3067\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u306a\u304b\u3063\u305f\u306e\u304c\u539f\u56e0\u306e\u3088\u3046\u3067\u3059\u3002<\/span><\/p>\n

$hotelNo2 = $xml->xpath(‘hotels\/hotel\/hotelBasicInfo\/hotelNo’);\u3000\u306e\uff11\u3064\u524d\u306e<\/span>
\n$xml = simplexml_load_string($str);\u3000\u306e\u30c7\u30fc\u30bf\u304c\u7121\u3044\u5834\u5408\u306b\u8a72\u5f53\u306a\u3057\u306e\u30c7\u30fc\u30bf\u3092\u767b\u9332\u3057\u3066\u66f8\u304d\u8fbc\u3080\u547d\u4ee4\u3092\u633f\u5165\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

if(empty($xml)){
\n$data=[];
\n$data[‘id’] =$n1;
\n$data[‘no’] =$n1;
\n$data[‘date’] =$day2;
\n$data[‘check’] =$day2;
\n$data[‘hotelNo’] =””;
\n$data[‘yadomei’] =”\u8a72\u5f53\u306a\u3057”;
\n$data[‘ryoukin’] =””;
\necho $data[‘date’].’ ‘.$data[‘check’].’ ‘.$data[‘yadomei’].’ ‘.$data[‘ryoukin’].”<br \/>”;<\/p>\n

fputcsv($fp, $data);
\n}
\nelse
\n{
\n\u5f93\u6765\u306e\u51e6\u7406\u5185\u5bb9
\n}<\/p>\n

2020\u5e7411\u670815\u65e5<\/strong><\/span><\/p>\n

\u30a8\u30e9\u30fc\u8868\u793a\u304c\u51fa\u3066\u3001\u5bbf\u306e\u6700\u5b89\u5024\u3092\u53d6\u5f97\u3067\u304d\u306a\u3044\u65e5\u304c\u3042\u308b\u73fe\u8c61\u304c\u8d77\u304d\u307e\u3057\u305f\u3002
\n\u305d\u306e\u4ed6\u306e\u65e5\u306e\u30c7\u30fc\u30bf\u306f\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u305d\u308c\u307b\u3069\u81f4\u547d\u7684\u306a\u72b6\u6cc1\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002
\n\u305d\u306e\u65e5\u306e\u30c7\u30fc\u30bf\u3092\u8abf\u3079\u308b\u3068\u3001\u305d\u306e\u65e5\u306b\u6cca\u307e\u308c\u308b\u5bbf\u306f\uff11\u8ed2\u3060\u3051\u3057\u304b\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002
\n\u305d\u306e\u5bbf\u304c\u3001\u9ad8\u9f62\u306e\u8a95\u751f\u65e5\u306e\u4eba\u3060\u3051\u306b\u5bfe\u3057\u3066\u306e\u7279\u5225\u4fa1\u683c\u3092\u8a2d\u7f6e\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u8a72\u5f53\u30c7\u30fc\u30bf\u304b\u3089\u5916\u3057\u3066\u3042\u308b\u5bbf\u306a\u306e\u3067\u3057\u305f\u3002
\n\u3053\u3046\u3044\u3046\u4f8b\u306f\u3001\u6ec5\u591a\u306b\u306a\u3044\u4e8b\u306a\u306e\u3067\u3001\u305d\u306e\u307e\u307e\u306b\u3057\u3066\u304a\u304d\u307e\u3057\u305f\u3002<\/span><\/p>\n

2021\u5e741\u67085\u65e5<\/strong><\/span><\/p>\n

\u6700\u8fd1\u3001\u30a8\u30e9\u30fc\u8868\u793a\u304c\u51fa\u308b\u3053\u3068\u304c\u5897\u3048\u307e\u3057\u305f\u3002
\n\u30d1\u30bd\u30b3\u30f3\u306e\u6027\u80fd\u306e\u554f\u984c\u3082\u3042\u308b\u304b\u306a\u3068\u601d\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u30d1\u30bd\u30b3\u30f3\u3092\u5165\u308c\u66ff\u3048\u3066\u307f\u307e\u3057\u305f\u3002<\/span><\/p>\n

XAMPP Version: 7.4.13\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3057\u305f\u3002\u7279\u6b8a\u306a\u8a2d\u5b9a\u3092\u3057\u306a\u304f\u3066\u3082\u3059\u3093\u306a\u308a\u3068\u4f7f\u3048\u307e\u3057\u305f\u3002
\n\u306a\u305c\u304b\u65e5\u4ed8\u6642\u9593\u304c8\u6642\u9593\u307b\u3069\u305a\u308c\u3066\u3044\u307e\u3057\u305f\u3002
\nphp.ini \u306e\u5730\u57df\u3092Asia\/Tokyo\u306b\u8a2d\u5b9a\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

[Date]
\n; Defines the default timezone used by the date functions
\n; http:\/\/php.net\/date.timezone
\ndate.timezone =Asia\/Tokyo<\/p>\n

\u3067\u3082\u89e3\u6c7a\u3057\u306a\u304f\u3066\u3001PHP\u30d5\u30a1\u30a4\u30eb\uff08XAMPP\u4e0a\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u30d5\u30a1\u30a4\u30eb\uff09\u306e\u6700\u521d\u306b<\/span><\/p>\n

<?php
\ndate_default_timezone_set(‘Asia\/Tokyo’);
\n?><\/p>\n

\u3092\u52a0\u3048\u308b\u3068\u89e3\u6c7a\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u30d1\u30bd\u30b3\u30f3\u306e\u6027\u80fd\u304c\u4e0a\u304c\u308b\u3068\u3001\u697d\u5929\u306e\u30b5\u30fc\u30d0\u30fc\u4e0a\u306e\u51e6\u7406\u3092\u5f85\u3061\u304d\u308c\u306a\u304f\u30a8\u30e9\u30fc\u306b\u306a\u308b\u306e\u3067\u3001usleep();\u306e\u5024\u3092\u4e0a\u3052\u3066\u5f85\u3061\u6642\u9593\u3092\u78ba\u4fdd\u3057<\/span>\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3088\u3046\u3067\u3059\u3002<\/span><\/p>\n

\/\/REST\u3067\u8fd4\u3055\u308c\u308bXML\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3059\u308b
\n$str = @file_get_contents($url);
\nusleep(20000);
\n\/\/XML\u3092\u89e3\u6790\u3057\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u30bb\u30c3\u30c8\u3059\u308b
\n$xml = simplexml_load_string($str);
\nusleep(20000);
\n\/\/xpath\u306b\u3088\u3063\u3066\uff64Item\u8981\u7d20\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059
\n$yado2 = $xml->hotels->hotel->roomInfo->dailyCharge->total;
\n$yado = $xml->hotels->hotel->hotelBasicInfo->hotelName;
\nusleep(200000);<\/p>\n

usleep(20000);
\n$hotelNo2 = $xml->xpath(‘hotels\/hotel\/hotelBasicInfo\/hotelNo’);
\nusleep(20000);
\nforeach($hotelNo2 as $hotelNo3)<\/p>\n

2021\u5e741\u670813\u65e5<\/strong><\/span><\/p>\n

\u30a8\u30e9\u30fc\u8868\u793a\u304c\u51fa\u305f\u306e\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3055\u308c\u308b\u5834\u5408\u306e\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002
\n\u5bbf\u306e\u767b\u9332\u756a\u53f7\u307e\u3067\u306f\u53d6\u5f97\u3067\u304d\u3066\u3044\u308b\u306e\u306b\u3001\u5bbf\u540d\u3068\u5bbf\u6cca\u8cbb\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3067\u304d\u3066\u3044\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/span><\/p>\n

2021\u5e741\u670820\u65e5<\/strong><\/span><\/p>\n

usleep\u306e\u6642\u9593\u3092\u5ef6\u9577\u3059\u308b\u3068\u3001\u30a8\u30e9\u30fc\u304c\u5168\u304f\u3067\u306a\u304f\u306a\u308a\u307e\u3057\u305f\u3002<\/span>
\n\u30d1\u30bd\u30b3\u30f3\u306e\u30b9\u30da\u30c3\u30af\u304c\u4e0a\u304c\u308b\u3068\u3001\u30c7\u30fc\u30bf\u51e6\u7406\u306e\u6642\u9593\u304c\u77ed\u304f\u306a\u308b\u306e\u3067\u3001usleep\u306e\u6642\u9593\u3092\u9577\u304f\u3057\u3066\u3082\u30b5\u30fc\u30d0\u30fc\u3067\u306ePHP\u306e\u51e6\u7406\u6642\u9593\u306e\u5236\u9650\u5185\u306b\u53ce\u3081\u308b\u4e8b\u304c\u3067\u304d\u308b\u306e\u3067\u3001\u3088\u308a\u5b89\u5b9a\u7684\u3057\u305f\u51e6\u7406\u304c\u53ef\u80fd\u306e\u3088\u3046\u3067\u3059\u3002<\/span><\/p>\n

2022\u5e749\u67087\u65e5<\/strong><\/span><\/p>\n

\u6700\u8fd1\u3001firefox\u306e\u8d77\u52d5\u6642\u306bXAMPP\u304c\u307e\u3060\u8d77\u52d5\u3057\u3066\u3044\u306a\u3044\u4e8b\u304c\u539f\u56e0\u3067\u30a2\u30af\u30bb\u30b9\u5148\u306b\u3064\u306a\u304c\u3089\u306a\u3044\u3068\u3044\u3046\u30c8\u30e9\u30d6\u30eb\u304c\u767a\u751f\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u304d\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u4e45\u3057\u3076\u308a\u306b\u3001\u3053\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u89e6\u308d\u3046\u3068\u601d\u3063\u305f\u3089\u3001\u3069\u3053\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u304b\u3082\u5fd8\u308c\u3066\u3044\u3066\u3001\u3059\u3054\u304f\u82e6\u52b4\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

c:xampp\/htdocs\/ \u3000\u3000\u306b\u3042\u308a\u307e\u3057\u305f\u3002<\/span><\/p>\n

\u30b9\u30bf\u30fc\u30c8\u30a2\u30c3\u30d7\u306b\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u9045\u5ef6\u8d77\u52d5\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb\u3092\u4fee\u6b63\u3057\u3001xampp-control\u306e\u8d77\u52d5\u309220\u79d2\u5f8c\u306b\u3001\u305d\u306e5\uff10\u79d2\u5f8c\u306bfirefox\u304c\u8d77\u52d5\u3059\u308b\u3088\u3046\u306b\u5909\u66f4\u3057\u307e\u3057\u305f\u3002<\/span><\/p>\n

@echo off
\n:\u9045\u5ef6\u8d77\u52d5\u30d0\u30c3\u30c1\u30d5\u30a1\u30a4\u30eb
\n:20\u79d2\u5f85\u3064
\ntimeout 20
\nstart “” “C:\\xampp\\xampp-control.exe”
\necho \u9045\u5ef6\u8d77\u52d5\u3092\u958b\u59cb\u3057\u307e\u3059\u3002
\n:50\u79d2\u5f85\u3064
\ntimeout 50
\n:\u30d7\u30ed\u30b0\u30e9\u30e0\u5b9f\u884c(\u30ab\u30ec\u30f3\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u6307\u5b9a\u306a\u3057)
\nstart “” “C:\\Program Files\\Mozilla Firefox\\firefox.exe”<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

2019\u5e743\u67083\u65e5 \u697d\u5929API\u3092\u5229\u7528\u3057\u3066\u5546\u54c1\u691c\u7d22\u3057\u3066\u8868\u793a\u3059\u308bPHP\u30d7\u30ed\u30b0\u30e9\u30e0\u304c\u52d5\u4f5c\u3057\u305f\u306e\u3067\u3001\u30a2\u30d5\u30a3\u30ea\u30a8\u30a4\u30c8\u306b\u3082\u5f79\u7acb\u3066\u3088\u3046\u3068\u3001\u697d\u5929API\u3092\u5229\u7528\u3057\u305f\u5bbf\u6cca\u60c5\u5831\u306e\u8868\u793a\u306b\u30c8\u30e9\u30a4\u3059\u308b\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002 \u697d\u5929API\u306e\u4e00\u89a7\u3067\u4f7f\u3044\u305f\u3044API […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[48,17,19],"tags":[],"class_list":["post-19634","post","type-post","status-publish","format-standard","hentry","category-php","category-17","category-19"],"_links":{"self":[{"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=\/wp\/v2\/posts\/19634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19634"}],"version-history":[{"count":181,"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=\/wp\/v2\/posts\/19634\/revisions"}],"predecessor-version":[{"id":24080,"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=\/wp\/v2\/posts\/19634\/revisions\/24080"}],"wp:attachment":[{"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kimassi.net\/zak\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}