Laravel: Query Exception

Question

Array to string conversion (SQL: insert into RegisterStudent (LRN, dateOfBirth, sex, updated_at, created_at) values (1234, 1996-02-10, Female, 2017-10-26 05:30:32, 2017-10-26 05:30:32))

StudentController store content

public function store(Request $request){

     //validation
    $this->validate($request, [
        'LRN' => 'required|max:100',
    ]);

    $student = New Student;
    $student->LRN = $request->input('LRN');
    $student->dateOfBirth = $request->input('dateOfBirth');
    $student->sex = $request->input('sex');

    $student->save();

    return redirect()->back();
}

You are sending LRN and sex as an array. Show your html code — Pankaj Makwana
– Pankaj Makwana, Commented Oct 26, 2017 at 5:45
Lois Arce, check out madalinivascu's answer. It will solve the issue. — Himanshu Upadhyay
– Himanshu Upadhyay, Commented Oct 26, 2017 at 5:57

madalinivascu · Accepted Answer · 2017-10-26 05:39:25Z

1

Change the following:

$student->sex = $request->input('sex')[0];

the input seems to be a array so you need the value at [0] or remove the [] in your input name to use in php $request->input('sex')

answered Oct 26, 2017 at 5:39

madalinivascu

32.4k4 gold badges41 silver badges59 bronze badges

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

2 Comments

Himanshu Upadhyay Over a year ago

How could you decide that its sex but not any other field?

madalinivascu Over a year ago

@HimanshuUpadhyay if you look in the screenshot,in the white list the second item you can see array('Female')

Collectives™ on Stack Overflow

Laravel: Query Exception

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related