編集履歴

質問編集履歴

追記部分コード

2019/11/08 05:44

投稿

kokok

スコア145

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -401,3 +401,307 @@
 サーバにアップロードする前には、開けるので　自分の書いたどこかのプログラムがおかしいとは思うのですが、　原因が特定できなかったのでアドバイス頂けると助かります。
+--追記--
+```php
+<?php
+namespace DBIO;
+use PDO;
+use PDOException;
+class MyPDO{
+    private $dsn;
+    private $user;
+    private $pass;
+    private $pdo;
+    function __construct(){
+        $this->dsn = "mysql:dbname=test;host=localhost;charset=utf8mb4";
+        $this->user = "root";
+        $this->pass = "";
+        $this->connect();
+    }
+    function connect(){
+        $this->pdo = new PDO($this->dsn, $this->user, $this->pass, array(
+            PDO::ATTR_PERSISTENT => true
+        ));
+    }
+    function close(){
+        $this->pdo = null;
+    }
+    function getAll(){
+        $sql = "SELECT * FROM images";
+        $this->connect();
+        $tmp = $this->pdo->query($sql);
+        // 全部の行を配列して返す
+        $result = $tmp->fetchAll();
+        $this->close();
+        return $result;
+    }
+    function getInfo($id){
+        $sql = "SELECT * FROM images WHERE  id=?";
+        $this->connect();
+        $stmt = $this->pdo->prepare($sql);
+        $stmt->bindParam(1, $id);
+        // 戻り値 成功でtrueが返ってくる
+        $stmt->execute();
+        $result = $stmt->fetchAll();
+        $this->close();
+        return $result;
+    }
+    // データベースに画像情報一行分のレコードを追加
+    function insertImgInfo_recode($title, $info, $photographer, $filePath){
+        try {
+            // SQLの実行結果の判断
+          //  $result = false;
+            $sql = "INSERT INTO images(TITLE, INFO, PHOTOGRAPHER, PATH, DATE) VALUES(?,?,?,?,?)";
+            $date = date("Y/m/d G:i:s");
+            $this->connect();
+            $stmt = $this->pdo->prepare($sql);
+            $stmt->bindParam(1, $title);
+            $stmt->bindParam(2, $info);
+            $stmt->bindParam(3, $photographer);
+            $stmt->bindParam(4, $filePath);
+            $stmt->bindParam(5, $date);
+            // 実行結果
+            $result = $stmt->execute();
+        } catch (PDOException $e) {
+            print('PDOException:' . $e->getMessage());
+        } finally{
+            $this->close();
+        }
+//実行結果が成功か失敗かを返す: true/flse
+        return $result;
+    }
+    //データベースimagesテーブルの全てのデータ取得
+    function getRecodeAll(){
+        $sql = "SELECT *  FROM images";
+        $this->connect();
+        $stmt = $this->pdo->prepare($sql);
+        $stmt->execute();
+        $recode = $stmt->fetchAll();
+        $this->close();
+        //テーブルの全てのデータを返す
+        return   $recode;
+    }
+    //idで一行分のレコード取得
+    function getRecode($id){
+        $sql = "SELECT *  FROM images WHERE ID = ?";
+        $this->connect();
+        $stmt = $this->pdo->prepare($sql);
+        $stmt->bindParam(1, $id);
+        $stmt->execute();
+        $recode = $stmt->fetchAll();
+        $this->close();
+        //一行分のデータを返す
+        return   $recode;
+    }
+    function updateRecode($id,$title,$image_info,$photographer){
+        $sql = "UPDATE images  SET TITLE=?, INFO=?, PHOTOGRAPHER=?,  DATE=? where ID = ?";
+        $date = date("Y/m/d G:i:s");
+        $this->connect();
+        $stmt = $this->pdo->prepare($sql);
+        $stmt->bindParam(1, $title);
+        $stmt->bindParam(2, $image_info);
+        $stmt->bindParam(3, $photographer);
+        $stmt->bindParam(4, $date);
+       $stmt->bindParam(5, $id);
+        $result = $stmt->execute();
+        $this->close();
+        //更新結果が成功ならtrue/失敗ならfalse
+        return   $result;
+    }
+}
+```