How to save a JSON response in Database with Laravel Eloquent, I'm getting an error "Array to string conversion"

Question

Error: "Array to string conversion"

I'm trying to save a JSON(string) with Eloquent into the database but I'm getting an error: "Array to string conversion"

I try to add in my model:

protected $casts = ['payload' => 'array'];

or

protected $casts = ['payload' => 'json'];

but is not working!

Controller

    try{
        if( $type == 'b2c'){
            $searchEnquiry = B2CSearchEnquiry::find($enquiryID);
            $data = $this->searchInDataSource($searchEnquiry);

            $repuveConsult = new B2cRepuveConsult;
            $repuveConsult->search_enquiry_id = $enquiryID;
            $repuveConsult->payload = (string)$data;
            $repuveConsult->saveOrFail();
        }
    }catch(\Exception $e){
        return $e->getMessage();
    }

Model

    class B2cRepuveConsult extends Model
    {
        protected $table = ['b2c_repuve_consults'];
        protected $fillable = ['search_enquiry_id','information'];
        protected $casts = [
            'information' => 'array',
        ];
    }

Migration


    public function up()
        {
            Schema::create('b2c_repuve_consults', function (Blueprint $table) {
                $table->increments('id');
                $table->integer('search_enquiry_id')->unsigned();
                $table->longText('payload')->nullable();
                $table->timestamps();
            });

            Schema::table('b2c_repuve_consults', function($table) {
                $table->foreign('search_enquiry_id')
                    ->references('id')
                    ->on('b2c_search_enquiries')
                    ->onDelete('cascade');
            });
        }

A raw query works but is not a good practice since I'm using Laravel

      DB::insert('insert into b2c_repuve_consults (search_enquiry_id,payload) values (?, ?)', [$enquiryID, $data]);

Vipertecpro · Accepted Answer · 2019-06-20 03:02:59Z

0

I assumed that you've put "payload_Array[]" in view file to get the array or somehow you create array in create method.

B2cRepuveConsult::create([
  '....'       => '....',
  'payload'  => json_encode($request->get('payload_Array')); // This is how you save json
  '....'       => '....',
]);

Reference : https://www.php.net/manual/en/function.json-encode.php

From you're code

try{
        if( $type == 'b2c'){
            $searchEnquiry = B2CSearchEnquiry::find($enquiryID);
            $data = $this->searchInDataSource($searchEnquiry);

            $repuveConsult = new B2cRepuveConsult;
            $repuveConsult->search_enquiry_id = $enquiryID;
            $repuveConsult->payload = json_encode($data); // update this
            $repuveConsult->saveOrFail();
        }
    }catch(\Exception $e){
        return $e->getMessage();
    }

answered Jun 20, 2019 at 3:02

Vipertecpro

3,3142 gold badges33 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

How to save a JSON response in Database with Laravel Eloquent, I'm getting an error "Array to string conversion"

Error: "Array to string conversion"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

** Error: "Array to string conversion" **

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related

Error: "Array to string conversion"