×
Clear all filters including search bar
Valeri Tandilashvili's Personal Professional Blog
Results: 1024
model pagination
In controller we have to use 
paginate
method
public function index()
{
    $posts = Post::orderBy('title', 'asc')->paginate(1);
    return $posts;
}
In blade template we will have pagination
{{$posts->links()}}
if there are less records then per page, pagination will not appear
DB::select 
public function index()
{
    $posts = DB::select('SELECT * FROM posts');
    return view('posts.index')->with('posts', $posts);
}
If we want to use the above query, we have to bring in the 
DB
class
use DB;
Model::where
Filters result using the 
where
method
public function index()
{
    $posts = Post::where('title', 'pst')->get();
    return view('posts.index')->with('posts', $posts);
}
Model::orderBy
Lists all records of the model ordered by 
title
descending
$posts = Post::orderBy('title', 'asc')->get();
return view('posts.index')->with('posts', $posts);
Model::all
Lists all records of the model
$posts = Post::All();
return view('posts.index')->with('posts', $posts);
set timestamps to true or false
Sets timestamps to false (default is 
true
)
class Post extends Model
{
    // Timestamps
    public $timestamps = false;
}
set primary key for model
Sets primary key for the model (default is 
id
)
class Post extends Model
{
    // Primary key
    public $primaryKey = 'record_id';
}
set table name for model
Sets table name for the model (default is lowercase plural form, in this case 
posts
)
class Post extends Model
{
    // Table Name
    protected $table = 't_posts';
}
tinker eloquent syntax
Shows count of posts
echo App\Post::count();
Creates new post in 
posts
table using tinker from terminal
$post = new App\Post();
$post->title = 'the post title';
$post->content = 'the post body';
$post->save();
Deletes the newly created post
$post->delete();
php artisan tinker
Activates database eloquent mode in terminal
php artisan tinker
Results: 1024