質問編集履歴
2
MySQLの修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -197,14 +197,17 @@
|
|
|
197
197
|
}
|
|
198
198
|
```
|
|
199
199
|
```MySQL
|
|
200
|
+
mysql> show columns from users;
|
|
201
|
+
+----------+--------------+------+-----+---------+-------+
|
|
200
|
-
Field | Type | Null | Key | Default | Extra |
|
|
202
|
+
| Field | Type | Null | Key | Default | Extra |
|
|
201
203
|
+----------+--------------+------+-----+---------+-------+
|
|
202
204
|
| id | int | NO | PRI | NULL | |
|
|
203
205
|
| username | varchar(100) | YES | | NULL | |
|
|
204
206
|
| email | varchar(200) | YES | UNI | NULL | |
|
|
205
207
|
| verified | tinyint | YES | | NULL | |
|
|
206
208
|
| token | varchar(100) | YES | | NULL | |
|
|
207
|
-
| password | varchar(255) | YES | | NULL
|
|
209
|
+
| password | varchar(255) | YES | | NULL | |
|
|
210
|
+
+----------+--------------+------+-----+---------+-------+
|
|
208
211
|
```
|
|
209
212
|
### 試したこと
|
|
210
213
|
|
1
db.phpを追記した。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -88,7 +88,6 @@
|
|
|
88
88
|
}
|
|
89
89
|
}
|
|
90
90
|
}
|
|
91
|
-
|
|
92
91
|
```
|
|
93
92
|
```PHP
|
|
94
93
|
// signup.php
|
|
@@ -185,6 +184,18 @@
|
|
|
185
184
|
|
|
186
185
|
</html>
|
|
187
186
|
```
|
|
187
|
+
```PHP
|
|
188
|
+
// db.php
|
|
189
|
+
|
|
190
|
+
<?php
|
|
191
|
+
require 'constants.php';
|
|
192
|
+
|
|
193
|
+
$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
|
|
194
|
+
|
|
195
|
+
if ($conn->connect_error) {
|
|
196
|
+
die("Database error:" . $conn->connect_error);
|
|
197
|
+
}
|
|
198
|
+
```
|
|
188
199
|
```MySQL
|
|
189
200
|
Field | Type | Null | Key | Default | Extra |
|
|
190
201
|
+----------+--------------+------+-----+---------+-------+
|