Get MySQL table columns using Eloquent in Laravel

Question

How would I get inside of a custom model the columns for a specific MySQL table using Eloquent in Laravel

I was trying DB::query("SHOW COLUMNS FROM " . $table) but without any success

Do you get an error or an unexpected result? – Andreas May 04 '14 at 19:16 — Andreas, May 04 '14 at 19:16

sidneydobber · Accepted Answer · 2014-05-04T20:28:50.973

5

What you are using is not Eloquent, but raw database queries.

RAW queries:

$table = 'your_table';
$columns = DB::select("SHOW COLUMNS FROM ". $table);

edited May 04 '14 at 20:28

answered May 04 '14 at 19:24

sidneydobber

thanks for the update but unfortunately I do not get any expected I use it like MyModel::select("SHOW COLUMNS FROM ". $table); – fefe May 04 '14 at 20:13
OK, that is Eloquent! The answer works for me, but it might not work with Eloquent. – sidneydobber May 04 '14 at 20:14
how do I refactor the method to use in this case raw query – fefe May 04 '14 at 20:18
Doesn't seem to work for Eloquent. This is for RAW queries. DB:: is RAW queries. – sidneydobber May 04 '14 at 20:29
1

okay thanks again to use RAW queries is needed to use Illuminate\Support\Facades\DB as DB; in model – fefe May 04 '14 at 20:52
You're welcome! By trying to answer questions I'm learning more and more too! ;) – sidneydobber May 04 '14 at 21:00

score 0 · Answer 2 · answered May 04 '14 at 20:32

0

There's no Eloquent function for this as it is considered out of its scope. I'd just do the following:

DB::select('show columns from '.(new MyModel)->getTable());

answered May 04 '14 at 20:32

Andreas

2 Answers2