質問編集履歴
3
追記しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -303,3 +303,29 @@
|
|
|
303
303
|
}
|
|
304
304
|
|
|
305
305
|
```
|
|
306
|
+
|
|
307
|
+
:追記②
|
|
308
|
+
|
|
309
|
+
```php
|
|
310
|
+
|
|
311
|
+
private function _connectDB() {
|
|
312
|
+
|
|
313
|
+
try {
|
|
314
|
+
|
|
315
|
+
$this->_db = new \PDO(PDO_DSN, DB_USERNAME, DB_PASSWORD);
|
|
316
|
+
|
|
317
|
+
$this->_db->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
|
|
318
|
+
|
|
319
|
+
} catch (\PDOException $e){
|
|
320
|
+
|
|
321
|
+
error_log($e->getMessage(), 3, __DIR__ . "/exceptions.log");
|
|
322
|
+
|
|
323
|
+
echo "Faild to connect DB";
|
|
324
|
+
|
|
325
|
+
exit;
|
|
326
|
+
|
|
327
|
+
}
|
|
328
|
+
|
|
329
|
+
}
|
|
330
|
+
|
|
331
|
+
```
|
2
追記しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -271,3 +271,35 @@
|
|
|
271
271
|
```
|
|
272
272
|
|
|
273
273
|
開発中や学習用ならば die(var_dump($e)) で終わらせるべきらしいのですが、では実際に運営するとなった場合にPDOException Exceptionはどのように書くべきなのでしょうか？
|
|
274
|
+
|
|
275
|
+
|
|
276
|
+
|
|
277
|
+
|
|
278
|
+
|
|
279
|
+
：追記①
|
|
280
|
+
|
|
281
|
+
|
|
282
|
+
|
|
283
|
+
```php
|
|
284
|
+
|
|
285
|
+
public function post() {
|
|
286
|
+
|
|
287
|
+
try {
|
|
288
|
+
|
|
289
|
+
$this->_validateSelect();
|
|
290
|
+
|
|
291
|
+
$this->_validateToken();
|
|
292
|
+
|
|
293
|
+
$this->_searchDate();
|
|
294
|
+
|
|
295
|
+
} catch (\Exception $e) {
|
|
296
|
+
|
|
297
|
+
header('Location: http://' . $_SERVER['HTTP_HOST']);
|
|
298
|
+
|
|
299
|
+
exit;
|
|
300
|
+
|
|
301
|
+
}
|
|
302
|
+
|
|
303
|
+
}
|
|
304
|
+
|
|
305
|
+
```
|
1
コードと質問を見やすく致しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -58,7 +58,7 @@
|
|
|
58
58
|
|
|
59
59
|
<?php foreach($search->_result as $rownum=>$rowdata) {
|
|
60
60
|
|
|
61
|
-
echo $rowdata[
|
|
61
|
+
echo $rowdata[カラム名];
|
|
62
62
|
|
|
63
63
|
}
|
|
64
64
|
|