Wednesday, 26 April 2017

CRUD

Model
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
use DB;
use Session;

class Flight extends Model {
    protected $table = 'flight';
    protected $primaryKey = 'id';
    // protected $guarded = [];
    // protected $hidden = ['id'];
    protected $fillable = ['name','age','status'];
    public $timestamps = true;


    public function updateflight ($id,$data)
    {
      $updatedRows = App\Flight::where('id', $id)->update('name'=>$data['name'],'status'=>$data['status'])->save();
      return  $updatedRows;   
    } 

    public function deleteflight ($id)
    {
      $deletedRows = App\Flight::where('id', $id)->where('status','0')->delete();
      return  $deletedRows;   
    }
}


?>
Controller

<?php
namespace App\Http\Controllers;
use App\Models\Flight;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use Session;
use DB;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\Redirect;

class FlightController extends Controller
{  
    public function addrecord(Request $request)
    {
    
       $postData = Input::all();
     
        $messages = array(
             'name.required'=>'You cant leave name field empty',
             'age.required'=>'You cant leave age field empty',
             'status.required'=>'Age cannot be blank',
    );

    $rules = array(
        'name'=>'required | min:5',',
        'age'=>''required ',
        'status'=>'required',
    );
   
     $validator = Validator::make($postData, $rules,$messsages);   
     
  if($validator->fails()) {                         
                 return Redirect::to('sales/createnew')->withInput()->withErrors($validator);           
     }else {
       
      $flight = new Flight;
      $flight->name = $request->name;
      $flight->age = $request->age;
      $flight->status = $request->status;
     
      $flight->save();
      return redirect('dashboard')->with('status', 'Sucessfully inserted!');  
      }
}
   
    public function updaterecord(Request $request)
    {
      // Validate the request...
      $id = $request->id;
      $flight = new Flight;
     
      $flight_array = Flight::find( $id );

    //CHECK FOR NEW OR EXISTING Flight
        if( $flight_array ) {
            $flight_array->name = $request->name;
            $flight_array->age = $request->age;
            $flight_array->status = $request->status;
            $flight_array->save();
        }   
    or
   
        $data['name'] = $request->name;
        $data['age'] = $request->age;     
        $data['status'] = $request->status;
   
        $updated = $flight->updateflight($id,$data);
        if($updated  > 0 )
        {          
           Session::flash('success',"Sucessfully updated!");
           return redirect('dashboard');  
           or
           return redirect('dashboard')->with('success', 'Sucessfully updated!');  
        } else {
       
           return redirect('dashboard')->with('error', 'Try again!');  
        }       
       
     }
       
    public function deleterecord(Request $request)
    {
      // Validate the request...
      $id = $request->id;
      $flight = new Flight;     
      $flight_array = Flight::find( $id );

    //CHECK FOR NEW OR EXISTING Flight
    if( $flight_array )
      {
        $flight_array->delete();
      }
   
    Or
        $deletedRows = $flight->deleteflight($id);
        if($deletedRows  > 0 )
        {          
           return redirect('dashboard')->with('status', 'Sucessfully deleted!');  
        } else {
           return redirect('dashboard')->with('error', 'Try again!');  
        }
    }
       
}

?>

**************************************
View file
<form action="" method="post" name="form1">
  <table width="200" border="1">
    <tr>
      <td colspan="2">
@if(Session::has('success'))
<div class="alert alert-success">{{ Session::get('success') }}</div>
@endif

Error on view page for all the errors.
@foreach ($errors->all() as $error)
   <p class="alert alert-danger">{{ $error }}</p>
@endforeach

</td>
     
    </tr>
    <tr>
      <td>Name</td>
      <td>

     <input type="text" class="form-control" id="name" placeholder="Name" name="name" value="{{ old('name') }}">
        <?php if($errors->first('name') ){ ?><div class="alert alert-danger"> {{ $errors->first(name') }}</div><?php }  ?>

      </td>
    </tr>
    <tr>
      <td>Age</td>
      <td>
  <input type="text" class="form-control" id="age" placeholder="Age" name="age" value="{{ old('age') }}">
       <?php if($errors->first('age') ){ ?><div class="alert alert-danger"> {{ $errors->first(age') }}</div><?php }  ?>

      </td>
    </tr>
    <tr>
      <td>Status</td>
      <td><input name="status" type="radio" value="Active">
        <input name="status" type="radio" value="Inactive">

        </td>
    </tr>
  </table>
</form>

No comments:

Machine Learning - Potato Leaf Disease Prediction

Step 1: import numpy as np import pandas as pd import splitfolders import matplotlib.pyplot as plt import tensorflow as tf from tensorflow i...