How to store data to database in LARAVEL 5.2

问题:

Iam beginer on Laravel, i have problem when i want to store data to database. When name on view different with field name on database data didn't save on database but when input name on view same with field name on database data stored correctly

example this is view

<div class="form-group">
    <div class="row">
        <div class="col-md-3">
            <label>Job</label>
            <input type="text" class="form-control" name="job" placeholder="Job">
        </div>
    </div>
</div>
<div class="form-group">
    <div class="row">
        <div class="col-md-3">
            <label>Machine</label>
            {{ Form::select('machine', $mesin_laminating->pluck('active', 'kode')->all(), null, ['class' => 'form-control select2'])}}                                      
        </div>
    </div>

</div> 

this is my controller

 public function store(Request $request)
{
    $this->validate($request, [
        'job' => 'required',
        'machine' => 'required'
    ]);

    $input = $request->all();
    SpkAdmin::create($input);

}

this is my model

protected $table = 'tb_job';

protected $fillable = ['user_job', 'machine'];

this is my database

user_job | machine
------   | ------
Cell     | Cell

How to scyn job on controller to store on user_job? Sorry for my english

回答1:

Replace store as below:

public function store(Request $request)
{
    $this->validate($request, [
        'job' => 'required',
        'machine' => 'required'
    ]);

    $spkAdmin = new SpkAdmin();
    //On left field name in DB and on right field name in Form/view
    $spkAdmin->user_job = $request->input('job');
    $spkAdmin->machine = $request->input('machine');
    $spkAdmin->save();
}

回答2:

there is another way of adding data in database something like this

$data = Input::all();    
$check = DB::table('tablename')->insertGetId(array(
                                                'phone_no'      => $data['number'],
                                                'firstname'     => $data['first_name'],
                                                'lastname'      => $data['last_name'],
                                                'birth_month'   => $data['birth_month'],
                                                'birth_year'    => $data['birth_year'],
                                                'zipcode'       => $data['zip_code'],
                                                'device_token'  => $data['device_token'],
                                                'created_at' => Carbon::now()
                                                        ));

hope this could solve your query