get table column names sql laravel
use IlluminateSupportFacadesSchema;
use IlluminateSupportFacadesDB;
public function getTableColumns($table)
{
return DB::getSchemaBuilder()->getColumnListing($table);
// OR
return Schema::getColumnListing($table);
}laravel eloquent get column
//return array of json
Model::where('id', 1)->get(['column1','column2']);
or
Model::all(['column1']);
//return array
Model::whereNull('deleted_at')->pluck('column1');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')Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
