adsense ランダム表示用　PHPの作成

adsense ランダム表示用　PHPの作成した。

プラグインもあったのだが、設定が面倒なのと、有料オプションだったりで、

でもやっぱり、久々にＰＨＰで、作ってみたかった。ってのが大きい。

前までの感覚だと、mysqlの接続が、もっとかんたんだった気がする。

オブジェクト型、手続き型、よくわからないが、手続き型の参考例が少ない。

今回の取り回しは、手続き型　これしかわからない　理解できない

１、
DB接続
$link = mysqli_connect(‘localhost’, ‘USER’, ‘PASSWORD’, ‘DBNAME’);

２、文字セット
mysqli_set_charset($link, “utf8mb4”);

３、SQL問い合わせ
$sql = “SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;”;

４、実際投げる
$result = mysqli_query($link, $sql);

５、結果取得
このコマンドがなかなか出てこなかった、半分無理やり。
連想配列がどうのと、意味わからん
$row = mysqli_fetch_assoc($result);

６、結果取得
$hyouzimei = $row[‘hyouzimei’];
$mozi = $row[‘mozi’];

複数行だとどうなるのだろう、今回は１行指定なので気にしていないのだが
今後、困ることがあるかもしれん。

一応ファイル載せておきます。
データベースの作りなどは、面倒なので今回は説明は省略。

PHPファイル
ad_random_php

＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
以下PHPファイル
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊

*/
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////

$ad_size_A = 0;
if(strcmp($ad_size, “指定なし”) == 0){
$ad_sizeA = 1;
}
else if(strcmp($ad_size, “縦長小”) == 0){
$ad_size_A = 10;
}
else if(strcmp($ad_size, “縦長中”) == 0){
$ad_size_A = 11;
}
else if(strcmp($ad_size, “縦長大”) == 0){
$ad_size_A = 12;
}
else if(strcmp($ad_size, “横長小”) == 0){
$ad_size_A = 20;
}
else if(strcmp($ad_size, “横長中”) == 0){
$ad_size_A = 21;
}
else if(strcmp($ad_size, “横長大”) == 0){
$ad_size_A = 22;
}
else if(strcmp($ad_size, “スクエア小”) == 0){
$ad_size_A = 30;
}
else if(strcmp($ad_size, “スクエア中”) == 0){
$ad_size_A = 31;
}
else if(strcmp($ad_size, “スクエア大”) == 0){
$ad_size_A = 32;
}
else{
$ad_size_A = 99;
}
//print $ad_size.”=”.$ad_size_A.”
“;

////////////////////////////////////////////////////////
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////

$ad_syurui_A = 0;
if(strcmp($ad_syurui, “クリック型”) == 0){
$ad_syurui_A = 1;
}
else if(strcmp($ad_syurui, “報酬型”) == 0){
$ad_syurui_A = 2;
}
else{
$ad_syurui_A = 99;
}
//print $ad_syurui.”=”.$ad_syurui_A.”
“;

////////////////////////////////////////////////////////
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////

$ad_tagu_A = 0;
if(strcmp($ad_tagu, “指定なし”) == 0){
$ad_tagu_A = 1;
}
else if(strcmp($ad_tagu, “ＥＡ”) == 0){
$ad_tagu_A = 10;
}
else if(strcmp($ad_tagu, “自宅サーバー”) == 0){
$ad_tagu_A = 11;
}
else if(strcmp($ad_tagu, “ショッピングサイト”) == 0){
$ad_tagu_A = 12;
}
else if(strcmp($ad_tagu, “雑記”) == 0){
$ad_tagu_A = 13;
}
else if(strcmp($ad_tagu, “ＦＸ”) == 0){
$ad_tagu_A = 14;
}
else if(strcmp($ad_tagu, “English”) == 0){
$ad_tagu_A = 50;
}
else if(strcmp($ad_tagu, “English-EA”) == 0){
$ad_tagu_A = 51;
}
else if(strcmp($ad_tagu, “English-Notes”) == 0){
$ad_tagu_A = 52;
}
else{
$ad_tagu_A = 99;
}
//print $ad_tagu.”=”.$ad_tagu_A.”
“;

////////////////////////////////////////////////////////
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////

$ad_debaisu_A = 0;
if(strcmp($ad_debaisu, “指定なし”) == 0){
$ad_debaisu_A = 1;
}
else if(strcmp($ad_debaisu, “パソコン”) == 0){
$ad_debaisu_A = 2;
}
else if(strcmp($ad_debaisu, “タブレット”) == 0){
$ad_debaisu_A = 3;
}
else if(strcmp($ad_debaisu, “スマホ”) == 0){
$ad_debaisu_A = 4;
}
else{
$ad_debaisu_A = 99;
}
//print $ad_debaisu.”=”.$ad_debaisu_A.”
“;

////////////////////////////////////////////////////////
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////

$link = mysqli_connect(‘localhost’, ‘USER’, ‘PASSWORD’, ‘DBNAME’);

mysqli_set_charset($link, “utf8mb4”);

/*
if(!$link){
die(“データベースに接続できません:” . mysqli_connect_error() . “\n”);
}
else{
echo “データベースの接続に成功しました。\n”;
}
*/

if($ad_size_A == 99 AND $ad_syurui_A == 99 AND $ad_tagu_A == 99 AND $ad_debaisu_A == 99){
//指定なしで出力する
$sql = “SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;”;
}
else{
$sql = “SELECT hyouzimei, mozi FROM wp_astcc_blog_ad_random WHERE “;

$sql_A=””;
if($ad_size_A == 99){
$sql_A = “”;
}
else{
$sql_A = “ookisa = $ad_size_A”;
}

if($ad_syurui_A == 99){
//$sql_A = “”;
}
else{
if($sql_A == “”){
$sql_A = “ad_syurui = $ad_syurui_A”;
}
else{
$sql_A = $sql_A.” AND “.”ad_syurui = $ad_syurui_A”;
}
}

if($ad_tagu_A == 99){
//$sql_A = “”;
}
else{
if($sql_A == “”){
$sql_A = “tagu = $ad_tagu_A”;
}
else{
$sql_A = $sql_A.” AND “.”tagu = $ad_tagu_A”;
}
}

if($ad_debaisu__A == 99){
$ad_debaisu__B = “”;
}
else{
if($sql_A == “”){
$sql_A = “debaisu = $ad_debaisu_A”;
}
else{
$sql_A = $sql_A.” AND “.”debaisu = $ad_debaisu_A”;
}
}

$sql = $sql.$sql_A.” ORDER BY RAND() LIMIT 1;”;
}

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

//print $sql.”

“;

$result = mysqli_query($link, $sql);
$row = mysqli_fetch_assoc($result);
if($result->num_rows == 1){
//echo “ok

“;
}
else{
//echo “no

“;
$sql = “SELECT * FROM wp_astcc_blog_ad_random ORDER BY RAND() LIMIT 1;”;
$result = mysqli_query($link, $sql);
$row = mysqli_fetch_assoc($result);
}

$hyouzimei = “alt=”.”\””.$row[‘hyouzimei’].”\””;
$mozi = $row[‘mozi’];
$mozi = str_replace(“☆”, $hyouzimei, $mozi);
$mozi = “

“;

//print ‘hyouzimei’.”=”.$row[‘hyouzimei’].”

“.’mozi’.”=”.$mozi.”

“;

print $mozi;

mysqli_close($link);

?>