Insert array column query builder laravel

Question

I am using laravel and I want to insert an array to a column but it gives me this error I do not why

here is my query

        DB::table('cart_product')->insert([
          ['product_id' => $request->product_id,'quantity' => $request->quantity, 'cart_id' => \Auth::user()->cart()->get()->first()->id, 'color_id' => $request->color, 'total_price' => $productPrice, 'specification' => $request->specification]
          , ]);

and here is model

class CartProduct extends Model
{
  use SoftDeletes;
  protected $guarded = ['id'];
  protected $dates = ['deleted_at'];
  protected $table = 'cart_product';
  protected $casts = ['specification' => 'array'];
  }
}

and error is for this

$request->specification

here is a dd of this

array:4 [▼
  0 => "4"
  1 => "7"
  2 => "8"
  3 => "9"
]

gives me this error

Array to string conversion

If this is an array than you can save this field as json in your database — Sehdev
– Sehdev, Commented Feb 10, 2020 at 9:06

Jerodev · Accepted Answer · 2020-02-10 09:06:52Z

3

Casts only work when you use Eloquent Models to execute the queries. When you use the Query Builder directly, your casts are not executed, so you are trying to bind an array to a MySQL query.

Either manually json_encode the value:

DB::table('cart_product')->insert([
    ['specification' => \json_encode($request->specification)]
]);

Or use the eloquent model:

CartProduct::create([
    'specification' => $request->specification,
]);

answered Feb 10, 2020 at 9:06

Jerodev

33.3k11 gold badges96 silver badges113 bronze badges

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

Comments

dhamo · Accepted Answer · 2020-02-10 09:05:02Z

0

Convert Your Array to string

DB::table('cart_product')->insert([[
 'product_id' => $request->product_id,
 'quantity' => $request->quantity,
 'cart_id' => \Auth::user()->cart()->get()->first()->id,
 'color_id' => $request->color, 
 'total_price' => $productPrice, 
 'specification' => '[4, 7, 8, 9]'
]]);

answered Feb 10, 2020 at 9:05

dhamo

5552 silver badges7 bronze badges

Comments

Sehdev · Accepted Answer · 2020-02-10 09:11:04Z

0

If you want to use DB then you have to user json_encode to save array in your database

DB::table('cart_product')->insert([
          [
          'product_id' => $request->product_id, 
          'quantity' => $request->quantity,
          'cart_id' => \Auth::user()->cart()->get()->first()->id, 
          'color_id' => $request->color,
          'total_price' => $productPrice,
          'specification' => json_encode($request->specification) // add json_enocde here
          ]
          , ]);

answered Feb 10, 2020 at 9:11

Sehdev

5,7123 gold badges14 silver badges34 bronze badges

Collectives™ on Stack Overflow

Insert array column query builder laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related