{"id":1897,"date":"2021-12-17T17:13:06","date_gmt":"2021-12-17T08:13:06","guid":{"rendered":"https:\/\/astcconline.com\/?p=1897"},"modified":"2022-01-26T04:08:00","modified_gmt":"2022-01-25T19:08:00","slug":"adsense-%e3%83%a9%e3%83%b3%e3%83%80%e3%83%a0%e8%a1%a8%e7%a4%ba%e7%94%a8%e3%80%80php%e3%81%ae%e4%bd%9c%e6%88%90","status":"publish","type":"post","link":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/1897\/adsense-%e3%83%a9%e3%83%b3%e3%83%80%e3%83%a0%e8%a1%a8%e7%a4%ba%e7%94%a8%e3%80%80php%e3%81%ae%e4%bd%9c%e6%88%90\/","title":{"rendered":"adsense \u30e9\u30f3\u30c0\u30e0\u8868\u793a\u7528\u3000PHP\u306e\u4f5c\u6210"},"content":{"rendered":"<p>adsense \u30e9\u30f3\u30c0\u30e0\u8868\u793a\u7528\u3000PHP\u306e\u4f5c\u6210\u3057\u305f\u3002<\/p>\n<p>\u30d7\u30e9\u30b0\u30a4\u30f3\u3082\u3042\u3063\u305f\u306e\u3060\u304c\u3001\u8a2d\u5b9a\u304c\u9762\u5012\u306a\u306e\u3068\u3001\u6709\u6599\u30aa\u30d7\u30b7\u30e7\u30f3\u3060\u3063\u305f\u308a\u3067\u3001<\/p>\n<p>\u3067\u3082\u3084\u3063\u3071\u308a\u3001\u4e45\u3005\u306b\uff30\uff28\uff30\u3067\u3001\u4f5c\u3063\u3066\u307f\u305f\u304b\u3063\u305f\u3002\u3063\u3066\u306e\u304c\u5927\u304d\u3044\u3002<\/p>\n<p>\u524d\u307e\u3067\u306e\u611f\u899a\u3060\u3068\u3001mysql\u306e\u63a5\u7d9a\u304c\u3001\u3082\u3063\u3068\u304b\u3093\u305f\u3093\u3060\u3063\u305f\u6c17\u304c\u3059\u308b\u3002<\/p>\n<p>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u578b\u3001\u624b\u7d9a\u304d\u578b\u3001\u3088\u304f\u308f\u304b\u3089\u306a\u3044\u304c\u3001\u624b\u7d9a\u304d\u578b\u306e\u53c2\u8003\u4f8b\u304c\u5c11\u306a\u3044\u3002<\/p>\n<p>\u4eca\u56de\u306e\u53d6\u308a\u56de\u3057\u306f\u3001\u624b\u7d9a\u304d\u578b\u3000\u3053\u308c\u3057\u304b\u308f\u304b\u3089\u306a\u3044\u3000\u7406\u89e3\u3067\u304d\u306a\u3044<\/p>\n<p>\uff11\u3001<br \/>\nDB\u63a5\u7d9a<br \/>\n$link = mysqli_connect(&#8216;localhost&#8217;, &#8216;USER&#8217;, &#8216;PASSWORD&#8217;, &#8216;DBNAME&#8217;);<\/p>\n<p>\uff12\u3001\u6587\u5b57\u30bb\u30c3\u30c8<br \/>\nmysqli_set_charset($link, &#8220;utf8mb4&#8221;);<\/p>\n<p>\uff13\u3001SQL\u554f\u3044\u5408\u308f\u305b<br \/>\n$sql = &#8220;SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;&#8221;;<\/p>\n<p>\uff14\u3001\u5b9f\u969b\u6295\u3052\u308b<br \/>\n$result = mysqli_query($link, $sql);<\/p>\n<p>\uff15\u3001\u7d50\u679c\u53d6\u5f97<br \/>\n\u3053\u306e\u30b3\u30de\u30f3\u30c9\u304c\u306a\u304b\u306a\u304b\u51fa\u3066\u3053\u306a\u304b\u3063\u305f\u3001\u534a\u5206\u7121\u7406\u3084\u308a\u3002<br \/>\n\u9023\u60f3\u914d\u5217\u304c\u3069\u3046\u306e\u3068\u3001\u610f\u5473\u308f\u304b\u3089\u3093<br \/>\n$row = mysqli_fetch_assoc($result);<\/p>\n<p>\uff16\u3001\u7d50\u679c\u53d6\u5f97<br \/>\n$hyouzimei = $row[&#8216;hyouzimei&#8217;];<br \/>\n$mozi = $row[&#8216;mozi&#8217;];<\/p>\n<p>\u8907\u6570\u884c\u3060\u3068\u3069\u3046\u306a\u308b\u306e\u3060\u308d\u3046\u3001\u4eca\u56de\u306f\uff11\u884c\u6307\u5b9a\u306a\u306e\u3067\u6c17\u306b\u3057\u3066\u3044\u306a\u3044\u306e\u3060\u304c<br \/>\n\u4eca\u5f8c\u3001\u56f0\u308b\u3053\u3068\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u3093\u3002<\/p>\n<p>\u4e00\u5fdc\u30d5\u30a1\u30a4\u30eb\u8f09\u305b\u3066\u304a\u304d\u307e\u3059\u3002<br \/>\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u308a\u306a\u3069\u306f\u3001\u9762\u5012\u306a\u306e\u3067\u4eca\u56de\u306f\u8aac\u660e\u306f\u7701\u7565\u3002<\/p>\n<p>PHP\u30d5\u30a1\u30a4\u30eb<br \/>\n<a href=\"http:\/\/kerotto.mydns.jp\/wp-content\/uploads\/2021\/12\/ad_random_php.php\">ad_random_php<\/a><\/p>\n<p>\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a<br \/>\n\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a<br \/>\n\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a<br \/>\n\u4ee5\u4e0bPHP\u30d5\u30a1\u30a4\u30eb<br \/>\n\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a<br \/>\n\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a<br \/>\n\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a<\/p>\n<p><?php\n\/\/print \"product:\";\n\/\/print $_SERVER[\"DOCUMENT_ROOT\"].\"\/wp-content\/ad_random_php\/ad_random_php.php\";\n\n\n\n\/* \u3053\u306e\u6587\u5b57\u5217\u3092\u3001\u30d6\u30ed\u30c3\u30af\u306b\u8ffd\u52a0\u3059\u308b\n\n\n<?php\n$ad_size='\u7e26\u9577\u5927';$ad_syurui='\u30af\u30ea\u30c3\u30af\u578b';$ad_tagu='\u6307\u5b9a\u306a\u3057';$ad_debaisu='\u6307\u5b9a\u306a\u3057';\nrequire $_SERVER[\"DOCUMENT_ROOT\"].\"\/wp-content\/ad_random_php\/ad_random_php.php\";\n?><\/p>\n<p>*\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n<p>$ad_size_A = 0;<br \/>\nif(strcmp($ad_size, &#8220;\u6307\u5b9a\u306a\u3057&#8221;) == 0){<br \/>\n\t$ad_sizeA = 1;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u7e26\u9577\u5c0f&#8221;) == 0){<br \/>\n\t$ad_size_A = 10;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u7e26\u9577\u4e2d&#8221;) == 0){<br \/>\n\t$ad_size_A = 11;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u7e26\u9577\u5927&#8221;) == 0){<br \/>\n\t$ad_size_A = 12;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u6a2a\u9577\u5c0f&#8221;) == 0){<br \/>\n\t$ad_size_A = 20;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u6a2a\u9577\u4e2d&#8221;) == 0){<br \/>\n\t$ad_size_A = 21;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u6a2a\u9577\u5927&#8221;) == 0){<br \/>\n\t$ad_size_A = 22;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u30b9\u30af\u30a8\u30a2\u5c0f&#8221;) == 0){<br \/>\n\t$ad_size_A = 30;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u30b9\u30af\u30a8\u30a2\u4e2d&#8221;) == 0){<br \/>\n\t$ad_size_A = 31;<br \/>\n}<br \/>\nelse if(strcmp($ad_size, &#8220;\u30b9\u30af\u30a8\u30a2\u5927&#8221;) == 0){<br \/>\n\t$ad_size_A = 32;<br \/>\n}<br \/>\nelse{<br \/>\n\t$ad_size_A = 99;<br \/>\n}<br \/>\n\/\/print $ad_size.&#8221;=&#8221;.$ad_size_A.&#8221;<br \/>&#8220;;<\/p>\n<p>\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n<p>$ad_syurui_A = 0;<br \/>\nif(strcmp($ad_syurui, &#8220;\u30af\u30ea\u30c3\u30af\u578b&#8221;) == 0){<br \/>\n\t$ad_syurui_A = 1;<br \/>\n}<br \/>\nelse if(strcmp($ad_syurui, &#8220;\u5831\u916c\u578b&#8221;) == 0){<br \/>\n\t$ad_syurui_A = 2;<br \/>\n}<br \/>\nelse{<br \/>\n\t$ad_syurui_A = 99;<br \/>\n}<br \/>\n\/\/print $ad_syurui.&#8221;=&#8221;.$ad_syurui_A.&#8221;<br \/>&#8220;;<\/p>\n<p>\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n<p>$ad_tagu_A = 0;<br \/>\nif(strcmp($ad_tagu, &#8220;\u6307\u5b9a\u306a\u3057&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 1;<br \/>\n}<br \/>\nelse if(strcmp($ad_tagu, &#8220;\uff25\uff21&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 10;<br \/>\n}<br \/>\nelse if(strcmp($ad_tagu, &#8220;\u81ea\u5b85\u30b5\u30fc\u30d0\u30fc&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 11;<br \/>\n}<br \/>\nelse if(strcmp($ad_tagu, &#8220;\u30b7\u30e7\u30c3\u30d4\u30f3\u30b0\u30b5\u30a4\u30c8&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 12;<br \/>\n}<br \/>\nelse if(strcmp($ad_tagu, &#8220;\u96d1\u8a18&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 13;<br \/>\n}<br \/>\nelse if(strcmp($ad_tagu, &#8220;\uff26\uff38&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 14;<br \/>\n}<br \/>\nelse if(strcmp($ad_tagu, &#8220;English&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 50;<br \/>\n}<br \/>\nelse if(strcmp($ad_tagu, &#8220;English-EA&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 51;<br \/>\n}<br \/>\nelse if(strcmp($ad_tagu, &#8220;English-Notes&#8221;) == 0){<br \/>\n\t$ad_tagu_A = 52;<br \/>\n}<br \/>\nelse{<br \/>\n\t$ad_tagu_A = 99;<br \/>\n}<br \/>\n\/\/print $ad_tagu.&#8221;=&#8221;.$ad_tagu_A.&#8221;<br \/>&#8220;;<\/p>\n<p>\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n<p>$ad_debaisu_A = 0;<br \/>\nif(strcmp($ad_debaisu, &#8220;\u6307\u5b9a\u306a\u3057&#8221;) == 0){<br \/>\n\t$ad_debaisu_A = 1;<br \/>\n}<br \/>\nelse if(strcmp($ad_debaisu, &#8220;\u30d1\u30bd\u30b3\u30f3&#8221;) == 0){<br \/>\n\t$ad_debaisu_A = 2;<br \/>\n}<br \/>\nelse if(strcmp($ad_debaisu, &#8220;\u30bf\u30d6\u30ec\u30c3\u30c8&#8221;) == 0){<br \/>\n\t$ad_debaisu_A = 3;<br \/>\n}<br \/>\nelse if(strcmp($ad_debaisu, &#8220;\u30b9\u30de\u30db&#8221;) == 0){<br \/>\n\t$ad_debaisu_A = 4;<br \/>\n}<br \/>\nelse{<br \/>\n\t$ad_debaisu_A = 99;<br \/>\n}<br \/>\n\/\/print $ad_debaisu.&#8221;=&#8221;.$ad_debaisu_A.&#8221;<br \/>&#8220;;<\/p>\n<p>\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n<p>$link = mysqli_connect(&#8216;localhost&#8217;, &#8216;USER&#8217;, &#8216;PASSWORD&#8217;, &#8216;DBNAME&#8217;);<\/p>\n<p>mysqli_set_charset($link, &#8220;utf8mb4&#8221;);<\/p>\n<p>\/*<br \/>\nif(!$link){<br \/>\n\tdie(&#8220;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3067\u304d\u307e\u305b\u3093:&#8221; . mysqli_connect_error() . &#8220;\\n&#8221;);<br \/>\n}<br \/>\nelse{<br \/>\n\techo &#8220;\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u63a5\u7d9a\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002\\n&#8221;;<br \/>\n}<br \/>\n*\/<\/p>\n<p>if($ad_size_A == 99 AND $ad_syurui_A == 99 AND $ad_tagu_A == 99 AND $ad_debaisu_A == 99){<br \/>\n\t\/\/\u6307\u5b9a\u306a\u3057\u3067\u51fa\u529b\u3059\u308b<br \/>\n\t$sql = &#8220;SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;&#8221;;<br \/>\n}<br \/>\nelse{<br \/>\n\t$sql = &#8220;SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random WHERE &#8220;;<\/p>\n<p>\t$sql_A=&#8221;&#8221;;<br \/>\n\tif($ad_size_A == 99){<br \/>\n\t\t$sql_A = &#8220;&#8221;;<br \/>\n\t}<br \/>\n\telse{<br \/>\n\t\t$sql_A = &#8220;ookisa = $ad_size_A&#8221;;<br \/>\n\t}<\/p>\n<p>\tif($ad_syurui_A == 99){<br \/>\n\t\t\/\/$sql_A = &#8220;&#8221;;<br \/>\n\t}<br \/>\n\telse{<br \/>\n\t\tif($sql_A == &#8220;&#8221;){<br \/>\n\t\t\t$sql_A = &#8220;ad_syurui = $ad_syurui_A&#8221;;<br \/>\n\t\t}<br \/>\n\t\telse{<br \/>\n\t\t\t$sql_A = $sql_A.&#8221; AND &#8220;.&#8221;ad_syurui = $ad_syurui_A&#8221;;<br \/>\n\t\t}<br \/>\n\t}<\/p>\n<p>\tif($ad_tagu_A == 99){<br \/>\n\t\t\/\/$sql_A = &#8220;&#8221;;<br \/>\n\t}<br \/>\n\telse{<br \/>\n\t\tif($sql_A == &#8220;&#8221;){<br \/>\n\t\t\t$sql_A = &#8220;tagu = $ad_tagu_A&#8221;;<br \/>\n\t\t}<br \/>\n\t\telse{<br \/>\n\t\t\t$sql_A = $sql_A.&#8221; AND &#8220;.&#8221;tagu = $ad_tagu_A&#8221;;<br \/>\n\t\t}<br \/>\n\t}<\/p>\n<p>\tif($ad_debaisu__A == 99){<br \/>\n\t\t$ad_debaisu__B = &#8220;&#8221;;<br \/>\n\t}<br \/>\n\telse{<br \/>\n\t\tif($sql_A == &#8220;&#8221;){<br \/>\n\t\t\t$sql_A = &#8220;debaisu = $ad_debaisu_A&#8221;;<br \/>\n\t\t}<br \/>\n\t\telse{<br \/>\n\t\t\t$sql_A = $sql_A.&#8221; AND &#8220;.&#8221;debaisu = $ad_debaisu_A&#8221;;<br \/>\n\t\t}<br \/>\n\t}<\/p>\n<p>\t$sql = $sql.$sql_A.&#8221; ORDER BY RAND() LIMIT 1;&#8221;;<br \/>\n}<\/p>\n<p>\/\/$sql = &#8220;SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;&#8221;;<br \/>\n\/\/SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random  AND ad_syurui = $ad_syurui_A AND tagu = $ad_tagu_A AND debaisu = $ad_debaisu_A ORDER BY RAND() LIMIT 1;&#8221;;<\/p>\n<p>\/\/print $sql.&#8221;<\/p>\n<p>&#8220;;<\/p>\n<p>$result = mysqli_query($link, $sql);<br \/>\n$row = mysqli_fetch_assoc($result);<br \/>\nif($result->num_rows == 1){<br \/>\n\t\/\/echo &#8220;ok<\/p>\n<p>&#8220;;<br \/>\n}<br \/>\nelse{<br \/>\n\t\/\/echo &#8220;no<\/p>\n<p>&#8220;;<br \/>\n\t$sql = &#8220;SELECT * FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;&#8221;;<br \/>\n\t$result = mysqli_query($link, $sql);<br \/>\n\t$row = mysqli_fetch_assoc($result);<br \/>\n}<\/p>\n<p>$hyouzimei = &#8220;alt=&#8221;.&#8221;\\&#8221;&#8221;.$row[&#8216;hyouzimei&#8217;].&#8221;\\&#8221;&#8221;;<br \/>\n$mozi = $row[&#8216;mozi&#8217;];<br \/>\n$mozi = str_replace(&#8220;\u2606&#8221;, $hyouzimei, $mozi);<br \/>\n$mozi = &#8220;<\/p>\n<div style=\\\"text-align: center\\\">&#8220;.$mozi.&#8221;<\/div>\n<p>&#8220;;<\/p>\n<p>\/\/print &#8216;hyouzimei&#8217;.&#8221;=&#8221;.$row[&#8216;hyouzimei&#8217;].&#8221;<\/p>\n<p>&#8220;.&#8217;mozi&#8217;.&#8221;=&#8221;.$mozi.&#8221;<\/p>\n<p>&#8220;;<\/p>\n<p>print $mozi;<\/p>\n<p>mysqli_close($link);<\/p>\n<p>?><\/p>\n","protected":false},"excerpt":{"rendered":"<p>adsense \u30e9\u30f3\u30c0\u30e0\u8868\u793a\u7528\u3000PHP\u306e\u4f5c\u6210\u3057\u305f\u3002 \u30d7\u30e9\u30b0\u30a4\u30f3\u3082\u3042\u3063\u305f\u306e\u3060\u304c\u3001\u8a2d\u5b9a\u304c\u9762\u5012\u306a\u306e\u3068\u3001\u6709\u6599\u30aa\u30d7\u30b7\u30e7\u30f3\u3060\u3063\u305f\u308a\u3067\u3001 \u3067\u3082\u3084\u3063\u3071\u308a\u3001\u4e45\u3005\u306b\uff30\uff28\uff30\u3067\u3001\u4f5c\u3063\u3066\u307f\u305f\u304b\u3063\u305f\u3002\u3063\u3066\u306e\u304c\u5927\u304d\u3044\u3002 \u524d\u307e\u3067\u306e\u611f\u899a\u3060\u3068\u3001mysql\u306e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1897","post","type-post","status-publish","format-standard","hentry","category-server"],"_links":{"self":[{"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/posts\/1897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/comments?post=1897"}],"version-history":[{"count":1,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/posts\/1897\/revisions"}],"predecessor-version":[{"id":2383,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/posts\/1897\/revisions\/2383"}],"wp:attachment":[{"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/media?parent=1897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/categories?post=1897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/tags?post=1897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}