質問編集履歴
6
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -202,4 +202,4 @@
|
|
|
202
202
|
---
|
|
203
203
|
|
|
204
204
|
15:02追記
|
|
205
|
-
|
5
具体化
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -197,4 +197,9 @@
|
|
|
197
197
|
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'email' cannot be null' in C:\xampp\htdocs\xxx\register_human_thanks.php:34 Stack trace: #0 C:\xampp\htdocs\xxx\register_human_thanks.php(34): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\xxx\register_human_thanks.php on line 34
|
|
198
198
|
|
|
199
199
|
テーブル構造です。
|
|
200
|
-
|
|
200
|
+
|
|
201
|
+
|
|
202
|
+
---
|
|
203
|
+
|
|
204
|
+
15:02追記
|
|
205
|
+
(d3aa2bcab0faa365263e201e93023de6.jpeg)
|
4
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -194,4 +194,7 @@
|
|
|
194
194
|
```ここに言語を入力
|
|
195
195
|
$stmt = $pdo->prepare("INSERT INTO user_data(email, password, fname_kanji, lname_kanji, fname_kana, lname_kana, fname_roma, lname_roma, middle_name, birthday_year, birthday_month, birthday_day, gender, first_post, last_post, prefectures, city, town, building, tel1, tel2, tel3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
|
|
196
196
|
```
|
|
197
|
-
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'email' cannot be null' in C:\xampp\htdocs\xxx\register_human_thanks.php:34 Stack trace: #0 C:\xampp\htdocs\xxx\register_human_thanks.php(34): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\xxx\register_human_thanks.php on line 34
|
|
197
|
+
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'email' cannot be null' in C:\xampp\htdocs\xxx\register_human_thanks.php:34 Stack trace: #0 C:\xampp\htdocs\xxx\register_human_thanks.php(34): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\xxx\register_human_thanks.php on line 34
|
|
198
|
+
|
|
199
|
+
テーブル構造です。
|
|
200
|
+
|
3
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -172,4 +172,26 @@
|
|
|
172
172
|
$_SEESION['join1']['tel3']
|
|
173
173
|
の部分です。
|
|
174
174
|
|
|
175
|
-
**Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in C:\xampp\htdocs\xxx\register_human_thanks.php:34 Stack trace: #0 C:\xampp\htdocs\IDH\register_human_thanks.php(34): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\xxx\register_human_thanks.php on line 34**
|
|
175
|
+
**Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in C:\xampp\htdocs\xxx\register_human_thanks.php:34 Stack trace: #0 C:\xampp\htdocs\IDH\register_human_thanks.php(34): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\xxx\register_human_thanks.php on line 34**
|
|
176
|
+
|
|
177
|
+
|
|
178
|
+
|
|
179
|
+
|
|
180
|
+
|
|
181
|
+
|
|
182
|
+
|
|
183
|
+
---
|
|
184
|
+
14:36 追記
|
|
185
|
+
カラム名を指定してみると、エラーの結果が若干変わりました。
|
|
186
|
+
```ここに言語を入力
|
|
187
|
+
$stmt = $pdo->prepare("INSERT INTO user_data VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
|
|
188
|
+
```
|
|
189
|
+
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in C:\xampp\htdocs\xxx\register_human_thanks.php:34 Stack trace: #0 C:\xampp\htdocs\xxx\register_human_thanks.php(34): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\xxx\register_human_thanks.php on line 34
|
|
190
|
+
|
|
191
|
+
|
|
192
|
+
---
|
|
193
|
+
|
|
194
|
+
```ここに言語を入力
|
|
195
|
+
$stmt = $pdo->prepare("INSERT INTO user_data(email, password, fname_kanji, lname_kanji, fname_kana, lname_kana, fname_roma, lname_roma, middle_name, birthday_year, birthday_month, birthday_day, gender, first_post, last_post, prefectures, city, town, building, tel1, tel2, tel3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
|
|
196
|
+
```
|
|
197
|
+
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'email' cannot be null' in C:\xampp\htdocs\xxx\register_human_thanks.php:34 Stack trace: #0 C:\xampp\htdocs\xxx\register_human_thanks.php(34): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\xxx\register_human_thanks.php on line 34
|
2
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -170,4 +170,6 @@
|
|
|
170
170
|
|
|
171
171
|
同じ３４行目で
|
|
172
172
|
$_SEESION['join1']['tel3']
|
|
173
|
-
の部分です。
|
|
173
|
+
の部分です。
|
|
174
|
+
|
|
175
|
+
**Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in C:\xampp\htdocs\xxx\register_human_thanks.php:34 Stack trace: #0 C:\xampp\htdocs\IDH\register_human_thanks.php(34): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\xxx\register_human_thanks.php on line 34**
|
1
追記
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -133,4 +133,41 @@
|
|
|
133
133
|
|
|
134
134
|
session_destroy();
|
|
135
135
|
?>
|
|
136
|
-
```
|
|
136
|
+
```
|
|
137
|
+
|
|
138
|
+
|
|
139
|
+
6/20 14:11追記
|
|
140
|
+
|
|
141
|
+
プレースホルダーの数を修正し、user_data()の（）を取り除いても一向にエラーが収まりません...
|
|
142
|
+
|
|
143
|
+
```ここに言語を入力
|
|
144
|
+
$stmt = $pdo->prepare("INSERT INTO user_data VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");//基本項目22個
|
|
145
|
+
$stmt->execute([
|
|
146
|
+
$_SEESION['join1']['email'],
|
|
147
|
+
password_hash($_SEESION['join1']['pw'],PASSWORD_DEFAULT),
|
|
148
|
+
$_SEESION['join1']['name1'],
|
|
149
|
+
$_SEESION['join1']['name2'],
|
|
150
|
+
$_SEESION['join1']['name3'],
|
|
151
|
+
$_SEESION['join1']['name4'],
|
|
152
|
+
$_SEESION['join1']['name5'],
|
|
153
|
+
$_SEESION['join1']['name6'],
|
|
154
|
+
$_SEESION['join1']['name7'],
|
|
155
|
+
$_SEESION['join1']['year'],
|
|
156
|
+
$_SEESION['join1']['month'],
|
|
157
|
+
$_SEESION['join1']['day'],
|
|
158
|
+
$_SEESION['join1']['gender'],
|
|
159
|
+
$_SEESION['join1']['first_post'],
|
|
160
|
+
$_SEESION['join1']['last_post'],
|
|
161
|
+
$_SEESION['join1']['pref'],
|
|
162
|
+
$_SEESION['join1']['city'],
|
|
163
|
+
$_SEESION['join1']['town'],
|
|
164
|
+
$_SEESION['join1']['building'],
|
|
165
|
+
$_SEESION['join1']['tel1'],
|
|
166
|
+
$_SEESION['join1']['tel2'],
|
|
167
|
+
$_SEESION['join1']['tel3']
|
|
168
|
+
]);
|
|
169
|
+
```
|
|
170
|
+
|
|
171
|
+
同じ３４行目で
|
|
172
|
+
$_SEESION['join1']['tel3']
|
|
173
|
+
の部分です。
|