Get Field Names from database table

Question

In this case, I need to get the Field Name from the table :

this is my static model

  <?php

namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
class Act_admin extends Model
{
    static function showCust(){
        $query = DB::table("dummy_db.customer")->select("*")->paginate(10);
        $FieldNames = Schema::getColumnListing($query);
        dd($FieldNames);

      // return $data;
    }
}

and the result just:

[]

Thanks before.

You must pass table name in function – Hossein Azad May 01 '20 at 13:43 — Hossein Azad, May 01 '20 at 13:43

score 0 · Answer 1 · answered May 01 '20 at 11:49

Pass table_name instead of $query in getColumnListing() function and it will works:-

<?php

namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Schema;
class Act_admin extends Model
{
    static function showCust(){
        $table_name = dummy_db.customer;
        $field_names = Schema::getColumnListing($table_name);
        dd($field_names);
    }
}

score 0 · Answer 2 · answered May 01 '20 at 11:55

0

You can get columns by this code

Public function getsomecolumns ($table)
{
Return DB::getSchemaBuilder()->getColumnListing($able);
}

Or you can replace return to this method

Return Schema::getColumnlisting($table);

answered May 01 '20 at 11:55

Hossein Azad

108
1
13

Get Field Names from database table

2 Answers2