mardi 18 octobre 2016

how to insert multiple rows in laravel 5

i want to insert an array with an id : create.blade :


        <select id="disabledSelect" class="form-control" name="Facture_id">
            <option value="" ></option>
        </select>
        <br/>
        <div class="form-inline">
            <div class="form-group">
                <input type="text" class="form-control" name="rows[0][Title]" placeholder="libelé"/>
            </div>
            <div class="form-group">
                <input type="text" class="form-control" name="rows[0][Quantity]" placeholder="Quantité"/>
            </div>
            <div class="form-group">
                <input type="text" class="form-control" name="rows[0][Price]" placeholder="Prix unitaire "/>
            </div>
            <div class="form-group">
                <input type="button" class="btn btn-default" value="Ajouter" onclick="createNew()" />
            </div>
            <div id="mydiv"></div>
        </div>
        <br/>

        <div class="form-group">
            <input type="submit" value="Ajouter" class="btn btn-info">
            <a href="" class="btn btn-default">Cancel</a>
        </div>
        

<script>
    var i = 2;

    function createNew() {
        $("#mydiv").append('<div class="form-group">'+'<input type="text" name="rows[' + i +'][Title]" class="form-control" placeholder="libelé"/>'+
                '</div>'+'<div class="form-group">'+'<input type="text" name="rows[' + i +'][Quantity]" class="form-control" placeholder="Quantité"/>'+'</div>'+'<div class="form-group">'+'<input type="text" name="rows[' + i +'][Price]" class="form-control" placeholder="Prix unitaire "/>'+'</div>'+'<div class="form-group">'+
                '<input type="button" name="" class="btn btn-default" value="Ajouter" onclick="createNew()" />'+
                '</div><br/>');
        i++;
    }
</script>

here is my controller , when i tried to submit the form , it inject rows with value of 0 what should i do i tried to use elequent bolk data , but the problem remain the same enter image description here

public function store(Request $request)
{
    // validated input request
    $this->validate($request, [
        'Facture_id' => 'required',


    ]);

    // create new task
    $rows = $request->input('rows');
    foreach ($rows as $row)
    {
        $Charges[] = new Charge(array(
            'course_id'=>$request->input('Facture_id'),
            'Title'=>$row['Title'],
            'Quantity'=>$row['Quantity'],
            'Price'=>$row['Price'],

        ));
    }
    Charge::create($Charges);
    return redirect()->route('Charge.index')->with('success', 'Your task added successfully!');
}



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire