How can I insert multiple rows to the database in Laravel

Question

I tried to save multiple rows to the database with one query, without success. I used a for loop but it can't retrieve the value of the inputs that are generated using jQuery after setting the number of rows.

Controller

public function store(Request $request)
{
    $nbrrowsol = $request->get('nbrrowsol');
    for ($i = 1; $i < $nbrrowsol; $i++) {
        $commande = new Commande();
        $commande->nom_client = $request->get('nomclient');
        $commande->organisme = $request->get('organisme');
        $commande->adresse = $request->get('adresse');
        $commande->email = $request->get('email');
        $commande->tel1 = $request->get('tel');
        $commande->tel2 = $request->get('tel2');
        $commande->fax = $request->get('fax');
        $commande->commercial = $request->get('commercial');
        $commande->date_reception = $request->get('datereception');
        $commande->date_prelevement = $request->get('dateprelev');
        $commande->saved_by = $request->get('savedby');
        $commande->code = $request->get('codesol' + $i);
        $commande->nature = $request->get('naturesol' + $i);
        $commande->reference_cli = $request->get('reference_clisol' + $i);
        $commande->profondeur = $request->get('profondeursol' + $i);
        $commande->culture = $request->get('culturesol' + $i);
        $commande->variete = $request->get('varietesol' + $i);
        $commande->gps = $request->get('gpssol' + $i);
        $commande->analyse_demande = $request->get('analysedemandesol' + $i);
        $commande->valide = $request->get('checkvalidee');
        $commande->save();
    }

    return redirect('gestion_commandes/create');
}

I get the following error after the user submits for saving data.

A non-numeric value encountered

I think that I didn't use (for) correctly or the form of:

$commande->code = $request->get('codesol' + $i);

Error image

have you tried passing index to your inputs like, $request->get('nomclient[ '. $i . ']') — Aditya Thakur
– Aditya Thakur, Commented May 8, 2019 at 22:16

Aditya Thakur · Accepted Answer · 2019-05-08 22:21:21Z

1

You seem to be fetching input using + addition operator which is for javascript, in PHP . operator is used for concatenation, also you'll need to fetch inputs it using the index of your inputs array, for example when your <input name="nomClient[]">

$request->get('nomclient['. $i . ']')

answered May 8, 2019 at 22:21

Aditya Thakur

2,6202 gold badges12 silver badges21 bronze badges

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

Comments

nakov · Accepted Answer · 2019-05-08 22:17:46Z

0

First of all to concat a string in PHP is done using . (dot) notation, not +. So this 'codesol'+$i should become 'codesol' . $i and so on for the rest.

If you want to insert multiple rows directly, then take a look at this example.

answered May 8, 2019 at 22:17

nakov

14.4k14 gold badges74 silver badges129 bronze badges

3 Comments

Oussama Ammy Driss Over a year ago

yes you are right, now the data are registered in the database but only with the value i = 1, the value of i does not increment

nakov Over a year ago

it won't if your $nbrrowsol is 2.

nakov Over a year ago

Because you say $i < 2 which means all below 2, try $i <= $nbrrowsol.

Collectives™ on Stack Overflow

How can I insert multiple rows to the database in Laravel

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related