如何在post_表和tags表中插入标记？

Question

我想在标签表中插入标签，也可以在post创建页面的post_标签表中插入标签。当我创建一个新的贴子时，标签插入到标签表中，而不是插入到贴子标签表中。它显示的日期时间格式无效。

SQLSTATE[22007]：无效的日期时间格式：1366不正确的整数值：第1行的列anusondhan.post_tag.tag_id的“start，tas”（SQL:插入到post_tag（post_id，tag_id）值中（20，start，tas））

            //Store Post
            public function storeNewPost(Request $request){
                //return $request->all();
                $request->validate([
                    'post_title' => 'required',
                    'post_details' => 'required',
                    'category_id' => 'required',
                    'image' => 'image|max:15360|dimensions:max_width=4000,max_height=3000'
                ]);

                $image = $request->file('post_thumbnail');
                
                $name_gen=uniqid().'.'.$image->getClientOriginalExtension();
                Image::make($image)->resize(700,400)->save('frontend/assets/images/post/'.$name_gen);
                $save_url = 'frontend/assets/images/post/'.$name_gen;

                $post = Post::create([
                    'user_id' => Auth::id(),
                    'post_uper_title' =>$request->post_uper_title,
                    'post_title' =>$request->post_title,
                    'post_sub_title' =>$request->post_sub_title,
                    'post_details' =>$request->post_details,
                    'post_slug' =>str_replace(' ', '-', $request->post_title),
                    'seo_title' =>$request->seo_title,
                    'seo_descp' =>$request->seo_descp,
                    'lead' =>$request->lead,
                    'lead2' =>$request->lead2,
                    'featured' =>$request->featured,
                    'repoter_name' =>$request->repoter_name,
                    'division_id' =>$request->division_id,
                    'district_id' =>$request->district_id,
                    'category_id' =>$request->category_id,
                    'post_thumbnail' =>$save_url,
                    'thumbnail_caption' =>$request->thumbnail_caption,
                    'thumbnail_alt' =>$request->thumbnail_alt,
                    'created_at' => Carbon::now(),
                ]);

                if($post){
                    $tags = explode(",", implode($request->tags));
                    $tagNames = [];
                    if (!empty($tags)) {
                        foreach ($tags as $tagName)
                        {
                        $tag = Tags::firstOrCreate(['name'=>$tagName]);
                        if($tag)
                        {
                            $tagNames[] = $tag->id;
                        }
                        }
                        
                    }
                    $post->tags()->sync($request->tags);
                    $notification = array(
                        'message' => 'Post Inserted Successfully',
                        'alert-type' => 'success'
                    );
                    return redirect()->route('all.posts')->with($notification);
                }else{
                    return back();
                }             

            }//end insert post

**这是我的桌子**

        public function up()
        {
            Schema::create('tags', function (Blueprint $table) {
                $table->bigIncrements('id');
                $table->string('name');
                $table->string('slug')->nullable();
                $table->longText('description')->nullable();
                $table->longText('tag_thumb')->nullable();
                $table->text('thumb_caption')->nullable();
                $table->text('thumb_alt')->nullable();
                $table->softDeletes();
                $table->timestamps();
            });
        }

**这是我的邮政标签表**

        public function up()
        {
            Schema::create('post_tag', function (Blueprint $table) {
                $table->increments('id');
                $table->unsignedBigInteger('post_id')->nullable();
                $table->foreign('post_id')->references('id')->on('posts')->onDelete('cascade');
                $table->unsignedBigInteger('tag_id')->nullable();
                $table->foreign('tag_id')->references('id')->on('tags')->onDelete('cascade');
                $table->timestamps();
            });
        }

Answer 1

如果您的模型中有多个关系，请在控制器中的更新函数上使用sync（）方法。

示例：$post-

如果你需要更多的帮助告诉我。

Answer 2

我认为您需要使用$tagNames数组而不是$request-

$post->tags()->sync($tagNames);

根据Laravel文档，sync（）方法需要一个ID数组：https://laravel.com/docs/8.x/eloquent-relationships#syncing-联想