Q&A
insertShohinCheck.php(渡された情報をデータベースに登録し、登録できたかを表示して確認するページ)
```
<?php
session_start();
require_once "DBManager.php";
$db = new DBManager;
try {
$id=$db->INSERTShohin($_POST['shohin_mei'],$_POST['bunrui'],$_POST['hanbai_bi'],$_POST['shohin_kakaku'],$_POST['shohin_writer'],$_POST['shohin_conpany'],$_POST['isbn'],$_POST['tosyo']);
if(!empty($_FILES['shohin_img'])){
$db->INSERTShohinImg($id,$_FILES['shohin_img']['tmp_name'],$_FILES['shohin_img']['name'],$_FILES['shohin_img']['type'],$_FILES['shohin_img']['size']);
}
$shohin = $db->getShohin($id);
foreach ($shohin as $shohinData) {
echo "<p>書籍名：$shohinData[shohin_mei]<br>著者：$shohinData[shohin_writer]<br>出版社：$shohinData[shohin_conpany]<br>価格：$shohinData[shohin_kakaku]<br>ISBNコード：$shohinData[shohin_ISBN]<br>書籍コード：$shohinData[shohin_bookcode]<br>ジャンル：$shohinData[shohin_bunrui]<br>販売日：$shohinData[hanbai_bi]<br></p>";
}
$images = $db->getShohinImg($id);
} catch (Exception $e) {
echo $e.getMessage();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr" crossorigin="anonymous">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<title>商品登録の確認</title>
</head>
<body>
<div class="row">
<div class="col-md-8 border-right">
<ul class="list-unstyled">
<?php for($i = 0; $i < count($images); $i++): ?>
<li class="media mt-5">
<img src="image.php?id=<?= $id; ?>?detailId=<?=$i;?>" width="100" height="auto" class="mr-3" alt="画像が表示されていません">
</li>
<?php endfor; ?>
</ul>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
</body>
</html>
```
DBManager.php(データベースに関するphp関数を可能な限りまとめたファイル)
```
<?php
class DBManager{
private function dbConnect(){
$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8',
'username','password');//都合上別のものに置き換えています。
return $pdo;
}
function INSERTMember($nickname,$familyname,$firstname,$mail,$pass){
$pdo = $this->dbConnect();
$in = $pdo->prepare("INSERT INTO members(mem_name,mem_familyname,mem_firstname,mem_mail,mem_pass) VALUES(?,?,?,?,?)");
$in->bindValue(1,$nickname,PDO::PARAM_STR);
$in->bindValue(2,$familyname,PDO::PARAM_STR);
$in->bindValue(3,$firstname,PDO::PARAM_STR);
$in->bindValue(4,$mail,PDO::PARAM_STR);
$in->bindValue(5,password_hash($pass,PASSWORD_DEFAULT),PDO::PARAM_STR);
$in->execute();
}
function shohinIdSearch($name,$bunrui,$day,$kakaku){
$pdo = $this->dbConnect();
$search = $pdo->prepare("SELECT shohin_id FROM shohins WHERE shohin_mei=? AND shohin_bunrui=? AND hanbai_bi=? AND shohin_kakaku=?");
$search->bindValue(1,$name,PDO::PARAM_STR);
$search->bindValue(2,$bunrui,PDO::PARAM_STR);
$search->bindValue(3,$day,PDO::PARAM_STR);
$search->bindValue(4,$kakaku,PDO::PARAM_INT);
$search->execute();
$id=0;
foreach($search as $key){
$id=$key['shohin_id'];
}
return $id;
}
function INSERTShohin($name,$bunrui,$day,$kakaku,$writer,$conpany,$isbn,$tosyo){
$pdo = $this->dbConnect();
$inS = $pdo->prepare("INSERT INTO shohins(shohin_mei,shohin_bunrui,hanbai_bi,shohin_kakaku) VALUES(?,?,?,?)");
$inS->bindValue(1,$name,PDO::PARAM_STR);
$inS->bindValue(2,$bunrui,PDO::PARAM_STR);
$inS->bindValue(3,$day,PDO::PARAM_STR);
$inS->bindValue(4,$kakaku,PDO::PARAM_INT);
$inS->execute();
$id = $this->shohinIdSearch($name,$bunrui,$day,$kakaku);
if(!empty($writer)){
$upwri = $pdo->prepare("UPDATE shohins set shohin_writer = ? WHERE shohin_id = ?");
$upwri ->bindValue(1,$writer,PDO::PARAM_STR);
$upwri ->bindValue(2,$id,PDO::PARAM_INT);
$upwri ->execute();
}
if(!empty($conpany)){
$upcon = $pdo->prepare("UPDATE shohins set shohin_conpany = ? WHERE shohin_id = ?");
$upcon ->bindValue(1,$conpany,PDO::PARAM_STR);
$upcon ->bindValue(2,$id,PDO::PARAM_INT);
$upcon ->execute();
}
if(!empty($isbn)){
$upisb = $pdo->prepare("UPDATE shohins set shohin_ISBN = ? WHERE shohin_id = ?");
$upisb->bindValue(1,$isbn,PDO::PARAM_INT);
$upisb ->bindValue(2,$id,PDO::PARAM_INT);
$upisb ->execute();
}
if(!empty($tosyo)){
$upcod = $pdo->prepare("UPDATE shohins set shohin_bookcode = ? WHERE shohin_id = ?");
$upcod ->bindValue(1,$tosyo,PDO::PARAM_INT);
$upcod ->bindValue(2,$id,PDO::PARAM_INT);
$upcod ->execute();
}
return $id;
}
function getShohin($id){
$pdo = $this->dbConnect();
$getShohin = $pdo->prepare("SELECT * FROM shohins WHERE shohin_id = ?");
$getShohin->bindValue(1,$id,PDO::PARAM_INT);
$getShohin->execute();
return $getShohin->fetchAll();
}
function INSERTShohinImg($id,$content,$name,$type,$size){
$pdo = $this->dbConnect();
for ($i=0; $i<count($name); $i++) {
$inImg = $pdo->prepare("INSERT INTO shohindetails(shohin_id,shohin_img,image_name,image_type,image_size,created_at) VALUES(?,?,?,?,?,now())");
$inImg ->bindValue(1,$id,PDO::PARAM_INT);
$inImg ->bindValue(2,file_get_contents($content[$i]),PDO::PARAM_STR);
$inImg ->bindValue(3,$name[$i],PDO::PARAM_STR);
$inImg ->bindValue(4,$type[$i],PDO::PARAM_STR);
$inImg ->bindValue(5,$size[$i],PDO::PARAM_STR);
$inImg ->execute();
}
}
function getShohinImg($id){
$pdo = $this->dbConnect();
$getSImage = $pdo->prepare("SELECT * FROM shohindetails WHERE shohin_id = ?");
$getSImage ->bindValue(1,$id,PDO::PARAM_STR);
$getSImage ->execute();
return $getSImage->fetch();
exit();
}
}
?>
```
-------------------------------------------------------------------------------------------------------------------
image.php(外部サイトより引用＋改変。shohindetailsに登録されている画像データを取得する)
```
<?php
require_once 'functions.php';
$pdo = connectDB();
$sql = 'SELECT * FROM shohindetails WHERE shohin_id = :shohin_id AND shohindetail_id = :shohindetail_id LIMIT 1';
$stmt = $pdo->prepare($sql);
$stmt->bindValue(':shohin_id', (int)$_GET['id'], PDO::PARAM_INT);
$stmt->bindValue(':shohindetail_id', (int)$_GET['detailId'], PDO::PARAM_INT);
$stmt->execute();
$image = $stmt->fetch();
header('Content-type: ' . $image['image_type']);
echo $image['shohin_img'];
exit();
?>
```
--------------------------------------------------------------------------------------------------------------------
function.php(外部サイトより引用＋改変。image.phpで使用されるページ。データベースへ接続している。)
```
<?php
// データベースに接続
function connectDB() {
$param = 'mysql:dbname=my_image;host=localhost';
try {
$pdo = new PDO($param, 'username', 'password');//都合上別の物に置き換えています。
return $pdo;
} catch (PDOException $e) {
exit($e->getMessage());
}
}
?>
```
ベストアンサー
