Laravel JSON Response with Eloquent

Question

I got three tables called threads,posts,users

threads got

id
title
etc.

posts got

id
thread_id
user_id
post
post_date
etc.

users got

id
username 
password
email
etc.

when users wants to view a thread i simply call a jquery ajax request using post data to send thread id and return this code :

Response::eloquent(Thread::find(Input::get('threadid'))->posts()->get());

this code does his job perfectly and return posts by same thread_id. (post model also eager loads the user by looking user_id).

however this code grabs every attribute of posts and users i mean everything to json, post_date, post_updatereason, user_password, user_email all columns in tables.

I just want to grab post, username and post_date with json

Bartek · Accepted Answer · 2013-01-19 13:13:03Z

4

You can add public static $hidden = array('list', 'of', 'fields'); to your model which extends Eloquent. Then none of the fields which you enumarate in the array will be returned. For more information refer to the documentation.

For example

class User extends Eloquent {
  public static $hidden = array('password', 'email');
}

will return the user model without the password and email.

answered Jan 19, 2013 at 13:13

Bartek

1,0596 silver badges18 bronze badges

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

Comments

Blessing · Accepted Answer · 2013-01-19 07:49:37Z

1

If you are using laravel 3, and this is probably the same for version 4, you should be able to specific the columns you want using the get method.

Response::eloquent(Thread::find(Input::get('threadid'))->posts()->get(['username','post_date']));

answered Jan 19, 2013 at 7:49

Blessing

4,8881 gold badge20 silver badges13 bronze badges

1 Comment

T. Cem Yılmaz Over a year ago

I did that actualy but if I not grab user_id model can't find the author(which eager loads in Post::with('author')). If i put user_id in get() json will show the user_id

Collectives™ on Stack Overflow

Laravel JSON Response with Eloquent

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