Can LaravelSchema::getColumnListing() return columns in order?-CodePudding

I would like to list all of the columns in a given table, Schema::getColumnListing() does a great job of this however it is returning the columns alphabetically rather than the order they are created in, is there a way to change this?

Here is an example on a standard users table:

Table Structure:

 --- ------------------- ----------------- 
| 1 | id                | bigint unsigned |
 --- ------------------- ----------------- 
| 2 | name              | varchar(255)    |
 --- ------------------- ----------------- 
| 3 | email             | varchar(255)    |
 --- ------------------- ----------------- 
| 4 | email_verified_at | timestamp       |
 --- ------------------- ----------------- 
| 5 | password          | varchar(255)    |
 --- ------------------- ----------------- 
| 6 | remember_token    | varchar(100)    |
 --- ------------------- ----------------- 
| 7 | created_at        | timestamp       |
 --- ------------------- ----------------- 
| 8 | updated_at        | timestamp       |
 --- ------------------- -----------------

Test Code:

$model = new \App\Models\User;
$table = $model->getTable();
$columns = Schema::getColumnListing($table);
dd($columns);

Output:

^ array:8 [▼
  0 => "created_at"
  1 => "email"
  2 => "email_verified_at"
  3 => "id"
  4 => "name"
  5 => "password"
  6 => "remember_token"
  7 => "updated_at"
]

Desired Output:

^ array:8 [▼
  0 => "id"
  1 => "name"
  2 => "email"
  3 => "email_verified_at"
  4 => "password"
  5 => "remember_token"
  6 => "created_at"
  7 => "updated_at"
]

CodePudding user response：

You can use model attributes.

$item = Model::where('id', 1)->first();
$attributes = array_keys($item->getOriginal());
// or
$attributes = array_keys($item->getAttributes());
dd($attributes);

CodePudding user response：

Haven't looked at the implementation of it, but if it's not returning the columns in order, why not try raw mysql?

SHOW COLUMNS
FROM users;

Use that within a DB::select() query and get the results.

Full query: $columns = \DB::select('SHOW COLUMNS FROM users');

If you want to keep it dynamic, use $columns = \DB::select('SHOW COLUMNS FROM ?', [$table]);

Note: Code is untested.