[Check if column exists] #php #laravel

Column.php

<?php

declare(strict_types=1);

namespace Database\Helpers;

use Illuminate\Support\Facades\Schema;

class Column
{
    public static function exists(string $table, string $column, ?string $database = null): bool
    {
        $columns = Schema::getConnection()->getDoctrineSchemaManager()->listTableColumns($table, $database);
        $columnNames = collect($columns)->map(fn ($column) => $column->getName());

        return $columnNames->contains($column);
    }
}
// create helper folder in database folder
// add "Database\\Helpers\\": "database/helpers/" to composer psr-4 section