Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- controller:
- <?php
- namespace App\Http\Controllers;
- use View;
- use Input;
- use DB;
- use Redirect;
- class FormController extends Controller{
- public function index(){
- $data['query'] = DB::table('tb_mahasiswa')->orderBy('nama', 'DESC')->paginate(5);
- return view('form.main', $data);
- }
- public function search(){
- $keyword = Input::get('keyword');
- $data['query'] = DB::table('tb_mahasiswa')->where('nama', 'like', '%'.$keyword.'%')->orderBy('nama', 'DESC')->paginate(5);
- return view('form.search', $data);
- }
- public function add(){
- return View::make('form.add');
- }
- public function create(){
- $nim = Input::get('nim');
- $nama = Input::get('nama');
- $asal =Input::get('asal');
- $insert = DB::insert('insert into tb_mahasiswa(nim,nama,asal) VALUES (?, ?, ?)', array($nim, $nama, $asal));
- if($insert){
- return Redirect::to('form?report=1');
- }else{
- return Redirect::to('form?report=2');
- }
- }
- }
- ---------------------------------------------------------------------------------------------------------------------------------
- routes:
- <?php
- Route::get('/', 'FormController@index');
- Route::get('/main', 'FormController@index');
- Route::get('/search', 'FormController@search');
- Route::get('/form', 'FormController@add');
- Route::post('/form/add', 'FormController@create');
- ---------------------------------------------------------------------------------------------------------------------------------
- view(main.blade.php):
- @extends ('layouts/master')
- @section('title', 'Laravel crud')
- @section('extrahead')
- <script src="{{ asset('assets/js/search.js') }}" type="text/javascript"></script>
- @stop
- @section('content')
- <div class="container">
- <div class="row">
- <div class="col-sm-12 content-t pad-t">
- <legend>Tampil Data</legend>
- <div class="row">
- <div class="col-sm-4">
- <div class="form-group has-feedback">
- <input type="text" id="isearch" placeholder="Cari nama" class="form-control">
- <i class="form-control-feedback glyphicon glyphicon-search"></i>
- </div>
- </div>
- <div class="col-sm-8" align="right">
- <a href="form"><button type="button" class="btn btn-primary">Tambah</button></a>
- </div>
- </div>
- @if(Request::get('report')==1)
- <div class="alert alert-success" role="alert"><span class="glyphicon glyphicon-ok"></span> Masukan data berhasil</div>
- @elseif(Request::get('report')==2)
- <div class="alert alert-danger" role="alert"><span class="glyphicon glyphicon-remove"></span> Masukan data gagal</div>
- @endif
- <table class="table table-hover">
- <thead>
- <tr>
- <td>No</td>
- <td>Nim</td>
- <td>Nama</td>
- <td>Asal</td>
- <td>Aksi</td>
- </tr>
- </thead>
- <tbody id="idatadisplay">
- <?php $no=Input::get('page')*5-4; ?>
- @foreach($query as $result)
- <tr>
- <td>{{{ $no }}}.</td>
- <td>{{{ $result->nim }}}</td>
- <td>{{{ $result->nama }}}</td>
- <td>{{{ $result->asal }}}</td>
- <td><button type="button" class="btn btn-default"><span class="glyphicon glyphicon-cog"></span></button>
- <button type="button" class="btn btn-danger" onclick="return confirm('Hapus {{{ $result->nama }}}?')"><span class="glyphicon glyphicon-remove"></span></button></td>
- </tr>
- <?php $no++; ?>
- @endforeach
- <tr>
- <td colspan="5"><center>{!! $query->render() !!}</center></td>
- </tr>
- </tbody>
- </table>
- <div class="version-t">
- Laravel 5.1 CRUD
- </div>
- </div>
- </div>
- </div>
- @stop
- ---------------------------------------------------------------------------------------------------------------------------------
- view(search.blade.php):
- <?php $no=Input::get('page')*5-4; ?>
- @foreach($query as $result)
- <tr>
- <td>{{{ $no }}}.</td>
- <td>{{{ $result->nim }}}</td>
- <td>{{{ $result->nama }}}</td>
- <td>{{{ $result->asal }}}</td>
- <td><button type="button" class="btn btn-default"><span class="glyphicon glyphicon-cog"></span></button>
- <button type="button" class="btn btn-danger" onclick="return confirm('Hapus {{{ $result->nama }}}?')"><span class="glyphicon glyphicon-remove"></span></button></td>
- </tr>
- <?php $no++; ?>
- @endforeach
- <tr>
- <td colspan="5"><center>{!! $query->render('') !!}</center></td>
- </tr>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement