PHP Laravel 4 - Database table "as"

Question

I am creating a backend interface for a site made in Joomla. I am using Laravel to create the backend. Joomla has table prefixes and tend to have long table names there are some of which around 25 characters.

My issue is, I have looked around to see if that you can alias table names (so I don't have to type the table name all the time in the join statement) by I don't seem to be able to find a method for this in the query object.

ModelName::getTable(); // Happens to be a static method.

Any helper much appreciated.

score 5 · Accepted Answer · edited May 23 '17 at 12:23

5

As answered in that StackOverflow question:

How to alias a table in Laravel Eloquent queries (or using Query Builder)?

you can either use aliases while building your query

$users = DB::table('really_long_table_name AS t')
       ->select('t.id AS uid')
       ->get();

or define the alias in your Eloquent model

protected $table = 'really_long_table_name AS short_name';

edited May 23 '17 at 12:23

Community

1
1

answered Jul 19 '13 at 15:48

Gadoma

6,475
1
31
34

You shouldn't define the alias in the models. It will cause problems on inserts or updates. insert into really_long_table_name AS short_name ... – c4pone Apr 10 '15 at 04:15
I agree with @c4pone – William Jan 05 '16 at 18:34

PHP Laravel 4 - Database table "as"

1 Answers1