Array to string conversion using laravel 8

Question

I am trying to insert data but unfortunately i am getting error Array to string conversion please help me how can i resolve that thanks.

please check error https://flareapp.io/share/x5Mznjem

return request

{
"_token": "3qLsIoNwWiOuze8aurlSQGqU4FsgttXgY6sMFYnw",
"icon": "0AKj2DRZii6yhJsoWKLNUbmOWKrXzOqKoFJTF4LI.jpg",
"name": "fdgdfg",
"person_name": "dfg",
"contact_number": "43543543",
"city": [
"2",
"3",
"4",
"5"
],
"location": [
"1",
"3",
"4"
],
"address": "A-232 Gulshan-e-hadeed ph 2"
}

controller

    public function store(Request $request)
    {   
            // return $request->all();
        $request->validate([
            'name' => "required",
            'icon' => 'nullable',
            'person_name' => 'required',
            'contact_number' => 'required',

        ]);

        $agency = Agency::create($request->except('_token'));
            
            

        foreach ($request->city as  $key => $value) {
               
            $agencyCityLocation = new AgencyCityLocation;
            $agencyCityLocation->agency_id = $agency->id;
            $agencyCityLocation->city_id = $value;
            $agencyCityLocation->location_id = $request->location;
            $agencyCityLocation->save();
        }

        return redirect()->route('agency');
    }

$agencyCityLocation->location_id = $request->location; here you need to send id but your sending array — Kamlesh Paul
– Kamlesh Paul, Commented Mar 15, 2021 at 11:46
i am selecting multiple location and city i am sending ids of city and location — zubair malik
– zubair malik, Commented Mar 15, 2021 at 11:50
$agencyCityLocation->save(); i am getting error in this line — zubair malik
– zubair malik, Commented Mar 15, 2021 at 11:51
if your selecting multiple location then your database need to allow to insert array insted of single id — Kamlesh Paul
– Kamlesh Paul, Commented Mar 15, 2021 at 12:00

Nurullah · Accepted Answer · 2021-03-15 13:20:54Z

1

Replace this

$agencyCityLocation->location_id = $request->location;

By

$agencyCityLocation->location_id = $request->location[$key]

answered Mar 15, 2021 at 13:20

Nurullah

1023 bronze badges

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

Comments

dns_nx · Accepted Answer · 2021-03-15 12:28:32Z

0

The issue is this line:

$agencyCityLocation->location_id = $request->location;

As you wrote $request->location is an array...

"location": [
   "1",
   "3",
   "4"
],

...and I assume, that in $agencyCityLocation->location_id only one string is expected and not an array.

One solution would be to iterate through the locations as well (as you do with the cities), but actually we don't know how you want to save your data into the database. Do you want one DB entry for each city - location combination or is the city combined with the location?

edited Mar 15, 2021 at 12:28

answered Mar 15, 2021 at 11:51

dns_nx

3,9556 gold badges47 silver badges79 bronze badges

2 Comments

Kamlesh Paul Over a year ago

is this solution ?

dns_nx Over a year ago

We don't know how the OP wants to handle this situation. He needs to iterate through all locations and all cities. We don't know, if he wants to create one DB entry for each city and location combination. But I will add this explantion to my answer.

Collectives™ on Stack Overflow

Array to string conversion using laravel 8

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related