Laravel Enum

enum is natively supported. In your migration, just add the column thusly:

  // ...
  
  // Enum schema format:
  // $table->enum($column_name, $allowed_values);
  $table->enum('fruit', ['apple', 'banana', 'cantalope']);

  // ...

You will probably want to add your own validation to prevent creating records will null values which would happen if you passed a non-allowed value to the enum column, but otherwise it already exists and works.

If you don't write that validation, then you'll end up with something like this, even though the field is set to disallow null values:

>>> App\Foobar::create(['fruit' => 'apple']);
=> App\Foobar {#640
     fruit: "apple",
     updated_at: "2016-03-11 18:27:12",
     created_at: "2016-03-11 18:27:12",
     id: 1,
   }
>>> App\Foobar::create(['fruit' => 'banana']);
=> App\Foobar {#647
     fruit: "banana",
     updated_at: "2016-03-11 18:27:15",
     created_at: "2016-03-11 18:27:15",
     id: 2,
   }
>>> App\Foobar::create(['fruit' => 'pear']);
=> App\Foobar {#640
     fruit: "pear",
     updated_at: "2016-03-11 18:27:21",
     created_at: "2016-03-11 18:27:21",
     id: 3,
   }


>>> App\Foobar::all()
=> Illuminate\Database\Eloquent\Collection {#646
     all: [
       App\Foobar {#649
         id: 1,
         created_at: "2016-03-11 18:27:12",
         updated_at: "2016-03-11 18:27:12",
         fruit: "apple",
       },
       App\Foobar {#651
         id: 2,
         created_at: "2016-03-11 18:27:15",
         updated_at: "2016-03-11 18:27:15",
         fruit: "banana",
       },
       App\Foobar {#652
         id: 3,
         created_at: "2016-03-11 18:27:21",
         updated_at: "2016-03-11 18:27:21",
         fruit: "",
       },
     ],
   }

Note the empty fruit value for record 3.

Also note: sqlite does not support enum, so if you're using sqlite, a varchar field will be created.

sorry, not explained right , I need to create a class.

Example:

class CitiesEnum{

const PVH = "Porto Velho"; const VIL = "Vilhena";

}

I give a foreach to display these records

I see.. so in the database you want to store the three letter code, or whatever the constant names are, but on the frontend you want to display the actual constant values?

So, ENUM in the DB may or may not be necessary then, it would probably depend on whether or not your list of constants is going to grow, if it is I'd probably avoid the enum in the db.

Also, instead of constants this might be easier to handle with a private array. I'm just thinking about data moving the other way -- into the database rather than out of it. If this were handled with an array you can easily find the key with a particular value, or the value of a particular key. Not sure how easy it would be to determine the name of a constant with a particular value programatically.

But, for the sake of argument, lets say you're going to use constants. If those are defined in the relevant model, then you could define an accessor. Something like this, for example:

class Cities extends Model {

  const PVH = "Porto Velho";
  const VIL = "Vilhena";


  public function getCityAttribute($value) {
    if (defined(self::$value)) {
      return self::$value;
    }
  }
}

Then, when loading your models, city values stored in the DB as VIL should be in the result set as Vilhena and so forth.

Is that more along the lines of what your were looking for?

I avoid enum fields as all db don't support them an really don't help much, but to each his/her own.

You can either set another table and return that data, or hard code an array a return it. Very similar to countries list with abbreviation => full name

Anyone know how to get value of and Enum column in for instance MySQL and display it in HTML combobox?

http://stackoverflow.com/questions/2350052/how-can-i-get-enum-possible-values-in-a-mysql-database

Never tried but may work

mnm

@bensampo @NetoPVH I prefer the interface approach instead of an abstract class since you can extend only one class but you can implement whatever interface you require. so as all the models already extend the Eloquent Model class, I used to create an interface with all my enum constants and implementing that from my main Model class. So to speak, I have

Class ContractModel extends Model implements EnumContract
{
    ....
}

Class Post extends ContractModel
{
    public function foo()
    {
        return self::enumXXX;
    }
}