laravel Error: Array to string conversion

Question

I have gone through every solution I could find over youtube, stakoverflow and other websites. I am using Select2 to add multiple roles but I a consistently getting the same error.

<select id="role" name="role_id[]" multiple='multiple' 
        class="form-control js-example-basic-multiple">
    @foreach($roles as $role)
        <option value="{{$role->id}}">{{$role->name}}</option>
    @endforeach
</select>

DD function is showing perfect result but after that it shows error.

It works perfectly untill I add [] with the name="role_id[]". form action is as under.

public function store(Request $request)
{
    $this->validate($request, [
        'name'=> 'required|string|max:225',
        'status'=> 'required',
        'role_id'=> 'required',
        'email'=> 'required|string|email|max:225|unique:users',
        'password'=> 'required|string|min:6|confirmed'
    ]);

    $password = Hash::make($request->password);
    // dd($request->all());

    $user = new User;
    $user->name = $request->name;
    $user->status = $request->status;
    $user->role_id = $request->role_id;
    $user->email = $request->email;
    $user->password = $password;
    $user->remember_token;
    $user->save();
    // $user->roles()->sync($request->roles, false);
    return back()->with('message', 'User added successfully!!');
}

If I validate for integer 'role_id'=> 'required|integer', it shows error

Migration is as under

public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->unsignedInteger('role_id')->default(1);
            $table->boolean('status')->default(0);
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

Change it to 'role_id.*'=> 'required', and role_id is collection of array you should run that with loop and then insert in users role table since user have more than one role you need to keep them in another table like user_roles — JYoThI
– JYoThI, Commented Nov 29, 2018 at 5:00
error is here $user->role_id = $request->role_id; in this line you are assigning array ($request->role_id) to single variable. So, you should first create array and then used foreach loop on $request->role_id to assign value to array — Bilal Ahmed
– Bilal Ahmed, Commented Nov 29, 2018 at 5:11
I have another error in validation as well. If I use 'role_id'=> 'required|integer', instead of 'role_id'=> 'required', I get error "The role id is not integer". — Ali A.
– Ali A., Commented Nov 29, 2018 at 5:25
@AliAnwar whats the error?? You should include the actual error message in your question — Sohel0415
– Sohel0415, Commented Nov 29, 2018 at 5:45
error is "The role id is not integer" when I validate for Integer. — Ali A.
– Ali A., Commented Nov 29, 2018 at 6:08

Sagar Gautam · Accepted Answer · 2018-11-29 05:05:39Z

5

$request->role_id is array so you can't store array to database directly so you can use following,

  $user->role_id = json_encode($request->role_id);

Later you can use json_decode function to get array of role_id.

answered Nov 29, 2018 at 5:05

Sagar Gautam

9,4099 gold badges62 silver badges95 bronze badges

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

2 Comments

Ali A. Over a year ago

Thanks for answering to my question. I am getting another error with this code.

Ali A. Over a year ago

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '["2","3"]' for column 'role_id' at row 1 (SQL: insert into users (name, status, role_id, email, password, updated_at, created_at) values (Admin, 0, ["2","3"], [email protected], $2y$10$DEzjq.XtHPL06FnbtPTa9Oht0Bm5k9eJQT1dh6.A/5TBmVqMGi3yy, 2018-11-29 06:22:48, 2018-11-29 06:22:48))

Leena Patel · Accepted Answer · 2018-11-29 06:35:37Z

2

As you have pivot table for roles than you dont need role_id column in your users table

public function store(Request $request)
{
$this->validate($request, [
    'name'=> 'required|string|max:225',
    'status'=> 'required',
    'role_id'=> 'required|array',
    'email'=> 'required|string|email|max:225|unique:users',
    'password'=> 'required|string|min:6|confirmed'
]);

$password = Hash::make($request->password);
// dd($request->all());

$user = new User;
$user->name = $request->name;
$user->status = $request->status;
$user->email = $request->email;
$user->password = $password;
$user->remember_token;
$user->save();

foreach($request->input('role_id') as $role)
{
   $user->assign($role);
}
// $user->roles()->sync($request->roles, false);
return back()->with('message', 'User added successfully!!');
}

edited Nov 29, 2018 at 6:35

answered Nov 29, 2018 at 5:03

Leena Patel

2,4531 gold badge17 silver badges30 bronze badges

14 Comments

Ali A. Over a year ago

Thanks for replying to my question but I am getting error again with this code.

Ali A. Over a year ago

Please check this 33:00 to 33:35 in this tutorial youtube.com/watch?v=BNUYaLWdR04&t=232s

Leena Patel Over a year ago

That is because you have set length in your database column role_id that is exceeding when you are selecting more than one roles in your dropdown. so make it larger as varchar(256)

Leena Patel Over a year ago

use required|array to validate as an array

Ali A. Over a year ago

I am following ur suggestions.

|

Emtiaz Zahid · Accepted Answer · 2018-11-29 05:08:38Z

2

Problem:

$request->role_id is an array. not a single data.

Suggestion:

Here two things

You allocating multiple rules with an user

You should not store your rules in users table

You should do that like this:

create another table to store users role

and store user rules separately

Example:

      $user = new User;
      $user->name = $request->name;
      $user->status = $request->status;
      $user->email = $request->email;
      $user->password = $password;
      $user->remember_token;
      $user->save();

      $roleAssigns = [];
      foreach($request->role_id as $role){
          $roleAssigns[] = [
              'role_id' => $role,
              'user_id' => $user->id
          ]
      }
      //UserRole is the model of user_roles table
      UserRole::insert($roleAssigns);

edited Nov 29, 2018 at 5:08

answered Nov 29, 2018 at 5:06

Emtiaz Zahid

2,8552 gold badges23 silver badges36 bronze badges

3 Comments

Ali A. Over a year ago

You have pointed out the problem rightly. I tried your code but again I am getting syntax error. I have another error in validation as well. If I use 'role_id'=> 'required|integer', instead of 'role_id'=> 'required', I get error "The role id is not integer". I have seen many people using many to many relationships adding data the same way.

Emtiaz Zahid Over a year ago

if controller want integer type role_id then you should pass integer from view. its the view issue.

Ali A. Over a year ago

I am following the process as Alex is following in many to many relations in his youtube tutorial. I have also seen in many tutorials for the many to many relationships. But in my case its not working. Please check this 33:00 to 33:35 in this tutorial youtube.com/watch?v=BNUYaLWdR04&t=232s –

Junaid Abbas · Accepted Answer · 2019-02-27 06:26:34Z

0

You cannot "echo" an array, that is the error.

you will need to collect the lines in an array, and then return that array

answered Feb 27, 2019 at 6:26

Junaid Abbas

112 bronze badges

Comments

Adam · Accepted Answer · 2019-10-24 18:10:37Z

0

If you want to output an array for your .js code, you may use

@json($array)

since Laravel 5.5

answered Oct 24, 2019 at 18:10

Adam

29.6k30 gold badges187 silver badges281 bronze badges

Collectives™ on Stack Overflow

laravel Error: Array to string conversion

5 Answers 5

2 Comments

14 Comments

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

14 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related