質問編集履歴
4
パスワードを晒していた。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -99,7 +99,7 @@
|
|
|
99
99
|
$email=$userData["email"];
|
|
100
100
|
$pass=password_hash($userData["password"],PASSWORD_DEFAULT);
|
|
101
101
|
try{
|
|
102
|
-
$pdo=new PDO("mysql:host=localhost;dbname=portfolio2;charset=utf8","root","
|
|
102
|
+
$pdo=new PDO("mysql:host=localhost;dbname=portfolio2;charset=utf8","root","パスワードです",[
|
|
103
103
|
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
|
|
104
104
|
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
|
|
105
105
|
PDO::ATTR_EMULATE_PREPARES=>false,
|
3
誤字があったので、修正。$password→$pass(dbconnect.php)
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -107,7 +107,7 @@
|
|
|
107
107
|
$stmt= $pdo->prepare($sql);
|
|
108
108
|
$stmt->bindValue(1,$username);
|
|
109
109
|
$stmt->bindValue(2,$email);
|
|
110
|
-
$stmt->bindValue(3,$pass
|
|
110
|
+
$stmt->bindValue(3,$pass);
|
|
111
111
|
$stmt->execute();
|
|
112
112
|
}catch(PDOException $e){
|
|
113
113
|
echo $e->getMessage() . PHP_EOL;
|
2
$stmt->bindValue()を3つ追加した。（dbconnect.php）
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -105,7 +105,10 @@
|
|
|
105
105
|
PDO::ATTR_EMULATE_PREPARES=>false,
|
|
106
106
|
]);
|
|
107
107
|
$stmt= $pdo->prepare($sql);
|
|
108
|
+
$stmt->bindValue(1,$username);
|
|
109
|
+
$stmt->bindValue(2,$email);
|
|
108
|
-
$stmt->
|
|
110
|
+
$stmt->bindValue(3,$password);
|
|
111
|
+
$stmt->execute();
|
|
109
112
|
}catch(PDOException $e){
|
|
110
113
|
echo $e->getMessage() . PHP_EOL;
|
|
111
114
|
exit;
|
1
・エラーメッセージを出力するようにした(dbconnect.php) ・$stmt->execute([$username,$email,$password]);に変更(dbconnect.php)
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -94,21 +94,21 @@
|
|
|
94
94
|
<?php
|
|
95
95
|
class CreateUser{
|
|
96
96
|
public function _construct($userData){
|
|
97
|
-
$result=false;
|
|
98
97
|
$sql="insert into users(name,email,password)values(?,?,?)";
|
|
99
98
|
$username=$userData["username"];
|
|
100
99
|
$email=$userData["email"];
|
|
101
100
|
$pass=password_hash($userData["password"],PASSWORD_DEFAULT);
|
|
102
101
|
try{
|
|
103
|
-
$pdo=new PDO("mysql:host=localhost;dbname=portfolio2;charset=utf8","root","
|
|
102
|
+
$pdo=new PDO("mysql:host=localhost;dbname=portfolio2;charset=utf8","root","rHXFDFk_Ss_4#SP",[
|
|
104
103
|
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
|
|
105
104
|
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
|
|
106
105
|
PDO::ATTR_EMULATE_PREPARES=>false,
|
|
107
106
|
]);
|
|
108
107
|
$stmt= $pdo->prepare($sql);
|
|
109
|
-
$stmt->execute([$username
|
|
108
|
+
$stmt->execute([$username,$email,$password]);
|
|
110
109
|
}catch(PDOException $e){
|
|
110
|
+
echo $e->getMessage() . PHP_EOL;
|
|
111
|
-
|
|
111
|
+
exit;
|
|
112
112
|
|
|
113
113
|
}}}
|
|
114
114
|
?>
|