mardi 27 février 2018

Creating a row in two tables with one form. How do I add IDs connecting them?

I'm using laravel 5.6 and I'm trying to insert a row into two different tables and link them together inside public function store()

Here's what I have:

public function store(Request $request)
    {
        $this->validate($request, [
          'name'         => 'required',
          'email'        => 'required',
          'project'      => 'required',
          'project_type' => 'required',
          'budget'       => 'required'
        ]);

        $client = new Client;
        $project = new Project;

        $client->name       = $request->input('name');
        $client->email      = $request->input('email');
        $client->save();

        $project->project      = $request->input('project');
        $project->project_type = $request->input('project_type');
        $project->budget       = $request->input('budget');
        $project->save();

        return redirect('/admin/clients');
    }

I need to do something like:

$client->project_id = $project->id;
$project->client_id = $client->id;

But that obviously won't work. How would I go about getting IDs for these rows whenever the rows haven't been created yet to access them? Is it possible? If not I'll find a work around or approach it a different way.

Thanks.



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Cu8zPk
via IFTTT

Aucun commentaire:

Enregistrer un commentaire