Array to string conversion using Laravel

Question

I am trying to send a multi user-id into the database. When I select users from the checkbox, and I click to submit, I face an error:

Array to string conversion

How can I resolve this issue?

Please see error: https://flareapp.io/share/17DKWRPv

Controller

public function adduseraction(REQUEST $request)
{  
    $useradd=$request->get('userid');
    $checkid=$request->get('multiusersid');
    $user=Users_permissions::create([             
        'user_id'=>$useradd,
        'user_Access_id'=> $checkid
    ]);    
    $user->save();
}

HTML view

<div class="card card-success">
    <div class="card-header">
        <h3 class="card-title">Users Permission </h3>
    </div>
    <br>
    <form action="{{route('adduseraction')}}" method="post">
        {{ csrf_field() }}
        <div class="col-sm-4">
            <select name="userid" class="form-control">
                @foreach($users as  $user)
                <option  value="{{$user->id}}">{{$user->name}}</option>           
                @endforeach
            </select>
        </div>
        <div class="card-body">
            <!-- Minimal style -->
            <div class="row">
            @foreach($users as  $user)
                <div class="col-sm-2">
                    <div class="form-check">
                    <input type="checkbox" name="multiusersid[]"  value="{{$user->id}}" class="form-check-input" > 
                    <h5 style="position:relative;left:10px;">{{$user->name}}</h5>
                    </div>
                    <!-- checkbox -->
                </div>
            @endforeach
        </div>
        <!-- /.card-body -->
        </div>
        <div class="card-footer">
            <button type="submit" name="btnsubmit" class="btn btn-primary col-md-2 
            center">Submit</button>
        </div>
    </form>
</div>
<!-- /.content-wrapper -->

Route

Route::post('adduseraction','AdminController@adduseraction')->name('adduseraction');

Current status

{"_token":"4Z3ISznqKFXTMcpBKK5tUgemteqxuJjQpKF8F0Ma","userid":"6","multiusersid":["2","5","7"],"btnsubmit":null}

VIKAS KATARIYA · Accepted Answer · 2020-02-21 05:05:08Z

4

use implode($checkid, ',');

public function adduseraction(REQUEST $request)
{  
   $useradd=$request->get('userid');
   $checkid=$request->get('multiusersid');
   $user=Users_permissions::create([             
        'user_id'=>$useradd,
        'user_Access_id'=> implode($checkid, ',');
   ]);    
 }

Change in your Users_permissions model

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Users_permissions extends Model
{
     protected $table = 'userspermissions';
     protected $fillable = [
        'user_id','user_Access_id'
    ];
}

edited Feb 21, 2020 at 5:05

answered Feb 21, 2020 at 5:01

VIKAS KATARIYA

6,0153 gold badges19 silver badges37 bronze badges

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

6 Comments

Alex Mac Over a year ago

won't run you are missing '

VIKAS KATARIYA Over a year ago

why this answer get downvote @AlexMac you can just edit my answer not give only missing semi coloun mistake fr downvoted

Alex Mac Over a year ago

lol I updated as soon as you fixed. However, json_encode and json_decode you can type cast unlike implode and explode. It is also less work.

Alex Mac Over a year ago

laravel.com/docs/5.8/eloquent-mutators#attribute-casting more specifically this... laravel.com/docs/5.8/eloquent-mutators#array-and-json-casting

Zubair Over a year ago

I have used this code but facing error please check flareapp.io/share/dPbodL7k#F62

|

Naeem Ijaz · Accepted Answer · 2020-02-21 05:25:31Z

0

Here is your solution

public function adduseraction(REQUEST $request)
        {  
          $useradd=$request->get('userid');
          $checkid=implode(",", $request->get('multiusersid'));
          Users_permissions::create([             
               'user_id'=>$useradd,
               'user_Access_id'=> $checkid
            ]);
         }

edited Feb 21, 2020 at 5:25

answered Feb 21, 2020 at 5:00

Naeem Ijaz

7979 silver badges18 bronze badges

1 Comment

Zubair Over a year ago

I have used this code but facing error please check flareapp.io/share/dPbodL7k#F62

Alex Mac · Accepted Answer · 2020-02-21 05:31:44Z

0

It is expecting a string and you are passing an array of ids. You may want to change the database to json or do json_ecode(checkid). Which will stringify your array. then you can store. However, remember you will need to convert it back with typecasting or manually doing it.

example:

public function adduseraction(REQUEST $request)
{  
   $useradd=$request->get('userid');
   $checkid=$request->get('multiusersid');
   $user=Users_permissions::create([             
        'user_id'=>$useradd,
        'user_Access_id'=> json_encode($checkid)
   ]);    
   // $user->save(); // yes obviously not needed
 }

edited Feb 21, 2020 at 5:31

answered Feb 21, 2020 at 4:53

Alex Mac

9201 gold badge7 silver badges21 bronze badges

4 Comments

Alex Mac Over a year ago

json_encode will turn your array into a string that then can be stored in your database.

Alex Mac Over a year ago

trust me you want to go this route laravel.com/docs/5.8/eloquent-mutators#attribute-casting

Naeem Ijaz Over a year ago

you donot need to $user->save();

Alex Mac Over a year ago

I just copied his his example the key part was json_encode(checkid). create will new up your model and save() all in one swipe!

Collectives™ on Stack Overflow

Array to string conversion using Laravel

3 Answers 3

6 Comments

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related