How to get Column Name from a table in Laravel and PHP
You can get the column name through a raw query. There are other ways too and we will discuss all.
// Through raw query
$query = “SHOW COLUMNS FROM $table_name”;
$data[‘columns’] = \DB::select($query);
It will return the total array of everything.
And here is the magic one.
// Through Schema Facade
$columns = \Schema::getColumnListing(‘table_name’);
or
// Through DB Facade
$columns = \DB::getSchemaBuilder()->getColumnListing(‘table_name’);
// or
$columns = \DB::connection()->getSchemaBuilder()->getColumnListing(“table_name”);
Take a look at the following posts..
How to Run raw insert query or SQL file in Laravel seeder
How to find a column or field name of a table from an entire database?
