{"id":17,"date":"2011-02-10T00:46:04","date_gmt":"2011-02-09T15:46:04","guid":{"rendered":"http:\/\/inage.happystamp.jp\/?page_id=17"},"modified":"2013-06-03T15:20:44","modified_gmt":"2013-06-03T06:20:44","slug":"%e8%a9%a6%e5%90%88%e7%b5%90%e6%9e%9c","status":"publish","type":"page","link":"http:\/\/inage.happystamp.jp\/?page_id=17","title":{"rendered":"\u8a66\u5408\u7d50\u679c"},"content":{"rendered":"<p><?php\n$old_id = 0; \/\/taikai_id\u306e\u6bd4\u8f03\u7528\u30d1\u30e9\u30e1\u30fc\u30bf\n$cnt = 0;\n\n$list = \"<center><\/p>\n<div class='result'>&#8220;;<\/p>\n<p>$conn = mysql_connect(&#8216;mysql31.heteml.jp&#8217;,&#8217;_inage2&#8242;,&#8217;tade2212&#8242;) or die(mysql_error());<br \/>\nmysql_select_db(&#8216;_inage2&#8217;) or die(mysql_error());<\/p>\n<p>$sql = &#8220;select * from taikai, result where taikai.id = result.taikai_id order by taikai.date desc;&#8221;;<br \/>\n$res = mysql_query($sql) or die(mysql_error());<br \/>\nwhile($row = mysql_fetch_assoc($res)){<br \/>\n\tif($row[taikai_id] != $old_id){<br \/>\n\t\t$old_id = $row[taikai_id];<br \/>\n\t\tif( $cnt =! 0 )<br \/>\n\t\t{<br \/>\n\t\t\t$list .= &#8220;<\/table>\n<p>&#8220;;<br \/>\n\t\t\t$cnt++;<br \/>\n\t\t}<\/p>\n<p>\t\t$list .= &#8220;<\/p>\n<table width=80%>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/p>\n<tr>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/p>\n<td colspan=3 width=50% style='background:black;color:white;text-align:center;'>&#8220;.$row[date].&#8221;<\/td>\n<p>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/p>\n<td colspan=3 width=50% style='background:black;color:white;text-align:center;'>&#8220;.$row[event].&#8221;<\/td>\n<p>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/tr>\n<p>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/p>\n<tr>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/p>\n<td colspan=3 width=50% style='background:white;text-align:center;'>&#8220;.$row[result].&#8221;<\/td>\n<p>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/p>\n<td colspan=3 width=50% style='background:white;text-align:center;'>&#8220;.$row[win].&#8221; \u52dd &#8220;.$row[rose].&#8221; \u6557 &#8220;.$row[draw].&#8221; \u5206<\/td>\n<p>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/tr>\n<p>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/p>\n<tr>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/p>\n<td colspan=6>\n<p>&#8220;.$row[comment].&#8221;<\/p>\n<\/td>\n<p>&#8220;;<br \/>\n\t\t$list .= &#8220;<\/tr>\n<p>&#8220;;<br \/>\n\t}<\/p>\n<p>        if( $row[mark] == 1 ) $mark_text =&#8221;\u25cb&#8221;;<br \/>\n        elseif( $row[mark] == 2 ) $mark_text =&#8221;\u25cf&#8221;;<br \/>\n        else $mark_text =&#8221;\u25b3&#8221;;<\/p>\n<p>\t$list .= &#8220;<\/p>\n<tr>&#8220;;<br \/>\n\t$list .= &#8220;<\/p>\n<td colspan=3 width=50%>&#8220;.$row[&#8216;opponent&#8217;].&#8221;<\/td>\n<td colspan=2 style='background:white;text-align:center;'>&#8220;.$row[&#8216;goal&#8217;].&#8221; &#8211; &#8220;.$row[&#8216;lost&#8217;].&#8221;<\/td>\n<td style='background:white;text-align:center;'>&#8220;.$mark_text.&#8221;<\/td>\n<p>&#8220;;<br \/>\n\t$list .= &#8220;<\/tr>\n<p>&#8220;;<br \/>\n}<br \/>\n$list .= &#8220;<\/table>\n<p>&#8220;;<br \/>\n$list .= &#8220;<\/p><\/div>\n<p><\/center>&#8220;;<br \/>\necho $list;<\/p>\n<p>?><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/pages\/17"}],"collection":[{"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17"}],"version-history":[{"count":54,"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/pages\/17\/revisions"}],"predecessor-version":[{"id":2890,"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=\/wp\/v2\/pages\/17\/revisions\/2890"}],"wp:attachment":[{"href":"http:\/\/inage.happystamp.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}