SQL raw query in laravel query builder

Question

I have a working SQL query.

SELECT stuid,grade,SUM(full_amount) FROM due_payments group by stuid having SUM(full_amount) !=15600

This is working fine in MySQL workbench and phpmyadmin,But i cant seems to get this work in Laravel 5.3

I tried this on Laravel app with no Luck

$someVariable = Input::get(15600);

$results = DB::select( DB::raw("SELECT stuid,grade,SUM(full_amount) FROM due_payments 
                group by stuid having SUM(full_amount) =:somevariable)", array(
        'somevariable' => $someVariable,
)));

Can someone Help me with this.Thank You.

TalESid · Accepted Answer · 2018-01-16 07:14:54Z

1

First if all Input::get() doesn't take value as argument but the element name
$someVariable = Input::get(15600);
You can just use $someVariable = 15600;

Then use Query Builder rather than Raw SQL query

     $results = DB::table('due_payments')
     ->select(array('stuid', 'grade', DB::raw('SUM(full_amount)'))) 
     ->groupBy('stuid')
     ->havingRaw('SUM(full_amount) != '.$someVariable)
     ->get();

edited Jan 16, 2018 at 7:14

answered Jan 16, 2018 at 7:07

TalESid

2,5541 gold badge25 silver badges47 bronze badges

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

Comments

Sohel0415 · Accepted Answer · 2018-01-16 07:01:10Z

1

Use query builder.

$results = DB::table('due_payments')
        ->select('stuid', 'grade',DB::raw('SUM(full_amount)'))
        ->groupBy('stuid')
        ->havingRaw('SUM(full_amount) != 15600')
        ->get();

answered Jan 16, 2018 at 7:01

Sohel0415

9,89124 silver badges32 bronze badges

1 Comment

Sohel0415 Over a year ago

glad it helps :)

Collectives™ on Stack Overflow

SQL raw query in laravel query builder

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related