How do I post data from a form into a database with laravel?

Question

Im doing a university project which is a foodlog, where the user is able to log in and then log their food items. Ideally this will post to the database, then the user will be able to view all their logged foods displayed in a table.

at the minute im trying to post the form information to the database and it doesnt seem to work. I also want the user's id to be logged in the database which is a foreign key in the food log table (from users table).

This is my PostsController.php

    <?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Post;

class PostsController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        //
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store()
    {

        Post::create([

            'id'->request('id');
            'user_id'->Auth::user()->id;
            'name'->request('name');
            'servings'->request('servings');
            'servingsize'->request('servingsize');
            'calories'->request('calories');
            'fat'->request('fat');

        ]);

        return redirect('/foodlog');

    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }
}

This is my add.blade.php

    @extends('layouts.app')

<!-- Styles -->
    <link href="{{ asset('css/app.css') }}" rel="stylesheet">

@section('content')
<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-8">



                    <form method="POST" action="/posts">

        {{ csrf_field() }}

        <h1>Add to Foodlog</h1>
        <div class="form-group">

            <label for="item">Item:</label>

            <input type="text" id="name" name="name" class="form-control">

        </div>



        <div class="form-group">

                    <label for="noOfServings">Number of Servings:</label>

                    <input type="number" id="servings" name="servings" class="form-control">

        </div>



        <div class="form-group">

                    <label for="servingSize">Serving Size (g):</label>

                    <input type="number" id="servingsize" name="servingsize" class="form-control">

        </div>



        <div class="form-group">

                    <label for="calories">Calories (kcal):</label>

                    <input type="number" id="calories" name="calories" class="form-control">

        </div>



        <div class="form-group">

                    <label for="fat">Fat (g):</label>

                    <input type="number" id="fat" name="fat" class="form-control">

        </div>


        <button type="submit" class="btn btn-primary">Add</button>




    </form>



        </div>
    </div>
</div>
@endsection

And my web.php

<?php

Route::get('/', 'FoodlogController@index');

Route::get('/add', 'FoodlogController@add');

Route::get('/account', 'FoodlogController@account');


Auth::routes();

Route::get('/home', 'HomeController@index')->name('home');

Route::get('/foodlog', function() {


    return view('/foodlog');

});


Route::get('/logout', function(){
   Auth::logout();
   return Redirect::to('welcome');
});


Route::post('/posts', 'PostsController@store');

I have also included a screenshot of my create foodlog migrations file so that you can see the fields in my table

Also my Post model is empty as you can see

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    //
}

Answer 1

Your store function should looks like:

public function store(Request $request)
{

    Post::create([

        'id' => $request->id, //<--- if this is autoincrement then just delete this line
        'user_id' => Auth::user()->id,
        'name' => $request->name,
        'servings' => $request->servings,
        'servingsize' => $request->servingsize,
        'calories' => $request->calories,
        'fat' => $request->fat
    ]);

    return redirect('/foodlog');

}

For relationship between tables please follow this link

Add to Post model fillable fields:

protected $fillable = [
    //if id is not autoincrement then add 'id'
    'user_id', 
    'name', 
    'servings', 
    'servingsize',
    'calories',
    'fat'
];