entityMap|blocks|key|bvq2p|text|在您的Addresses表中，|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|c1c2c|Schema::create('addresses',+function+(Blueprint+$table)+{
++++++++$table->Increments('id');
++++++++$table->integer('user_id')->unsigned()->nullable();
++++++++$table->string('name');
++++++++//$table->timestamps();

++++++++//+define+foreign+key+like+this
++++++++$table->foreign('user_id')
++++++++++++++->references('id')->on('users')
++++++++++++++->onDelete('cascade');
});|code-block|syntax|javascript|7n6gu|像下面这样更新你的routes/web.php，|oi6p|Route::get('/insert',+function(){
++++$user+=+User::findOrFail(1);
++++$address+=+new+Addresses();
++++$address->name+=+'1234+Houston+av+NY+NY+234';
++++$address->user_id+=+$user->id;
++++$address->save();
});|3mmn6^0|3|9|0|0|9|E|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|Q|9|@$A|R|B|S|C|D]]|E|@]|F|$]]|$2|G|4|H|6|I|8|T|9|@]|E|@]|F|$J|K]]|$2|L|4|M|6|7|8|U|9|@$A|V|B|W|C|D]]|E|@]|F|$]]|$2|N|4|O|6|I|8|X|9|@]|E|@]|F|$J|K]]|$2|P|4|-4|6|7|8|Y|9|@]|E|@]|F|$]]]]

In your <code>Addresses</code> table,

<pre><code>Schema::create('addresses', function (Blueprint $table) {
 $table-&gt;Increments('id');
 $table-&gt;integer('user_id')-&gt;unsigned()-&gt;nullable();
 $table-&gt;string('name');
 //$table-&gt;timestamps();

 // define foreign key like this
 $table-&gt;foreign('user_id')
 -&gt;references('id')-&gt;on('users')
 -&gt;onDelete('cascade');
});
</code></pre>

update your <code>routes/web.php</code> like below,

<pre><code>Route::get('/insert', function(){
 $user = User::findOrFail(1);
 $address = new Addresses();
 $address-&gt;name = '1234 Houston av NY NY 234';
 $address-&gt;user_id = $user-&gt;id;
 $address-&gt;save();
});
</code></pre>

entityMap|blocks|key|d5346|text|用户模型中的关系无效。您应该纠正这一点，以便与关系一起工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6chpb|2.App/User.php|brvpb|public+function+address(){
++++return+$this->hasOne('App\Address',+'user_id','id');
}|code-block|syntax|javascript|et9u8|另一种将你的地址分配给用户的方法(另一种方法，只是一个提示)：|atc3v|$address+=+new+Addresses(['name'=>'1234+Houston+av+NY+NY+234',+'user_id',$user->id]);
$adresss->save();|72dq9|我认为您还应该将关系添加到数据库迁移中。在你的代码中你没有这样做。|5eepk|4.地址表|4fkgk|Schema::create('addresses',+function+(Blueprint+$table)+{
++++++++$table->Increments('id');
++++++++$table->integer('user_id')->unsigned()->nullable();
++++++++$table->string('name');

++++++++$table->foreign('user_id')->references('id')->on('user');+//+this+line+is+the+forgein+key.
++++});|9loab^0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|U|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|V|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|W|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|X|9|@]|A|@]|B|$]]|$2|L|4|M|6|G|8|Y|9|@]|A|@]|B|$H|I]]|$2|N|4|O|6|7|8|Z|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|10|9|@]|A|@]|B|$]]|$2|R|4|S|6|G|8|11|9|@]|A|@]|B|$H|I]]|$2|T|4|-4|6|7|8|12|9|@]|A|@]|B|$]]]]

The relationship in your User Model is not valid. You should correct this to work with the relation.

2.App/User.php

<pre><code>public function address(){
 return $this-&gt;hasOne('App\Address', 'user_id','id');
}
</code></pre>

Another method to assign your address to the user (alternative way and just a hint):

<pre><code>$address = new Addresses(['name'=&gt;'1234 Houston av NY NY 234', 'user_id',$user-&gt;id]);
$adresss-&gt;save();
</code></pre>

I think you also should add the relation to your database migration. In your code you did not.

4.Addresses table

<pre><code>Schema::create('addresses', function (Blueprint $table) {
 $table-&gt;Increments('id');
 $table-&gt;integer('user_id')-&gt;unsigned()-&gt;nullable();
 $table-&gt;string('name');

 $table-&gt;foreign('user_id')-&gt;references('id')-&gt;on('user'); // this line is the forgein key.
 });
</code></pre>

entityMap|blocks|key|59lt1|text|在这里，我将一步一步地添加用于将数据插入数据库的代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3ohbk|创建创建post表的迁移|34a6o|php+artisan+make:migration+create_post_table+--create=post|code-block|syntax|javascript|8lo9|在迁移中添加标题和内容列|1ki0t|public+function+up()
++++{
++++++++Schema::create('post',+function+(Blueprint+$table)+{
++++++++++++$table->bigIncrements('id');
++++++++++++$table->string('title');
++++++++++++$table->longText('content');
++++++++++++$table->timestamps();
++++++++});
++++}|22kcg|在post文件夹的视图目录中创建post文件夹创建刀片文件create.blade.php|bhqm3|<form+method="POST"+action="{{+route('post.store')+}}">
++++@csrf

+++Title:++<input+type="text"+name="title"+placeholder="Title"+required>

+++ 

++++Content:+<textarea+name="content"+placeholder="Content"+required></textarea>

++++<button+type="submit">Save</button>

</form>|7ciht|创建控制器|9ho2a|php+artisan+make:controller+PostController+--resource|fi2ho|控制器中的代码|5g85s|use+App\Post;

++++public+function+create()
++++{
++++++++return+view('post.create');
++++}

++++public+function+store(Request+$request)
++++{
++++++++$request->validate([
++++++++++++'title'+=>+'required',
++++++++++++'content'+=>+'required',
++++++++]);

++++++++$post+=+$request->all();

++++++++Post::create($post);

++++++++return+redirect('/post');
++++}|fa9vi|在路由文件(web.php)中|3k8b7|//routes+for+post
Route::resource('post',+'PostController');|556c5|打开post表单|etgo4|http://example.test/post/create+|1u6om|输入标题和内容，然后单击保存按钮|5336p^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|1A|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|1B|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|1C|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|1D|9|@]|A|@]|B|$]]|$2|L|4|M|6|G|8|1E|9|@]|A|@]|B|$H|I]]|$2|N|4|O|6|7|8|1F|9|@]|A|@]|B|$]]|$2|P|4|Q|6|G|8|1G|9|@]|A|@]|B|$H|I]]|$2|R|4|S|6|7|8|1H|9|@]|A|@]|B|$]]|$2|T|4|U|6|G|8|1I|9|@]|A|@]|B|$H|I]]|$2|V|4|W|6|7|8|1J|9|@]|A|@]|B|$]]|$2|X|4|Y|6|G|8|1K|9|@]|A|@]|B|$H|I]]|$2|Z|4|10|6|7|8|1L|9|@]|A|@]|B|$]]|$2|11|4|12|6|G|8|1M|9|@]|A|@]|B|$H|I]]|$2|13|4|14|6|7|8|1N|9|@]|A|@]|B|$]]|$2|15|4|16|6|G|8|1O|9|@]|A|@]|B|$H|I]]|$2|17|4|18|6|7|8|1P|9|@]|A|@]|B|$]]|$2|19|4|-4|6|7|8|1Q|9|@]|A|@]|B|$]]]]

Here I add code for insert data into database step by step

Create migration for creating post table

<pre><code>php artisan make:migration create_post_table --create=post
</code></pre>

Add title and content column in migration

<pre><code>public function up()
 {
 Schema::create('post', function (Blueprint $table) {
 $table-&gt;bigIncrements('id');
 $table-&gt;string('title');
 $table-&gt;longText('content');
 $table-&gt;timestamps();
 });
 }

</code></pre>

create post folder in the view directory 
in the post folder create blade file create.blade.php

<pre><code>&lt;form method="POST" action="{{ route('post.store') }}"&gt;
 @csrf

 Title: &lt;input type="text" name="title" placeholder="Title" required&gt;

 &lt;br&gt;

 Content: &lt;textarea name="content" placeholder="Content" required&gt;&lt;/textarea&gt;

 &lt;button type="submit"&gt;Save&lt;/button&gt;

&lt;/form&gt;
</code></pre>

Create the controller

<pre><code>php artisan make:controller PostController --resource
</code></pre>

code in controller

<pre><code>use App\Post;

 public function create()
 {
 return view('post.create');
 }

 public function store(Request $request)
 {
 $request-&gt;validate([
 'title' =&gt; 'required',
 'content' =&gt; 'required',
 ]);

 $post = $request-&gt;all();

 Post::create($post);

 return redirect('/post');
 }

</code></pre>

In route file (web.php)

<pre><code>//routes for post
Route::resource('post', 'PostController');
</code></pre>

Open the post form

<pre><code>http://example.test/post/create 
</code></pre>

enter title and content and click on save button

I am using laravel 5.8 and learning CRUD. I have 2 tables, users table and addresses table. I want to connect user_id to

addresses table. But my code doesn't work. I cannot insert data.

I have already migrate 2 tables, and I am able to add columns.
I inserted one user's data. So table has one user's information.

I am using MAMP and mysql server in local server.

1.App/Address.php

<pre><code>protected $fillable = [
 'name'
];//
</code></pre>

2.App/User.php

<pre><code>public function address(){
 return $this-&gt;hasOne('App\Address', 'foreign_key');
}
</code></pre>

3.Userstable

<pre><code>Schema::create('users', function (Blueprint $table) {
 $table-&gt;Increments('id');
 $table-&gt;string('name');
 $table-&gt;string('email')-&gt;unique();
 $table-&gt;timestamp('email_verified_at')-&gt;nullable();
 $table-&gt;string('password');
 $table-&gt;rememberToken();
 $table-&gt;timestamps();
 });
</code></pre>

4.Addresses table

<pre><code>Schema::create('addresses', function (Blueprint $table) {
 $table-&gt;Increments('id');
 $table-&gt;integer('user_id')-&gt;unsigned()-&gt;nullable();
 $table-&gt;string('name');
 //$table-&gt;timestamps();
 });
</code></pre>

5.routes/web.php

<pre><code>use App\User;
use App\Address;
Route::get('/', function () {
return view('welcome');
});

Route::get('/insert', function(){
$user = User::findOrFail(1);
$address = new Addresses(['name'=&gt;'1234 Houston av NY NY 234']);
$user-&gt;address()-&gt;save($address);
});
</code></pre>

Nothing shows on log file, so I cannot figure out why it doesn't work.

I am using laravel 5.8, and I cannot insert data to mysql database

日志文件

数据库

服务器

路由

 我正在使用laravel 5.8并学习CRUD。我有2个表，用户表和地址表。我想将user_id连接到 地址表。但是我的代码不能工作。我无法插入数据。 我已经迁移了2个表，并且我能够添加列。我插入了一个用户的数据。所以表中只有一个用户信息。 我在本地服务器上使用MAMP和mysql服务器。 1.App/Address...

问我使用的是laravel 5.8，无法向mysql数据库插入数据
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我使用的是laravel 5.8，无法向mysql数据库插入数据EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我使用的是laravel 5.8，无法向mysql数据库插入数据
EN