laravel:how to get columns name of eloquent model? [duplicate]

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
– num8er, Commented Aug 22, 2017 at 13:01

Kuldeep Mishra · Accepted Answer · 2017-08-22 13:02:31Z

88

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

answered Aug 22, 2017 at 13:02

Kuldeep Mishra

4,0601 gold badge24 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

sanjay mundhra Over a year ago

Import schema at the top - use Illuminate\Support\Facades\Schema;

Kristaps J. Over a year ago

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.

J. Robinson Over a year ago

Does not work in 7.x

Sumit Wadhwa Over a year ago

for some strange reason, it started auto-sorting keys in alphabetical order. \array_keys( $model->getAttributes() ) works for me

Roman Over a year ago

For newer Laravel versions (in my case 5.8) just use: use Schema; The path with Illuminate\Support\ etc. will not work.

|

Pavel · Accepted Answer · 2017-08-22 12:58:31Z

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, 2017 at 12:58

Pavel

9361 gold badge7 silver badges19 bronze badges

2 Comments

namal Over a year ago

if it is a collection use $items->first()->getAttributes()

Yan Zhao Over a year ago

This is a better way instead of using Schema.

Jatin Parmar · Accepted Answer · 2017-08-22 13:09:59Z

2

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);

answered Aug 22, 2017 at 13:09

Jatin Parmar

2,9596 gold badges22 silver badges34 bronze badges

Collectives™ on Stack Overflow

laravel:how to get columns name of eloquent model? [duplicate]

3 Answers 3

6 Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

2 Comments

Comments

Linked

Related