如何在laravel 5.2中保存多个请求参数？

Question

I am just learning laravel now. And I have this problem. I have passed 2 request parameters to my controller function. First request parameter holds an object value, but I converted it to a serialized form since the field of my table where it will be saved has a text datatype. The second request parameter holds a overall_total calculated value and it has a float datatype field. My problem is, how would I store it in my database? I have tried to use the create function but it returns an error. Some forums regarding this are not so clear. I just can't figure it out yet. Can somebody help me with this? Here are my codes.

function store

public function store(Request $request){

       $serialize_po = serialize($request['purchase_orders']);
       $overall_total = $request['overall_total'];
       $purchase_orders_save = PurchaseOrder::create(?);

}

How would I save 2 parameters using create? or is there other way I can saved it?

Inside of $request['purchase_orders'] is shown in the image below

Inside of $request['overall_total'] is just a number. E.g. 310

My Database Table Structure is shown below

Answer 1

The create() function in Laravel accepts an associative array, where the array keys are the names of the columns, and the array values are the corresponding values for the columns.

So your store function might look something like this:

public function store(Request $request){
    $serialize_po = serialize($request['purchase_orders']);
    $overall_total = $request['overall_total'];
    $purchase_orders_save = PurchaseOrder::create([
        'purchase_orders' => $serialize_po,
        'overall_total' => $overall_total
    ]);
}

One other thing to note is that as a safety precaution, Laravel does not allow the properties of a model to be filled in this fashion out of the box. You will need to list in your model using the $fillable property which keys you will allow to be filled by passing in an associative array. If you don't, you'll likely get a MassAssignmentException.

So in your model, you will likely need to have at least the following:

class PurchaseOrder extends Model
{
    protected $fillable = ['purchase_orders', 'overall_total'];
}

There are more options and ways to do this, but that is the basic and typical scenario.

More info on using the create() method and handling mass assignment is available in the documentation: https://laravel.com/docs/5.2/eloquent#mass-assignment