View:
<div class="container card" style="padding:20px">
@if (session('msg'))
<div class="alert alert-success">
{{ session('msg') }}
</div>
@endif
<h3 style="text-align: center;">Registration Form</h3>
<form action="{{route('submit_records')}}" method="post">
<div class="form-group">
<label>Name</label>
<input type="text" name="name" id="name" class="form-control" />
</div><br/>
@csrf
<div class="form-group">
<label>Email</label>
<input type="text" name="email" id="email" class="form-control" />
</div><br/>
<div class="form-group">
<label>What is your favarate fruits</label><br/>
Mango : <input type="checkbox" name="fruits[]" value="mango" />
Apple : <input type="checkbox" name="fruits[]" value="apple" />
Banana : <input type="checkbox" name="fruits[]" value="banana" />
Orange : <input type="checkbox" name="fruits[]" value="orange" />
</div><br/>
<div class="form-group">
<label>Message</label>
<textarea class="form-control" id="message" name="msg"></textarea>
</div><br/>
<button class="btn btn-success" id="submit" type="submit">Submit</button>
</form>
</div>
Fetch Data:
<?php
$fruits = DB::table('fruits')->get();
foreach($fruits as $fr){
$arr = explode(",",$fr->fruits);
foreach($arr as $ar){
echo $ar.'<br/>';
}
}
?>
Insert Data:
function submit_records(Request $req){
$name = $req->name;
$email = $req->email;
$fruits = $req->fruits;
$msg = $req->msg;
$str = implode(",",$fruits);
$query = DB::table('fruits')->insert([
'name' => $name,
'email' => $email,
'fruits' => $str,
'msg' => $msg,
]);
if($query){
return back()->with('msg', 'Successfully Inserted !');
}
else{
return back()->with('msg', 'Successfully Failled !');
}
}