<?php
try {
// パラメータを$idに代入
$num = '08241';
throw new Exception('パラメータが不正です');
}
// PDOオブジェクト生成
$pdo = new PDO(
'mysql:dbname=testdb',
'user',
'password',
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'
)
);
// SQLエラー時に例外をスローするように設定
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// ステートメントを生成して実行し、結果をフェッチする
$stmt = $pdo->prepare('SELECT * FROM testTable WHERE id = ?');
$stmt->execute(array($id)); $raw_data = $stmt->fetch(PDO::FETCH_ASSOC);
if ($raw_data === false) {
throw new Exception('データが見つかりませんでした');
}
// HTMLとして表示できるようにエンティティをエスケープ
}, $raw_data);
} catch (Exception $e) {
// エラーメッセージを$errorに代入
$error = $e->getMessage();
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>test</title>
</head>
<body>
<?php if (isset($error)): ?> <p><?=$error?></p>
<?php else: ?>
<table width="250" border="1">
<tr>
<td width="250">選択したもの</td>
</tr>
<tr>
<td><?=$data['id']?></td>
</tr>
<tr>
<td>
<form name="a11" action="/products/detail.php" method="post" >
<input type="hidden" name="mode" value="cart" />
<input type="hidden" name="product_id" value="<?=$data['product_id']?>" />
<input type="hidden" name="product_class_id" value="<?=$data['product_class_id']?>" />
<input type="hidden" name="quantity" value="1" /><br />
<input type="submit" value="決定する" onClick="alert('選択しました')" />
</form>
</td>
</tr>
</table>
<?php endif; ?>
</body>
</html>
PD9waHAKCnRyeSB7CiAgICAKICAgIC8vIOODkeODqeODoeODvOOCv+OCkiRpZOOBq+S7o+WFpQogICAgJG51bSA9ICcwODI0MSc7CiAgICBpZiAoIWlzc2V0KCRfUE9TVFskbnVtXSkgfHwgIWlzX3N0cmluZygkaWQgPSAkX1BPU1RbJG51bV0pKSB7CiAgICAgICAgdGhyb3cgbmV3IEV4Y2VwdGlvbign44OR44Op44Oh44O844K/44GM5LiN5q2j44Gn44GZJyk7CiAgICB9CiAgICAKICAgIC8vIFBET+OCquODluOCuOOCp+OCr+ODiOeUn+aIkAogICAgJHBkbyA9IG5ldyBQRE8oCiAgICAgICAgJ215c3FsOmRibmFtZT10ZXN0ZGInLAogICAgICAgICd1c2VyJywKICAgICAgICAncGFzc3dvcmQnLAogICAgICAgIGFycmF5KAogICAgICAgICAgICBQRE86Ok1ZU1FMX0FUVFJfSU5JVF9DT01NQU5EID0+ICdTRVQgTkFNRVMgdXRmOCcKICAgICAgICApCiAgICApOwogICAgCiAgICAvLyBTUUzjgqjjg6njg7zmmYLjgavkvovlpJbjgpLjgrnjg63jg7zjgZnjgovjgojjgYbjgavoqK3lrpoKICAgICRwZG8tPnNldEF0dHJpYnV0ZShQRE86OkFUVFJfRVJSTU9ERSwgUERPOjpFUlJNT0RFX0VYQ0VQVElPTik7CiAgICAKICAgIC8vIOOCueODhuODvOODiOODoeODs+ODiOOCkueUn+aIkOOBl+OBpuWun+ihjOOBl+OAgee1kOaenOOCkuODleOCp+ODg+ODgeOBmeOCiwogICAgJHN0bXQgPSAkcGRvLT5wcmVwYXJlKCdTRUxFQ1QgKiBGUk9NIHRlc3RUYWJsZSBXSEVSRSBpZCA9ID8nKTsKICAgICRzdG10LT5leGVjdXRlKGFycmF5KCRpZCkpOwogICAgJHJhd19kYXRhID0gJHN0bXQtPmZldGNoKFBETzo6RkVUQ0hfQVNTT0MpOwogICAgaWYgKCRyYXdfZGF0YSA9PT0gZmFsc2UpIHsKICAgICAgICB0aHJvdyBuZXcgRXhjZXB0aW9uKCfjg4fjg7zjgr/jgYzopovjgaTjgYvjgorjgb7jgZvjgpPjgafjgZfjgZ8nKTsKICAgIH0KICAgIAogICAgLy8gSFRNTOOBqOOBl+OBpuihqOekuuOBp+OBjeOCi+OCiOOBhuOBq+OCqOODs+ODhuOCo+ODhuOCo+OCkuOCqOOCueOCseODvOODlwogICAgJGRhdGEgPSBhcnJheV9tYXAoZnVuY3Rpb24gKCRpbnB1dCkgewogICAgICAgIHJldHVybiBodG1sc3BlY2lhbGNoYXJzKCRpbnB1dCwgRU5UX1FVT1RFUywgJ1VURi04Jyk7CiAgICB9LCAkcmF3X2RhdGEpOwogICAgCn0gY2F0Y2ggKEV4Y2VwdGlvbiAkZSkgewogICAgCiAgICAvLyDjgqjjg6njg7zjg6Hjg4Pjgrvjg7zjgrjjgpIkZXJyb3Ljgavku6PlhaUKICAgICRlcnJvciA9ICRlLT5nZXRNZXNzYWdlKCk7CiAgICAKfQoKCj8+CjwhRE9DVFlQRSBodG1sPgo8aHRtbD4KPGhlYWQ+CjxtZXRhIGNoYXJzZXQ9IlVURi04IiAvPgo8dGl0bGU+dGVzdDwvdGl0bGU+CjwvaGVhZD4KPGJvZHk+Cjw/cGhwIGlmIChpc3NldCgkZXJyb3IpKTogPz4KPHA+PD89JGVycm9yPz48L3A+Cjw/cGhwIGVsc2U6ID8+Cjx0YWJsZSB3aWR0aD0iMjUwIiBib3JkZXI9IjEiPgo8dHI+Cjx0ZCB3aWR0aD0iMjUwIj7pgbjmip7jgZfjgZ/jgoLjga48L3RkPgo8L3RyPgo8dHI+Cjx0ZD48Pz0kZGF0YVsnaWQnXT8+PC90ZD4KPC90cj4KPHRyPgo8dGQ+Cjxmb3JtIG5hbWU9ImExMSIgYWN0aW9uPSIvcHJvZHVjdHMvZGV0YWlsLnBocCIgbWV0aG9kPSJwb3N0IiA+CjxpbnB1dCB0eXBlPSJoaWRkZW4iIG5hbWU9Im1vZGUiIHZhbHVlPSJjYXJ0IiAvPgo8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJwcm9kdWN0X2lkIiB2YWx1ZT0iPD89JGRhdGFbJ3Byb2R1Y3RfaWQnXT8+IiAvPgo8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJwcm9kdWN0X2NsYXNzX2lkIiB2YWx1ZT0iPD89JGRhdGFbJ3Byb2R1Y3RfY2xhc3NfaWQnXT8+IiAvPgo8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJxdWFudGl0eSIgdmFsdWU9IjEiIC8+PGJyIC8+CjxpbnB1dCB0eXBlPSJzdWJtaXQiIHZhbHVlPSLmsbrlrprjgZnjgosiIG9uQ2xpY2s9ImFsZXJ0KCfpgbjmip7jgZfjgb7jgZfjgZ8nKSIgLz4KPC9mb3JtPgo8L3RkPgo8L3RyPgo8L3RhYmxlPgo8P3BocCBlbmRpZjsgPz4KPC9ib2R5Pgo8L2h0bWw+