編集履歴

質問編集履歴

文法の修正

2020/08/24 12:35

投稿

allfree

スコア3

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -68,7 +68,7 @@
       //テーブルの作成
-    $sql = "CREATE TABLE IF NOT EXISTS keiziban_txt"
+    $sql = "CREATE TABLE IF NOT EXISTS tech_text"
     ."("
@@ -94,13 +94,13 @@
       //編集選択機能
-if(!empty($_POST["edit"]) && !empty($_POST["editpass"])){
+if(!empty($_POST["editNo"]) && !empty($_POST["editpass"])){
-    $id = $_POST["edit"];
+    $id = $_POST["editNo"];
     $editpass = $_POST["editpass"];
-    $sql = 'SELECT * FROM keiziban_test';
+    $sql = 'SELECT * FROM tech_text';
     $stmt = $pdo->query($sql);
@@ -118,7 +118,7 @@
         $pass = $row['pass'];
-        $enumber = $row['id'];
+        $editnumber = $row['id'];
         }
@@ -144,7 +144,7 @@
 <input id="pass" type = "text" name = "password" value ="<?php if(!empty($pass)){echo $pass;}?>"  placeholder = "<?php if(empty($pass)){echo "パスワード";}?>">
-<input type = "hidden"  name = "edit-number" value = "<?php if(!empty($pass)){echo $enumber;}?>" >
+<input type = "hidden"  name = "edit-number" value = "<?php if(!empty($pass)){echo $editnumber;}?>" >
 <input type = "submit"  name = "btn"value = "送信"><br>
@@ -158,7 +158,7 @@
-<input type = "text" name = "edit" placeholder = "編集対象番号" placeholder="編集番号を入力してください">
+<input type = "text" name = "editNo" placeholder = "編集対象番号" placeholder="編集番号を入力してください">
 <input id="pass" type = "text" name = "editpass"  placeholder = "パスワード">
@@ -180,31 +180,31 @@
       //編集実行機能
-if(!empty($_POST["edit-number"]) && !empty($_POST["edit"])){
+if(!empty($_POST["edit-number"]) && !empty($_POST["editNo"])){
-    $editid = $_POST["edit-number"];      //ここで編集対象番号の値の受け取りを行う
+    $id = $_POST["edit-number"];      //ここで編集対象番号の値の受け取りを行う
-    $editname = $_POST["name"];
+    $name = $_POST["name"];
-    $editcomment = $_POST["comment"];
+    $comment = $_POST["comment"];
-    $editpassword = $_POST["password"];
+    $password = $_POST["password"];
-    $editdate = date("Y年m月d日 H時i分s秒");
+    $date = date("Y年m月d日 H時i分s秒");
-    $sql = 'update tb_test set name=:name,comment=:comment,pass=:pass,date=date where id=:id';
+    $sql = 'update tech_text set name=:name,comment=:comment,pass=:pass,date=date where id=:id';
     $stmt = $pdo->prepare($sql);
-    $stmt->bindParam(':name', $editname, PDO::PARAM_STR);
+    $stmt->bindParam(':name', $name, PDO::PARAM_STR);
-    $stmt->bindParam(':comment', $editcomment, PDO::PARAM_STR);
+    $stmt->bindParam(':comment', $comment, PDO::PARAM_STR);
-    $stmt->bindParam(':pass', $editpassword, PDO::PARAM_STR);
+    $stmt->bindParam(':pass', $password, PDO::PARAM_STR);
-    $stmt->bindParam(':date', $editdate, PDO::PARAM_STR);
+    $stmt->bindParam(':date', $date, PDO::PARAM_STR);
-    $stmt->bindParam(':id', $editid, PDO::PARAM_INT);
+    $stmt->bindParam(':id', $id, PDO::PARAM_INT);
     $stmt->execute();
@@ -230,7 +230,7 @@
     $date = date("Y年m月d日 H時i分s秒");
-    $sql = $pdo -> prepare("INSERT INTO tb_test (name, comment, pass,date) VALUES(:name, :comment, :pass,:date)");
+    $sql = $pdo -> prepare("INSERT INTO tech_text (name, comment, pass,date) VALUES(:name, :comment, :pass,:date)");
     $sql -> bindParam(':name', $name, PDO::PARAM_STR);
@@ -256,7 +256,7 @@
     $delpassword=$_POST['delpass'] ;
-    $sql = 'delete from tb_test where id=:id';
+    $sql = 'delete from tech_text where id=:id';
 	$stmt = $pdo->prepare($sql);
@@ -274,7 +274,7 @@
-    $sql = 'SELECT * FROM tb_test';
+    $sql = 'SELECT * FROM tech_text';
     $stmt = $pdo->query($sql);