Accessing input array data Laravel 4.2 Form

Question

I'm struggling to access all of the input array data in Laravel, as I was with no problem previously: e.g., $_POST['name'][$row]

I'm also receiving the following error, but I assume it's because of the NULL data.
SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'field list'

POST Data:

name    Array ( [0] => name1 [1] => name2 )
dob Array ( [0] => 06/23/16 [1] => 06/03/16 )
gender  Array ( [0] => 1 [1] => 0 )

Loop:

$jobID = 2;
$data = array();
foreach(Input::get('name') as $row=>$name){

    $dob = Input::get('dob'.$row);
    $gender = Input::get('gender'.$row);

    $data[] = "['job_id' => '$jobID', 'first_name' => '$name', 'dob' => '$dob', 'gender' => '$gender']";

}

$data_insert = implode(',', $data);

if(!empty($name)) {
    DB::table('job_data')->insert([
        $data_insert
    ]);

}

Resulting SQL:

insert into `job_data` (`0`) 
values (
  ['job_id' => '2', 'first_name' => 'name1', 'dob' => '', 'gender' => ''],
  ['job_id' => '2', 'first_name' => 'name2', 'dob' => '', 'gender' => '']
)

Ronald · Accepted Answer · 2016-06-16 19:09:54Z

1

You dont have to stringify your data, just simply use this

$data[] = [
    'job_id' => $jobID, 
    'first_name' => $name, 
    'dob' => $dob, 
    'gender' => $gender
];

and insert it with

DB::table('job_data')->insert($data);

answered Jun 16, 2016 at 19:09

Ronald

737 bronze badges

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

3 Comments

Klav Over a year ago

Strike previous comment. Thank you, this takes care of the Unknown column error, but my data is still NULL except for name.

Ronald Over a year ago

Change your line $dob = Input::get('dob'.$row); into $dob = Input::get('dob')[$row]; and also with the gender

Ronald Over a year ago

or Input::get("dob.$row");

Collectives™ on Stack Overflow

Accessing input array data Laravel 4.2 Form

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related