我使用的框架laravel 5.4，我有3个表（用户，包，联系人）

Question

当我想用关系（hasMany和belongsTo）编码时，我会得到错误：

查询异常

SQLSTATE[42S22]：找不到列： 1054未知列'contacts.user_id'in'where子句'（SQL：选择*from联系人其中联系人.user_id=2 and联系人.user_id不是null和联系人.deleted_at是null）

这是控制器，ContactController.php：

 <?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Contact;

use Auth;

use App\Http\Requests\contactRequest;

class ContactController extends Controller
{
    public function __construct()
    {
        $this->middleware('auth');
    }

    public function index()
    {
        $listcontact = Auth::user()->contacts;

        return view('contact.index', ['lists' => $listcontact]);
    }

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

            public function store(contactRequest $request)
    {
        $contact = new Contact();

        $contact->nom=$request->input('nom');
        $contact->tel=$request->input('tel');
        $contact->genre=$request->input('genre');
        $contact->age=$request->input('age');
        $contact->ville=$request->input('ville');

        $contact->user_idd=Auth::user()->id;

        $contact->save();

        session()->flash('success', 'Contact bien enregistré!!');

        return redirect('contacts');
    }

    public function edit($id)
    {
        $contact = Contact::find($id);

        return view('contact.edit', ['cont' => $contact]);
    }

    public function update(contactRequest $request, $id)
    {
        $contact = Contact::find($id);

        $contact->nom = $request->input('nom');
        $contact->tel = $request->input('tel');
        $contact->genre = $request->input('genre');
        $contact->age = $request->input('age');
        $contact->ville = $request->input('ville');

        $contact->save();

        session()->flash('edited', 'Contact bien modifié!!');

        return redirect('contacts');
    }

    public function destroy(Request $request, $id)
    {
        $contact = Contact::find($id);

        $contact->delete();

        return redirect('contacts');
    }
}

Answer 1

更改为$contact-

$contact->user_id=Auth::user()->id;