質問編集履歴
2
SQL文にtrycatchの処理とif(!empty($_POST))外にvar_dump($_POST)を追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -200,39 +200,69 @@
|
|
200
200
|
|
201
201
|
}
|
202
202
|
|
203
|
-
|
203
|
+
echo $_SESSION['join']['image'];
|
204
|
+
|
205
|
+
|
206
|
+
|
207
|
+
// 教本のdb実行部分をもう一度見直す
|
208
|
+
|
209
|
+
// $_POSTのようなスーパーグローバル変数は上書きしない
|
210
|
+
|
211
|
+
// headerはpostではなくgetで飛ぶ
|
204
212
|
|
205
213
|
if(!empty($_POST)){
|
206
214
|
|
207
|
-
|
215
|
+
var_dump($_POST);
|
216
|
+
|
217
|
+
echo "<br>";
|
218
|
+
|
219
|
+
var_dump($_SESSION);
|
220
|
+
|
221
|
+
echo "<br>";
|
208
222
|
|
209
223
|
var_dump($db);
|
210
224
|
|
225
|
+
|
226
|
+
|
211
227
|
//登録処理をする
|
212
228
|
|
229
|
+
try{
|
230
|
+
|
213
|
-
$statement = $db->prepare('INSERT INTO members (name,email,password,
|
231
|
+
$statement = $db->prepare('INSERT INTO members (name,email,password,image) VALUES (:name, :email, :password, :image)');
|
214
|
-
|
232
|
+
|
215
|
-
$statement->bind
|
233
|
+
$statement->bindValue(':name',$_SESSION['join']['name']);
|
216
|
-
|
234
|
+
|
217
|
-
$statement->bind
|
235
|
+
$statement->bindValue(':email',$_SESSION['join']['email']);
|
218
|
-
|
236
|
+
|
219
|
-
$statement->bind
|
237
|
+
$statement->bindValue(':password',$_SESSION['join']['password']);
|
220
|
-
|
238
|
+
|
221
|
-
$statement->bind
|
239
|
+
$statement->bindValue(':picture',$_SESSION['join']['image']);
|
222
|
-
|
223
|
-
|
224
|
-
|
240
|
+
|
241
|
+
|
242
|
+
|
225
|
-
$kekka = $statement->execute();
|
243
|
+
$kekka = $statement->execute();
|
226
|
-
|
244
|
+
|
227
|
-
var_dump($kekka);
|
245
|
+
var_dump($kekka);
|
246
|
+
|
228
|
-
|
247
|
+
}catch(PDOException $e){
|
248
|
+
|
249
|
+
echo "エラー" . $e->getMessage();
|
250
|
+
|
251
|
+
}finally{
|
252
|
+
|
229
|
-
unset($_SESSION['join']);
|
253
|
+
unset($_SESSION['join']);
|
230
|
-
|
231
|
-
|
232
|
-
|
254
|
+
|
233
|
-
//header('Location: thanks.php');
|
255
|
+
// header('Location: thanks.php');
|
234
|
-
|
256
|
+
|
235
|
-
exit();
|
257
|
+
exit();
|
258
|
+
|
259
|
+
}
|
260
|
+
|
261
|
+
|
262
|
+
|
263
|
+
|
264
|
+
|
265
|
+
|
236
266
|
|
237
267
|
}
|
238
268
|
|
@@ -240,6 +270,18 @@
|
|
240
270
|
|
241
271
|
|
242
272
|
|
273
|
+
<?php
|
274
|
+
|
275
|
+
var_dump($_POST);
|
276
|
+
|
277
|
+
echo "<br>";
|
278
|
+
|
279
|
+
var_dump($_SESSION);
|
280
|
+
|
281
|
+
echo "<br>";
|
282
|
+
|
283
|
+
?>
|
284
|
+
|
243
285
|
<p>次のフォームに必要事項を記入してください</p>
|
244
286
|
|
245
287
|
<form action="" method="post">
|
1
check.phpのif(!empty($_POST))内を修正しました
test
CHANGED
File without changes
|
test
CHANGED
@@ -204,27 +204,33 @@
|
|
204
204
|
|
205
205
|
if(!empty($_POST)){
|
206
206
|
|
207
|
+
|
208
|
+
|
209
|
+
var_dump($db);
|
210
|
+
|
207
211
|
//登録処理をする
|
208
212
|
|
209
|
-
$statement = $db->prepare('INSERT INTO members
|
213
|
+
$statement = $db->prepare('INSERT INTO members (name,email,password,picture) VALUES (:name, :email, :password, :picture)');
|
214
|
+
|
210
|
-
|
215
|
+
$statement->bindParam(':name',$_SESSION['join']['name']);
|
216
|
+
|
217
|
+
$statement->bindParam(':email',$_SESSION['join']['email']);
|
218
|
+
|
219
|
+
$statement->bindParam(':password',$_SESSION['join']['password']);
|
220
|
+
|
221
|
+
$statement->bindParam(':picture',$_SESSION['join']['image']);
|
222
|
+
|
223
|
+
|
224
|
+
|
211
|
-
|
225
|
+
$kekka = $statement->execute();
|
212
|
-
|
226
|
+
|
213
|
-
|
227
|
+
var_dump($kekka);
|
214
|
-
|
215
|
-
$_SESSION['join']['email'],
|
216
|
-
|
217
|
-
shal($_SESSION['join']['password']),
|
218
|
-
|
219
|
-
$_SESSION['join']['image']
|
220
|
-
|
221
|
-
));
|
222
228
|
|
223
229
|
unset($_SESSION['join']);
|
224
230
|
|
225
231
|
|
226
232
|
|
227
|
-
header('Location: thanks.php');
|
233
|
+
//header('Location: thanks.php');
|
228
234
|
|
229
235
|
exit();
|
230
236
|
|