douquanzhan0315 2017-04-18 18:26
浏览 231
已采纳

在SQL laravel 5.4中找不到列

I'm trying to publish post with user that register in my app, but this error happened: enter image description here

And I'm using XAMPP and my posts table is this picture enter image description here

And this error is in phpMyAdmin: enter image description here

My PostController is:

use App\Post;

class PostsController extends Controller

{

    public function __construct()
    {
        $this->middleware('auth')->except(['index','show']);
    }

    public function index()
    {
        $posts=Post::latest()->get();

        return view('posts.index',compact('posts'));
    }

    public function show(Post $post)
    {

        return view('posts.show',compact('post'));
    }

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

    public function store()
    {

       $this->validate(request(),[
           'title'=>'required',
           'body' => 'required|min:5'
       ]);


        Post::create(request([
           'title' => request('title'),
            'body' => request('body'),
            'user_id' =>auth()->id()
            //auth()->user()->id*/
        ]));

        return redirect()->home;
    }
}

and Post Model:

class Post extends Model
{
    public function comments()
    {
      return $this->hasMany(Comment::class);
    }

    public function user()
    {
      return $this->belongsTo(User::class);
    }
}
  • 写回答

3条回答 默认 最新

  • dougu2036 2017-04-18 19:11
    关注

    It seems your store method is wrong.

    Try something like this:

    public function store()
    {
    
       $this->validate(request(),[
           'title'=>'required',
           'body' => 'required|min:5'
       ]);
    
       Post::create([
           'title' => request('title'),
           'body' => request('body'),
           'user_id' =>auth()->id()
       ]);
    
        return redirect()->home;
    
    }
    

    This code works for you?

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 爬取豆瓣电影相关处理
  • ¥15 手机淘宝抓清除消息接口
  • ¥15 C#无selenium
  • ¥15 LD衰减计算的结果过大
  • ¥15 用机器学习方法帮助保险公司预测哪些是欺诈行为
  • ¥15 计算300m以内的LD衰减
  • ¥15 数据爬取,python
  • ¥15 怎么看 cst中一个面的功率分布图,请说明详细步骤。类似下图
  • ¥15 为什么我的pycharm无法用pyqt6的QtWebEngine
  • ¥15 FOR循环语句显示查询超过300S错误怎么办