Advertisement
Guest User

search-ajax-lararev

a guest
Oct 10th, 2015
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.30 KB | None | 0 0
  1. controller:
  2. <?php
  3. namespace App\Http\Controllers;
  4.  
  5. use View;
  6. use Input;
  7. use DB;
  8. use Redirect;
  9.  
  10. class FormController extends Controller{
  11. public function index(){
  12. $data['query'] = DB::table('tb_mahasiswa')->orderBy('nama', 'DESC')->paginate(5);
  13.  
  14. return view('form.main', $data);
  15. }
  16.  
  17. public function search(){
  18. $keyword = Input::get('keyword');
  19. $data['query'] = DB::table('tb_mahasiswa')->where('nama', 'like', '%'.$keyword.'%')->orderBy('nama', 'DESC')->paginate(5);
  20.  
  21. return view('form.search', $data);
  22. }
  23.  
  24. public function add(){
  25. return View::make('form.add');
  26. }
  27.  
  28. public function create(){
  29. $nim = Input::get('nim');
  30. $nama = Input::get('nama');
  31. $asal =Input::get('asal');
  32.  
  33. $insert = DB::insert('insert into tb_mahasiswa(nim,nama,asal) VALUES (?, ?, ?)', array($nim, $nama, $asal));
  34. if($insert){
  35. return Redirect::to('form?report=1');
  36. }else{
  37. return Redirect::to('form?report=2');
  38. }
  39. }
  40. }
  41.  
  42. ---------------------------------------------------------------------------------------------------------------------------------
  43.  
  44. routes:
  45. <?php
  46. Route::get('/', 'FormController@index');
  47. Route::get('/main', 'FormController@index');
  48. Route::get('/search', 'FormController@search');
  49.  
  50. Route::get('/form', 'FormController@add');
  51. Route::post('/form/add', 'FormController@create');
  52.  
  53. ---------------------------------------------------------------------------------------------------------------------------------
  54.  
  55. view(main.blade.php):
  56. @extends ('layouts/master')
  57.  
  58. @section('title', 'Laravel crud')
  59.  
  60. @section('extrahead')
  61. <script src="{{ asset('assets/js/search.js') }}" type="text/javascript"></script>
  62. @stop
  63.  
  64. @section('content')
  65. <div class="container">
  66. <div class="row">
  67. <div class="col-sm-12 content-t pad-t">
  68. <legend>Tampil Data</legend>
  69. <div class="row">
  70. <div class="col-sm-4">
  71. <div class="form-group has-feedback">
  72. <input type="text" id="isearch" placeholder="Cari nama" class="form-control">
  73. <i class="form-control-feedback glyphicon glyphicon-search"></i>
  74. </div>
  75. </div>
  76. <div class="col-sm-8" align="right">
  77. <a href="form"><button type="button" class="btn btn-primary">Tambah</button></a>
  78. </div>
  79. </div>
  80. @if(Request::get('report')==1)
  81. <div class="alert alert-success" role="alert"><span class="glyphicon glyphicon-ok"></span> Masukan data berhasil</div>
  82. @elseif(Request::get('report')==2)
  83. <div class="alert alert-danger" role="alert"><span class="glyphicon glyphicon-remove"></span> Masukan data gagal</div>
  84. @endif
  85. <table class="table table-hover">
  86. <thead>
  87. <tr>
  88. <td>No</td>
  89. <td>Nim</td>
  90. <td>Nama</td>
  91. <td>Asal</td>
  92. <td>Aksi</td>
  93. </tr>
  94. </thead>
  95. <tbody id="idatadisplay">
  96. <?php $no=Input::get('page')*5-4; ?>
  97. @foreach($query as $result)
  98. <tr>
  99. <td>{{{ $no }}}.</td>
  100. <td>{{{ $result->nim }}}</td>
  101. <td>{{{ $result->nama }}}</td>
  102. <td>{{{ $result->asal }}}</td>
  103. <td><button type="button" class="btn btn-default"><span class="glyphicon glyphicon-cog"></span></button>
  104. <button type="button" class="btn btn-danger" onclick="return confirm('Hapus {{{ $result->nama }}}?')"><span class="glyphicon glyphicon-remove"></span></button></td>
  105. </tr>
  106. <?php $no++; ?>
  107. @endforeach
  108. <tr>
  109. <td colspan="5"><center>{!! $query->render() !!}</center></td>
  110. </tr>
  111. </tbody>
  112. </table>
  113. <div class="version-t">
  114. Laravel 5.1 CRUD
  115. </div>
  116. </div>
  117. </div>
  118. </div>
  119. @stop
  120.  
  121. ---------------------------------------------------------------------------------------------------------------------------------
  122.  
  123. view(search.blade.php):
  124. <?php $no=Input::get('page')*5-4; ?>
  125. @foreach($query as $result)
  126. <tr>
  127. <td>{{{ $no }}}.</td>
  128. <td>{{{ $result->nim }}}</td>
  129. <td>{{{ $result->nama }}}</td>
  130. <td>{{{ $result->asal }}}</td>
  131. <td><button type="button" class="btn btn-default"><span class="glyphicon glyphicon-cog"></span></button>
  132. <button type="button" class="btn btn-danger" onclick="return confirm('Hapus {{{ $result->nama }}}?')"><span class="glyphicon glyphicon-remove"></span></button></td>
  133. </tr>
  134. <?php $no++; ?>
  135. @endforeach
  136. <tr>
  137. <td colspan="5"><center>{!! $query->render('') !!}</center></td>
  138. </tr>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement