Related Tools & Blogs

Related.php

<?php
// --- For Tools 
/* 
    1. Run this command
        php artisan make:migration related_tools_to_tools 
    2. Then Write this code in the database/migration file
    3. Then Run That command 
    4. Store data in this formate
        [
            {"id":77,"slug":"calc\/percent-error-calculator","name":"Percent Error Calculator","lang":"en"},
            {"id":117,"slug":"calc\/pythagorean-theorem-calculator","name":"Pythagorean Theorem Calculator","lang":"en"},
            {"id":129,"slug":"calc\/arc-length-calculator","name":"Arc Length Calculator","lang":"en"},
            {"id":145,"slug":"calc\/grade-calculator","name":"Grade calculator","lang":"en"}
        ]
    
*/
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()
    {
        Schema::table('tools', function (Blueprint $table) {
            if (!Schema::hasColumn('tools', 'related_tools')) {
                $table->json('related_tools')->nullable()->after("parent_id")->comment('Related tools data available');
            }
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('tools', function (Blueprint $table) {
            $table->dropColumn('related_tools');
        });
    }
};