Pagination + query results (not working as intended)

I think it's :

{!! $all['all']->links() !!}

But I cant see your controller...

@bestmomo Thanks for the reply. I tried what you wrote, didn't work.

I have nothing included in my controller, its just a basic plain controller. Here is the function for the blogposts though:

public function grabPosts()
    {
        $model = [];
        $model['all'] = Blogposts::getAllPosts();
        /*dd($model);*/
        return View::make('pages.posts', array('all' => $model));       
    }

Why do you set a key ? Simply do that :

public function grabPosts()
    {
        $all = Blogposts::getAllPosts();
        return view('pages.posts', compact('all');       
    }

And in your view :

@foreach ($all as $post)
...

And then :

{!! $all->links() !!}

should work...

@bestmomo Tried what you said, but now it throws a:

ErrorException (E_ERROR) HELP Undefined variable: all (View: C:\xampp\htdocs\laravel\app\views\pages\posts.blade.php)

Controller

public function grabPosts()
    {
        /*$model = [];
        $model['all'] = Blogposts::getAllPosts();
        dd($model);*/
        $all = Blogposts::getAllPosts();
        return View::make('pages.posts', compact($all));        
    }

View

@extends('app')

@section('content')

<h1>All Posts</h1>

@foreach ($all as $post)
        <table class="table">
            <tr>
                <td>
                <tr><th><h2><kbd><font color='lime'>{{ $post->postname }}</font></kbd></h2>
                <kbd><font color='cyan'>{{ $post->postdate }}</font></kbd>
                <kbd><font color='red'>{{ $post->catname }}</font></kbd></th></tr>
                <tr><td><blockquote><font color='gray'>{{ mb_substr($post->postdesc, 0,120,'UTF-8') }}</font>
                <a href="{{ URL::to('/posts/').'/'.$post->postid }}">read more</a></blockquote>
                </td>
            </tr>
        </table>
    @endforeach
                {!! $post->links() !!}
@stop

1>

 return view('pages.posts', compact('all');       // notice 'all' and not $all;

2> Have you checked if query indeed has 15 elements

$data = DB::table('blogposts')
        ->select('*')
        ->join('blogcategories', 'blogposts.postid', '=', 'blogcategories.id')->get();
     
dd($data);

@premsaurav Oh, didn't see that. Thanks!

Ok, so it works like @bestmomo said, but pagination and query still don't work.

Yes I'm sure. I can send you a screenshot of the database if you want, since its a dummy base I use for learning stuff. I also tested with the dd thing - it returned a huge text. But it only picked items from the database to the 4th item. So I guess it only picked the first 4 items and then it stops.

Yes please share the screenshot, as far as i can tell, this has nothing to do with paginate then, but may be the join you are performing .

@premsaurav Okay, here you go. And I made a mistake, apparently I deleted some of the items in database it now has 10 items instead of 15. Still, its more than the 5 I've put into paginate so it should still work.

Link http://postimg.org/image/r5c9lmzpz/

http://postimg.org/image/3se834jmf/

Direct link http://s7.postimg.org/pdjaqqgd7/blogcategories_db_ss.jpg

http://s7.postimg.org/a63b6doij/blogposts_db_ss.jpg

Thumbnails [url=http://postimg.org/image/r5c9lmzpz/][img]http://s7.postimg.org/r5c9lmzpz/blogcategories_db_ss.jpg[/img][/url]

[url=http://postimg.org/image/3se834jmf/][img]http://s7.postimg.org/3se834jmf/blogposts_db_ss.jpg[/img][/url]

yes , as expected its the join that's wrong

$data = DB::table('blogposts')
        ->select('*')
        ->join('blogcategories', 'blogposts.postcatid', '=', 'blogcategories.id')
        ->paginate(5);

@premsaurav Now I just feel silly for wasting people's time. I'm still grateful for the help though.

Query works, but pagination still doesn't work.

@Dracool What do you mean by pagination still doesn't work ? What is that you are expecting and what is that you are getting ?

@premsaurav The query works now, but pagination doesn't. I asked when I opened the thread should I include something somewhere that deals with pagination because I have nothing included in any of the mvc components.

Pagination doesn't put links at the bottom, it just writes the raw code. I tried with {!! $all->render() !!}, {!! $all->links() !!}, {!! $post->render() !!} and {!! $post->links() !!} but none of those work, laravel just puts that code at the end of the page.

@Dracool Can't debug further unless I see your complete M V and C for this problem.

@premsaurav You want only the mvc or the entire laravel folder? I don't know if I can even attach something here.

If its shared on github, even better. However, just need the files(code) related to this problem. You can paste them here as well.

any chance you have blogposts as a model

then you can do something like this assuming you have one category per blog post otherwise the relationship would be a little different part of App\Blogpost.php

class BlogPost extends Model
{
    protected $table = 'blogposts';

 protected $fillable = ['all', 'columns', 'filled_in', 'by_form'];

   public function category()
   {
        return $this->belongsTo(App\BlogCategory::class);
   }

}

App\BlogCategory.php

    public function posts()
    {
        return $this->hasMany(App\Blogpost::class');
    }

then in the controller it would be

$all = App\BlogPost::with(['category'])->paginate(5);

bit of a refactor but if you can avoid writing joins like that all the better so in the view just reference pages/posts.blade.php

@foreach($all as $post)
    <table class="table">
            <tr>
                <td>
                <tr><th><h2><kbd><font color='lime'>{{ $post->postname }}</font></kbd></h2>
                <kbd><font color='cyan'>{{ $post->postdate }}</font></kbd>
                <kbd><font color='red'>{{ $post->category() }}</font></kbd></th></tr>
                <tr><td><blockquote><font color='gray'>{{ mb_substr($post->postdesc, 0,120,'UTF-8') }}</font>
                <a href="{{ URL::to('/posts/').'/'.$post->postid }}">read more</a></blockquote>
                </td>
            </tr>
        </table>
@endforeach 
{{!! $all->render() !!}