codes
i will save this code for educational purpose
Collective\Html\HtmlServiceProvider::class,
'Form' => Collective\Html\FormFacade::class, 'Html' => Collective\Html\HtmlFacade::class,
DB_DATABASE=crud DB_USERNAME=root DB_PASSWORD=
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Member; class MemberController extends Controller { public function index(){ return view('show'); } public function getMembers(){ $members = Member::all(); return view('show')->with('members', $members); } public function save(Request $request){ $member = new Member; $member->firstname = $request->input('firstname'); $member->lastname = $request->input('lastname'); $member->save(); return redirect('/'); } public function update(Request $request, $id){ $member = Member::find($id); $input = $request->all(); $member->fill($input)->save(); return redirect('/'); } public function delete($id) { $members = Member::find($id); $members->delete(); return redirect('/'); } }
<?php namespace App; use Illuminate\Database\Eloquent\Model; class Member extends Model { protected $fillable = ['firstname', 'lastname']; }
<?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateMembersTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('members', function (Blueprint $table) { $table->increments('id'); $table->string('firstname'); $table->string('lastname'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('members'); } }
<?php Route::get('/', 'MemberController@index'); Route::get('/', 'MemberController@getMembers'); Route::post('/save', 'MemberController@save'); Route::patch('/update/{id}', ['as' => 'member.update', 'uses' => 'MemberController@update']); Route::delete('/delete/{id}', ['as' => 'member.delete', 'uses' => 'MemberController@delete']);
<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" /> <link rel="stylesheet" href="/css/app.css"> <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet"> </head> <body> <div class="container"> @yield('content') </div> @include('modal') </body> </html>
@extends('app') @section('content') <div class="row"> <div class="col-md-10 col-md-offset-1"> <h2>Members Table </h2> </div> </div> <div class="row"> <div class="col-md-10 col-md-offset-1"> <table class="table table-bordered table-responsive table-striped"> <thead> </thead> <tbody> @foreach($members as $member) <tr> @include('action') </td> </tr> @endforeach </tbody> </table> </div> </div> @endsection
<!-- Add Modal --> <div class="modal fade" id="addnew" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> </div> <div class="modal-body"> {!! Form::open(['url' => 'save']) !!} <div class="form-group"> <div class="row"> <div class="col-md-2" style="margin-top:7px;"> {!! Form::label('firstname', 'Firstname') !!} </div> <div class="col-md-10"> {!! Form::text('firstname', '', ['class' => 'form-control', 'placeholder' => 'Input Firstname', 'required']) !!} </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-md-2" style="margin-top:7px;"> {!! Form::label('lastname', 'Lastname') !!} </div> <div class="col-md-10"> {!! Form::text('lastname', '', ['class' => 'form-control', 'placeholder' => 'Input Lastname', 'required']) !!} </div> </div> </div> </div> <div class="modal-footer"> {!! Form::close() !!} </div> </div> </div> </div>
<!-- Edit Modal --> <div class="modal fade" id="edit{{$member->id}}" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> </div> <div class="modal-body"> {!! Form::model($members, [ 'method' => 'patch','route' => ['member.update', $member->id] ]) !!} <div class="form-group"> <div class="row"> <div class="col-md-2" style="margin-top:7px;"> {!! Form::label('firstname', 'Firstname') !!} </div> <div class="col-md-10"> {!! Form::text('firstname', $member->firstname, ['class' => 'form-control']) !!} </div> </div> </div> <div class="form-group"> <div class="row"> <div class="col-md-2" style="margin-top:7px;"> {!! Form::label('lastname', 'Lastname') !!} </div> <div class="col-md-10"> {!! Form::text('lastname', $member->lastname, ['class' => 'form-control']) !!} </div> </div> </div> </div> <div class="modal-footer"> {!! Form::close() !!} </div> </div> </div> </div> <!-- Delete Modal --> <div class="modal fade" id="delete{{$member->id}}" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> </div> <div class="modal-body"> {!! Form::model($members, [ 'method' => 'delete','route' => ['member.delete', $member->id] ]) !!} </div> <div class="modal-footer"> {!! Form::close() !!} </div> </div> </div> </div>