Insert data to table Laravel?

Question

I use the following code to inser data in table:

$order = new OrderProduct();
        $order->save([
            "created_at" => Carbon::now(),
            "user_id" => $user->id,
            "note" => $request->note
        ]);

Model OrderProduct is:

class OrderProduct extends Model
{

    public $timestamps = true;

    protected $table = "class OrderProduct extends Model

{

public $timestamps = true;

protected $table = "order_product";

protected $fillable = [
    'order_id', 'status', 'user_id', 'note'
];";

    protected $fillable = [
        'order_id', 'status', 'user_id', 'note'
    ];
}

Why I always get user_id is equal 0 in table order_product?

I tried also replace $user->id to real value :

$order->save([
                "created_at" => Carbon::now(),
                "user_id" => 2,
                "note" => $request->note
            ]);

But again get zero value in this field.

Type of user_id is:

| user_id    | int(11)      | NO   |     | NULL

What happens if you use insert a record with pure SQL query? — Koray Küpe
– Koray Küpe, Commented Dec 18, 2016 at 0:04

Scott · Accepted Answer · 2016-12-18 00:30:45Z

1

Try adding it this way:

$order = new OrderProduct();
$order->user_id = 2;
$order->note = $noteHere;
$order->save():

By default Laravel adds the timestamp to the created_at and updated_at columns.

Let me know if that works.

answered Dec 18, 2016 at 0:30

Scott

8677 silver badges12 bronze badges

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

1 Comment

Scott Over a year ago

Perfect! Happy to help.

darshan · Accepted Answer · 2017-10-21 07:29:41Z

0

controller.php

      $name  = $request->name;
     $email  = $request->email;
        $data = array(
            "name" =>  $name,
            "email"=>  $email
            );

        $q = DB::table('users')->insert($data);

edited Oct 21, 2017 at 7:29

answered Oct 21, 2017 at 7:21

darshan

3733 silver badges13 bronze badges

Collectives™ on Stack Overflow

Insert data to table Laravel?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related