How to Get an Array of All of the Columns of a Query Builder Result in Laravel?

Question

I am trying to get the columns of a dynamically created table. I looked at this question to find how to get the columns.

\DB::getSchemaBuilder()->getColumnListing(\DB::table('product_list')
    ->join('product_categories', 'product_list.product_category', '=', 'product_categories.id')
    ->join('product_types', 'product_list.product_type', '=', 'product_types.id')
    ->where('product_list.id', $this->id)
    ->orderBy('product_list.id', 'DESC')
    ->get()
);

However, this is giving me an output of []. If I run the command without encapsulating it with \DB::getSchemaBuilder()->getColumnListing() I get this:

Collection {#652 ▼
  #items: array:1 [▼
    0 => {#650 ▼
      +"id": 3
      +"cost": "150.00"
      +"product_category": 1
      +"product_type": 3
      +"product_score": 0
      +"created_at": "2019-01-16 16:34:29"
      +"updated_at": "2019-01-16 16:34:29"
      +"rating": 0
      +"down_payment": "10.00"
      +"title": "Static"
      +"price_start": "50.00"
      +"price_stop": "150.00"
      +"theme": "Custom"
      +"pages": 4
      +"rbac": 0
      +"portal": 0
      +"external_software": 0
      +"company_supplier": "Iezon Solutions"
    }
  ]
}

How can I get an array of all of the columns?

maybe you can try to get the first item in the collection and pass it to get_object_vars ? is that what you want ? [ "id", "cost", "product_category" ...] — Eden Reich
– Eden Reich, Commented Jan 18, 2019 at 0:15
Yeah, I need ['id', 'cost', 'product_category', ...]. `Maatwebsite\Excel` expects the column headings passed in separate to the rows. (which is really annoying!) @EdenReich — Jaquarh
– Jaquarh, Commented Jan 18, 2019 at 0:19
I have just found a 'quick-fix' for my issue, but please! If you know the correct approach to doing this, I'd love to see how its done @EdenReich — Jaquarh
– Jaquarh, Commented Jan 18, 2019 at 0:19
hmmm so I think the easiest way would be get_object_vars($collection->first()); — Eden Reich
– Eden Reich, Commented Jan 18, 2019 at 0:20
Yeah, the issue is, the package expects to use a Model. Eloquent doesn't, from my failed attempts and experience, allow you to 'inner join' fluently. I am having to use QueryBuilder within my Model (which is just ugh) to even achieve my functionality but its the only package I've found that works well. That has done exactly what I needed - feel free to make that an answer as it is deffo a better solution to my current! Only, I needed to wrap array_keys() around get_object_vars() @EdenReich — Jaquarh
– Jaquarh, Commented Jan 18, 2019 at 0:25

Eden Reich · Accepted Answer · 2019-01-18 00:33:46Z

3

If you just need the dynamically created table column names a quick solution is:

array_keys(get_object_vars($collection->first())); // will output ['id', 'cost', 'product_category', ...]

answered Jan 18, 2019 at 0:33

Eden Reich

3872 silver badges8 bronze badges

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

Comments

Jaquarh · Accepted Answer · 2019-01-18 00:26:28Z

0

This is probably by far the worst solution to use, but I don't have the time to search through the collection documentation to find a better method of doing this or the way its meant to be done using Laravel functionality.

I decided to convert it toArray(), use the first index [0] and cast it to an array. This then allows me to use array_keys() to find the column names.

array_keys((array) \DB::table('product_list')->join('product_categories', 'product_list.product_category', '=', 'product_categories.id')
            ->join('product_types', 'product_list.product_type', '=', 'product_types.id')
            ->where('product_list.id', $this->id)
            ->orderBy('product_list.id', 'DESC')->get()->toArray()[0])

edited Jan 18, 2019 at 0:26

answered Jan 18, 2019 at 0:17

Jaquarh

6,7498 gold badges49 silver badges119 bronze badges

Collectives™ on Stack Overflow

How to Get an Array of All of the Columns of a Query Builder Result in Laravel?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related