Slivia

multiple insert laravel

Dec 5th, 2017
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.79 KB | None | 0 0
  1. Blade.php
  2. ========================
  3. @extends('layouts.main_layout')
  4. @section ('title', 'SSR- Add Result')
  5. @section('content')
  6.  
  7. @include('layouts.head')
  8. @include('layouts.left_aside')
  9. <style>
  10. .go .btn{
  11. margin-top:23px;
  12. }
  13. .bg-info{
  14. margin:20px 0px;
  15. }
  16.  
  17. </style>
  18. <div class="wrapper">
  19. <div class="content-wrapper">
  20. <!-- Content Header (Page header) -->
  21. <section class="content-header">
  22. <h1>
  23. Add Student Results
  24. <small></small>
  25. </h1>
  26. <ol class="breadcrumb">
  27. <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
  28. <li class="active">Add Result</li>
  29. </ol>
  30. </section>
  31.  
  32. <!-- Main content -->
  33. <section class="content">
  34. <div class="row">
  35. <div class="box">
  36. <div class="box-header">
  37. <!--<h3 class="box-title">All Student Information</h3> -->
  38. </div>
  39. <!-- /.box-header -->
  40. <div class="box-body">
  41. <div class="col-md-12">
  42. <div class="row">
  43. <form class="form-horizontal" role="form" method="get" action="{{url('/getResult') }}" data-parsley-validate >
  44. <input type="hidden" name="_token" value="{{ csrf_token() }}">
  45. <div class="col-md-2">
  46. <label for="exampleInputEmail1">Class <span class="text-danger">*</span> </label>
  47. <select class="form-control select_class2" name="class_name" required="" data-parsley-required-message ="Accounting System is required" data-parsley-trigger="change focusout">
  48. <option value="">Select a Class</option>
  49. <option value="1">Nursery </option>
  50. <option value="2">One</option>
  51. <option value="3">Two</option>
  52. <option value="4">Three</option>
  53. <option value="5">Four</option>
  54. <option value="6">Five</option>
  55. <option value="7">Six</option>
  56. <option value="8">Seven</option>
  57. <option value="9">Eight</option>
  58. <option value="10">Nine</option>
  59. <option value="11">Ten</option>
  60. <option value="12">Nine-Voc</option>
  61. <option value="13">Ten-Voc</option>
  62. <option value="14">Diploma-1</option>
  63. <option value="15">Diploma-2</option>
  64. <option value="16">Diploma-3</option>
  65. <option value="17">Diploma-4</option>
  66. <option value="18">Diploma-5</option>
  67. <option value="19">Diploma-6</option>
  68. <option value="20">Diploma-7</option>
  69. <option value="21">Diploma-8</option>
  70. </select>
  71. </div>
  72. <div class="col-md-1" >
  73. <label for="Class" class="col-sm-12 ">Section</label>
  74. <select class="form-control" name="section">
  75. <option value="" selected="selected">Section</option>
  76. <option value="A">A</option>
  77. <option value="B">B</option>
  78. <option value="C">C</option>
  79. <option value="D">D</option>
  80. <option value="E">E</option>
  81. </select>
  82. </div>
  83. <div class="col-md-2" id="group2" >
  84. <label for="Class" class="col-sm-12">Group <span class="text-danger">*</span></label>
  85. <select class="form-control group" name="sgroup">
  86. <option value="" selected="selected">Select a Group</option>
  87. <option value="Science">Science</option>
  88. <option value="Commerce">Commerce</option>
  89. <option value="Arts">Arts</option>
  90. </select>
  91. </div>
  92. <div class="col-md-2" id="trade2">
  93. <label for="Class" class="col-sm-12">Trade <span class="text-danger">*</span></label>
  94. <select class="form-control trade" name="trade">
  95. <option value="" selected="selected">Select a Trade</option>
  96. <option value="Computer">Computer</option>
  97. <option value="Dressmaking">Dressmaking</option>
  98. <option value="Electrical">Electrical</option>
  99. </select>
  100. </div>
  101. <div class="col-md-2" id="department2" >
  102. <label for="Class" class="col-sm-12 ">Department <span class="text-danger">*</span></label>
  103. <select class="form-control department" name="department">
  104. <option value="" selected="selected">Select a Department</option>
  105. <option value="Electrical">Electrical</option>
  106. <option value="Telecom">Telecom</option>
  107.  
  108. </select>
  109. </div>
  110. <div class="col-md-1">
  111. <label for="exampleInputEmail1">Gender </label>
  112. <select class="form-control" name="gender" >
  113. <option value="">Select Gender</option>
  114. <option value="Male">Male</option>
  115. <option value="Female">Female</option>
  116. </select>
  117. </div>
  118. <div class="col-md-2" id="Subject" >
  119. <label for="Select a Subject" class="col-sm-12">Subject<span class="text-danger">*</span></label>
  120. <select class="form-control subject" name="subject" required="" data-parsley-required-message ="Subject is required" data-parsley-trigger="change focusout">
  121.  
  122. </select>
  123. </div>
  124. <div class="col-md-2" id="Exam Name" >
  125. <label for="Exam Name" class="col-sm-12">Exam Name <span class="text-danger">*</span></label>
  126. <select class="form-control exam_name" name="exam_name" required="" data-parsley-required-message ="Exam Name is required" data-parsley-trigger="change focusout">
  127. <option value="" selected="selected">Select a Exam Name</option>
  128. @foreach ($examsName as $eN)
  129. <option value="{{ $eN->id }}">{{ $eN->exam_name}}</option>
  130. @endforeach
  131.  
  132. </select>
  133. </div>
  134. <div class="col-md-2 go">
  135. <button type="submit" class="btn btn-success"><i class="fa fa-search" aria-hidden="true"></i>
  136. Search Student</button>
  137. </div>
  138. </form>
  139. </div>
  140.  
  141. <div class="row bg-info">
  142. <h4 class="text-left">Add Class- Result Subject- </h4>
  143. </div>
  144. <div class="row">
  145. <div class="col-md-12">
  146. <form class="form-horizontal" method="post" action="{{URL::TO('/addResult')}}" enctype="multipart/form-data" data-parsley-validate>
  147. <input type="hidden" name="_token" value="{{ csrf_token() }}">
  148. <table class="table table-striped table-hover dt-responsive nowrap" cellspacing="0" width="100%" id="manage_std">
  149. <thead>
  150. <tr style="background-color: #374850; color: #FFF;">
  151. <th class="text-left">Sr No.</th>
  152. <th class="text-left">Picture</th>
  153. <th class="text-left">Student Id</th>
  154.  
  155. <th class="text-left">Subject</th>
  156. <th class="text-left">Subject Mark</th>
  157. <th class="text-left">Class Test Mark</th>
  158. </tr>
  159. </thead>
  160. <tbody>
  161. @if(isset($sdata))
  162. <?php $count =0; ?>
  163. @foreach($sdata as $data)
  164. <?php ++$count; ?>
  165. <tr>
  166. <td class="text-left">{{$count}}</td>
  167. <td class="text-left"><img src="{{ asset('/' . $data->image_file) }}" class="img-circle" width="35px" height="35px"/></td>
  168. <td class="text-left">{{$data->student_id}}</td>
  169.  
  170.  
  171. <td class="text-left">
  172. {{ App\Models\student_subject:: where('id', '=', $subject)->value('sub_name') }}
  173. </td>
  174.  
  175. <td class="text-left"> <input type="text" class="form-control" placeholder="Mark" name="sub_mark[]" max="100" data-parsley-max="100" > </td>
  176.  
  177. <td class="text-left"> <input type="text" class="form-control" placeholder="Class Test Mark" name="ct_mark[]" max="20" > </td>
  178. </tr>
  179. <input type="hidden" name="student_id" value="{{$data->student_id}}" >
  180. <input type="hidden" name="sub_name" value="{{$subject }}">
  181.  
  182.  
  183. @endforeach
  184.  
  185. <button type="submit" class="btn btn-success btn-lg"><i class="fa fa-plus" aria-hidden="true"></i> Add Marks </button>
  186. </td>
  187. </tr>
  188. @endif
  189. </tbody>
  190. </table>
  191. </form>
  192. </div>
  193. </div>
  194. </div>
  195. <!-- /.box-body -->
  196. </div>
  197. <!-- /.box -->
  198.  
  199. </div>
  200. <!-- /.row -->
  201. </div>
  202. </section>
  203.  
  204. <!-- /.content -->
  205. </div>
  206. <!-- /.content-wrapper -->
  207.  
  208. @include('layouts.footer')
  209. </div><!-- / .wrapper -->
  210. @endsection
  211.  
  212.  
  213.  
  214. Controller
  215. ========================
  216.  
  217. public function AddResult(Request $request) {
  218. $student_id= $request->input('student_id');
  219. $sub_name= $request->input('sub_name');
  220. $class_name= Session::get('class_name');
  221. $exam_id= Session::get('exam_name');
  222.  
  223. $sub_mark= $request->input('sub_mark');
  224. $ct_mark= $request->input('ct_mark');
  225. #dd($exam_id);
  226. $i = 0;
  227. foreach($sub_mark as $marks){
  228. $student_res = new student_results();
  229. $student_res->student_id = $student_id;
  230. $student_res->class_name = $class_name;
  231. $student_res->sub_name = $sub_name;
  232. $student_res->sub_mark = $marks;
  233. $student_res->ct_mark = $ct_mark[$i];
  234. $student_res->exam_id = $exam_id;
  235. $student_res->save();
  236. }
  237.  
  238. $notification = array(
  239. 'message'=>'Student Marks Add Successfully',
  240. 'alert-type'=>'success',
  241. );
  242.  
  243. return redirect('/indexAddResult')->with($notification);
  244.  
  245. }
Add Comment
Please, Sign In to add comment