How to insert data to database with Laravel

Question

I'm trying to insert my data to database from form.

My URL to create the data is web.com/siswa/create

But when I click submit system show error MethodNotAllowedHttpException.

How I can fix it? Is there anything wrong with my code?

Here is my form:

<form action="{{ url('siswa') }}" method="POST">
      <div class="form-group">
         <label for="exampleInputEmail1">NISN</label>
          <input type="text" class="form-control" name="nisn" id="nisn" placeholder="NISN"></div>
         <div class="form-group">
         <label for="exampleInputEmail1">Nama Siswa</label>
         <input type="text" class="form-control" name="nama_siswa" id="nama_siswa" placeholder="Nama Siswa"> </div>
         <button type="submit" class="btn btn-success btn-sm font-weight-bold">Submit</button></form>

Controller:

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

    public function store(Request $request)
      {

        $siswa = new \App\Siswa;
        $siswa->nisn = $request->nisn;
        $siswa->nama_siswa = $request->nama_siswa;
        $siswa->tanggal_lahir = $request->tanggal_lahir;
        $siswa->jenis_kelamin = $request->jenis_kelamin;
        $siswa->save();
        return redirect('siswa');
      }

Route:

Route::get('/siswa/create', [
    'uses' => 'SiswaController@tambah',
    'as' => 'tambah_siswa'
]);

Route::get('/siswa', [
    'uses' => 'SiswaController@store',
    'as' => 'simpan_siswa'
]);

You only have get routes but your form is trying to POST — Phil
– Phil, Commented Nov 12, 2018 at 4:44
i change it but now system show me error 419 Sorry, your session has expired. Please refresh and try again. — Jazuly
– Jazuly, Commented Nov 12, 2018 at 4:47

Leena Patel · Accepted Answer · 2018-11-12 05:05:02Z

4

change your store function route from get to post

Route::post('/siswa', [
'uses' => 'SiswaController@store',
'as' => 'simpan_siswa'
]);

Use Csrf protection field in your form for the session timeout error

{{ csrf_field() }}

OR

<input type="hidden" name="_token" id="csrf-token" value="{{ Session::token() }}" />

OR if you are using Form builder

{!! Form::token() !!}

edited Nov 12, 2018 at 5:05

answered Nov 12, 2018 at 4:47

Leena Patel

2,4531 gold badge17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jazuly Over a year ago

i change it but now system show me error 419 Sorry, your session has expired. Please refresh and try again.

Leena Patel Over a year ago

you need to refresh the form and try again as csrf protection will not allow to refresh the form itself from clicking f5

Jazuly Over a year ago

yup fix it with add '{{ csrf_field() }}' in the form.

Udhav Sarvaiya · Accepted Answer · 2018-11-12 05:55:04Z

3

In Route please use post instead of get

Route::post('/siswa','SiswaController@store');

and also include {{ csrf_field() }} in form

edited Nov 12, 2018 at 5:55

Udhav Sarvaiya

10.2k13 gold badges60 silver badges68 bronze badges

answered Nov 12, 2018 at 4:49

Raushan Singh

1,1302 gold badges9 silver badges19 bronze badges

Comments

Paul Mikki · Accepted Answer · 2018-11-12 04:50:23Z

0

you are using method="POST" on your form but in on your route you are using Route::get

Use Route::post for your route

answered Nov 12, 2018 at 4:50

Paul Mikki

833 bronze badges

Comments

OutForCode · Accepted Answer · 2018-11-12 04:50:38Z

0

In your form you've given POST method, but your router doesn't have any POST handler. So all you have to do is , when you are trying to store data from form to DB you have to post the data, and the router should handle it.

Try this

Route::post('/siswa', [
'uses' => 'SiswaController@store',
'as' => 'simpan_siswa'
]);

answered Nov 12, 2018 at 4:50

OutForCode

46111 silver badges28 bronze badges

Comments

Arif Hossain · Accepted Answer · 2018-11-12 06:54:02Z

0

You are using POST method in your form and using GET in route.

try this

Route::post( '/siswa', [
    'uses' => 'SiswaController@store',
    'as'   => 'simpan_siswa'
] );

answered Nov 12, 2018 at 6:54

Arif Hossain

12 bronze badges

Collectives™ on Stack Overflow

How to insert data to database with Laravel

5 Answers 5

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related