Laravel not inserting in database

Question

I have some problem with laravel app. I'm trying to insert some info in database, and it works fine, untill I have addded a new row 'ip_address'. Ip address is defined as varchar(255) and everything is storing except address. What could be the problem? This is the code

public static function log(string $message, string $action, string $request)
    {
        return Log::create(['user_id' => Auth::id() , 'log_message' => $message, 'action' => $action, 'ip_address' => '212.91.176.38', 'log_type' => 'log', 'request' => $request]);
    }

did you add that field to the $fillable array on the model? since you are using mass assignment — lagbox
– lagbox, Commented Sep 15, 2020 at 11:24

N69S · Accepted Answer · 2020-09-15 14:38:24Z

2

To create an entry using laravel model, you have two choices:

Mass assignement using create(), in wich case you need to define wich fields are safe to mass assign.

public static function log(string $message, string $action, string $request)
{
    return Log::create(['user_id' => Auth::id() , 'log_message' => $message, 'action' => $action, 'ip_address' => '212.91.176.38', 'log_type' => 'log', 'request' => $request]);
}

// file Log.php
//...
Class Log extends Model
{
//...
    protected $fillable = ['user_id','log_message','action','ip_address','log_type', 'request'];
//...
}

OR

Create a new model instance

public static function log(string $message, string $action, string $request)
{
    $log = new Log();
    $log->user_id = Auth::id();
    $log->log_message = $message;
    $log->action = $action;
    $log->ip_address = '212.91.176.38';
    $log->log_type = 'log';
    $log->request = $request;
    $log->save();

    return $log;
}

edited Sep 15, 2020 at 14:38

answered Sep 15, 2020 at 11:46

N69S

17.3k4 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

lagbox Over a year ago

insert doesn't involve fillable since it is a query builder method

lagbox Over a year ago

when called on a model instance it involves fillable because update is fill(...)->save , if called on a builder, it is a direct update though

Ahmed Atoui · Accepted Answer · 2020-09-15 13:42:44Z

1

you should define fillable property on your model with all your fields :

 protected $fillable = ['user_id','log_message','action','ip_address','log_type'];

edited Sep 15, 2020 at 13:42

answered Sep 15, 2020 at 11:34

Ahmed Atoui

1,5661 gold badge10 silver badges11 bronze badges

1 Comment

Bennett Over a year ago

I think you added an extra = :)

Collectives™ on Stack Overflow

Laravel not inserting in database

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related