CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

16 January, 2023

Laravel 9 and Vue JS CRUD with Pagination begning to scratch

 Programing Coderfunda     January 16, 2023     Laravel, Vuejs     No comments   

 In Todays, Most well known JS Structure are Precise JS and Vue JS. Rakish JS and Vue JS are an exceptionally easy to understand JS Structure and generally well known. It gives to oversee entire task or application without invigorate page and strong jquery approval.


In this post I going to incline how to make CRUD(Create, Read, Update and Erase) application with pagination utilizing Laravel 5. In my past instructional exercise I added muck application utilizing Precise JS, if you need to see then click here:


In this example i added "Item Management" with you can do several option like as bellow:

1. Item Listing

2. Item Create

3. Item Edit

4. Item Delete

you can implement crud application from scratch, so no worry if you can implement through bellow simple step. After create successful example, you will find layout as bellow:

Preview:


Step 1: Laravel Installation

In first step, If you haven't installed Laravel in your system then you have to run bellow command and get fresh Laravel project.

composer create-project --prefer-dist laravel/laravel blog

Step 2: Create items table and model

In this step we have to create migration for items table using Laravel 5 php artisan command, so first fire bellow command:

php artisan make:migration create_items_table

After this command you will find one file in following path database/migrations and you have to put bellow code in your migration file for create items table.

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;


class CreateItemsTable extends Migration

{


public function up()

{

Schema::create('items', function (Blueprint $table) {

$table->increments('id');

$table->string('title');

$table->text('description');

$table->timestamps();

});

}


public function down()

{

Schema::drop("items");

}

}

After create "items" table you should create Item model for items, so first create file in this path app/Item.php and put bellow content in item.php file:

app/Item.php

namespace App;


use Illuminate\Database\Eloquent\Model;


class Item extends Model

{


public $fillable = ['title','description'];


}

Read Also: Laravel 9 and AngularJS CRUD with Search and Pagination Example.

Step 3: Add Route and Controller

Now we have to add route for items CRUD and pagination, in this example i added resource route and one for manage-vue for application, if we add resource route then it will add index, create, edit and delete route automatically. So add bellow line in your route file.

app/Http/routes.php

Route::get('manage-vue', 'VueItemController@manageVue');

Route::resource('vueitems','VueItemController');

Ok, now we should create new controller as VueItemController in this path app/Http/Controllers/VueItemController.php. this controller will manage all route method:

app/Http/Controllers/VueItemController.php

namespace App\Http\Controllers;


use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

use App\Item;


class VueItemController extends Controller

{


public function manageVue()

{

return view('manage-vue');

}


/**

* Display a listing of the resource.

*

* @return \Illuminate\Http\Response

*/

public function index(Request $request)

{

$items = Item::latest()->paginate(5);


$response = [

'pagination' => [

'total' => $items->total(),

'per_page' => $items->perPage(),

'current_page' => $items->currentPage(),

'last_page' => $items->lastPage(),

'from' => $items->firstItem(),

'to' => $items->lastItem()

],

'data' => $items

];


return response()->json($response);

}


/**

* Store a newly created resource in storage.

*

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

*/

public function store(Request $request)

{

$this->validate($request, [

'title' => 'required',

'description' => 'required',

]);


$create = Item::create($request->all());


return response()->json($create);

}


/**

* Update the specified resource in storage.

*

* @param \Illuminate\Http\Request $request

* @param int $id

* @return \Illuminate\Http\Response

*/

public function update(Request $request, $id)

{

$this->validate($request, [

'title' => 'required',

'description' => 'required',

]);


$edit = Item::find($id)->update($request->all());


return response()->json($edit);

}


/**

* Remove the specified resource from storage.

*

* @param int $id

* @return \Illuminate\Http\Response

*/

public function destroy($id)

{

Item::find($id)->delete();

return response()->json(['done']);

}

}

Step 4: Create Blade File

In this step we have to create only one blade file that will manage create, update and delete operation of items module with vue js.

In this file i added jquery, bootstrap js and css, vue.js, vue-resource.min.js, toastr js and css for notification in this blade file.

So, let's create manage-vue.blade.php file on following way:

resources/views/manage-vue.blade.php

<!DOCTYPE html>

<html>

<head>

<title>Laravel Vue JS Item CRUD</title>

<meta id="token" name="token" value="{{ csrf_token() }}">

<link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/css/bootstrap.css">

</head>

<body>


<div class="container" id="manage-vue">


<div class="row">

<div class="col-lg-12 margin-tb">

<div class="pull-left">

<h2>Laravel Vue JS Item CRUD</h2>

</div>

<div class="pull-right">

<button type="button" class="btn btn-success" data-toggle="modal" data-target="#create-item">

Create Item

</button>

</div>

</div>

</div>


<!-- Item Listing -->

<table class="table table-bordered">

<tr>

<th>Title</th>

<th>Description</th>

<th width="200px">Action</th>

</tr>

<tr v-for="item in items">

<td>@{{ item.title }}</td>

<td>@{{ item.description }}</td>

<td>

<button class="btn btn-primary" @click.prevent="editItem(item)">Edit</button>

<button class="btn btn-danger" @click.prevent="deleteItem(item)">Delete</button>

</td>

</tr>

</table>


<!-- Pagination -->

<nav>

<ul class="pagination">

<li v-if="pagination.current_page > 1">

<a href="#" aria-label="Previous"

@click.prevent="changePage(pagination.current_page - 1)">

<span aria-hidden="true">«</span>

</a>

</li>

<li v-for="page in pagesNumber"

v-bind:class="[ page == isActived ? 'active' : '']">

<a href="#"

@click.prevent="changePage(page)">@{{ page }}</a>

</li>

<li v-if="pagination.current_page < pagination.last_page">

<a href="#" aria-label="Next"

@click.prevent="changePage(pagination.current_page + 1)">

<span aria-hidden="true">»</span>

</a>

</li>

</ul>

</nav>


<!-- Create Item Modal -->

<div class="modal fade" id="create-item" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">

<div class="modal-dialog" role="document">

<div class="modal-content">

<div class="modal-header">

<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>

<h4 class="modal-title" id="myModalLabel">Create Item</h4>

</div>

<div class="modal-body">


<form method="POST" enctype="multipart/form-data" v-on:submit.prevent="createItem">


<div class="form-group">

<label for="title">Title:</label>

<input type="text" name="title" class="form-control" v-model="newItem.title" />

<span v-if="formErrors['title']" class="error text-danger">@{{ formErrors['title'] }}</span>

</div>


<div class="form-group">

<label for="title">Description:</label>

<textarea name="description" class="form-control" v-model="newItem.description"></textarea>

<span v-if="formErrors['description']" class="error text-danger">@{{ formErrors['description'] }}</span>

</div>


<div class="form-group">

<button type="submit" class="btn btn-success">Submit</button>

</div>


</form>


</div>

</div>

</div>

</div>


<!-- Edit Item Modal -->

<div class="modal fade" id="edit-item" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">

<div class="modal-dialog" role="document">

<div class="modal-content">

<div class="modal-header">

<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>

<h4 class="modal-title" id="myModalLabel">Edit Item</h4>

</div>

<div class="modal-body">


<form method="POST" enctype="multipart/form-data" v-on:submit.prevent="updateItem(fillItem.id)">


<div class="form-group">

<label for="title">Title:</label>

<input type="text" name="title" class="form-control" v-model="fillItem.title" />

<span v-if="formErrorsUpdate['title']" class="error text-danger">@{{ formErrorsUpdate['title'] }}</span>

</div>


<div class="form-group">

<label for="title">Description:</label>

<textarea name="description" class="form-control" v-model="fillItem.description"></textarea>

<span v-if="formErrorsUpdate['description']" class="error text-danger">@{{ formErrorsUpdate['description'] }}</span>

</div>


<div class="form-group">

<button type="submit" class="btn btn-success">Submit</button>

</div>


</form>


</div>

</div>

</div>

</div>


</div>


<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>

<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/js/bootstrap.min.js"></script>


<script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/js/toastr.min.js"></script>

<link href="//cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/css/toastr.min.css" rel="stylesheet">


<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/vue/1.0.26/vue.min.js"></script>

<script type="text/javascript" src="https://cdn.jsdelivr.net/vue.resource/0.9.3/vue-resource.min.js"></script>


<script type="text/javascript" src="/js/item.js"></script>


</body>

</html>

Step 5: Create JS File

In last step we require to create one item.js file, first we have to create new folder "js" in public directory and then create item.js file inside of this folder.

item.js file through we can manage item pagination, create edit delete task and also ajax method.

public/js/item.js

Read Also: Laravel 5.2 - User ACL Roles and Permissions with Middleware using entrust from Scratch Tutorial

Vue.http.headers.common['X-CSRF-TOKEN'] = $("#token").attr("value");


new Vue({


el: '#manage-vue',


data: {

items: [],

pagination: {

total: 0,

per_page: 2,

from: 1,

to: 0,

current_page: 1

},

offset: 4,

formErrors:{},

formErrorsUpdate:{},

newItem : {'title':'','description':''},

fillItem : {'title':'','description':'','id':''}

},


computed: {

isActived: function () {

return this.pagination.current_page;

},

pagesNumber: function () {

if (!this.pagination.to) {

return [];

}

var from = this.pagination.current_page - this.offset;

if (from < 1) {

from = 1;

}

var to = from + (this.offset * 2);

if (to >= this.pagination.last_page) {

to = this.pagination.last_page;

}

var pagesArray = [];

while (from <= to) {

pagesArray.push(from);

from++;

}

return pagesArray;

}

},


ready : function(){

this.getVueItems(this.pagination.current_page);

},


methods : {


getVueItems: function(page){

this.$http.get('/vueitems?page='+page).then((response) => {

this.$set('items', response.data.data.data);

this.$set('pagination', response.data.pagination);

});

},


createItem: function(){

var input = this.newItem;

this.$http.post('/vueitems',input).then((response) => {

this.changePage(this.pagination.current_page);

this.newItem = {'title':'','description':''};

$("#create-item").modal('hide');

toastr.success('Item Created Successfully.', 'Success Alert', {timeOut: 5000});

}, (response) => {

this.formErrors = response.data;

});

},


deleteItem: function(item){

this.$http.delete('/vueitems/'+item.id).then((response) => {

this.changePage(this.pagination.current_page);

toastr.success('Item Deleted Successfully.', 'Success Alert', {timeOut: 5000});

});

},


editItem: function(item){

this.fillItem.title = item.title;

this.fillItem.id = item.id;

this.fillItem.description = item.description;

$("#edit-item").modal('show');

},


updateItem: function(id){

var input = this.fillItem;

this.$http.put('/vueitems/'+id,input).then((response) => {

this.changePage(this.pagination.current_page);

this.fillItem = {'title':'','description':'','id':''};

$("#edit-item").modal('hide');

toastr.success('Item Updated Successfully.', 'Success Alert', {timeOut: 5000});

}, (response) => {

this.formErrorsUpdate = response.data;

});

},


changePage: function (page) {

this.pagination.current_page = page;

this.getVueItems(page);

}


}


});

  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Write API Integrations in Laravel and PHP Projects with Saloon
    Write API Integrations in Laravel and PHP Projects with Saloon Saloon  is a Laravel/PHP package that allows you to write your API integratio...
  • Features CodeIgniter
    Features CodeIgniter There is a great demand for the CodeIgniter framework in PHP developers because of its features and multiple advan...
  • Laravel Breeze with PrimeVue v4
    This is an follow up to my previous post about a "starter kit" I created with Laravel and PrimeVue components. The project has b...
  • Fast Excel Package for Laravel
      Fast Excel is a Laravel package for importing and exporting spreadsheets. It provides an elegant wrapper around Spout —a PHP package to ...
  • Send message via CANBus
    After some years developing for mobile devices, I've started developing for embedded devices, and I'm finding a new problem now. Th...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (68)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

Loading...

Laravel News

Loading...

Copyright © CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda