Laravel, insert multiple rows without using foreach

Question

$input['activities'] = array(3,2,5);

foreach($input['activities'] as $activity_id){

    $user_activities = new User_activities;

    $user_activities->activity_id = $activity_id;

    $user_activities->user_id = Auth::id();

    $user_activities->save();

}

Is it possible to have a single line of script to do the above save for each statement in Laravel ? Instead doing the save in foreach, is it possible to do it in a single line?

if you're happy with my answer below, you can accept it :)

Limon Monte
– Limon Monte

2015-04-18 13:45:44 +00:00
Commented Apr 18, 2015 at 13:45 — Limon Monte
– Limon Monte, Commented Apr 18, 2015 at 13:45

Limon Monte · Accepted Answer · 2015-04-13 11:25:08Z

5

Just pass array of arrays to Eloquent::insert():

$data = [];

foreach($input['activities'] as $activity_id) {
    $data[] = [
        'activity_id' => $activity_id,
        'user_id' => Auth::id()
    ];
}

Coder::insert($data);

answered Apr 13, 2015 at 11:25

Limon Monte

54.8k49 gold badges191 silver badges222 bronze badges

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

2 Comments

Monang Shah Over a year ago

Insert won't add created_at and updated_at time. That's need to be added manual. :)

Rajesh Kumar Over a year ago

$input[activities] contains array of values which needs to be inserted without using the foreach in separate rows.

Rajesh Kumar · Accepted Answer · 2015-05-28 12:28:34Z

3

I have found the solution,

$activities = array(3,2,5);
$user->activities()->sync($activities);

User model will have the activities function like the following,

public function activities()
{
    return $this->belongsToMany('App\Activity', 'user_activities')->select(['activities.id'])->withTimestamps();
}

answered May 28, 2015 at 12:28

Rajesh Kumar

2472 gold badges6 silver badges22 bronze badges

Collectives™ on Stack Overflow

Laravel, insert multiple rows without using foreach

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related