Database data is not an array or object

Question

I want to print '$post' as an array from database.

<tbody>
            @if (is_array($posts) || is_object($posts)){
                @foreach ($posts as $post)
                <tr>
                    <th>{{$post->id }}</th>
                    <td>{{$post->title }}</td>
                    <td>{{$post->body }}</td>
                    <td>{{$post->created_at }}</td>
                    <td><a href="#" class="btn btn-default">View</a><a href="#" class="btn btn-default">Edit</a></td>
                </tr>
                @endforeach

            @else
                {{'no!'}}
            @endif
            </tbody>

it just prints no! this is the main function:

    public function index()
{
    $posts = Post::all();

    return view('posts.index')->withPosts('$posts');
}

why can't you check like this i.e.. $posts = Post::all()->toArray(); — DPS
– DPS, Commented Apr 5, 2018 at 8:16
@DPS I checked it did not work, the solution was : public function index() { $posts = Post::all(); return view('posts.index',compact('posts')); } — Pali
– Pali, Commented Apr 5, 2018 at 8:23

AddWeb Solution Pvt Ltd · Accepted Answer · 2018-04-05 08:17:14Z

3

You should below way to pass the data from view file.

public function index()
{
    $posts = Post::all();

    return view('posts.index',compact('posts'));

}

answered Apr 5, 2018 at 8:17

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

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

2 Comments

Pali Over a year ago

IT WORKED! Thank you

AddWeb Solution Pvt Ltd Over a year ago

@Pali Glad to help you. Feel free to accept this as answer if our solution addressed your concern.

Kuldeep Mishra · Accepted Answer · 2018-04-05 09:39:19Z

0

You can use get method , get will return all of the results in the model's table. After that you can pass the result to your view.

public function index(){
$posts = Post::get();

return view('posts.index',compact('posts'));

}

edited Apr 5, 2018 at 9:39

answered Apr 5, 2018 at 9:11

Kuldeep Mishra

4,0601 gold badge24 silver badges26 bronze badges

1 Comment

Toby Speight Over a year ago

Thank you for this code snippet, which might provide some limited short-term help. A proper explanation would greatly improve its long-term value by showing why this is a good solution to the problem, and would make it more useful to future readers with other, similar questions. Please edit your answer to add some explanation, including the assumptions you've made.

Collectives™ on Stack Overflow

Database data is not an array or object

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related