Loop through array and MySQL query for each element - Laravel

Question

I have a table with a list of websites. Also I have a table with information about visits and conversions. In this table I have one row per website per day with columns visits and conversions. So I know which website had how many visits and conversions every day.

Now, I want to list all websites in a table with the sum of visits and conversions on this website over the last 30 days.

So what I do is I load all websites into an array with:

$websites = Website::all();

And then I loop through this array to get the additional data:

$complete_list = array();

foreach ($websites as $website) {

    $clicks = Stats::where(DATE INSIDE DATE RANGE)->where('website_id', '=', $website->id)->sum('visits');
    $complete_list[] = array(
       'website' => $website->id,
       'click'=> $clicks
    }; 
}

Same thing for conversions.

This works but does not seem the best way to do this...

Does anyone have an idea on how to simplify?

Omer M. · Accepted Answer · 2014-10-13 20:06:38Z

1

Have you thought about using Eager Loading? http://laravel.com/docs/4.2/eloquent#eager-loading

answered Oct 13, 2014 at 20:06

Omer M.

6307 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Loop through array and MySQL query for each element - Laravel

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