Laravel insert and display multiple records

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" /> &nbsp; 
Apple : <input type="checkbox" name="fruits[]" value="apple" /> &nbsp; 
Banana : <input type="checkbox" name="fruits[]" value="banana" /> &nbsp; 
Orange : <input type="checkbox" name="fruits[]" value="orange" /> &nbsp; 
</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 !');
}

}

 

 

 

Leave a Reply