Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Laravel 5 Array with key save in model

Have array which have key & value. The keys name are same database columns name.

Total of keys in an index is greater than 50.

  • So,not possible to save data one by one key like

    $user = new User;
    
    $user->name = 'John';
    ..........
    .......
    .......so on
    
    $user->save();
    

Sample array:

Array
(
    [name] => 'Amit',
    [age] => 25,
    [field1] => 'val1',
    ....
  [field33] => 'how'    ,
....
   [field54] => 'sumit'     
)

Now, my question is that how can i save data in an model using easiest process.

Info:

  • Using laravel 5

Try:

$Plan=new Plans;
 $Plan->fill( $array);
 $Plan->save();

Note: I know that fill not working as it not defined at fillable variable of that model

like image 963
Amit Bera Avatar asked Dec 22 '15 08:12

Amit Bera


2 Answers

The Eloquent model has encapsulated the attributes of the object. So you can only alter/set them through the set ($model->attribute) or the fill(array $attributes) method. All the Eloquent methods that mass assign the attributes is using the method fill().

So there are 2 ways to insert new Eloquent based models with an array in the database, one that uses the fill() method and one that doens't.

Method 1: Mass assignment

Add the attribute protected $fillable = [ 'column_a', 'column_b', .. ]; to your model. Then you can use the mass assignment like this.

$Plan = new Plans;
$Plan->fill( $array );
$Plan->save();

Or you can use:

$plan = Plans::create( $array );

Method 2: QueryBuilder::insert( array )

If you don't have any boot methods registered on creating and created (DB won't trigger these) then you also can use the QueryBuilder to insert the rows in the database.

// insert one plan
DB::table('plans')->insert([ $array ]);
$plan = Plans::find( DB::getPdo()->lastInsertId() );

// insert multiple plans in one query
$plans = [ $plan_a_arr, $plan_b_arr, .. ];
DB::table('plans')->insert( $plans );
like image 186
Sven van Zoelen Avatar answered Oct 09 '22 00:10

Sven van Zoelen


I don't understand why you don't want to define the database columns/array keys in $fillable attribute of your model, as it is a just a one-time task and then you would be able to do this simply:

$plan = Plans::create( $array );

Another way, if you have all the data in an associative array with keys matching to the columns in DB table, which you do, is to use a foreach loop:

$plan = new Plans;
foreach( $array as $key => $value )
{
    $plan->$key = $value;
}
$plan->save();
like image 41
Vikas Avatar answered Oct 09 '22 01:10

Vikas