Laravel - add row foreach date between dates

Question

Here I have code that store my $auction into auction database:

public function store(Requests\OfferRequest $request)
    {

            $auction= new Auction($request->all());

            Auth::user()->auctions()->save($auction);
}

Now I from request get $from and $to fields:

$auction->from //return me start date for auction
$auction->to // return me end date for auction

Now I want to store into maxoffers database - rows, foreach date between 'from' and 'to' and this rows just to have auction_id = $auction->id; and price = $auction->price ... other fields to be empty...

How I can do that? So how to make foreach date between from and to and store id of auction and price from request...

Can I see your database structure?

Siddharth
– Siddharth

2016-04-22 13:45:21 +00:00
Commented Apr 22, 2016 at 13:45 — Siddharth
– Siddharth, Commented Apr 22, 2016 at 13:45
i.imgur.com/PqEHQl2.png

Andrew
– Andrew

2016-04-22 14:10:00 +00:00
Commented Apr 22, 2016 at 14:10 — Andrew
– Andrew, Commented Apr 22, 2016 at 14:10
@Andrew did you try my answer ?

nextt1
– nextt1

2016-04-23 09:22:59 +00:00
Commented Apr 23, 2016 at 9:22 — nextt1
– nextt1, Commented Apr 23, 2016 at 9:22

nextt1 · Accepted Answer · 2016-04-22 16:43:15Z

2

It is quite simple.

$start_date = \Carbon\Carbon::parse($auction->from);
$end_date = \Carbon\Carbon::parse($auction->to);


    while(!$start_date->eq($end_date))
    {
        $temp = new maxoffers;
        $temp->id = $auction->id;
        $temp->price = $auction->price;

        //$temp->something_else = 'value';
        //If Your structure does not support null values then you must define some values here.

        $temp->save()

        $start_date->addDay();
    }

answered Apr 22, 2016 at 16:43

nextt1

4,0082 gold badges20 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Laravel - add row foreach date between dates

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related