lundi 28 janvier 2019

Laravel - Insert Array of data into database

Hello how can I achieve to insert data on an array? using eloquent? right now i have this on my

Controller

public function insertSchedule(Request $request)
{
    $employAdd = [];

    foreach($employAdd as $key){

        $employeeTimeSet = new Schedule;
        $employeeTimeSet->employee_no = $request->input('hidEmployeeno'); 
        $employeeTimeSet->last_name = $request->input('hidEmployeeLast'); 
        $employeeTimeSet->first_name = $request->input('hidEmployeeFirst'); 
        $employeeTimeSet->date_today = $request->input('dateToday'); 
        $employeeTimeSet->time_in = $request->input('timeIn'); 
        $employeeTimeSet->time_out = $request->input('timeOut'); 
        $employeeTimeSet->save();    

    }


  }

View

See here my view? the dates here are arrays then when I insert this into the database the output or the data that is being inserted is the last data why is that?

         {!! Form::open(['action' => 'Admin\EmployeeFilemController@insertSchedule', 'method' => 'POST']) !!}
        <div class="row">
                <div class="form-group col-md-12">

                    <small>Employee No. and Name: </small><b><i>  : , </i></b>

                    <input type="hidden" name="hidEmployeeno[]" value='<?php echo $employee->employee_no ?>'>
                    <input type="hidden" name="hidEmployeeLast[]" value='<?php echo $employee->last_name ?>'>
                    <input type="hidden" name="hidEmployeeFirst[]" value='<?php echo $employee->first_name ?>'>
                    <hr>

                </div>

        </div>


        @php
        $today = today(); 
        $dates = []; 

        for($i=1; $i < $today->daysInMonth + 1; ++$i) {
            $dates[] = \Carbon\Carbon::createFromDate($today->year, $today->month, $i)->format('F-d-Y');
        }
    @endphp

    <table class="table">
        <thead>
            <tr>
            <th>DATE TODAY</th>
            <th>TIME IN</th>
            <th>TIME OUT</th>
            <th>ACTION</th>
            </tr>
        </thead>
        <tbody>
            @foreach($dates as $date)
                <tr>
                    <td><b></b></td>
                    <input type="hidden" name="dateToday[]" value="">
                    <td><input type="time" name="timeIn[]" class="form-control col-md-10"></td>
                    <td><input type="time" name="timeOut[]" class="form-control col-md-10"></td>
                    <td> </td>
                </tr>
            @endforeach
        </tbody>
    </table>

          {!! Form::close() !!}



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire