How to solve Array to string conversion when save data into database in laravel 6

Question

When I am going to save data to database using save($data) . Then there show a error ErrorException Array to string conversion.

Here is controller :

public function create(Request $request){
        $company = new Company();
        $data = [
        'name' => $request['name'] ,
        'address' => $request['address'] ,
        'city' => $request['city'] ,
        'state' => $request['state'] ,
        'zip' => $request['zip'] ,
        'country' => $request['country'] ,
        'email' => $request['email'] ,
        'logo' => $request['logo']
        ];

        $file = $request->file('logo');
        if($request->hasFile('logo')){
            $destinationPath = 'upload';
            $file->move($destinationPath,$file->getClientOriginalName());
        }

        //dd($data);

        $company->save($data);

        return true ;

    }

If logo is a file. You should save the path where it's stored. — apokryfos
– apokryfos, Commented Dec 21, 2019 at 9:23

Md Al imrun Khandakar · Accepted Answer · 2019-12-21 10:57:59Z

1

try this ..

public function create(Request $request){

    $data = [
    'name' => $request['name'] ,
    'address' => $request['address'] ,
    'city' => $request['city'] ,
    'state' => $request['state'] ,
    'zip' => $request['zip'] ,
    'country' => $request['country'] ,
    'email' => $request['email'] ,
    'logo' => $request['logo']
    ];

    $file = $request->file('logo');
    if($request->hasFile('logo')){
        $destinationPath = 'upload';
        $file->move($destinationPath,$file->getClientOriginalName());
    }

    //dd($data);

    DB::table('companies')->insert($data); //dont forget to import DB namespace.  

    return true ;

}

the table name is companies so I used that. Model( company )

answered Dec 21, 2019 at 10:57

Md Al imrun Khandakar

1591 silver badge8 bronze badges

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

1 Comment

Russel Monzur Over a year ago

Thanks . It's work fine but it also provide following error : UnexpectedValueException The Response content must be a string or object implementing __toString(), "boolean" given.

Maksat · Accepted Answer · 2019-12-21 09:18:09Z

Add the attribute protected $fillable = [ 'column_a', 'column_b', .. ]; to your model. Then you can use the mass assignment like this.

Too much extra code. You should use modern variants.

public function create(Request $request){
    $file = $request->file('logo');
    if($request->hasFile('logo')){
        $file->move('upload', $file->getClientOriginalName());
    }

    Company::create([
        'name' => $request->name,
        'address' => $request->address,
        'city' => $request->city,
        'state' => $request->state,
        'zip' => $request->zip,
        'country' => $request->country,
        'email' => $request->email,
        'logo' => $request->logo
    ]);

    //You can also use this if "$fillable" array in model is filled:
    //Company::create($request->all());

    return true;
}

user2711639 · Accepted Answer · 2019-12-21 11:26:26Z

0

Since you instantiating the model. you could do like this instead of passing an array.

$company = new Company();
$company->name = $request['name'];
$company->address = $request['address'];
$company->city = $request['city'];
$company->state = $request['state'];
$company->zip = $request['zip'];
$company->country = $request['country'];
$company->email = $request['email'];
$company->save();

if $request['name'] like variables doesn't work with associative array then i would personally change it to more like object e.g $request->name and so on with every other variables.

answered Dec 21, 2019 at 11:26

user2711639

Collectives™ on Stack Overflow

How to solve Array to string conversion when save data into database in laravel 6

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related