Laravel Eloquent Model将所有值都插入为NULL

Question

I have run into problems with Laravel Eloquent Model

I have a model as follow:

class Activity extends Eloquent {
    protected $table = 'activity';

    protected $timestamps = false;

    public $item;

    public $content;

    public $year;

    protected $fillable = array('item', 'content', 'year');
}

And the corresponding controller:

class ActivityController extends \BaseController {
     public function create()
     {
         $activity = new Activity();

         $actitity->item = 'Example';
         $activity->content = 'Example content';
         $activity->year = 2015;

         $activity->save();
     }
}

The above code should work fine and there should be a record in 'activity' table. However, all the value of columns of activity table are inserted as NULL when I run this code (except for the id column which is auto_increment).

In addition, when I var_dump the $activity (just before calling $activity->save()), the $activity with all of its properties are shown as expected (I mean, with values I've assigned before)

Is there any subtle error in my code?

Answer 1

You must not define database fields as actual class properties. The problem is that Laravel uses an $attributes array internally, not the models properties.

When doing

$activity->content = 'Example content';

Laravel uses the magic __set() method to update the value in it's $attributes array. But that setter method is never called because you have an actual property with that name.

What you need to do to resolve this problem is remove the properties:

class Activity extends Eloquent {
    protected $table = 'activity';

    protected $timestamps = false;

    protected $fillable = array('item', 'content', 'year');
}

If you want to document the properties and have autocomplete support you can use the @property annotation:

/**
 * @property string $item
 * @property string $content
 * @property int $year
 */
class Activity extends Eloquent {