传递给 Illuminate\Database\Grammar::parameterize()

Question

很好，我有一个原始属性，正在创建一个属性，该属性具有用户通过复选框选择的特征，我想知道如何使用属性 id 保存在特征表中选择的复选框集控制器           $characteristics = new Characteristic;                $characteristics->characteristic = $request->input('characteristic');            $characteristics->save();        迁移特性 public function up()    {        Schema::create('properties', function (Blueprint $table) {            $table->increments('id');            $table->string('name')->nullable;            $table->string('price')->nullable;            $table->text('description')->nullable;            $table->unsignedBigInteger('property_type_id')->nullable();            $table->unsignedBigInteger('offer_type_id')->nullable();            $table->unsignedBigInteger('spaces_id')->nullable();            $table->unsignedBigInteger('departaments_id')->nullable();            $table->unsignedBigInteger('municipalities_id')->nullable();            $table->unsignedBigInteger('details_id')->nullable();            $table->unsignedBigInteger('characteristics_id')->nullable();            $table->string('images')->nullable;            $table->float('lat')->nullable;            $table->float('lng')->nullable;            $table->string('address')->nullable;                        $table->timestamps();                        $table->foreign('property_type_id')->references('id')->on('property_type')->onDelete('cascade');            $table->foreign('offer_type_id')->references('id')->on('offer_type')->onDelete('cascade');            $table->foreign('spaces_id')->references('id')->on('spaces')->onDelete('cascade');            $table->foreign('departaments_id')->references('id')->on('departaments')->onDelete('cascade');            $table->foreign('municipalities_id')->references('id')->on('municipalities')->onDelete('cascade');            $table->foreign('details_id')->references('id')->on('details')->onDelete('cascade');            $table->foreign('characteristics_id')->references('id')->on('characteristics')->onDelete('cascade');        });    }

Answer 1

看起来你的$request->input('characteristic');是一个数组而不是字符串。

你需要一个循环来解决这个问题。一种方法可以是：

$data = []

foreach ($request->input('characteristic') as $characteristic) {

   $data[] = [

      'characteristic' => $characteristic,

      'property_id' => '' // something

   ];

}

Characteristic::insert($data);

->saveMany()更好的方法是通过设置关系来使用hasMany()。

$characteristics = [];

foreach ($request->input('characteristic') as $characteristic) {

   $characteristics = new Characteristic([

        'characteristic' => $characteristic

   ]);

}

$property->characteristics()->saveMany($characteristics);

Answer 2

我能够保存数据如下

$piso_id = $properti->id;

        

            foreach ($request->input('characteristic') as $characteristic) {

               

               $charc = new Characteristic;

               

               $charc->property_id = $piso_id;

               $charc->characteristic = $characteristic;

               $charc->save();

            }