Insert dynamically generated form inputs to MySQL database using Laravel [duplicate]

Question

I have a form for adding cheques to a system. The form has two parts; part one is for the common info i.e the customer details and part two is for the unique details i.e cheque details. Multiple cheques can be added for the same user by clicking an Add button which generates duplicate inputs for the form. While saving the data on mysql database using Laravel, i got the error

"Undefined offset: 1"

Here is my laravel controller :

public function store(Request $request)
{
  $customer_name = $request->customer_name;
  $cheque_number=$request->cheque_number;
  $count = count($cheque_number);

    for($i = 0; $i < $count; $i++){
        $objModel = new Cheque();
        $objModel->customer_name = $customer_name[$i];
        $objModel->cheque_number = $cheque_number[$i];
        $objModel->save();
    }
}

My main challenge is each cheque number should be saved on a new row, but with the same customer name which is provided only once.

the customer name is a single value while the cheque number can have more than one value. different cheque numbers should be stored in different db rows but with the same customer name — Vic
– Vic, Commented Feb 20, 2019 at 12:16

Jignesh Joisar · Accepted Answer · 2019-02-20 12:18:42Z

1

try this one

public function store(Request $request)
{
  $customer_name = $request->customer_name;
  $cheque_number = $request->cheque_number;
  $count = count($cheque_number);

    for($i = 0; $i < $count; $i++){
       if(isset($cheque_number[$i])) {  //for check value is set or not..
          $objModel = new Cheque();
          $objModel->customer_name = $customer_name;  //same name
          $objModel->cheque_number = $cheque_number[$i]; //different number
          $objModel->save();  
       }
    }
}

answered Feb 20, 2019 at 12:18

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

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

Comments

Prathamesh Doke · Accepted Answer · 2019-02-20 12:24:30Z

0

public function store(Request $request){
 $customer_name = $request->get('customer_name');
 $cheque_number = $request->get('cheque_number');
 $count = count($cheque_number);

 for($i = 0; $i < $count; $i++){
  if(isset($cheque_number[$i])){
   $objModel = new Cheque();
          $objModel->customer_name = $customer_name;  //same name
          $objModel->cheque_number = $cheque_number[$i]; //different number
          $objModel->save(); 
  }
 }
}

answered Feb 20, 2019 at 12:24

Prathamesh Doke

8552 gold badges19 silver badges41 bronze badges

Comments

AddWeb Solution Pvt Ltd · Accepted Answer · 2019-02-20 12:24:19Z

-1

You should try this:

public function store(Request $request)
{
  $customer_name = $request->customer_name;
  $cheque_number = $request->cheque_number;
  $count = count($cheque_number);

    for($i = 0; $i < $count; $i++){
       if(isset($cheque_number[$i])) {  
          $objModel = new Cheque();
          $objModel->customer_name = $customer_name;  //same name
          $objModel->cheque_number = $cheque_number[$i]; //different number
          $objModel->save();  
       }
    }
}

answered Feb 20, 2019 at 12:24

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

1 Comment

AddWeb Solution Pvt Ltd Over a year ago

@Vic: Glad to help :)

Collectives™ on Stack Overflow

Insert dynamically generated form inputs to MySQL database using Laravel [duplicate]

3 Answers 3

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Linked

Related