I have a table for data
Schema::create('general', function (Blueprint $table) {
$table->id();
$table->string('key')->unique();
$table->longText('value')->nullable();
$table->timestamps();
});
When adding data, I get the following records in the database
id: 2
key: country
value: ["Italy","Germany"]
Countries are now added to me through tags, like this
$form->tags('value', __('Value'))->help('Use key `<b>Enter</b>` to add a new value')->separators([';']);
The model has a function that receives and shares all values with the key country
public static function getCountries()
{
$country= self::where('key', 'country')->first();
return explode(',', $country['value']);
}
And then on the blade.php page I display these countries
@foreach(App\Models\General::getCountries() as $country)
<span>{{ $country }}</span>
@endforeach
The task is to attach a picture with a flag to each country
I create a new model with migration to add a picture
Schema::create('general_flags', function (Blueprint $table) {
$table->id();
$table->string('flag_image', 128);
$table->timestamps();
});
My controllers are all done correctly and pictures are added and saved
The main question is how do I create a relation of each value from the array with the desired flag, any ideas how to do this?
The problem is that I can’t change adding countries, so I have to work with what I have.