質問編集履歴
2
完成コードを追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -91,4 +91,22 @@
|
|
|
91
91
|
|
|
92
92
|
mysql -V => `mysql Ver 14.14 Distrib 5.7.23`
|
|
93
93
|
php -V => `PHP 7.0.32-0ubuntu0.16.04.1`
|
|
94
|
-
OS => `Linux 4.4.0-133-generic #159-Ubuntu`
|
|
94
|
+
OS => `Linux 4.4.0-133-generic #159-Ubuntu`
|
|
95
|
+
|
|
96
|
+
|
|
97
|
+
###追記
|
|
98
|
+
指摘を受けた後に直したコード(login.php)
|
|
99
|
+
```PHP
|
|
100
|
+
/* query DB */
|
|
101
|
+
$UID=$_POST["userPassword"];
|
|
102
|
+
$pass=$_POST["password"];
|
|
103
|
+
$query = "select exists(select * from db where userID='$UID' and password='$pass')";
|
|
104
|
+
$result = $mysqli->query($query);
|
|
105
|
+
if($result->fetch_assoc()){
|
|
106
|
+
echo "User $UID have successfully logged in!!" . "<br>";
|
|
107
|
+
}
|
|
108
|
+
else {
|
|
109
|
+
echo "Could not find user $UID" . "<br>";
|
|
110
|
+
}
|
|
111
|
+
|
|
112
|
+
```
|
1
コード訂正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -73,7 +73,7 @@
|
|
|
73
73
|
+------------------+----------+-----------+---------------+----------+---------------+
|
|
74
74
|
```
|
|
75
75
|
|
|
76
|
-
######htmlに表示される内容
|
|
76
|
+
######htmlに表示される内容(ID:5bd70d70add61, pass:XXXXXでログインするがXXXXXのパスワードはテーブルに無いにも関わらずログインに成功)
|
|
77
77
|
```
|
|
78
78
|
Connect success!
|
|
79
79
|
id : 5bd70d70add61
|