Post array data into database in Laravel

Question

I want to record equipment in many forms, but errors always occur. Undefined index: name

public function EquipCheck(Request $request) {
    $user = User::where('username', $request -> username) -> firstOrFail();
    if ($request -> token == $user -> token) {
        $item_detail_id = CheckLog::where('user_id', $user -> id) -> orderBy('id', 'desc') -> first() -> item_detail_id;
        $new_form = new Form;
        $new_form -> item_detail_id = $item_detail_id;
        $new_form -> user_id = User::where('username', $request -> username) -> firstOrFail() -> id;
        $new_form -> created_time = Carbon::now() -> format('Y-m-d H:i:s');
        $new_form -> save();
        $form = Form::with('eqpt') -> where('item_detail_id', $item_detail_id) -> orderBy('created_time', 'desc') -> first();

        $data = $request -> eqpt;
        $i = 0;
        $sql = array();

        while($i < count($cyldata['serie'])){
            $sql[] = array(
                'form_id' => $form -> id,
                'name' => $data['name'][$i],
                'unit' => $data['unit'][$i],
                'quantity' => $data['quantity'][$i],
                'check_quantity' => $data['check_quantity'][$i],
            );
            $i++;
        }

        DB::table('eqpt') -> insert($sql);

        return "Success";
    }
}

When I use the following code, the database can be inserted the array.

$dataSet[] = [
            'form_id' => $form -> id,
            'name' => 'test',
            'unit' => 'box',
            'quantity' => 20,
            'check_quantity' => 20,
        ];

        DB::table('eqpt') -> insert($dataSet);

This is post data.

Have you tried inspecting the $data variable after you set it? Also, where is $cyldata['serie'] being set? — jackel414
– jackel414, Commented May 5, 2017 at 18:22
It might be an issue of character set collation, have you tried changing the character set and collation? This link might help you stackoverflow.com/questions/14456313/… — linktoahref
– linktoahref, Commented May 6, 2017 at 13:51

jedrzej.kurylo · Accepted Answer · 2017-05-06 16:03:54Z

2

$data contains an array of objects. $data['name'] refers to the property of that array, while you should access properties of objects in that array.

Replace

$sql[] = array(
  'form_id' => $form -> id,
  'name' => $data['name'][$i],
  'unit' => $data['unit'][$i],
  'quantity' => $data['quantity'][$i],
  'check_quantity' => $data['check_quantity'][$i],
);

with

$sql[] = array(
  'form_id' => $form -> id,
  'name' => $data[$i]['name'],
  'unit' => $data[$i]['unit'],
  'quantity' => $data[$i]['quantity'],
  'check_quantity' => $data[$i]['check_quantity'],
);

answered May 6, 2017 at 16:03

jedrzej.kurylo

41.1k10 gold badges108 silver badges112 bronze badges

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

1 Comment

jackel414 Over a year ago

Good catch - I hadn't seen that OP had transposed the keys.

Collectives™ on Stack Overflow

Post array data into database in Laravel

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related