回答編集履歴
1
a
answer
CHANGED
|
@@ -1,12 +1,14 @@
|
|
|
1
|
-
|
|
1
|
+
明らかに変数名が違います… `$dbh` `$pdo`
|
|
2
2
|
|
|
3
3
|
```php
|
|
4
|
-
|
|
4
|
+
$dbh = new PDO($dsn, $user, $password, $option);
|
|
5
|
+
$stmt = $pdo->prepare("INSERT INTO user_data() VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//基本項目22個
|
|
5
6
|
```
|
|
6
7
|
|
|
8
|
+
Noticeレベルのエラーも表示するようにすべきですね．php.iniの設定を変えてください．
|
|
9
|
+
|
|
7
10
|
```php
|
|
8
|
-
|
|
11
|
+
error_reporting = E_ALL
|
|
9
|
-
$stmt = $pdo->prepare("INSERT INTO user_data() VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//基本項目22個
|
|
10
12
|
```
|
|
11
13
|
|
|
12
|
-
|
|
14
|
+
こうしておくことで， `Notice: Undefined variable: pdo` というエラーも見えるようになります．
|