/PHP/Laravel/Laravel get column field name

Laravel get column field name

Laravel get list of columns in a table

use Illuminate\Support\Facades\Schema;

use Illuminate\Support\Facades\DB;

public function getTableColumns($table)
{
    return DB::getSchemaBuilder()->getColumnListing($table);

    // OR

    return Schema::getColumnListing($table);

}

Source: stackoverflow.com

Laravel get column field name

// You may need to run
composer require doctrine/dbal
// Retrieve laravel column type
$columnType = DB::getSchemaBuilder()->getColumnType($tableName, $colName)
// for example
$columnType = DB::getSchemaBuilder()->getColumnType('user', 'age')

Similar codes

0 vote401 views1 answer
Laravel collection shuffle
PHP Laravel
-1 vote385 views3 answers
Delete rows by migration laravel
PHP Laravel
1 vote365 views1 answer
Laravel increment column value in update query
PHP Laravel
1 vote438 views2 answers
Laravel JWTAuthentication
PHP Laravel
19 votes368 views6 answers
Laravel Route Group
PHP Laravel
2 votes388 views2 answers
Laravel eloquent get all where in
PHP Laravel
0 vote366 views2 answers
Laravel validation exact string length
PHP Laravel
0 vote388 views1 answer
Remove invalid characters from a string laravel
PHP Laravel
0 vote397 views1 answer
Morph laravel without classes name
PHP Laravel
12 votes347 views6 answers
Laravel where and where
PHP Laravel