Array to string conversion in laravel 5.4 , controllers

Question

I'm getting array to conversion error while inserting multiple data , code which i mentioned below please take a look and somebody help me

Controller.php

         if(!empty($value))
                {
                    foreach ($value as $v) 
                    {   
                        $insert[] = ['name' => $v['name'], 'email' => $v['email'],'company_name' => $v['company_name'],'company_id' => $v['company_id'], 'emp_id' => $v['emp_id']];     
                         $role_id= $v['role_id'];
                         $name=$v['name'];
                         $email=$v['email'];
                         $emails[]=$v['email'];
                         $emp_id=$v['emp_id'];                      
                         $data = array( 'name' => $name,'email' => $email , 'emp_id' => $emp_id);
                         $roles[]= $v['role_id']; 

                    }
                }
            }

            if(!empty($insert))
            {
                 $inserted=User::insert($insert);
                 if($inserted)
                 {
                     $email_select=User::select('id')->whereIn('email',$emails)->where('company_id',Auth::user()->company_id)->orderBy('id','Asc')->get();
                    foreach ($email_select as $key => $idget) 
                    {
                        $getid[]=$idget->id;
                    }
                 }
                 $datas[]=['user_id' => $getid , 'role_id' => $roles];                  
                 $insert_role=DB::table('role_user')->insert($datas) ;

I'm getting error called array to string conversion while insert_role variable execution

(2/2) QueryException Array to string conversion (SQL: insert into role_user (role_id, user_id) values (1, 16))

looks like $datas['role_id'] is an array, since you build $roles in the foreach — Harry
– Harry, Commented Sep 12, 2017 at 10:11

Mark Walet · Accepted Answer · 2017-09-12 10:16:49Z

1

$roles and $getid are both arrays. I am guessing you want to assign all roles to all selected mail addresses. Then you would have to do the following:

if($inserted)
{
    $email_select=User::select('id')->whereIn('email',$emails)->where('company_id',Auth::user()->company_id)->orderBy('id','Asc')->get();
    foreach ($email_select as $key => $idget) 
    {
        foreach($roles as $role) {
            $datas[] = ['user_id' => $idget->id, 'role_id' => $role];
        }
    }
}
$insert_role=DB::table('role_user')->insert($datas);

I think this should work.

answered Sep 12, 2017 at 10:16

Mark Walet

1,21611 silver badges23 bronze badges

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

1 Comment

Mark Walet Over a year ago

Could you accept this as your answer if it's working?

Milan Chheda · Accepted Answer · 2017-09-12 10:15:12Z

1

Make $roles[]= $v['role_id']; to $roles= $v['role_id'];

And $getid[]=$idget->id; to $getid=$idget->id;

edited Sep 12, 2017 at 10:15

Milan Chheda

8,2593 gold badges23 silver badges35 bronze badges

answered Sep 12, 2017 at 10:13

User123123

191 silver badge8 bronze badges

2 Comments

Mark Walet Over a year ago

Doesn't this only insert the last row and forgets the rest?

User123123 Over a year ago

For that you have to arraypush

Mohamed Akram · Accepted Answer · 2017-09-12 12:50:58Z

0

instead of assigning in array, you are trying to assign as string, that is what causing you the error, possible fix is.

$roles[]= $v['role_id']; 
$getid[]=$idget->id;

answered Sep 12, 2017 at 12:50

Mohamed Akram

2,11716 silver badges22 bronze badges

Collectives™ on Stack Overflow

Array to string conversion in laravel 5.4 , controllers

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related