Every two weeks I send out a newsletter containing lots of interesting stuff for the modern PHP developer. You can expect quick tips, links to interesting tutorials, opinions and packages. Want to learn the cool stuff? Then sign up now!

Making Eloquent models translatable

Spatie, the company where I work, is located in Belgium. Although our country is quite small, there are three official languages: Dutch, French and German. That’s why nearly all of our projects are multilingual. In most projects we used to rely on Dimitris Savvopoulos popular translatable package to make Eloquent models translatable. Installing and using it is fairly easy. A downside is that all translations are stored in a separate tables. This means that you need to migrate two tables and manage two models.

Today we released our newest package laravel-translatable. This big difference with Dimitris’ package is that translations are stored as json. There is no need for a second table or model. The idea to store translations as json is not ours, we got it from active community member Mohamed Said (be sure to check out his blog).

To make a model translatable you just have to use the HasTranslations-trait and specify in a property called $translatable which attributes should be translatable. All translatable attributes should be mapped as a text-column in the database.

Here’s an example of a model which uses HasTranslations-trait.

use Illuminate\Database\Eloquent\Model;
use Spatie\Translatable\HasTranslations;

class NewsItem extends Model
    use HasTranslations;

    public $translatable = ['name'];

Once that’s done you can do this to work with translations:

$newsItem = new NewsItem; // This is an Eloquent model
   ->setTranslation('name', 'en', 'Name in English');
   ->setTranslation('name', 'nl', 'Naam in het Nederlands');

$newsItem->name; // Returns 'Name in English' given that the current app locale is 'en'
$newsItem->getTranslation('name', 'nl'); // returns 'Naam in het Nederlands'


$newsItem->name; // Returns 'Naam in het Nederlands'

As announced in Mohamed’s post Laravel 5.2.23 gained fluent syntax to query json columns. If you use MySQL >= 5.7 and Laravel 5.2.23 you can do this:

NewsItem::where('name->en', 'Name in English')->get();

Awesome right?

Take a look at the package on GitHub to learn all available methods. If you like the package, take a look at the other ones we’ve previously made.

Freek Van der Herten is a partner and developer at Spatie, an Antwerp based company that specializes in creating web apps with Laravel. After hours he writes about modern PHP and Laravel on this blog. When not coding he’s probably rehearsing with his kraut rock band. He loves waffles and butterflies.
  • Bruno Seixas

    Great work, thanks for sharing =)

  • I was looking for it like a few weeks. I saw smiliar package but cannot find it again. But that’s save my life 🙂 Thank you.

  • I am doing it this way without packages:

    public function getTitleAttribute() {

    return ($this->{'title_'.config('app.locale')} ? $this->{'title_'.config('app.locale')} : $this->{'title_'.config('app.default_locale')});


    in migrations:

    foreach(config('app.locales') as $locale){

    app.locales is a array of available locales

  • Mastergalen

    Kind of lazy and confusing to give it the exact same name as dimsav’s package.

  • lnguyen55

    Can it be used without Laravel?

  • Mohamad Sh

    Is it scalable ! .. i wonder how much data it can hold without DB