public function setChoices(array $choices) { $flatChoices = PoolType::flatten($choices); $stringChoices = implode("','", $flatChoices); // UPDATE pool_users SET choices = COLUMN_CREATE('color', 'blue', 'size', 'XL') WHERE id = 1; \DB::table('pool_user')->where('pool_id', '=', $this->pool_id)->where('user_id', '=', $this->user_id)->update(['choices' => \DB::raw("COLUMN_CREATE('{$stringChoices}')")]); }
public function run() { $poolTypes = PoolType::all(); factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]); factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]); factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]); factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]); factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]); }