{"id":988,"date":"2024-04-16T04:53:50","date_gmt":"2024-04-15T19:53:50","guid":{"rendered":"http:\/\/inwelly.com\/?p=988"},"modified":"2024-04-16T04:53:50","modified_gmt":"2024-04-15T19:53:50","slug":"php-laravel-db-%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%82%b4%ec%9a%a9-%ec%b6%9c%eb%a0%a5-2-2","status":"publish","type":"post","link":"https:\/\/inwelly.com\/?p=988","title":{"rendered":"PHP Laravel – DB \ud14c\uc774\ube14 \ub0b4\uc6a9 \ucd9c\ub825 2\/2"},"content":{"rendered":"\n

10)\u00a0 test \ud14c\uc774\ube14\uc5d0 \uac12 insert\u00a0
– \uc804\ud1b5\uc801\uc778 \ubc29\ubc95\uc73c\ub85c \uc9c1\uc811 mysql \uc811\uc18d\ud558\uc5ec insert \ud574\ub3c4 \ub418\uc9c0\ub9cc
“Tinker” \ub97c \uc0ac\uc6a9 \ud574\ub3c4 \ub41c\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

– “Tinker” \uc774\uc6a9 \ud558\uc5ec \ud14c\uc774\ube14\uc5d0 \uac12\uc744 INSERT \uc544\ub798\uc640 \uac19\uc774 \ud55c\ub2e4.
10 -1 ) \ucee8\ud2b8\ub864 \ud30c\uc77c \ub9cc\ub4e4\ub54c \ub9cc\ub4e4\uc5b4\uc9c4 \ubaa8\ub378(Model)\u00a0 \ud30c\uc77c\uc744 \uc5f4\uc5b4\uc11c \ud3b8\uc9d1\ud55c\ub2e4.\u00a0
~\/www\/app$ vi Test.php<\/p>\n\n\n\n

\n

<?php<\/p>\n\n\n\n

namespaceApp;<\/p>\n\n\n\n

use Illuminate\\Database\\Eloquent\\Model;<\/p>\n\n\n\n

classTestextendsModel<\/p>\n\n\n\n

{<\/p>\n\n\n\n

protected$table = ‘test’;<\/p>\n\n\n\n

protected$fillable = [‘subject’,’contents’];<\/p>\n\n\n\n

}<\/p>\n<\/blockquote>\n\n\n\n

10-2) \ud130\ubbf8\ub110 \uc5d0\uc11c “Tinker” \ub97c \uc2e4\ud589\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc544\ub798\uc640 \uac19\uc774 insert \ud55c\ub2e4.<\/p>\n\n\n\n

~\/www$ php artisan tinker<\/p>\n\n\n\n

Psy Shell v0.9.12 (PHP 7.2.19-0ubuntu0.18.04.2 \u2014 cli) by Justin Hileman<\/p>\n\n\n\n

>>> App\\Test::create([<\/p>\n\n\n\n

‘subject’ => ‘subject 1’,<\/p>\n\n\n\n

‘contents’ => ‘contents 1’<\/p>\n\n\n\n

]);<\/p>\n\n\n\n

=> App\\Test {#3003<\/p>\n\n\n\n

     subject: “subject 1”,<\/p>\n\n\n\n

     contents: “contents 1”,<\/p>\n\n\n\n

     updated_at: “2019-12-24 02:19:02”,<\/p>\n\n\n\n

     created_at: “2019-12-24 02:19:02”,<\/p>\n\n\n\n

     id: 1,<\/p>\n\n\n\n

   }<\/p>\n\n\n\n

>>> App\\Test::create([<\/p>\n\n\n\n

‘subject’ => ‘subject 2’,<\/p>\n\n\n\n

‘contents’ => ‘contents 2’<\/p>\n\n\n\n

]);<\/p>\n\n\n\n

=> App\\Test {#3015<\/p>\n\n\n\n

     subject: “subject 2”,<\/p>\n\n\n\n

     contents: “contents 2”,<\/p>\n\n\n\n

     updated_at: “2019-12-24 02:19:20”,<\/p>\n\n\n\n

     created_at: “2019-12-24 02:19:20”,<\/p>\n\n\n\n

     id: 2,<\/p>\n\n\n\n

   }<\/p>\n\n\n\n

>>> App\\Test::create([<\/p>\n\n\n\n

‘subject’ => ‘subject 3’,<\/p>\n\n\n\n

‘contents’ => ‘contents 3’<\/p>\n\n\n\n

]);<\/p>\n\n\n\n

=> App\\Test {#3004<\/p>\n\n\n\n

     subject: “subject 3”,<\/p>\n\n\n\n

     contents: “contents 3”,<\/p>\n\n\n\n

     updated_at: “2019-12-24 02:19:33”,<\/p>\n\n\n\n

     created_at: “2019-12-24 02:19:33”,<\/p>\n\n\n\n

     id: 3,<\/p>\n\n\n\n

   }<\/p>\n\n\n\n

>>> App\\Test::create([<\/p>\n\n\n\n

‘subject’ => ‘subject 4’,<\/p>\n\n\n\n

=> App\\Test {#3014tents 4′<\/p>\n\n\n\n

     subject: “subject 4”,<\/p>\n\n\n\n

     contents: “contents 4”,<\/p>\n\n\n\n

     updated_at: “2019-12-24 02:19:46”,<\/p>\n\n\n\n

     created_at: “2019-12-24 02:19:46”,<\/p>\n\n\n\n

     id: 4,<\/p>\n\n\n\n

   }<\/p>\n\n\n\n

>>><\/p>\n\n\n\n

Tinker  “\ud130\ubbf8\ub110” \uc885\ub8cc\uc2dc\uc5d0\ub294 “Ctrl + C”  \ud574\uc11c \ube60\uc838\ub098\uc640\ub3c4 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

10-3)  test \ud14c\uc774\ube14\uc5d0 \ub4f1\ub85d\ub41c \ub0b4\uc6a9 \ud655\uc778 \uc544\ub798 <\/p>\n\n\n\n

mysql> select * from test ;<\/p>\n\n\n\n

+—-+———–+————+———————+———————+<\/p>\n\n\n\n

| id | subject   | contents   | created_at          | updated_at          |<\/p>\n\n\n\n

+—-+———–+————+———————+———————+<\/p>\n\n\n\n

|  1 | subject 1 | contents 1 | 2019-12-24 02:19:02 | 2019-12-24 02:19:02 |<\/p>\n\n\n\n

|  2 | subject 2 | contents 2 | 2019-12-24 02:19:20 | 2019-12-24 02:19:20 |<\/p>\n\n\n\n

|  3 | subject 3 | contents 3 | 2019-12-24 02:19:33 | 2019-12-24 02:19:33 |<\/p>\n\n\n\n

|  4 | subject 4 | contents 4 | 2019-12-24 02:19:46 | 2019-12-24 02:19:46 |<\/p>\n\n\n\n

+—-+———–+————+———————+———————+<\/p>\n\n\n\n

4 rows in set (0.00 sec)<\/p>\n\n\n\n

11) \uc6f9 \ube0c\ub77c\uc6b0\uc838 \ud654\uba74\uc5d0 \ucd9c\ub825\ud558\uae30 
11-1) \ucee8\ud2b8\ub864 \ud30c\uc77c \ud3b8\uc9d1
 ~\/www\/app\/Http\/Controllers$ vi TestController.php<\/p>\n\n\n\n

\n

<?php<\/p>\n\n\n\n

namespaceApp\\Http\\Controllers;<\/p>\n\n\n\n

use App\\Test;<\/p>\n\n\n\n

use Illuminate\\Http\\Request;<\/p>\n\n\n\n

classTestControllerextendsController<\/p>\n\n\n\n

{<\/p>\n\n\n\n

\/**<\/p>\n\n\n\n

     * Display a listing of the resource.<\/p>\n\n\n\n

     *<\/p>\n\n\n\n

     * @return \\Illuminate\\Http\\Response<\/p>\n\n\n\n

     *\/<\/p>\n\n\n\n

publicfunctionindex()<\/p>\n\n\n\n

    {<\/p>\n\n\n\n

\/\/ return view(‘test.index’);<\/p>\n\n\n\n

$items = \\App\\Test::all(); <\/p>\n\n\n\n

\/\/ return $items;<\/p>\n\n\n\n

returnview(‘test.index’,compact(‘items’)); <\/p>\n\n\n\n

    }<\/p>\n<\/blockquote>\n\n\n\n

11-2) \ubdf0(view) \ud30c\uc77c \ud3b8\uc9d1 2\u00a0
~\/www\/resources\/views\/test$ vi index.blade.php<\/p>\n\n\n\n

\n

<!DOCTYPEhtml><html><\/p>\n\n\n\n

<head><\/p>\n\n\n\n

<title>TEST PAGE<\/title><\/p>\n\n\n\n

<\/head><\/p>\n\n\n\n

<body><\/p>\n\n\n\n

    TEST PAGE \uc785\ub2c8\ub2e4. <br><\/p>\n\n\n\n

<ul><\/p>\n\n\n\n

        @foreach($items as $column)<\/p>\n\n\n\n

<li>{{ $column->subject }}<\/li><\/p>\n\n\n\n

        @endforeach<\/p>\n\n\n\n

<\/ul><\/p>\n\n\n\n

<\/body><\/p>\n\n\n\n

<\/html><\/p>\n<\/blockquote>\n\n\n\n

12) \uacb0\uacfc \ud655\uc778 ( http:\/\/\ub3c4\uba54\uc778\/test )<\/p>\n\n\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

10)\u00a0 test \ud14c\uc774\ube14\uc5d0 \uac12 insert\u00a0– \uc804\ud1b5\uc801\uc778 \ubc29\ubc95\uc73c\ub85c \uc9c1\uc811 mysql \uc811\uc18d\ud558\uc5ec insert \ud574\ub3c4 \ub418\uc9c0\ub9cc“Tinker” \ub97c \uc0ac\uc6a9 \ud574\ub3c4 \ub41c\ub2e4. – “Tinker” \uc774\uc6a9 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[112],"tags":[],"class_list":["post-988","post","type-post","status-publish","format-standard","hentry","category-laravel"],"_links":{"self":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=988"}],"version-history":[{"count":1,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/988\/revisions"}],"predecessor-version":[{"id":991,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/988\/revisions\/991"}],"wp:attachment":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}