質問編集履歴
4
データ追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -271,3 +271,41 @@
|
|
271
271
|
7 rows in set (0.00 sec)
|
272
272
|
|
273
273
|
```
|
274
|
+
|
275
|
+
|
276
|
+
|
277
|
+
### データ(2019/08/24 21:50追記)
|
278
|
+
|
279
|
+
```
|
280
|
+
|
281
|
+
mysql> select * from posts where id = 1;
|
282
|
+
|
283
|
+
+----+---------+---------------+---------------------+---------------------+
|
284
|
+
|
285
|
+
| id | user_id | emoji | created_at | updated_at |
|
286
|
+
|
287
|
+
+----+---------+---------------+---------------------+---------------------+
|
288
|
+
|
289
|
+
| 1 | 1 | りんご???? | 2019-08-14 11:38:05 | 2019-08-14 11:38:05 |
|
290
|
+
|
291
|
+
+----+---------+---------------+---------------------+---------------------+
|
292
|
+
|
293
|
+
1 row in set (0.00 sec)
|
294
|
+
|
295
|
+
|
296
|
+
|
297
|
+
mysql> select * from users where id = 1;
|
298
|
+
|
299
|
+
+----+-------+-------------------+--------------------------------------------------------------+--------------------------------------------------------------+---------------------+---------------------+
|
300
|
+
|
301
|
+
| id | name | email | password | remember_token | created_at | updated_at |
|
302
|
+
|
303
|
+
+----+-------+-------------------+--------------------------------------------------------------+--------------------------------------------------------------+---------------------+---------------------+
|
304
|
+
|
305
|
+
| 1 | user1 | user1@example.com | $2y$10$oFI7Koi/jEx/ghZhjce4HOEFzQGHcGpTT5xERyNNM9CqF0DY8jOXq | WVygmE7sHrYhSSYQ7fHOQH6kctJJrau0mHSHf2ZhMSqdsz3YvWNF55rJyu85 | 2019-08-14 11:11:54 | 2019-08-14 11:11:54 |
|
306
|
+
|
307
|
+
+----+-------+-------------------+--------------------------------------------------------------+--------------------------------------------------------------+---------------------+---------------------+
|
308
|
+
|
309
|
+
1 row in set (0.00 sec)
|
310
|
+
|
311
|
+
```
|
3
テーブルの情報を追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -211,3 +211,63 @@
|
|
211
211
|
PHP 7.1
|
212
212
|
|
213
213
|
Laravel 5.5
|
214
|
+
|
215
|
+
|
216
|
+
|
217
|
+
### テーブルの情報(2019/08/24 21:20追記)
|
218
|
+
|
219
|
+
```
|
220
|
+
|
221
|
+
mysql> desc posts;
|
222
|
+
|
223
|
+
+------------+------------------+------+-----+---------+----------------+
|
224
|
+
|
225
|
+
| Field | Type | Null | Key | Default | Extra |
|
226
|
+
|
227
|
+
+------------+------------------+------+-----+---------+----------------+
|
228
|
+
|
229
|
+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
|
230
|
+
|
231
|
+
| user_id | int(10) unsigned | NO | MUL | NULL | |
|
232
|
+
|
233
|
+
| emoji | text | NO | | NULL | |
|
234
|
+
|
235
|
+
| created_at | timestamp | YES | | NULL | |
|
236
|
+
|
237
|
+
| updated_at | timestamp | YES | | NULL | |
|
238
|
+
|
239
|
+
+------------+------------------+------+-----+---------+----------------+
|
240
|
+
|
241
|
+
5 rows in set (0.00 sec)
|
242
|
+
|
243
|
+
```
|
244
|
+
|
245
|
+
```
|
246
|
+
|
247
|
+
mysql> desc users;
|
248
|
+
|
249
|
+
+----------------+------------------+------+-----+---------+----------------+
|
250
|
+
|
251
|
+
| Field | Type | Null | Key | Default | Extra |
|
252
|
+
|
253
|
+
+----------------+------------------+------+-----+---------+----------------+
|
254
|
+
|
255
|
+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
|
256
|
+
|
257
|
+
| name | varchar(255) | NO | | NULL | |
|
258
|
+
|
259
|
+
| email | varchar(255) | NO | UNI | NULL | |
|
260
|
+
|
261
|
+
| password | varchar(255) | NO | | NULL | |
|
262
|
+
|
263
|
+
| remember_token | varchar(100) | YES | | NULL | |
|
264
|
+
|
265
|
+
| created_at | timestamp | YES | | NULL | |
|
266
|
+
|
267
|
+
| updated_at | timestamp | YES | | NULL | |
|
268
|
+
|
269
|
+
+----------------+------------------+------+-----+---------+----------------+
|
270
|
+
|
271
|
+
7 rows in set (0.00 sec)
|
272
|
+
|
273
|
+
```
|
2
タイトル変更
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
Laravel
|
1
|
+
Userテーブルを紐付けたい(Laravel Eloquent)
|
test
CHANGED
File without changes
|
1
誤字修正等
test
CHANGED
File without changes
|
test
CHANGED
@@ -20,7 +20,7 @@
|
|
20
20
|
|
21
21
|
### 発生している問題
|
22
22
|
|
23
|
-
|
23
|
+
Userテーブルの内容を紐付けができない
|
24
24
|
|
25
25
|
|
26
26
|
|
@@ -186,7 +186,7 @@
|
|
186
186
|
|
187
187
|
$p = Post::find(1);
|
188
188
|
|
189
|
-
var_dump($p->users); // null
|
189
|
+
var_dump($p->users); // nullになる
|
190
190
|
|
191
191
|
|
192
192
|
|