Query returns an object instead of Array

Question

I have written a model function which has to give me all the posts with user's id, but it returns a model object instead. My model:

public static function my_posts(){

    $userId = Auth::id();
    $getPosts = DB::table('posts')->where('user_id',$userId)->get();
    return $getPosts;
}

My Controller function:

public function myPosts(){
        $getPosts = new posts_model();
        $getPosts->my_posts();
        return view("myposts",["posts" => $getPosts]);
    }

How can I fix this error?

This is what I get when I do a dd($posts) in my view: posts_model {#239 ▼ #table: "posts" #primaryKey: "id" +incrementing: true #connection: null #keyType: "int" #with: [] #withCount: [] #perPage: 15 +exists: false +wasRecentlyCreated: false #attributes: [] #original: [] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #hidden: [] #visible: [] #fillable: [] #guarded: array:1 [▶] } — Grigory Volkov
– Grigory Volkov, Commented Jun 19, 2019 at 13:05

Kiran Kanzar · Accepted Answer · 2019-06-19 13:12:04Z

1

Can you please change Model

public static function my_posts(){
    $userId = Auth::id();
    $getPosts = Post::where('user_id',$userId)->get();
    return $getPosts;
}

Then Change Your controller

public function myPosts(){
    $getPosts = new posts_model();
    $data = $getPosts->my_posts();
    return view("myposts", ["posts" => $data]);
}

answered Jun 19, 2019 at 13:12

Kiran Kanzar

3291 gold badge5 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Query returns an object instead of Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related