Get user specific information from database using Laravel and AngularJS

Question

I am developing an application using Laravel and AngularJS.

My problem is that I want to get all information from a table for a certain user.

In the routes.php file I have declared a group so that I can reach all comments by going to:

localhost/project/public/api/comments.

I also want to be able to get all comments by a given user by going to:

localhost/project/public/api/comment/id.

Route::group(array('prefix' => 'api'), function() {
    Route::resource('comments', 'CommentController', array('only' => array('index', 'store', 'destroy')));
    Route::get('comment/{id}', function($id) {
       $col = 'user_id';
       return Comments::where($col, '=', $id);
    });
}

When using this code I get the error:

ErrorException
    Object of class Illuminate\Database\Eloquent\Builder could not be converted to string

I can receive the first result by adding:

return Comment::where($col, '=', $id)->first();

But I want to receive all comments for the given user. How can this be done.

Did you read the docs? laravel.com/docs/eloquent#basic-usage (hint: ->get()) — Sergiu Paraschiv
– Sergiu Paraschiv, Commented May 23, 2014 at 9:37
I think I missed that part. Thank you, I will read the documentation more thoroughly in the future. — Jonas Petersson
– Jonas Petersson, Commented May 23, 2014 at 9:52

Razor · Accepted Answer · 2014-05-23 09:38:48Z

3

You need to get a result

return Comments::where($col, '=', $id)->get();

But you should serialize it to JSON format (for example), so you should do:

$comments = Comments::where($col, '=', $id)->get();
return Response::json(array('success'=>true,'comments'=>$comments->toJson()));

answered May 23, 2014 at 9:38

Razor

9,8633 gold badges39 silver badges52 bronze badges

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

1 Comment

Jonas Petersson Over a year ago

Thank you! Almost disappointed I didn't figured out the answer by myself.

Damien Pirsy · Accepted Answer · 2014-05-23 09:36:52Z

1

The Router requires you to return a Response object, not a Collection, a Builder or anything else - since Laravel tries to convert the respons to a string (like it happens to Views), but while Responses have a _toString() method, other objects might not - hence your error.

You should return a View or another response (like JSON), maybe doing something like:

Route::get('comment/{id}', function($id) {
    $comments = Comments::where('user_id', '=', $id)->get();
    return View::make('myview')->with('comments', $comments);
});

answered May 23, 2014 at 9:36

Damien Pirsy

25.5k8 gold badges72 silver badges77 bronze badges

2 Comments

Sergiu Paraschiv Over a year ago

I think he most likely will need a JSON response: laravel.com/docs/responses#special-responses

Damien Pirsy Over a year ago

That would be better indeed

Collectives™ on Stack Overflow

Get user specific information from database using Laravel and AngularJS

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related