laravel:how to get columns name of eloquent model?

Question

I am using laravel 5.2 ,i want to get all the column (attribute) name of selected eloquent model,is there way to do this?

following is my code in controller method

    if($request->method=="edit")
    {
        /*we are in edit mode details of given news ID should be attached*/
        $curNews=News::find($request->newsID);
        if($curNews==null)return back()->withErrors(["Unable to Edit News:No Data Found For Given News ID"]);

        foreach((array)$curNews->attributes as $key=>$val)
        {
            $data[$key]=$val;
        }

    }

    return view('adminarea.news.news-addedit',$data);

@joy it's basics of php, You already have object that has `fieldName = 'some data'`, so it's not laravel question - it's all about basics of php (how to get attributes of object), sorry I'll downvote Your question — num8er, Aug 22 '17 at 13:01

score 78 · Accepted Answer · answered Aug 22 '17 at 13:02

78

$columns = Schema::getColumnListing('users'); // users table
dd($columns); // dump the result and die

answered Aug 22 '17 at 13:02

Kuldeep Mishra

3,846
1
21
26

5

Import schema at the top - use Illuminate\Support\Facades\Schema; – sanjay mundhra Apr 27 '20 at 05:50
This is how you get column names from table, not model - which was asked in question. If model tables are dynamic and may change - this is not good solution. – Kristaps J. Aug 20 '20 at 08:09
1

Does not work in 7.x – J. Robinson Dec 03 '20 at 17:52
for some strange reason, it started auto-sorting keys in alphabetical order. `\array_keys( $model->getAttributes() )` works for me – Sumit Wadhwa Dec 21 '20 at 06:40
For newer Laravel versions (in my case 5.8) just use: `use Schema;` The path with Illuminate\Support\ etc. will not work. – Roman Feb 10 '21 at 10:45

score 22 · Answer 2 · answered Aug 22 '17 at 12:58

22

If you want get the names of your attributes, you can try this

$item = News::find($request->newsID);

    $attributes = array_keys($item->getOriginal());
// or 
$attributes = array_keys($item->getAttributes());

answered Aug 22 '17 at 12:58

Pavel

918
7
18

2

if it is a collection use $items->first()->getAttributes() – namal Jun 22 '20 at 07:21
1

This is a better way instead of using Schema. – Yan Zhao Jun 27 '21 at 14:13

score 2 · Answer 3 · answered Aug 22 '17 at 13:09

don't know i am right or not, but i have overcome with following code,and its working for me.

    if($request->method=="edit")
    {
        /*we are in edit mode details of given news ID should be attached*/
        $curNews=News::find($request->newsID);
        if($curNews==null)return back()->withErrors(["Unable to Edit News:No Data Found For Given News ID"]);

        foreach($curNews->toArray() as $key=>$val)
        {
            $data[$key]=$val;
        }

    }

    return view('adminarea.news.news-addedit',$data);

laravel:how to get columns name of eloquent model?

3 Answers3

Linked