返回

laravel-SQLSTATE [HY000]:一般错误:1364 字段“agent_id”没有默认值

发布时间:2022-05-25 01:33:00 484
# php# 数据

由于外键字段我有两个模型(Agent,Post),我无法将用户的主键保存为posts表中的外键。我可以手动插入数据,并与父表链接,但当用户从视图中的表单插入时,它会给我该错误的帮助吗。。提前感谢

Agent

<?php

namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Agent extends Model
{
    use HasFactory;
    
    public function posts(){
        return $this->hasMany(Post::class);
    }
}

Post

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    use HasFactory;

    public function user(){
        return $this->belongsTo(Agent::class);
    }
}

这是我在控制器中保存数据的方法

 public function savepost(Request $request){
        $post = new Post ;
        $post->title = $request->title ;
        $post->description = $request->description ;
        $post->type = $request->type;
        $saved = $post->save();
       if($saved){
         return back()->with('success','New post has been added successfuly');
     }else{
         return back()->with('fail' , 'Something went wrong , try again later');
     }
    }
特别声明:以上内容(图片及文字)均为互联网收集或者用户上传发布,本站仅提供信息存储服务!如有侵权或有涉及法律问题请联系我们。
举报
评论区(1)
按点赞数排序
用户头像
下一篇
java-为什么我不能初始化Webview 2022-05-24 23:30:16