CODEWITHSUNDEEP
phpmysqllaravellaravel-5
wisnuaryadipa
wisnuaryadipa

Reputation: 760

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

Upvotes: 2

Views: 58924

Answers (3)

Ganesh Ghalame
Ganesh Ghalame

Reputation: 7073

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/request
    $spkAdmin->user_job = $request->input('job');
    $spkAdmin->machine = $request->input('machine');
    $spkAdmin->save();
}

Upvotes: 16

Ramnish Parmar
Ramnish Parmar

Reputation: 1

use App\SpkAdmin;

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

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

    Or 

$input = [];
$input = $request->all();
$input['user_job'] = $request->get('job');
$input['machine'] = $request->get('machine');
SpkAdmin::create($input);
}

Upvotes: 0

Gaurav Gupta
Gaurav Gupta

Reputation: 1713

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

Upvotes: 4

Related Questions