{"id":163,"date":"2023-08-29T17:08:24","date_gmt":"2023-08-29T08:08:24","guid":{"rendered":"https:\/\/yutanpo-create.tech\/?p=163"},"modified":"2023-11-21T10:04:42","modified_gmt":"2023-11-21T01:04:42","slug":"laravel-error-01","status":"publish","type":"post","link":"https:\/\/yutanpo-create.tech\/?p=163","title":{"rendered":"\u3010Laravel\u3011\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30a8\u30e9\u30fc\u306e\u3042\u308b\u3042\u308b\uff06\u5bfe\u51e6\u6cd5"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"330\" src=\"https:\/\/yutanpo-create.tech\/wp-content\/uploads\/2023\/08\/thumbnail_04.png\" alt=\"\" class=\"wp-image-164\" srcset=\"https:\/\/yutanpo-create.tech\/wp-content\/uploads\/2023\/08\/thumbnail_04.png 680w, https:\/\/yutanpo-create.tech\/wp-content\/uploads\/2023\/08\/thumbnail_04-300x146.png 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>Laravel\u3067\u958b\u767a\u3092\u3059\u308b\u306b\u3042\u305f\u3063\u3066\u3001 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u69cb\u7bc9\u3059\u308b\u969b\u306b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u304c\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u79c1\u306f\u3001\u3053\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u5b9f\u884c\u306b\u3042\u305f\u308a\u300cphp artisan migrate\u300d\u3092\u53e9\u304f\u3068\u304d\u306b\u6bce\u5ea6\u306e\u3088\u3046\u306b\u30a8\u30e9\u30fc\u304c\u51fa\u307e\u3059\u30fb\u30fb\u30fb\u6ce3<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u3068\u3044\u3046\u3053\u3068\u3067\u5099\u5fd8\u9332\u304c\u3066\u3089\u3001\u3088\u304f\u3042\u308b\u30a8\u30e9\u30fc\u30d1\u30bf\u30fc\u30f3\u3068\u3001\u305d\u306e\u5bfe\u51e6\u6cd5\u306b\u3064\u3044\u3066\u3067\u3059\u3002\u4f55\u304b\u306e\u30d2\u30f3\u30c8\u306b\u306a\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-heading c-section__title\"><div class=\"vk_heading vk_heading-style-default\"><h2 style=\"margin-bottom:2rem\" class=\"vk_heading_title vk_heading_title-style-default\"><span>\u5148\u306b\u7d50\u8ad6\u3002<\/span><\/h2><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u3060\u3044\u305f\u3044\u30b3\u30ec\u306e\u3069\u308c\u304b\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-border-box vk_borderBox vk_borderBox-background-transparent is-style-vk_borderBox-style-solid-kado-tit-tab\"><div class=\"vk_borderBox_title_container\"><i class=\"\"><\/i><h4 class=\"vk_borderBox_title\">\u307e\u305a\u30b3\u30ec\u78ba\u8a8d\u3057\u3066\u307f\u3066\u3002<\/h4><\/div><div class=\"vk_borderBox_body\">\n<p>\u25cf  <span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">DB\u306b\u305d\u3082\u305d\u3082\u30d9\u30fc\u30b9\u3068\u306a\u308b\u30c6\u30fc\u30d6\u30eb\u4f5c\u3063\u3066\u306a\u3044\u3002<\/span><\/p>\n\n\n\n<p>\u25cf <span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">.env\u30d5\u30a1\u30a4\u30eb\u306e DB\u8a2d\u5b9a\u304a\u304b\u3057\u3044 or \u5909\u66f4\u304c\u53cd\u6620\u3055\u308c\u3066\u3044\u306a\u3044<\/span><\/p>\n\n\n\n<p>\u25cf <span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u306b\u300conDelete('cascade')\u300d\u3068\u300conUpdate('cascade')\u300d\u304c\u629c\u3051\u3066\u308b<\/span><\/p>\n\n\n\n<p>\u25cf <span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">\u30c6\u30fc\u30d6\u30eb\u306e\u9806\u756a\u554f\u984c\uff08\u5916\u90e8\u30ad\u30fc\u3067\u53c2\u7167\u3059\u308b\u305f\u3081\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u305d\u3082\u305d\u3082\u672a\u5b8c\u6210\uff09<\/span><\/p>\n\n\n\n<p>\u25cf <span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">\u30ab\u30e9\u30e0\u306e\u300c\u578b\u300d\u304c\u53c2\u7167\u5143\u3068\u53c2\u7167\u5148\u3067\u9055\u3046\u3002<\/span><\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u3053\u306e\u3069\u308c\u304b\u304c\u3042\u308b\u3060\u3051\u3067\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u3088\u3046\u3068\u3057\u305f\u3068\u304d\u306b\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305d\u308c\u305e\u308c\u306b\u3064\u3044\u3066\u3082\u8efd\u304f\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-heading c-section__subtitle\"><div class=\"vk_heading vk_heading-style-default\"><h3 style=\"margin-bottom:2rem\" class=\"vk_heading_title vk_heading_title-style-default\"><span>\u3000\u2460 DB\u306b\u305d\u3082\u305d\u3082\u30d9\u30fc\u30b9\u3068\u306a\u308b\u30c6\u30fc\u30d6\u30eb\u4f5c\u3063\u3066\u306a\u3044\u3002<\/span><\/h3><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u305d\u308a\u3083\u305d\u3046\u3088\u306d\u3002\u3063\u3066\u8a71\u3067\u3059\u304c\u3001\u610f\u5916\u3068\u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u3067\u958b\u767a \u2192 \u30c7\u30d7\u30ed\u30a4\u3057\u305f\u3068\u304d\u306a\u3069\u306b\u3084\u3063\u3061\u3083\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p><mark style=\"background-color:#000000\" class=\"has-inline-color has-white-color\">SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = \uff08\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u540d\u524d\uff09 and table_name = migrations and table_type = 'BASE TABLE')<\/mark><\/p>\n\n\n\n<p>\u591a\u5206\u3001\u3053\u3093\u306a\u611f\u3058\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u308b\u306f\u305a\u3002<br>\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u7121\u3044\u3093\u3060\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u308f\u3051\u304c\u306a\u3044\u3067\u3059\u306d\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p> DB\u306e\u72b6\u614b\u3001\u7279\u306b\u4eca\u5b9f\u884c\u3057\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u30d9\u30fc\u30b9\u3068\u306a\u308b\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308b\u304b\u306f\u78ba\u8a8d\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-heading c-section__subtitle\"><div class=\"vk_heading vk_heading-style-default\"><h3 style=\"margin-bottom:2rem\" class=\"vk_heading_title vk_heading_title-style-default\"><span>\u3000\u2461 .env\u30d5\u30a1\u30a4\u30eb\u306e DB\u8a2d\u5b9a\u304a\u304b\u3057\u3044 or \u5909\u66f4\u304c\u53cd\u6620\u3055\u308c\u3066\u3044\u306a\u3044<\/span><\/h3><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u3053\u308c\u3082\u5272\u3068\u3084\u308a\u304c\u3061\u3002\u3068\u3044\u3046\u304b\u5fd8\u308c\u304c\u3061\u3002<\/p>\n\n\n\n<p>\u4f8b\u3048\u3070\u3001\u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u3067\u3001MySQL\u3092\u7528\u3044\u3066\u3044\u308b\u5834\u5408\u306e\u300c.env\u300d\u306f<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>DB_CONNECTION=mysql\nDB_HOST=127.0.0.1\nDB_PORT=3306\nDB_DATABASE=\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u540d\u524d\nDB_USERNAME=\u4efb\u610f\u306e\u30e6\u30fc\u30b6\u30fc\u540d\nDB_PASSWORD=\u4efb\u610f\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\nDB_SOCKET=\/Applications\/MAMP\/tmp\/mysql\/mysql.sock<\/code><\/pre><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u306e\u3088\u3046\u306a\u5f62\u306b\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u30fb\u30c7\u30d7\u30ed\u30a4\u3057\u305f\u3068\u304d\u306b\u3001<span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">DB_SOCKET\u3000\u306e\u90e8\u5206\u3092\u5909\u66f4\u3057\u5fd8\u308c<\/span>\u3066\u3044\u305f\u308a<\/p>\n\n\n\n<p><mark style=\"background-color:#000000\" class=\"has-inline-color has-white-color\">SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = \uff08\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u540d\u524d\uff09 and table_name = migrations and table_type = 'BASE TABLE')<\/mark><\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u30fb<span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">DB_DATABASE\u3000\u306e\u90e8\u5206\u306e\u540d\u524d\u304c\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u540d\u3068\u9055\u3063\u305f<\/span>\u308a<\/p>\n\n\n\n<p><mark style=\"background-color:#000000\" class=\"has-inline-color has-white-color\">SQLSTATE[HY000] [1049] Unknown database \u300c.env\u306eDB_DATABASE\u306e\u90e8\u5206\u300d (SQL: select * from information_schema.tables where table_schema = \u3007\u3007 and table_name = migrations and table_type = 'BASE TABLE')<\/mark><\/p>\n\n\n\n<p>\u3059\u308b\u3068\u30a2\u30a6\u30c8\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-balloon vk_balloon vk_balloon-position-left vk_balloon-type-speech vk_balloon-animation-none\"><div class=\"vk_balloon_icon\"><figure><img decoding=\"async\" class=\"vk_balloon_icon_image vk_balloon_icon_image-type-normal \" src=\"http:\/\/yutanpo-create.tech\/wp-content\/uploads\/2023\/08\/cropped-DreamShaper_v7_A_back_view_of_a_man_looking_at_a_computer_whil_3.jpg\" alt=\"\"\/><figcaption class=\"vk_balloon_icon_name\">\u3086\u305f\u3093\u307d<\/figcaption><\/figure><\/div><div class=\"vk_balloon_content_outer\"><div class=\"vk_balloon_content  has-background-color has-vk-color-custom-2-background-color \"><span class=\"vk_balloon_content_before  has-text-color has-vk-color-custom-2-color\"><\/span><span class=\"vk_balloon_content_after \"><\/span>\n<p>.env\u306e\u8a2d\u5b9a\u5909\u66f4\u5f8c\u306f\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u30ad\u30e3\u30c3\u30b7\u30e5\u3092\u30af\u30ea\u30a2\u3059\u308b\u306e\u3092\u5fd8\u308c\u305a\u306b\u3002<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-balloon vk_balloon vk_balloon-position-right vk_balloon-type-speech vk_balloon-animation-none\"><div class=\"vk_balloon_icon\"><figure><img decoding=\"async\" class=\"vk_balloon_icon_image vk_balloon_icon_image-type-normal \" src=\"http:\/\/yutanpo-create.tech\/wp-content\/uploads\/2023\/08\/\u540d\u79f0\u672a\u8a2d\u5b9a\u306e\u30c7\u30b6\u30a4\u30f3-2.png\" alt=\"\"\/><figcaption class=\"vk_balloon_icon_name\">\u306c\u3053\u5148\u751f<\/figcaption><\/figure><\/div><div class=\"vk_balloon_content_outer\"><div class=\"vk_balloon_content  has-background-color has-vk-color-custom-5-background-color \"><span class=\"vk_balloon_content_before  has-text-color has-vk-color-custom-5-color\"><\/span><span class=\"vk_balloon_content_after \"><\/span>\n<p>\u30b3\u30de\u30f3\u30c9\u306f\u300cphp artisan config:cache\u300d\u3068\u304b\u3067\u3044\u3051\u308b\u30cb\u30e3<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-heading c-section__subtitle\"><div class=\"vk_heading vk_heading-style-default\"><h3 style=\"margin-bottom:2rem\" class=\"vk_heading_title vk_heading_title-style-default\"><span>\u3000\u2462 \u5916\u90e8\u30ad\u30fc\u5236\u7d04\u306b\u300conDelete('cascade')\u300d\u3068\u300conUpdate('cascade')\u300d\u304c\u629c\u3051\u3066\u308b<\/span><\/h3><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u3053\u308c\u304c\u629c\u3051\u3066\u3044\u308b\u3068\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u304c\u304b\u304b\u3063\u3066\u3044\u308b\u30ab\u30e9\u30e0\u3092\u30a4\u30b8\u308b\u3068\u304d\u306b\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u5916\u90e8\u30ad\u30fc\u5236\u7d04\u3092\u4ed8\u3051\u3064\u3064\u3082\u3001\u305d\u306e\u30ab\u30e9\u30e0\u306e\u5909\u66f4\uff08\u524a\u9664\u30fb\u66f4\u65b0\uff09\u3092\u8a31\u5bb9\u3059\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001\u3053\u308c\u3092\u8ffd\u8a18\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-php\" data-lang=\"PHP\"><code>$table-&gt;foreign(&#39;user_id&#39;)-&gt;references(&#39;id&#39;)-&gt;on(&#39;users&#39;)-&gt;onDelete(&#39;cascade&#39;)-&gt;onUpdate(&#39;cascade&#39;);<\/code><\/pre><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-heading c-section__subtitle\"><div class=\"vk_heading vk_heading-style-default\"><h3 style=\"margin-bottom:2rem\" class=\"vk_heading_title vk_heading_title-style-default\"><span>\u3000\u2463 \u30c6\u30fc\u30d6\u30eb\u306e\u9806\u756a\u554f\u984c\uff08\u5916\u90e8\u30ad\u30fc\u3067\u53c2\u7167\u3059\u308b\u305f\u3081\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u305d\u3082\u305d\u3082\u672a\u5b8c\u6210\uff09<\/span><\/h3><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u3053\u308c\u304c\u610f\u5916\u3068\u30cf\u30de\u3063\u3061\u3083\u3046\u90e8\u5206\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p><mark style=\"background-color:#000000\" class=\"has-inline-color has-white-color\">SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `\u3007\u3007\u30c6\u30fc\u30d6\u30eb<code> add constraint <\/code>\u25a1\u25a1_foreign` foreign key (`\u25b3\u25b3`) references `project_type` (`\u25b3\u306e\u76f8\u624b`) on delete cascade on update cascade)<\/mark><\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u306e\u3088\u3046\u306a\u5f53\u305f\u308a\u969c\u308a\u306a\u3044\u611f\u3058\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u3002<\/p>\n\n\n\n<p>\u30a8\u30e9\u30fc\u306e\u539f\u56e0\u306f\u300c\u5916\u90e8\u30ad\u30fc\u3092\u4f7f\u304a\u3046\u3068\u3057\u3066\u308b\u3051\u3069\u3001\u305d\u3093\u306a\u3093\uff08\u30ab\u30e9\u30e0\u306a\u308a\u30c6\u30fc\u30d6\u30eb\u306a\u308a\u304c\uff09\u7121\u3044\u3093\u3060\u3051\u3069\u30fb\u30fb\u30fb\u3002\u300d\u3063\u3066\u3053\u3068\u3089\u3057\u3044\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3059\u308b\u3068\u53e4\u3044\u9806\u306b\u8aad\u307f\u8fbc\u3093\u3067\u3044\u308b\u3088\u3046\u306a\u306e\u3067\u3001<span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">\u300c\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u306e\u9806\u756a\u3092\u5165\u308c\u66ff\u3048\u308b\u300d\u5fc5\u8981\u304c\u3042\u308b<\/span>\u3002<\/p>\n\n\n\n<p>\u305d\u3093\u306a\u5834\u5408\u304c\u3042\u308b\u306e\u304c\u3053\u306e\u30d1\u30bf\u30fc\u30f3\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>\u251c\u2500\u2500 database\n\u2502   \u251c\u2500\u2500 factories\n\u2502   \u2502   \u2514\u2500\u2500 UserFactory.php\n\u2502   \u251c\u2500\u2500 migrations\n\u2502   \u2502   \u251c\u2500\u2500 2014_10_12_000000_create_users_table.php\n\u2502   \u2502   \u251c\u2500\u2500 2014_10_12_100000_create_password_resets_table.php\n\u2502   \u2502   \u251c\u2500\u2500 2023_08_29_041302_create_category_table.php\n\u2502   \u2502   \u251c\u2500\u2500 2023_08_29_041513_create_purchase_table.php\n\u2502   \u2502   \u251c\u2500\u2500 2023_08_29_041727_create_goods_table.php\n\u2502   \u2514\u2500\u2500 seeds\n\u2502       \u2514\u2500\u2500 DatabaseSeeder.php<\/code><\/pre><\/div>\n\n\n\n<p>\u3053\u3093\u306a\u611f\u3058\u306e\u69cb\u6210\u306b\u306a\u3063\u3066\u3044\u308b\u3068\u4eee\u5b9a\u3057\u3066<\/p>\n\n\n\n<p>\u300cpurchase\uff08\u8cfc\u5165\uff09\u300d\u30c6\u30fc\u30d6\u30eb\u3067\u306f\u3001\u300c\u5546\u54c1\uff08goods\uff09\u300d\u3092\u8cfc\u5165\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u306eID\u3092\u5916\u90e8\u30ad\u30fc\u3092\u7528\u3044\u3066\u7d10\u3065\u3051\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u3088\u3046\u306a\u5834\u5408\u3001<strong><span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">\u5148\u306b\u5546\u54c1\uff08goods\uff09\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u3089\u308c\u3066\u3044\u306a\u3044\u3068\u3001\u3069\u3053\u306b\u5916\u90e8\u30ad\u30fc\u3092\u3064\u3051\u308b\u76f8\u624b\u3044\u308b\u3093\u3067\u3059\u304b\uff1f<\/span><\/strong>\u3068\u306a\u308a\u30a8\u30e9\u30fc\u304c\u8d77\u3053\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u3082\u3057\u3001\u3053\u308c\u306b\u5f53\u3066\u306f\u307e\u3063\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u30d5\u30a1\u30a4\u30eb\u540d\u306e\u65e5\u6642\u306e\u90e8\u5206\u3060\u3051\u5909\u66f4\u3067OK\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>\u251c\u2500\u2500 database\n\u2502   \u251c\u2500\u2500 factories\n\u2502   \u2502   \u2514\u2500\u2500 UserFactory.php\n\u2502   \u251c\u2500\u2500 migrations\n\u2502   \u2502   \u251c\u2500\u2500 2014_10_12_000000_create_users_table.php\n\u2502   \u2502   \u251c\u2500\u2500 2014_10_12_100000_create_password_resets_table.php\n\u2502   \u2502   \u251c\u2500\u2500 2023_08_29_041302_create_category_table.php\n\u2502   \u2502   \u251c\u2500\u2500 2023_08_29_041513_create_purchase_table.php\n\u2502   \u2502   \u251c\u2500\u2500 2023_08_29_041420_create_goods_table.php\u3000\u3000\/\/ \u3053\u3053\u306e\u300c2023_08_29\u300d\u4ee5\u964d\u3092\u3001purchase\u30c6\u30fc\u30d6\u30eb\u306e\u3088\u308a\u524d\u306b\u5909\u66f4\n\u2502   \u2514\u2500\u2500 seeds\n\u2502       \u2514\u2500\u2500 DatabaseSeeder.php<\/code><\/pre><\/div>\n\n\n\n<p>\u30d5\u30a1\u30a4\u30eb\u306e\u9806\u756a\u306f\uff08\u304d\u3063\u3068\uff09\u52dd\u624b\u306b\u5165\u308c\u66ff\u308f\u308a\u3001\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3059\u308b\u3068\u304d\u306b\u8aad\u307f\u8fbc\u307e\u308c\u308b\u9806\u756a\u304c\u5909\u308f\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-heading c-section__subtitle\"><div class=\"vk_heading vk_heading-style-default\"><h3 style=\"margin-bottom:2rem\" class=\"vk_heading_title vk_heading_title-style-default\"><span>\u3000\u2464 \u30ab\u30e9\u30e0\u306e\u300c\u578b\u300d\u304c\u53c2\u7167\u5143\u3068\u53c2\u7167\u5148\u3067\u9055\u3046\u3002<\/span><\/h3><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p><mark style=\"background-color:#000000\" class=\"has-inline-color has-white-color\">SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = \u3007\u3007 and table_name = migrations and table_type = 'BASE TABLE')<\/mark><\/p>\n\n\n\n<p>\u3063\u3066\u611f\u3058\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30bf\u30a4\u30c8\u30eb\u306e\u901a\u308a\u3067\u3059\u304c\u3001\u5916\u90e8\u30ad\u30fc\u3092\u3064\u3051\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u30ab\u30e9\u30e0\u540c\u58eb\u306e\u300c\u30c7\u30fc\u30bf\u578b\u300d\u304c\u9055\u3046\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u5148\u8ff0\u306e\u300cpurchase\u300d\u3068\u300cgoods\u300d\u3092\u4f8b\u306b\u8003\u3048\u305f\u3068\u304d<\/p>\n\n\n\n<p>\u30fbpurchase \u306b\u306f\u300cgoods_id\u300d\u30ab\u30e9\u30e0\u304c\u5b58\u5728\u3057\u3001\u300cgoods\u300d\u30c6\u30fc\u30d6\u30eb\u306e\u300cid\u300d\u3092\u3082\u3068\u306b\u3001\u3069\u306e\u5546\u54c1\u3092\u8cfc\u5165\u3057\u305f\u304b\u3092\u7d10\u3065\u3051\u305f\u3044\u3002<\/p>\n\n\n\n<p>\u3068\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u300cgoods_id\u300d\u3068\u300cid\u300d\u306e<strong><span data-color=\"#fffd6b\" style=\"background: linear-gradient(transparent 60%,rgba(255, 253, 107, 0.7) 0);\" class=\"vk_highlighter\">\u578b\u3092\u305d\u308d\u3048\u308b<\/span><\/strong>\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-php\" data-lang=\"PHP\"><code>$table-&gt;bigIncrements(&#39;id&#39;);\u3000\/\/ goods\u30c6\u30fc\u30d6\u30eb\u306eID\u3002\u578b\u306fBIGINT\n$table-&gt;integer(&#39;goods_id&#39;);\u3000\/\/\u30fb\u30fb\u30fb\u30c0\u30e1\u3002\n$table-&gt;bigInteger(&#39;goods_id&#39;);\u3000\/\/\u30fb\u30fb\u30fbOK<\/code><\/pre><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-heading c-section__title\"><div class=\"vk_heading vk_heading-style-default\"><h2 style=\"margin-bottom:2rem\" class=\"vk_heading_title vk_heading_title-style-default\"><span>\u307e\u3068\u3081<\/span><\/h2><\/div><\/div>\n\n\n\n<div class=\"wp-block-vk-blocks-spacer vk_spacer vk_spacer-type-margin-top\"><div class=\"vk_block-margin-md--margin-top\"><\/div><\/div>\n\n\n\n<p>\u4ed6\u306b\u3082\u300c\u5358\u7d14\u306a\u30b9\u30da\u30eb\u30df\u30b9\u300d\u306a\u3069\u3001\u8272\u3093\u306a\u30a8\u30e9\u30fc\u306e\u30d1\u30bf\u30fc\u30f3\u304c\u3042\u308b\u3068\u306f\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u305f\u3060\u3001\u4eca\u56de\u306f\u79c1\u500b\u4eba\u304c\u6bce\u5ea6\u306e\u3088\u3046\u306b\u629c\u3051\u3066\u3057\u307e\u3046\u90e8\u5206\u3092\u7d39\u4ecb\u3055\u305b\u3066\u3082\u3089\u3044\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>Laravel\u521d\u5b66\u8005\u306e\u65b9\u3005\u306a\u3069\u306e\u304a\u5f79\u306b\u7acb\u3066\u305f\u3089\u5e78\u3044\u3067\u3059\u3002<\/p>\n<div class=\"veu_socialSet veu_socialSet-position-after veu_contentAddSection\"><script>window.twttr=(function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],t=window.twttr||{};if(d.getElementById(id))return t;js=d.createElement(s);js.id=id;js.src=\"https:\/\/platform.twitter.com\/widgets.js\";fjs.parentNode.insertBefore(js,fjs);t._e=[];t.ready=function(f){t._e.push(f);};return t;}(document,\"script\",\"twitter-wjs\"));<\/script><ul><li class=\"sb_facebook sb_icon\"><a class=\"sb_icon_inner\" href=\"\/\/www.facebook.com\/sharer.php?src=bm&u=https%3A%2F%2Fyutanpo-create.tech%2F%3Fp%3D163&amp;t=%E3%82%86%E3%81%9F%E3%82%93%E3%81%BD%E3%81%AE%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2%E6%97%A5%E8%A8%98\" target=\"_blank\" onclick=\"window.open(this.href,'FBwindow','width=650,height=450,menubar=no,toolbar=no,scrollbars=yes');return false;\"><span class=\"vk_icon_w_r_sns_fb icon_sns\"><\/span><span class=\"sns_txt\">Facebook<\/span><span class=\"veu_count_sns_fb\"><\/span><\/a><\/li><li class=\"sb_x_twitter sb_icon\"><a class=\"sb_icon_inner\" href=\"\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fyutanpo-create.tech%2F%3Fp%3D163&amp;text=%E3%82%86%E3%81%9F%E3%82%93%E3%81%BD%E3%81%AE%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2%E6%97%A5%E8%A8%98\" target=\"_blank\" ><span class=\"vk_icon_w_r_sns_x_twitter icon_sns\"><\/span><span class=\"sns_txt\">X<\/span><\/a><\/li><li class=\"sb_hatena sb_icon\"><a class=\"sb_icon_inner\" href=\"\/\/b.hatena.ne.jp\/add?mode=confirm&url=https%3A%2F%2Fyutanpo-create.tech%2F%3Fp%3D163&amp;title=%E3%82%86%E3%81%9F%E3%82%93%E3%81%BD%E3%81%AE%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2%E6%97%A5%E8%A8%98\" target=\"_blank\"  onclick=\"window.open(this.href,'Hatenawindow','width=650,height=450,menubar=no,toolbar=no,scrollbars=yes');return false;\"><span class=\"vk_icon_w_r_sns_hatena icon_sns\"><\/span><span class=\"sns_txt\">Hatena<\/span><span class=\"veu_count_sns_hb\"><\/span><\/a><\/li><li class=\"sb_pocket sb_icon\"><a class=\"sb_icon_inner\"  href=\"\/\/getpocket.com\/edit?url=https%3A%2F%2Fyutanpo-create.tech%2F%3Fp%3D163&title=%E3%82%86%E3%81%9F%E3%82%93%E3%81%BD%E3%81%AE%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2%E6%97%A5%E8%A8%98\" target=\"_blank\"  onclick=\"window.open(this.href,'Pokcetwindow','width=650,height=450,menubar=no,toolbar=no,scrollbars=yes');return false;\"><span class=\"vk_icon_w_r_sns_pocket icon_sns\"><\/span><span class=\"sns_txt\">Pocket<\/span><span class=\"veu_count_sns_pocket\"><\/span><\/a><\/li><li class=\"sb_copy sb_icon\"><button class=\"copy-button sb_icon_inner\"data-clipboard-text=\"\u3086\u305f\u3093\u307d\u306e\u30a8\u30f3\u30b8\u30cb\u30a2\u65e5\u8a18 https:\/\/yutanpo-create.tech\/?p=163\"><span class=\"vk_icon_w_r_sns_copy icon_sns\"><i class=\"fas fa-copy\"><\/i><\/span><span class=\"sns_txt\">Copy<\/span><\/button><\/li><\/ul><\/div><!-- [ \/.socialSet ] -->","protected":false},"excerpt":{"rendered":"<p>Laravel\u3067\u958b\u767a\u3092\u3059\u308b\u306b\u3042\u305f\u3063\u3066\u3001 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u69cb\u7bc9\u3059\u308b\u969b\u306b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u304c\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002 \u79c1\u306f\u3001\u3053\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u5b9f\u884c\u306b\u3042\u305f\u308a\u300cphp artisan migrate\u300d\u3092\u53e9\u304f\u3068\u304d\u306b\u6bce\u5ea6\u306e\u3088\u3046 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":164,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"vkexunit_cta_each_option":"","footnotes":""},"categories":[11,9],"tags":[14,13,25],"class_list":["post-163","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-laravel","category-php","tag-laravel","tag-laravel5-8","tag-25"],"_links":{"self":[{"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=\/wp\/v2\/posts\/163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=163"}],"version-history":[{"count":11,"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=\/wp\/v2\/posts\/163\/revisions"}],"predecessor-version":[{"id":352,"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=\/wp\/v2\/posts\/163\/revisions\/352"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=\/wp\/v2\/media\/164"}],"wp:attachment":[{"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yutanpo-create.tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}