Eloquent multiple rows insert and in one array loop

Question

I have user input following the rules below;

public function rules()
    {
        return [
            'phone_number' => 'required|array',
            'amount' => 'required|string|max:4',
            'phone_number_debit' => 'required|string|max:15',
        ];
    }

I would want to save the data in a model Transaction. For the phone_number it is an array that could have one value or multiple. So that leaves for foreach loop.

This is what I want to achieve, save different rows determined by the number of records in the array.

$transaction = new Trasaction();
$transaction->phone_number = $req->phone_number; //Value in the array
$transaction->amount = $req->amount;
$transaction->phone_number_debit = $req->phone_number_debit;
$transaction->save();

Save diffrent records according to the records in the phone_number array.

However I can not think of a way to achieve this.

Anyone?

@IanRodrigues how do I achieve this? The array is in the same request as others. — Bob Mwenda
– Bob Mwenda, Commented Aug 24, 2017 at 17:50
Why not create a child table? One Transaction would have many phone numbers. It would make it easier to manage. — aynber
– aynber, Commented Aug 24, 2017 at 17:55

yoeunes · Accepted Answer · 2017-08-24 18:05:07Z

2

try this :

$data = request(['amount', 'phone_number', 'phone_number_debit']);

foreach($data['phone_number'] as $phone_number) {
    Trasaction::create([
       'amount' => $data['amout'],
       'phone_number' => $phone_number,
       'phone_number_debit' => $data['phone_number_debit']
    ]);
}

make sure in your Trasaction modal you've set to fillable property like this :

class Trasaction extends Model 
{
    protected $fillable = ['amount', 'phone_number', 'phone_number_debit'];
}

answered Aug 24, 2017 at 18:05

yoeunes

2,9452 gold badges17 silver badges29 bronze badges

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

Comments

Ian Rodrigues · Accepted Answer · 2017-08-24 18:07:50Z

There are many ways to do this, in a nutshell:

collect(request('phone_number'))->each(function ($phone) use ($req) {
    $transaction = new Trasaction();
    $transaction->phone_number = $phone; // element of the array
    $transaction->amount = $req->amount;
    $transaction->phone_number_debit = $req->phone_number_debit;
    $transaction->save();
});

TL;DR

One-to-Many Relationship

In order to get a better code, you can create a transaction_phones table, creating a one-to-many relationship.

You'll create a TransactionPhone model and add this:

public function transaction()
{
    return $this->belongsTo(Transaction::class);
}

The TransactionPhone migration:

Schema::create('transaction_phones', function (Blueprint $table) {
    $table->increments('id');
    $table->integer('transaction_id');
    $table->string('phone_number');
    $table->timestamps();
});

In your Transaction model you'll have the inverse:

public function phones()
{
    return $this->hasMany(TransactionPhone::class);
}

public function addPhone($phone)
{
    return $this->phones()->create(['phone_number' => $phone]);
}

And in you Controller:

$transaction = Trasaction::create(request()->only('amount', 'phone_number_debit'));

collect(request('phone_number'))->each(function ($phone) use ($transaction) {
    $transaction->addPhone($phone);
});

I hope this answer can help you.

Collectives™ on Stack Overflow

Eloquent multiple rows insert and in one array loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related