質問編集履歴

Wordpressのfunction.phpの中で、PHPファイルを呼び出す記述をしていますので、それを、掲載します。

2021/11/30 00:37

投稿

kimukimu009

スコア33

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -146,6 +146,32 @@
+WordPressのfunction.phpの中に、これを記述しています。
+//ショートコードを使ったphpファイルの呼び出し方法
+function my_php_Include($params = array()) {
+extract(shortcode_atts(array('file' => 'default'), $params));
+ob_start();
+include(STYLESHEETPATH . "/template-parts/$file.php");
+return ob_get_clean();
+}
+add_shortcode('myphp', 'my_php_Include');
 ```

ソースコードがややこしかったので、シンプルにしました。このコードで実行しても結果は期待はずれです。WordPress固定ページでは、ショートコードで、PHPファイルを読み出しています。では、

2021/11/30 00:36

投稿

kimukimu009

スコア33

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -76,75 +76,7 @@
  <meta charset="UTF-8">
- <title>抽選結果</title>
+ <title>結果</title>
- <meta name="viewport" content="width=device-width,initial-scale=1">
-<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
-<!-- Global site tag (gtag.js) - Google Analytics -->
-<script async src="https://www.googletagmanager.com/gtag/js?id=UA-130664081-1"></script>
-<script>
-  window.dataLayer = window.dataLayer || [];
-  function gtag(){dataLayer.push(arguments);}
-  gtag('js', new Date());
-  gtag('config', 'UA-1○○○-1');
-</script>
-<script>
-  window.addEventListener('message', function(e) {
-  var iframe = $("#parentframe");
-  var eventName = e.data[0];
-  var data = e.data[1];
-  switch(eventName) {
-      case 'setHeight':
-          iframe.height(data);
-          break;
-      }
-  }, false);
-</script>
-<link rel="preconnect" href="https://fonts.googleapis.com">
-<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
-<link href="https://fonts.googleapis.com/css2?family=MonteCarlo&family=Shippori+Mincho+B1&display=swap" rel="stylesheet">
-<style type="text/css">
-ここは割愛
-</style>
@@ -152,131 +84,23 @@
 <?php
-$shoppass = $_POST['prm1'];
+$shoppass="2014";
+$server = "○○○○";
+$userName = "○○○○";
+$password = "○○○○";
+$dbName = "○○○○";
-  //入力チェック
-  $errormsg = array();
-  //shoppass
-  if ($shoppass == null) {
-    $errormsg[] = "パスワードを入力してください。";
-  }
-  if ($shoppass != null){
-	$server = "○○○○";
-	$userName = "○○○○";
-	$password = "○○○○";
-	$dbName = "○○○○";
-	$mysqli = new mysqli($server, $userName, $password,$dbName);
+$mysqli = new mysqli($server, $userName, $password,$dbName);
-	if ($mysqli->connect_error){
-		echo $mysqli->connect_error;
-		exit();
-	}else{
-		$mysqli->set_charset("utf-8");
-	}
-    $sql = "SELECT * FROM  woma2 where pass = '" . $shoppass . "'";
-	$result = $mysqli -> query($sql);
-	//クエリー失敗
-	if(!$result) {
-		echo $mysqli->error;
-		exit();
-	}
- 	//レコード
-    $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
-  	$chusen_atari =$row["chusen_atari"];
-   if($row==0){
-   $errormsg[] = "パスワードが間違っています。<br><br>入力間違いの中で、<br>1(数字のいち）<br>l(小文字のエル)<br>i(小文字のアイ)<br><br>にご注意ください。";
-   }
-        }
-?>
-<?php if (count($errormsg) > 0): ?>
-<div id="errmsg">
-	ERROR<br />
-		<?php foreach ($errormsg as $msg): ?>
-  			<?=$msg?><br />
-		<?php endforeach; ?>
-</div>
-<?php else: ?>
-<?php
-	$server = "○○○○";
-	$userName = "○○○○";
-	$password = "○○○○";
-	$dbName = "○○○○";
-  $mysqli = new mysqli($server, $userName, $password,$dbName);
   if ($mysqli->connect_error){
@@ -298,57 +122,9 @@
+    $sql = "update woma2 set use_times = use_times+1 where pass = '" . $shoppass . "'";
-    $sql = "update woma2 set date_use_pass  =  '" . $now . "' where pass = '" . $shoppass . "'";
-     $result = $mysqli -> query($sql);
+	$result = $mysqli -> query($sql);
-//クエリー失敗
-  if(!$result) {
-    echo $mysqli->error;
-    exit();}
-	$server = "○○○○";
-	$userName = "○○○○";
-	$password = "○○○○";
-	$dbName = "○○○○";
-  $mysqli = new mysqli($server, $userName, $password,$dbName);
-  if ($mysqli->connect_error){
-    echo $mysqli->connect_error;
-    exit();
-  }else{
-    $mysqli->set_charset("utf-8");
-  }
-/////■■■■■■■■■■■■■■■ここです■■■■■■■■■■■■■■■
-        $sql = "update woma2 set use_times = use_times+1 where pass = '" . $shoppass . "'";
-	 	$result = $mysqli -> query($sql);
      //クエリー失敗
@@ -362,185 +138,11 @@
-    $num_rows=0;
-      // 接続処理
-    $con = mysqli_connect('○○', '○○', '○○', '○○');
-    if(!$con) {
-        die('接続に失敗しました');
-    }
-    // 文字コード
-    mysqli_set_charset($con, 'utf8');
-    // SQLの発行と出力
-    $sql = "SELECT * FROM  woma2 where use_times > 0";
-    $res = mysqli_query($con, $sql);
-    $num_rows = mysqli_num_rows($res);
-    echo $num_rows;
-     // 接続断
-    mysqli_close($con);
-//１００人にひとり当たる
-//１目は当たる
-//７人目は当たる
-  if(($num_rows %100 == 0)or($num_rows ==1)or($num_rows ==7)){
-	$server = "○○○○";
-	$userName = "○○○○";
-	$password = "○○○○";
-	$dbName = "○○○○";
-  $mysqli = new mysqli($server, $userName, $password,$dbName);
-  if ($mysqli->connect_error){
-    echo $mysqli->connect_error;
-    exit();
-  }else{
-    $mysqli->set_charset("utf-8");
-  }
-  //この条件のときにchusen_atariを１にする
-   $sql = "update woma2 set chusen_atari=1 where pass = '" . $shoppass . "'";
-     $result = $mysqli -> query($sql);
-//クエリー失敗
-  if(!$result) {
-    echo $mysqli->error;
-    exit();}
-      }
 ?>
-<!--クーポン当たり-->
-<?php
-if($chusen_atari !=1){echo "<!--";}
-?>
-<div class="p-result">
-	あたりの場合の文書
-</div>
-<?php
-if($chusen_atari!=1){echo "-->";}
-?>
-<!--はずれ-->
-<?php
-if($chusen_atari ==1){echo "<!--";}
-?>
-<div class="p-result">
-	はずれの場合の文書
- </div>
-<?php
-if(($chusen_atari ==1)&&($num_rows ==3)){echo "-->";}
-?>
-<?php endif; ?>
-	 </html>
+</html>

ソースコードについて、割愛したものの掲載から、できる限り全部掲載しました。

2021/11/29 21:14

投稿

kimukimu009

スコア33

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -68,55 +68,479 @@
 ```
+<!DOCTYPE html>
+ <html lang="ja">
+ <head>
+ <meta charset="UTF-8">
+ <title>抽選結果</title>
+ <meta name="viewport" content="width=device-width,initial-scale=1">
+<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
+<!-- Global site tag (gtag.js) - Google Analytics -->
+<script async src="https://www.googletagmanager.com/gtag/js?id=UA-130664081-1"></script>
+<script>
+  window.dataLayer = window.dataLayer || [];
+  function gtag(){dataLayer.push(arguments);}
+  gtag('js', new Date());
+  gtag('config', 'UA-1○○○-1');
+</script>
+<script>
+  window.addEventListener('message', function(e) {
+  var iframe = $("#parentframe");
+  var eventName = e.data[0];
+  var data = e.data[1];
+  switch(eventName) {
+      case 'setHeight':
+          iframe.height(data);
+          break;
+      }
+  }, false);
+</script>
+<link rel="preconnect" href="https://fonts.googleapis.com">
+<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
+<link href="https://fonts.googleapis.com/css2?family=MonteCarlo&family=Shippori+Mincho+B1&display=swap" rel="stylesheet">
+<style type="text/css">
+ここは割愛
+</style>
 <?php
+$shoppass = $_POST['prm1'];
+  //入力チェック
+  $errormsg = array();
+  //shoppass
+  if ($shoppass == null) {
+    $errormsg[] = "パスワードを入力してください。";
+  }
+  if ($shoppass != null){
+	$server = "○○○○";
+	$userName = "○○○○";
+	$password = "○○○○";
+	$dbName = "○○○○";
+	$mysqli = new mysqli($server, $userName, $password,$dbName);
+	if ($mysqli->connect_error){
+		echo $mysqli->connect_error;
+		exit();
+	}else{
+		$mysqli->set_charset("utf-8");
+	}
+    $sql = "SELECT * FROM  woma2 where pass = '" . $shoppass . "'";
+	$result = $mysqli -> query($sql);
+	//クエリー失敗
+	if(!$result) {
+		echo $mysqli->error;
+		exit();
+	}
+ 	//レコード
+    $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
+  	$chusen_atari =$row["chusen_atari"];
+   if($row==0){
+   $errormsg[] = "パスワードが間違っています。<br><br>入力間違いの中で、<br>1(数字のいち）<br>l(小文字のエル)<br>i(小文字のアイ)<br><br>にご注意ください。";
+   }
+        }
+?>
+<?php if (count($errormsg) > 0): ?>
+<div id="errmsg">
+	ERROR<br />
+		<?php foreach ($errormsg as $msg): ?>
+  			<?=$msg?><br />
+		<?php endforeach; ?>
+</div>
+<?php else: ?>
+<?php
-	$server = "mysql131.phy.lolipop.lan";
+	$server = "○○○○";
 	$userName = "○○○○";
 	$password = "○○○○";
-	$dbName = "LAA0○○○";
+	$dbName = "○○○○";
-	$mysqli = new mysqli($server, $userName, $password,$dbName);
+  $mysqli = new mysqli($server, $userName, $password,$dbName);
-	if ($mysqli->connect_error){
+  if ($mysqli->connect_error){
-		echo $mysqli->connect_error;
+    echo $mysqli->connect_error;
-		exit();
+    exit();
-	}else{
+  }else{
-		$mysqli->set_charset("utf-8");
+    $mysqli->set_charset("utf-8");
-	}
+  }
+    $now = date('Y/m/d H:i:s');
+    echo $now;
+    $sql = "update woma2 set date_use_pass  =  '" . $now . "' where pass = '" . $shoppass . "'";
+     $result = $mysqli -> query($sql);
+//クエリー失敗
+  if(!$result) {
+    echo $mysqli->error;
+    exit();}
+	$server = "○○○○";
+	$userName = "○○○○";
+	$password = "○○○○";
+	$dbName = "○○○○";
-　　　　　　　　　$sql = "update TEST set a = a+1 where no = 1;
+  $mysqli = new mysqli($server, $userName, $password,$dbName);
+  if ($mysqli->connect_error){
+    echo $mysqli->connect_error;
+    exit();
+  }else{
+    $mysqli->set_charset("utf-8");
+  }
+/////■■■■■■■■■■■■■■■ここです■■■■■■■■■■■■■■■
+        $sql = "update woma2 set use_times = use_times+1 where pass = '" . $shoppass . "'";
 	 	$result = $mysqli -> query($sql);
+     //クエリー失敗
+  if(!$result) {
+    echo $mysqli->error;
+    exit();}
+    $num_rows=0;
+      // 接続処理
+    $con = mysqli_connect('○○', '○○', '○○', '○○');
+    if(!$con) {
+        die('接続に失敗しました');
+    }
+    // 文字コード
+    mysqli_set_charset($con, 'utf8');
+    // SQLの発行と出力
+    $sql = "SELECT * FROM  woma2 where use_times > 0";
+    $res = mysqli_query($con, $sql);
+    $num_rows = mysqli_num_rows($res);
+    echo $num_rows;
+     // 接続断
+    mysqli_close($con);
+//１００人にひとり当たる
+//１目は当たる
+//７人目は当たる
+  if(($num_rows %100 == 0)or($num_rows ==1)or($num_rows ==7)){
+	$server = "○○○○";
+	$userName = "○○○○";
+	$password = "○○○○";
+	$dbName = "○○○○";
+  $mysqli = new mysqli($server, $userName, $password,$dbName);
+  if ($mysqli->connect_error){
+    echo $mysqli->connect_error;
+    exit();
+  }else{
+    $mysqli->set_charset("utf-8");
+  }
+  //この条件のときにchusen_atariを１にする
+   $sql = "update woma2 set chusen_atari=1 where pass = '" . $shoppass . "'";
+     $result = $mysqli -> query($sql);
+//クエリー失敗
+  if(!$result) {
+    echo $mysqli->error;
+    exit();}
+      }
+?>
+<!--クーポン当たり-->
+<?php
+if($chusen_atari !=1){echo "<!--";}
+?>
+<div class="p-result">
+	あたりの場合の文書
+</div>
+<?php
+if($chusen_atari!=1){echo "-->";}
+?>
+<!--はずれ-->
+<?php
+if($chusen_atari ==1){echo "<!--";}
+?>
+<div class="p-result">
+	はずれの場合の文書
+ </div>
+<?php
+if(($chusen_atari ==1)&&($num_rows ==3)){echo "-->";}
+?>
+<?php endif; ?>
-       //クエリー失敗
+	 </html>
-	if(!$result) {
-		echo $mysqli->error;
-		exit();}
-?>