Getting error like Argument 1 passed to Illuminate\Database\Grammar::parameterize() must be of the type array,

Show the code that generates the error.

First Thanks for your reply @tray2 ...

Here is my controller...

                 public function store(Request $request)
{
  //  dd($request->all());
    $data = new past_events();
    $data->title = $request->title;
    $data->slug = $request->slug;
    $data->event_date = $request->event_date;
    $data->event_video_link = $request->event_video_link;
    $data->event_place_name = $request->event_place_name;
    $data->category_id = $request->category_id;

    if($request->hasFile('image'))
    {
        $image = request('image');
        $filename = time().$image->getClientOriginalName();
        $image->move(public_path().'uploads/past/',$filename);
        $data->image = $filename;
   }
    $data->save();

    $id = $data->id; // foreign_key

    foreach ($request->Featured as $key=>$file){
        $speaker=new past_event_speaker();
        $speaker->past_event_id = $id;
        $speaker->Featured = $request->Featured[$key];(this is for image)
        $speaker->speaker_name = $request->speaker_name[$key];
        $speaker->speaker_position = $request->speaker_position[$key];

        $speaker->save();
    }

    foreach ($request->Featured1 as $key=>$file){
        $session = new past_event_session();
        $session->past_event_id = $id;
        $session->Featured1 = $request->Featured1[$key];   (This is for image)
        $session->session_time = $request->session_time[$key];
        $session->event_session_name = $request->event_session_name[$key];
        $session->session_person_name = $request->session_person_name[$key];
        $session->session_person_topic = $request->session_person_topic[$key];
        $session->File =$request->File[$key];(This is for pdf file)

        $session->save();
    }
}

And the complete error message?

Yes, here is link :

https://ibb.co/dkfR1GH

https://ibb.co/xFBhgjk

https://ibb.co/NtDSyFR

and another details like Controller working and error in

https://ibb.co/BqSLfyY

https://ibb.co/hmxz23f

https://ibb.co/SVkYpxh

https://ibb.co/9yXrBY1

Thanks again.

You trying to save arrays instead of string|int|whatever-else here:

$data->title = $request->title;
$data->slug = $request->slug;
$data->event_date = $request->event_date;
$data->event_video_link = $request->event_video_link;
$data->event_place_name = $request->event_place_name;
$data->category_id = $request->category_id;

Pass that values as text, or change __get from request way ($request->title[0])

upd. see your first screen - there are only arrays

@slev1n , in title, slug,event_date,event_video_link,event_place_name and category_id are in first table where I not using array just passing single time value. and in another I am using array, so that it's showing. Thanks

SHow dd($data->getAttributes()) output (put before $data->save())

upd. so it's helps?

what @slev1n says.

Each of your variables is a single element array. My guess is that on a front end form you have for some reason added [] to every form name

eg name="title[]" so all your input elements are arrays

@snapey , As title and all column store in single table so I am not using name="title[]" i have like name="title"..but still getting same error.

@slev1n , here is image that i did and still get error, https://ibb.co/PzMZnRL

so how do you get the data? How come they are all arrays?

@snapey , no, For first table all are in simple form and for 2nd table and 3rd table they are in array.

@snapey , @tray2 , @slev1n , Now data are submitting in simple form and also for array form for all 3 section , However, Image is showing NULL, and Featured1 has data like "C:\xampp\tmp\php4CD9.tmp" and For file "C:\xampp\tmp\php4CDA.tmp" and for Featured it's showing like "C:\xampp\tmp\php4CC7.tmp" in data base..Thanks to all

all the error images you posted were showing all array...

probably you should show your form and model as well...

Thanks @siangboon, Here is link for code..

1> controller->https://paste.ofcode.org/345CS7zgbDvT4uCdzgKtfcW

2>Create.blade.php->https://paste.ofcode.org/8eBxj7rD77GrnbEBYW7tNm

3> Model->past_event->https://paste.ofcode.org/6MtuQA7dnsu2wHWw4CivMZ

4>Model->past_event-speaker->https://paste.ofcode.org/agPLRm8t8tBTFdTtmLCzKq

5>Model->past_event-session->https://paste.ofcode.org/33T6nmH729w6tBtFL3m8SBK

Here is all code link so you can chech, only Image are showing in index, however, Featured , Featured1, File and slug is not working.

To me it looks like this is the culprit

foreach ($request->Featured as $key=>$file){

Try changing to

foreach ($request('Featured') as $key=>$file){

@tray2 , I changed with this logic , throwing error, Is it right to add multiple image (Featured)?

Please suggest in it.

Thanks

Rigth or wrong hm. I would probably not do it that way and use a package that does it for me or maybe have a loop checking for multiple files. It depends on what you are trying to do.

I wolud suggest remove all the [] from your form and get that to work first then add it on the ones where you really need to send multiples.

I would probably use javascript to submit them one by one.

@tray2 thanks, I did as you have suggested. However, only image problem. thanks

Thanks to all, all are working now :)