Laravel Using CRUD Operations

LARAVEL USING CRUD

Steps:

1)switch our project then  run the server using this-> cmd then php artsian serve

2) /resource/views/your viewfile name  save as filname.blade.php

3)go to Routes page app/http/routes.php open the file and then routes the viewpage

Route::get('your parameter to view page user defined', function () {

    return view('your view file name ');

});

(or)

Create Controller File using this cmd php artisan make:controller your controller name --resource

open your controller file index() method to implement

public function index(){

return view('your view file name');

}

then open your routes page

Route::get('your parameter to view page user defined','your cotroller name@your method');

EX:

Route::get('signup','firstcontroller@index');

then submit your  form Throw the Exception TokenMismatchException

go to your view file

<form method="post" action="">

{{ csrf_field() }} ---> put this code after form tag

then submit your values are show

go to your controller store method

public function store(Request $req){

return $req->all(); ----> it will display all

(or)

return $req->your specify name();

ex:

return $req->name; -----> it will display only name

}

then go to your .env file to configure

DB_DATABASE=your database name

DB_USERNAME=your username

DB_PASSWORD=your password

Create Model

php artisan make:model model name -m

then go to your APP/database/migration your modelname table

public function up()

    {

Schema::create('your table name is alredy defined ', function (Blueprint $table) {

            $table->your datatype('your column name')

            $table->your datatype('your column name')

            $table->your datatype('your column name')

             $table->your datatype('your column name')

                });

                }

then migrate your table

php artisan migrate

check your database your tables is created or not

go to your model file

put this code

$fillable=['Your posted values name','Your posted values name','Your posted values name'];

ex:

$data=['reg','name','mak'];

then go to your controller file store method

put the import your model

ex:

use App\your modelname;

write coding for insert database

public function store(Request $req){

create object for your  model

public function store(Request $req)

        {

        $test=new yourmodelname;

        $test->regno=$req->regno;

        $test->name=$req->name;

        $test->mark=$req->mark;

         if($test->save()){return redirect()->back();}else{}

           

        }

}

then run your file check the database data are insert or not

// Display Your Record

go to  your controller file

put this code

public function index()

        {

$samename['samename']=yourmodelname::all();--->it will display all records in array format

        return view('your view file',$samename);

        }

next  go your view file

<TABLE border='1' cellpadding='8'>

<tr><th>Regno</th><th>Name</th><th>Mark</th><th>Delete</th></tr>

@foreach($samename as $row)

<tr>

<td>{{ $row['regno'] }}</td>

<td>{{ $row['name'] }}</td>

<td>{{ $row['mark'] }}</td>

<td><a href="/register/{{ $row['id'] }}">delete</a></td>

</tr>

@endforeach

</TABLE><br>

//delete

go controller file delete method

public function delete($id)

    {

                $del=your model name::find($id);

        $del->delete();

                return redirect()->back();

    }

//Update  The record

go to Route File

Route::get('yourview file name/{pass parameter ex id }','controllername@function name');

Route::post('view name','controllername@function name');

Coding:

Route.php:

   <?php

Route::get('/', function () {

    return view('welcome');

});

Route::get('first','firstcontroller@index');

Route::post('first','firstcontroller@store');

Route::get('crud','crudctrl@index');

Route::post('crud','crudctrl@store');

Route::get('update/{id}','crudctrl@show');

Route::post('upd','crudctrl@update');

Route::get('crud/{id}','crudctrl@delete');

Route::get('login','crudctrl@loginpage');

Route::post('login','crudctrl@login');

View File :

<html>

<head>

<title>CRUD Operation Using Laravel</title>

<link rel="stylesheet" type="text/css" href="{{ ('css/bootstrap.min.css') }}">

</head>

<body>

<div class="container">

<div class="row">

<div class="col-md-3">

</div>

<div class="col-md-5 login-sec">

<h2 class="text-center">Signup</h2>

<form method="post" action="">

{{ csrf_field() }}

<div class="form-group">

<label for="exampleInputEmail1"  class="text-uppercase">First Name</label>

    <input type="text" class="form-control" name="fname" placeholder="" >

    <label for="exampleInputEmail1" class="text-uppercase">Last Name</label>

      <input type="text" class="form-control" name="lname" placeholder="" >

</div>

<div class="form-group">

<label class="text-uppercase">Email</label>

<input type="text" name="email" class="form-control">

</div>

<div class="form-group">

<label class="text-uppercase">Uname</label>

<input type="text" name="uname"  class="form-control">

</div>

<div class="form-group">

<label class="text-uppercase">Password</label>

<input type="password" class="form-control" name="pwd">

</div>

<center><input type="submit" value="Insert" class="btn btn-success"></center>

</form>

</div>

</div>

<table class='table table-responsive'>

<tr class='info'><th>Fname</th><th>Lname</th><th>Email</th><th>Uname</th><th>Password</th><th>Update</th><th>Delete</th></tr>

@foreach($records as $row)

<tr>

<td>{{ $row['fname'] }}</td>

<td>{{ $row['lname'] }}</td>

<td>{{ $row['email'] }}</td>

<td>{{ $row['uname'] }}</td>

<td>{{ $row['pwd'] }}</td>

<td><a href="/update/{{ $row['id'] }}"><button class='btn btn-warning'>Update</button></a></td>

<td><a href="/crud/{{ $row['id'] }}"><button class='btn btn-danger'>Delete</button></a></td>

</tr>

@endforeach

</table>

<center> {{ $rows->links()  }}

</center>

</div>

</body>

</html>

Update view file:

<html>

<head>

<link rel="stylesheet" type="text/css" href="{{ asset('css/bootstrap.min.css') }}">

</head>

<body>

<div class="container">

<div class="row">

<div class="col-md-5 login-sec">

<h2 class="text-center">Update</h2>

<form method="post" action="/upd">

{{ csrf_field() }}

<input type="hidden" value="{{$sow['id'] }}" name="id">

<div class="form-group">

<label for="exampleInputEmail1"  class="text-uppercase">First Name</label>

    <input type="text" value="{{$sow['fname'] }}" class="form-control" name="fname" placeholder="" >

    <label for="exampleInputEmail1" class="text-uppercase">Last Name</label>

      <input type="text" value="{{$sow['lname'] }}" class="form-control" name="lname" placeholder="" >

</div>

<div class="form-group">

<label class="text-uppercase">Email</label>

<input type="text" value="{{$sow['email'] }}" name="email" class="form-control">

</div>

<div class="form-group">

<label class="text-uppercase">Uname</label>

<input type="text" value="{{$sow['uname'] }}" name="uname"  class="form-control">

</div>

<div class="form-group">

<label class="text-uppercase">Password</label>

<input type="password" value="{{$sow['pwd'] }}" class="form-control" name="pwd">

</div>

<input type="submit" value="update" class="btn btn-success">

</form>

</div>

</div>

</div>

</body>

</html>

Model file: 

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class crudopn extends Model

{

    protected $datas=['fname','lname','email','uname','pwd'];

}

Controller file:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Requests;

use App\crudopn;

use DB;

class crudctrl extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return \Illuminate\Http\Response

     */

    public function index()

    {

        $records['records']=crudopn::all();

        

        return view('crudopr',$records);

    }

    /**

     * Show the form for creating a new resource.

     *

     * @return \Illuminate\Http\Response

     */

    public function loginpage()

    {

        return view('login');

    }

    /**

     * Store a newly created resource in storage.

     *

     * @param  \Illuminate\Http\Request  $request

     * @return \Illuminate\Http\Response

     */

    public function store(Request $request)

    {

        $inst=new crudopn;

        $inst->fname=$request->fname;

        $inst->lname=$request->lname;

        $inst->email=$request->email;

        $inst->uname=$request->uname;

        $inst->pwd=$request->pwd;

        if($inst->save()){return redirect()->back();}else{}

    }

    /**

     * Display the specified resource.

     *

     * @param  int  $id

     * @return \Illuminate\Http\Response

     */

    public function show($id)

    {

     $sow['sow']=crudopn::find($id);

     return view('update',$sow);

    }

    /**

     * Show the form for editing the specified resource.

     *

     * @param  int  $id

     * @return \Illuminate\Http\Response

     */

    public function login(Request $req)

    {

        $uname=$req->input('uname');

        $passwd=$req->input('passwd');

        $login=DB::table('crudopns')->where(['uname'=>$uname,'pwd'=>$passwd])->get();

        $cnt=count($login);

        if($cnt==1){

            echo "<script>window.location.href='http://localhost:8000/crud';</script>";

        }else{

echo "<script>alert('Your Username or Password is Wrong');window.location='http://localhost:8000/login';</script>";

        }

    }

    /**

     * Update the specified resource in storage.

     *

     * @param  \Illuminate\Http\Request  $request

     * @param  int  $id

     * @return \Illuminate\Http\Response

     */

    public function update(Request $req)

    {

        //$up=crudopn::find($req->id);

        $updates=crudopn::find($req->id);

        $updates->fname=$req->fname;

        $updates->lname=$req->lname;

        $updates->email=$req->email;

        $updates->uname=$req->uname;

        $updates->pwd=$req->pwd;

        

        if($updates->save()){echo "<script>window.location.href='http://localhost:8000/crud';</script>";}else{}

    }

    /**

     * Remove the specified resource from storage.

     *

     * @param  int  $id

     * @return \Illuminate\Http\Response

     */

    public function delete($id)

    {

        $del=crudopn::find($id);

        $del->delete();

        return redirect()->back();

    }

}

Outputs: