Create Project: composer create-project –prefer-dist laravel/laravel laravalstartup Controller Create: php artisan make:controller HomepageController Model Create: php artisan make:model Student. Migration Create: php artisan make:migration create_post_table –create=posts Migrate Tables: php artisan migrate Last 5 Migrate Tables: php artisan migrate:refresh –step=5 Database table drop & recreate: php artisan migrate:refresh Clear view cache: php artisan view:clear (12) 000

Custom Query with pagination: Controller:       public function blogs_list() { $title=”List of blog post”; $data = $this->paginateArray( DB::select(“SELECT blogs.id, blogs.title, blogs.description, blogs.created_at, categories.id, categories.category_name FROM (categories categories INNER JOIN post_category_map post_category_map ON (categories.id = post_category_map.category_id)) RIGHT OUTER JOIN blogs blogs ON (blogs.id = post_category_map.post_id) WHERE (categories.id = 1)”)); return view(‘crud.blog_list’)->with(‘title’,$title)->with(‘blogposts’,$data); } public function paginateArray($data, $perPage = […]