如何使用Laravel Elount在数据库中保存JSON响应，我得到一个错误“数组到字符串转换”

Question

我试图保存一个JSON（字符串）与雄辩到数据库，但我得到一个错误：数组到字符串转换

我试着在我的模型中添加：

protected$casts=['payload'=

或者

protected$casts=['payload'=

但是它不起作用！

控制器

    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();
    }

模型

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

迁移

    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');
            });
        }

原始查询工作，但不是一个好的做法，因为我使用Laravel

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




Answer 1

我假设您已经在视图文件中放置了“payload_Array[]”来获取数组，或者您以某种方式在create方法中创建了数组。

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

参考：https://www.php.net/manual/en/function.json-encode.php

从你的代码

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();
    }