When i want to code with the relationships(hasMany and belongsTo) I get the error:
QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contacts.user_id' in 'where clause' (SQL: select * from
contacts
wherecontacts
.user_id
= 2 andcontacts
.user_id
is not null andcontacts
.deleted_at
is null)
This is the controller, 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');
}
}
change to $contact->user_idd=Auth::user()->id;
$contact->user_id=Auth::user()->id;