Laravel DB query with count

Question

I have a query where i need to use count and have a normal query.

Normal

select sum(total) as Total,AffID,user_id from Affiliates 
group by AffID order by user_id ASC

And Then

foreach($result_array as $row) 
{ 
    echo $row['total']."<br/>"; 
    echo $row['AffID']."<br/>"; 
    echo $row['user_id ']."<br/>"; 
}

In Laravel i have tried

$affdata = DB::select('Affiliates')
         ->whereRaw('CompletedDate >= curdate()')
         ->groupBy('AffID')
         ->orderBy('user_id', 'ASC')
         ->sum('total');
         ->get();
foreach($affdata as $row) 
{
   echo $row->AffID ."<br>";
   echo $row->total ."<br>";
}

But it seems to throw out an error. As i need to echo out the AFFID along with calculating the Total

Oluwafemi Sule · Accepted Answer · 2016-06-14 10:24:54Z

1

Update your query to this.

$affdata = DB::table('Affiliates')->select(DB::raw('sum(total) as total'), 'AffID', 'user_id'))
            ->whereRaw('CompletedDate >= curdate()')
            ->groupBy('AffID')
            ->orderBy('user_id', 'ASC')
            ->sum('total');
            ->get();

answered Jun 14, 2016 at 10:24

Oluwafemi Sule

39.3k1 gold badge63 silver badges88 bronze badges

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

Comments

xTRIFAC70Rx · Accepted Answer · 2016-06-14 10:41:52Z

0

This is the correct query

$affdata = DB::table('Affiliates')->select(DB::raw('sum(total) as total'), 'AffID', 'user_id')
            ->whereRaw('CompletedDate >= curdate()')
            ->groupBy('AffID')
            ->orderBy('user_id', 'ASC')
            ->get();

answered Jun 14, 2016 at 10:41

xTRIFAC70Rx

4072 gold badges5 silver badges17 bronze badges

Collectives™ on Stack Overflow

Laravel DB query with count

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