{"id":2087,"date":"2021-12-22T14:24:56","date_gmt":"2021-12-22T05:24:56","guid":{"rendered":"https:\/\/astcconline.com\/?p=2087"},"modified":"2022-01-20T13:31:41","modified_gmt":"2022-01-20T04:31:41","slug":"en-server-note1","status":"publish","type":"post","link":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/2087\/en-server-note1\/","title":{"rendered":"Creation of PHP for adsense random display"},"content":{"rendered":"

Created PHP for adsense random display.<\/p>\n

There was also a plug-in, but it was troublesome to set up and it was a paid option, so<\/p>\n

But after all, I wanted to make it with PHP for the first time in a while. Is big.<\/p>\n

With the previous feeling, I feel that the connection of mysql is easier.<\/p>\n

Object type, procedural type, I’m not sure, but there are few reference examples of procedural type.<\/p>\n

This handling is procedural type, I only understand this, I can not understand<\/p>\n

1. DB connection
\n$link = mysqli_connect(‘localhost’, ‘USER’, ‘PASSWORD’, ‘DBNAME’);<\/p>\n

2, character set
\nmysqli_set_charset($link, “utf8mb4”);<\/p>\n

3. SQL inquiry
\n$sql = “SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;”;<\/p>\n

4, actually throw
\n$result = mysqli_query($link, $sql);<\/p>\n

5, result acquisition
\nThis command didn’t come out easily, half forcibly.
\nI don’t know what the associative array is<\/p>\n

$row = mysqli_fetch_assoc($result);<\/p>\n

6. Get results
\n$hyouzimei = $row[‘hyouzimei’];
\n$mozi = $row[‘mozi’];<\/p>\n

I wonder what happens if there are multiple lines, this time I specify one line so I do not care
\nYou may be in trouble in the future.<\/p>\n

I will post the file for the time being.
\nCreating a database is troublesome, so explanations are omitted this time.<\/p>\n

PHP file
\nad_random_php<\/a><\/p>\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
\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
\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
\nBelow PHP file
\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
\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
\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>\n

*\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n

$ad_size_A = 0;
\nif(strcmp($ad_size, “\u6307\u5b9a\u306a\u3057”) == 0){
\n\t$ad_sizeA = 1;
\n}
\nelse if(strcmp($ad_size, “\u7e26\u9577\u5c0f”) == 0){
\n\t$ad_size_A = 10;
\n}
\nelse if(strcmp($ad_size, “\u7e26\u9577\u4e2d”) == 0){
\n\t$ad_size_A = 11;
\n}
\nelse if(strcmp($ad_size, “\u7e26\u9577\u5927”) == 0){
\n\t$ad_size_A = 12;
\n}
\nelse if(strcmp($ad_size, “\u6a2a\u9577\u5c0f”) == 0){
\n\t$ad_size_A = 20;
\n}
\nelse if(strcmp($ad_size, “\u6a2a\u9577\u4e2d”) == 0){
\n\t$ad_size_A = 21;
\n}
\nelse if(strcmp($ad_size, “\u6a2a\u9577\u5927”) == 0){
\n\t$ad_size_A = 22;
\n}
\nelse if(strcmp($ad_size, “\u30b9\u30af\u30a8\u30a2\u5c0f”) == 0){
\n\t$ad_size_A = 30;
\n}
\nelse if(strcmp($ad_size, “\u30b9\u30af\u30a8\u30a2\u4e2d”) == 0){
\n\t$ad_size_A = 31;
\n}
\nelse if(strcmp($ad_size, “\u30b9\u30af\u30a8\u30a2\u5927”) == 0){
\n\t$ad_size_A = 32;
\n}
\nelse{
\n\t$ad_size_A = 99;
\n}
\n\/\/print $ad_size.”=”.$ad_size_A.”
“;<\/p>\n

\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n

$ad_syurui_A = 0;
\nif(strcmp($ad_syurui, “\u30af\u30ea\u30c3\u30af\u578b”) == 0){
\n\t$ad_syurui_A = 1;
\n}
\nelse if(strcmp($ad_syurui, “\u5831\u916c\u578b”) == 0){
\n\t$ad_syurui_A = 2;
\n}
\nelse{
\n\t$ad_syurui_A = 99;
\n}
\n\/\/print $ad_syurui.”=”.$ad_syurui_A.”
“;<\/p>\n

\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n

$ad_tagu_A = 0;
\nif(strcmp($ad_tagu, “\u6307\u5b9a\u306a\u3057”) == 0){
\n\t$ad_tagu_A = 1;
\n}
\nelse if(strcmp($ad_tagu, “\uff25\uff21”) == 0){
\n\t$ad_tagu_A = 10;
\n}
\nelse if(strcmp($ad_tagu, “\u81ea\u5b85\u30b5\u30fc\u30d0\u30fc”) == 0){
\n\t$ad_tagu_A = 11;
\n}
\nelse if(strcmp($ad_tagu, “\u30b7\u30e7\u30c3\u30d4\u30f3\u30b0\u30b5\u30a4\u30c8”) == 0){
\n\t$ad_tagu_A = 12;
\n}
\nelse if(strcmp($ad_tagu, “\u96d1\u8a18”) == 0){
\n\t$ad_tagu_A = 13;
\n}
\nelse if(strcmp($ad_tagu, “\uff26\uff38”) == 0){
\n\t$ad_tagu_A = 14;
\n}
\nelse if(strcmp($ad_tagu, “English”) == 0){
\n\t$ad_tagu_A = 50;
\n}
\nelse if(strcmp($ad_tagu, “English-EA”) == 0){
\n\t$ad_tagu_A = 51;
\n}
\nelse if(strcmp($ad_tagu, “English-Notes”) == 0){
\n\t$ad_tagu_A = 52;
\n}
\nelse{
\n\t$ad_tagu_A = 99;
\n}
\n\/\/print $ad_tagu.”=”.$ad_tagu_A.”
“;<\/p>\n

\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n

$ad_debaisu_A = 0;
\nif(strcmp($ad_debaisu, “\u6307\u5b9a\u306a\u3057”) == 0){
\n\t$ad_debaisu_A = 1;
\n}
\nelse if(strcmp($ad_debaisu, “\u30d1\u30bd\u30b3\u30f3”) == 0){
\n\t$ad_debaisu_A = 2;
\n}
\nelse if(strcmp($ad_debaisu, “\u30bf\u30d6\u30ec\u30c3\u30c8”) == 0){
\n\t$ad_debaisu_A = 3;
\n}
\nelse if(strcmp($ad_debaisu, “\u30b9\u30de\u30db”) == 0){
\n\t$ad_debaisu_A = 4;
\n}
\nelse{
\n\t$ad_debaisu_A = 99;
\n}
\n\/\/print $ad_debaisu.”=”.$ad_debaisu_A.”
“;<\/p>\n

\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n

$link = mysqli_connect(‘localhost’, ‘USER’, ‘PASSWORD’, ‘DBNAME’);<\/p>\n

mysqli_set_charset($link, “utf8mb4”);<\/p>\n

\/*
\nif(!$link){
\n\tdie(“\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3067\u304d\u307e\u305b\u3093:” . mysqli_connect_error() . “\\n”);
\n}
\nelse{
\n\techo “\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u63a5\u7d9a\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002\\n”;
\n}
\n*\/<\/p>\n

if($ad_size_A == 99 AND $ad_syurui_A == 99 AND $ad_tagu_A == 99 AND $ad_debaisu_A == 99){
\n\t\/\/\u6307\u5b9a\u306a\u3057\u3067\u51fa\u529b\u3059\u308b
\n\t$sql = “SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;”;
\n}
\nelse{
\n\t$sql = “SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random WHERE “;<\/p>\n

\t$sql_A=””;
\n\tif($ad_size_A == 99){
\n\t\t$sql_A = “”;
\n\t}
\n\telse{
\n\t\t$sql_A = “ookisa = $ad_size_A”;
\n\t}<\/p>\n

\tif($ad_syurui_A == 99){
\n\t\t\/\/$sql_A = “”;
\n\t}
\n\telse{
\n\t\tif($sql_A == “”){
\n\t\t\t$sql_A = “ad_syurui = $ad_syurui_A”;
\n\t\t}
\n\t\telse{
\n\t\t\t$sql_A = $sql_A.” AND “.”ad_syurui = $ad_syurui_A”;
\n\t\t}
\n\t}<\/p>\n

\tif($ad_tagu_A == 99){
\n\t\t\/\/$sql_A = “”;
\n\t}
\n\telse{
\n\t\tif($sql_A == “”){
\n\t\t\t$sql_A = “tagu = $ad_tagu_A”;
\n\t\t}
\n\t\telse{
\n\t\t\t$sql_A = $sql_A.” AND “.”tagu = $ad_tagu_A”;
\n\t\t}
\n\t}<\/p>\n

\tif($ad_debaisu__A == 99){
\n\t\t$ad_debaisu__B = “”;
\n\t}
\n\telse{
\n\t\tif($sql_A == “”){
\n\t\t\t$sql_A = “debaisu = $ad_debaisu_A”;
\n\t\t}
\n\t\telse{
\n\t\t\t$sql_A = $sql_A.” AND “.”debaisu = $ad_debaisu_A”;
\n\t\t}
\n\t}<\/p>\n

\t$sql = $sql.$sql_A.” ORDER BY RAND() LIMIT 1;”;
\n}<\/p>\n

\/\/$sql = “SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;”;
\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;”;<\/p>\n

\/\/print $sql.”<\/p>\n

“;<\/p>\n

$result = mysqli_query($link, $sql);
\n$row = mysqli_fetch_assoc($result);
\nif($result->num_rows == 1){
\n\t\/\/echo “ok<\/p>\n

“;
\n}
\nelse{
\n\t\/\/echo “no<\/p>\n

“;
\n\t$sql = “SELECT * FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;”;
\n\t$result = mysqli_query($link, $sql);
\n\t$row = mysqli_fetch_assoc($result);
\n}<\/p>\n

$hyouzimei = “alt=”.”\\””.$row[‘hyouzimei’].”\\””;
\n$mozi = $row[‘mozi’];
\n$mozi = str_replace(“\u2606”, $hyouzimei, $mozi);
\n$mozi = “<\/p>\n

“.$mozi.”<\/div>\n

“;<\/p>\n

\/\/print ‘hyouzimei’.”=”.$row[‘hyouzimei’].”<\/p>\n

“.’mozi’.”=”.$mozi.”<\/p>\n

“;<\/p>\n

print $mozi;<\/p>\n

mysqli_close($link);<\/p>\n

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

Created PHP for adsense random display. There was also a plug-in, but it was troublesome to set up and it was […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-2087","post","type-post","status-publish","format-standard","hentry","category-english-page-notes"],"_links":{"self":[{"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/posts\/2087","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=2087"}],"version-history":[{"count":0,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/posts\/2087\/revisions"}],"wp:attachment":[{"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/media?parent=2087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/categories?post=2087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kerotto.mydns.jp\/kerotto_mydns_jp\/wp-json\/wp\/v2\/tags?post=2087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}