I am trying to send data into the database but unfortunately its returning null…
The button with type=”submit” is working well it is saving all the marks of the student at once but the button which is saving one subject at at time
the one with “SaveSingleSubject” class is the one returning null on the fields, exam_work,class_work,test_work…
what is the issue
blade code
@if (!empty($getStudent) && !empty($getStudent->count()))
@foreach ($getStudent as $student)
<form name="post" class="SubmitForm">
{{csrf_field()}}
<input type="hidden" name="student_id" value="{{$student->id}}">
<input type="hidden" name="exam_id" value="{{Request::get('exam_id')}}">
<input type="hidden" name="class_id"
value="{{Request::get('class_id')}}">
<tr>
<td>{{$student->name}}{{$student->last_name}}</td>
@php
$i = 1;
@endphp
@foreach ($getSubject as $subject)
@php
$getMark = $subject->getMark($student->id, Request::get('exam_id'), Request::get('class_id'), $subject->subject_id);
@endphp
<td>
<div style="margin-bottom: 10px;">
Class Work
<input type="hidden" name="mark[{{$i}}][subject_id]"
value="{{$subject->subject_id}}" style="width: 200px;"
class="form_control" placeholder="Enter Marks">
<input type="text" name="mark[{{$i}}][class_work]"
id="class_work_{{$student->id}}{{$subject->id}}"
style="width: 200px;" class="form_control"
placeholder="Enter Marks"
value="{{!empty($getMark->class_work) ? $getMark->class_work : ''}}">
</div>
<div style="margin-bottom: 10px;">
Home Work
<input type="text" name="mark[{{$i}}][home_work]"
id="home_work_{{$student->id}}{{$subject->id}}"
style="width: 200px;" class="form_control"
placeholder="Enter Marks"
value="{{!empty($getMark->home_work) ? $getMark->home_work : ''}}">
</div>
<div style="margin-bottom: 10px;">
Test Work
<input type="text" name="mark[{{$i}}][test_work]"
id="test_work_{{$student->id}}{{$subject->id}}"
style="width: 200px;" class="form_control"
placeholder="Enter Marks"
value="{{!empty($getMark->test_work) ? $getMark->test_work : ''}}">
</div>
<div style="margin-bottom: 10px;">
Exam Work
<input type="text" name="mark[{{$i}}][exam_work]"
id="exam_work_{{$student->id}}{{$subject->id}}"
style="width: 200px;" class="form_control"
placeholder="Enter Marks"
value="{{!empty($getMark->exam_work) ? $getMark->exam_work : ''}}">
</div>
<div style="margin-bottom: 10px;">
<button type="button"
class="btn btn-primary SaveSingleSubject"
id="{{$student->id}}"
data-val="{{$subject->subject_id}}
"
data-exam="{{Request::get('exam_id')}}"
data-class="{{Request::get('class_id')}}">Save
</button>
</div>
</td>
@php
$i++;
@endphp
@endforeach
<td>
<button type="submit" class="btn btn-success">Save</button>
</td>
</tr>
</form>
@endforeach
@endif
</tbody>
</table>
</div>
</div>
@endif
<script type="text/javascript">
$('.SubmitForm').submit(function (e) {
e.preventDefault();
$.ajax({
type: "POST",
url: "{{url('admin/examinations/submit_marks_register')}}",
data: $(this).serialize(),
dataType: "json",
success: function (data) {
alert(data.message);
}
});
});
$('.SaveSingleSubject').click(function (e) {
var student_id = $(this).attr('id');
var subject_id = $(this).attr('data-val');
var exam_id = $(this).attr('data-exam');
var class_id = $(this).attr('data-class');
var class_work = $('#class_work_' + student_id + subject_id).val();
var home_work = $('#home_work_' + student_id + subject_id).val();
var test_work = $('#test_work_' + student_id + subject_id).val();
var exam_work = $('#exam_work_' + student_id + subject_id).val();
$.ajax({
type: "POST",
url: "{{url('admin/examinations/single_submit_marks_register')}}",
data: {
"_token": "{{csrf_token()}}",
student_id: student_id,
subject_id: subject_id,
exam_id: exam_id,
class_id: class_id,
class_work: class_work,
home_work: home_work,
test_work: test_work,
exam_work: exam_work,
},
dataType: "json",
success: function (data) {
alert(data.message);
}
});
});
</script>
</body>
</html>
controller file-> this is the controller file
public function single_submit_marks_register(Request $request)
{
Log::info('Request Data:', $request->all());
$class_work = !empty($request->class_work) ? $request->class_work : 0;
$home_work = !empty($request->home_work) ? $request->home_work : 0;
$test_work = !empty($request->test_work) ? $request->test_work : 0;
$exam_work = !empty($request->exam_work) ? $request->exam_work : 0;
$getMark = marksregistermodel::CheckAlreadyMark($request->student_id, $request->exam_id, $request->class_id, $request->subject_id);
if (!empty($getMark)) {
$save = $getMark;
} else {
$save = new marksregistermodel;
$save->created_by = Auth::user()->id;
}
$save->student_id = $request->student_id;
$save->exam_id = $request->exam_id;
$save->class_id = $request->class_id;
$save->subject_id = $request->subject_id;
$save->class_work = $class_work;
$save->home_work = $home_work;
$save->test_work = $test_work;
$save->exam_work = $exam_work;
$save->save();
$json['message'] = "Mark Register Successfully Saved";
echo json_encode($json);
}
error logs
the following are the logs am recieving when I click the save button the class_id,subject_id,student_id are working fine but the rest are returning null
[2024-07-23 14:58:57] local.INFO: Request Data: {"_token":"NUxJAZgGntTF65oczF8elM3fudmIxTjYPqY5OyN4","student_id":"34","subject_id":"11","exam_id":"2","class_id":"4","class_work":null,"home_work":null,"test_work":null,"exam_work":null}
