Route: Route::get('/cuisines','backEnd\contentManagement\CuisinesController@index'); Route::post('/data/cuisines','backEnd\contentManagement\CuisinesController@cuisinesList'); Route::match(['get','post'],'/cuisine/add','backEnd\contentManagement\CuisinesController@add'); Route::match(['get','post'],'/cuisine/edit/{cuisine_id}','backEnd\contentManagement\CuisinesController@edit');...
07 September, 2020
Laravel Add , Update, Delete in Singal Page CRUD By Ajax Easy Way
<?php Route:Route::get('/cuisines','backEnd\contentManagement\CuisinesController@index');Route::post('/data/cuisines','backEnd\contentManagement\CuisinesController@cuisinesList');Route::match(['get','post'],'/cuisine/add','backEnd\contentManagement\CuisinesController@add');Route::match(['get','post'],'/cuisine/edit/{cuisine_id}','backEnd\contentManagement\CuisinesController@edit');//soft-delete of cusisineRoute::match(['get','post'],'/cuisine/delete/{cuisine_id}','backEnd\contentManagement\CuisinesController@delete');?><!-- Controller --><?phpnamespace App\Http\Controllers\backEnd\contentManagement;use App\Http\Controllers\Controller;use Illuminate\Http\Request;use Auth, Hash;use App\Cuisine;class CuisinesController extends Controller{ public function index() { $page = 'cuisines'; return view('backEnd.contentManagement.cuisines.index', compact('page')); } public function cuisinesList(){ $draw = @$_POST['draw']; $row = @$_POST['start']; $rowperpage = @$_POST['length']; // Rows display per page $columnIndex = @$_POST['order'][0]['column']; // Column index $columnName = @$_POST['columns'][$columnIndex]['data']; // Column name $columnSortOrder = @$_POST['order'][0]['dir']; // asc or desc $searchValue = @$_POST['search']['value']; // Search value $listing = Cuisine::select('*') ->whereNull('deleted_at') ->skip($_POST['start']) ->take($_POST['length']); $listing = $listing->orderBy($columnName,$columnSortOrder); $recordCount = Cuisine::whereNull('deleted_at') ->count(); $with_filter_count = $listing->count(); // ----- search if($searchValue != ''){ $listing = $listing->where('name','like','%'.$searchValue.'%'); $with_filter_count = $listing->count(); } if($with_filter_count == 0){ $with_filter_count = $recordCount; } $allRecords = $listing->get()->toArray(); // Total number of records without filtering $totalRecords = $recordCount; //Total number of record with filtering $totalRecordwithFilter = $with_filter_count; $data = array(); foreach ($allRecords as $key => $value) { $joined_on = date('d M, Y', strtotime($value['created_at'])); $encoded_id = $value['id']; // $encoded_id = base64_encode($value['id']); $action = '<a href="'.url('/admin/cuisine/edit/'.$encoded_id). '" title="Edit"><i class="fa fa-edit"></i> </a> <a href="'.url('/admin/cuisine/delete/'.$encoded_id).'" title="Send Credential"><i class="fas fa-trash-alt"></i> </a>'; $data[] = array( "name"=>ucfirst($value['name']), "action"=>$action, ); } $response = array( "draw" => intval($draw), "iTotalRecords" => $totalRecords, "iTotalDisplayRecords" => $totalRecordwithFilter, "aaData" => $data ); echo json_encode($response); } public function add(Request $request){ if($request->isMethod('post')){ $data = $request->all(); //$id = $this->route('post'); $validatedData = $request->validate ([ 'name'=>'required|max:20|min:3', ]); $cusisineData = new Cuisine; $cusisineData->name = $data['name']; if($cusisineData->save()) { return redirect('/admin/cuisines')->with ('success','Cuisine added successfully'); } else { return redirect('/admin/cuisines')->with('errors',COMMON_ERROR); } } $page = 'cuisines'; return view('backEnd.contentManagement.cuisines.form', compact('page')); } public function edit(Request $request,$cuisine_id) { $cuisine_detail = Cuisine::where('id',$cuisine_id)->first(); if ($request->isMethod('post')){ $data = $request->all(); $this->validate($request,[ 'name'=>'required|max:20|min:3', ]); $cuisine_detail->name = $data['name']; if ($cuisine_detail->save()) { return redirect('/admin/cuisines')->with('success', 'Cuisine Updated Successfully'); }else{ return redirect()->back()->with('errors',COMMON_ERROR); } } $page = 'cuisines'; return view('backEnd.contentManagement.cuisines.form', compact('page','cuisine_detail','cuisine_id')); } public function delete($cuisine_id) { $del = Cuisine::where('id',$cuisine_id)->update(['deleted_at'=> date('Y-m-d h:i:s')]); if ($del) { return redirect()->back()->with('success', 'Cuisine deleted successfully'); } else { return redirect()->back()->with('errors',COMMON_ERROR); } }}// Blade File: index. thats is not main file it is only view file ;// Index.blade.php<?php@extends('backEnd.layouts.master')@section('title','categories')@section('content')<div class="page-wrapper"> <div class="page-breadcrumb"> <div class="row"> <div class="col-12 d-flex no-block align-items-center"> <h4 class="page-title">Content Management </h4> </div> </div> </div> <div class="container-fluid"> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <h5 class="card-title">Categories</h5> <div class="new_add_btn d-flex justify-content-end align-items-center mb-4"> <a href="{{ url('admin/category/add') }}" class="btn btn-primary mr-1">Add New</a> </div> <div class="table-responsive"> <table id="zero_config2" class="table table-striped table-bordered"> <thead> <tr> <th>Name</th> <th>Image</th> <th>Action</th> </tr> </thead> </table> </div> </div> </div> </div> </div> </div> @include('backEnd.common.footer')</div>@endsection@section('scripts')<script> $('#zero_config2').DataTable({ "order": [[ 0, "desc" ]], 'processing': true, 'serverSide': true, 'serverMethod': 'post', 'ajax':{ 'url': "{{ url('admin/data/categories') }}", "error": function(reason) { console.log(reason); } }, "columns" : [ { data: 'name' }, { data: 'image' }, { data: 'action', name: 'action', orderable: false, searchable: false} ] });</script>@endsectionform.blade.phpNote: this is main file you can edit and update only one file;<?php if(isset($categorieData)){ $title = 'Edit'; $form_id = 'CategoryForm';$image_text = 'Update Image'; $action = url('/admin/category/edit/'.$category_id); }else{ $title = 'Add'; $form_id = 'CategoryForm';$image_text = 'Update Image'; $action = url('/admin/category/add'); }?>@extends('backEnd.layouts.master')@section('title',$title.' Content Management')@section('content')<div class="page-wrapper"> <div class="page-breadcrumb"> <div class="row"> <div class="col-12 d-flex no-block align-items-center"> <h4 class="page-title">Content Management</h4> <div class="ml-auto text-left"> <nav aria-label="breadcrumb"> <ol class="breadcrumb"> <li class="breadcrumb-item"><a href="{{ url('admin/categories') }}">Content</a></li> <li class="breadcrumb-item active" aria-current="page">{{ $title }} category</li> </ol> </nav> </div> </div> </div> </div> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="card"> <form class="form-horizontal" name="registration" method="post" action="{{ $action }}" id="user_form" enctype="multipart/form-data"> @csrf <div class="card-body"> <h4 class="card-title">{{ $title }} Category</h4> <div class="form-group row"> <label class="col-sm-3 text-right control-label col-form-label">Name:</label> <div class="col-sm-7"> <input type="text" class="form-control" placeholder="Name" name="name" value="{{ isset($categorieData['name'])? $categorieData['name']: old('name') }}"> </div> </div> <label for="image" class="m-t-10"></label> <?php $image = DefaultImgPath; if(!empty($categorieData['image'])){ $image = ContentCategoriesImgPath.'/'.$categorieData['image']; } ?> <div class="container-fluid" style="padding-left: 270px; padding-bottom: 20px;"> <div> <img src="{{$image}}" id="old_image" alt="No image" class="img-fluid" width="15%" height="10%" accept=".jpg,.png,.gif,.jpeg"> </div> <div> <div class="Upload-img mt-3"> <span class="uploader"> <button type="button" ...