回答編集履歴
2
修正
answer
CHANGED
@@ -22,7 +22,7 @@
|
|
22
22
|
$arrParam[] = $email;
|
23
23
|
$stmt->execute();
|
24
24
|
|
25
|
-
$row = $stmt->fetch();
|
25
|
+
$row = $stmt->fetch(PDO::FETCH_ASSOC);
|
26
26
|
if (0 < $row['cnt']) {
|
27
27
|
$error = "{$email}は既に登録されています";
|
28
28
|
}
|
1
修正
answer
CHANGED
@@ -17,6 +17,8 @@
|
|
17
17
|
// $sql = 'select * from userdata';
|
18
18
|
$sql = 'select count(*) as cnt from userdata where email=?';
|
19
19
|
$stmt = $dbh->prepare($sql);
|
20
|
+
|
21
|
+
$arrParam = array();
|
20
22
|
$arrParam[] = $email;
|
21
23
|
$stmt->execute();
|
22
24
|
|