Level 51
You can use insert method which accept array as argument
Semester1::insert($data);
Jun 7, 2018
8
Level 2
how to insert multiple rows in mysql using laravel
This is my view and data come into multipal form so please help me to insert all data into database with sql query
@csrf() ENROLL NO. STUDENT NAME CLASS ROLL NO. ABSENT/PRESENT @foreach($student as $stu) <tr style="border: 1px solid #f2f2f2;">
<td><input type="text" name="enroll_no" class="form-control" value="{{$stu->enroll_no}}"></td>
<td><input type="text" name="student_name" class="form-control" value="{{$stu->student_name}}"></td>
<td>{{$loop->index+1}}</td>
<td>
<div class="form-check">
<label class="form-check-label">
<input style="zoom:2;" name="present" class="form-control" type="checkbox" value="P"> Absent/Present
</label>
</div>
</td>
</tr>
@endforeach
</tbody>
my controller
public function sem1_C(Request $request) { $sem1= new Semester1; $sem1->enroll_no= $request->enroll_no; $sem1->student_name= $request->student_name; $sem1->present_Absent = $request->present; $sem1->save(); $class_name = ClassAdd::all(); $student = DB::table('students')->where('class_name', '=', 1)->get(); return view('teacher.sem1',compact('student')); }
Level 2
no its not working
Level 67
It needs to be an array, of arrays.
// insert these 2 records
$data = [
['something' => value1, 'somethingElse' => anotherValue1], // record 1
['something' => value2, 'somethingElse' => anotherValue2], // record 2
];
Model::insert($data);
all fields being inserted (something and somethingElse in this example) need to be in the $fillable array on the Model.
4 likes
Level 2
thank you for your reply sir, but i want to save data in my database throw foreach loop so how i impliment foreach loop in my controller to save or insert record into database
please help me
Level 5
@foreach($student as $stu)
<tr style="border: 1px solid #f2f2f2;">
<td><input type="text" name="enroll_no[]" class="form-control" value="{{$stu->enroll_no}}"></td>
<td><input type="text" name="student_name[]" class="form-control" value="{{$stu->student_name}}"></td>
<td>{{$loop->index+1}}</td>
<td>
<div class="form-check">
<label class="form-check-label">
<input style="zoom:2;" name="present[]" class="form-control" type="checkbox" value="P"> Absent/Present
</label>
</div>
</td>
</tr>
@endforeach
</tbody>
Then in your controller
$enroll_no = $request->enroll_no;
$student_name = $request->student_name;
$present= $request->present;
foreach($enroll_no as $key => $no)
{
$input['enroll_no'] = $no;
$input['student_name '] = $student_name[$key];
$input['present'] = $present[$key];
Model::create($input);
}
3 likes
Level 2
its working properly but i get an error that was\
SQLSTATE[HY000]: General error: 1364 Field 'student_name' doesn't have a default value (SQL: insert into semester1s (enroll_no, present_Absent, updated_at, created_at) values (16/0889, P, 2018-06-07 20:38:01, 2018-06-07 20:38:01))
Level 2
config/database.php
file and set 'strict' => false for your connection.
if do this then its working but student name can not be entered so how can i resolve this error
Level 2
i found my error its an small error and thank so much for supporting me
Please or to participate in this conversation.