QueryException, ErrorException and PDOException in Connection.php

Question

I would like to ask if you can help me with the errors I am encountering with my newly installed Laravel 5.4. Here is my blade template

home.blade.php

@extends('layouts.app') @section('content') <div class="container">
<div class="row">                           
            {{ App\StudentHistory::select(['date', 'student_id', 'grade'])
            ->where('subject', 'English')
            ->groupBy('student_id')
            ->orderBy('date','desc')
            ->first()
            ->get()}}
    </div>@endsection

Let me know what else you guys need, I'll update as you ask

@Maerlyn, well I can actually do it from the controller. It's supposed to work both ways, right? Alex, you mean to say I can't have the two in the same syntax? — Rodney Zanoria
– Rodney Zanoria, Commented May 18, 2017 at 9:11

Sérgio Reis · Accepted Answer · 2017-05-18 09:14:15Z

2

You're doing xxx->first()->get() ...

You either call ->first() and get one object or do ->get() and get an array of objects

Reference https://laravel.com/docs/5.4/queries#retrieving-results

PS: I really can't see the advantages of doing those queries IN the view, that's missing the MVC objective of laravel.

edited May 18, 2017 at 9:14

answered May 18, 2017 at 9:11

Sérgio Reis

2,5232 gold badges22 silver badges32 bronze badges

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

1 Comment

Rodney Zanoria Over a year ago

it's actually saying this in the PDOException "Expression #1 of SELECT list is not in GROUP BY clause"...Does that relate?

Sandeesh · Accepted Answer · 2017-05-18 09:19:41Z

1

You're trying to run a db query in your view, which is better suited in your controller.
You can't use first() and get() together, use one.
You're trying to output the query result directly, which is an object, which would throw an error even if your query was successful.

answered May 18, 2017 at 9:19

Sandeesh

12k3 gold badges35 silver badges42 bronze badges

Collectives™ on Stack Overflow

QueryException, ErrorException and PDOException in Connection.php

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related