"SET CHARACTER SET 'utf8'"
));
}catch(PDOException $e){
die($e->getMessage());
}
$sql = "INSERT INTO order_log
(customer_name, customer_mail, customer_address, goods_id)
VALUES ("
. "\"" . $_POST["c_name"] . "\", "
. "\"" . $_POST["c_mail"] . "\", "
. "\"" . $_POST["c_address"] . "\", "
. "\"" . $_SESSION["item"] . "\""
. ")";
$result = $pdo->query($sql);
if(!$result){
echo "購入できませんでした。";
exit();
}
$sql = "SELECT name,price FROM goods WHERE id=" . $_SESSION["item"];
$result = $pdo->query($sql);
while($row = $result->fetch(PDO::FETCH_ASSOC)){
echo $row["name"] . "(" . $row["price"] . "円)を購入しました！";
}
//セッション変数を全て解除する
$_SESSION = array();
}else{
echo "商品が選択されていません";
}
?>