LARAVEL: SELECT2 DATATABLES INSERT IMPLODE COMPACT [[ DATA INSERT & FETCH ]]
Avenger.blade.php >>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
<title>Cafe</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
</head>
<body>
<form method="post" action="/order_action">
@csrf
<div class="mb-3">
<label for="" class="form-label">No of Person/s: </label>
<select name="person[]" id="table" multiple="multiple" class="form-control js-example-basic-multiple">
<option value="1">1</option>
<option value="2">2</option>
<option value="4">4</option>
<option value="6">6</option>
<option value="8">8</option>
<option value="20">20</option>
</select>
<script>
$(document).ready(function() {
$('.js-example-basic-multiple').select2();
});
</script>
</div>
<div class="mb-3">
<label for="" class="form-label">Orders: </label>
<select name="orders[]" id="orders" multiple="multiple" class="form-control js-example-basic-multiple2">
<option value="tandooriRoti">Tandoori Roti</option>
<option value="aluParatha">Alu Paratha</option>
<option value="chickenTikker">Chicken Tikka</option>
<option value="malaiPaneer">Malai Paneer</option>
<option value="mixVeg">Mix Veg</option>
</select>
<script>
$(document).ready(function() {
$('.js-example-basic-multiple2').select2();
});
</script>
</div>
<button type="submit" class="btn btn-primary">Submit</button>
</form>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>
</body>
</html>
Order_data.blade.php
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Bootstrap CSS -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.0/css/all.min.css" integrity="sha512-xh6O/CkQoPOWDdYTDqeRdPCVd1SpvCA9XXcUnZS2FmJNp1coAFzvtCN9BmamE+4aHK8yyUHUSCcJHgXloTyT2A==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<title>DATE: 5/9/22</title>
<!-- -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<!-- -->
<!-- -->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.12.1/css/jquery.dataTables.css">
<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.js"></script>
<!-- -->
</head>
<body
style=" font-family: 'Julius Sans One', sans-serif; background:linear-gradient(#b6c3e8,#1d803a99); background-size: 100vw 100vh; background-repeat: no-repeat; background-attachment: fixed; ">
<!-- <marquee behavior="scroll" direction="right"><h6>Sk SAIFUDDIN</h6></marquee> -->
<div class="col-sm-9 col-md-6 col-lg-8 mt-3">
<h3 class="text-center fw-bolder"> Details of Users </h3>
<div class="mb-2 table-responsive">
<table class="table align-middle table-hover table-sm" id="table_id">
<thead>
<tr>
<td>No of Person</td>
<td>Orders</td>
</tr>
</thead>
<tbody>
@foreach ($data as $items)
<tr>
<td>{{ $items['person']}}</td>
<td>{{ $items['orders']}}</td>
</tr>
@endforeach
</tbody>
</table>
<script>
$(document).ready( function () {
$('#table_id').DataTable();
} );
</script>
<!-- display ends -->
</div>
<script src = "https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity = "sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin = "anonymous"></script>
</body>
</html>
Web.php [Route] >>
Route::get('/', function () {
return view('avenger');
});
Route::post('/order_action',[CafeController::class,'order_action'])->name('order_action');
Route::get('/all_orders',[CafeController::class,'all_orders'])->name('all_orders');
CafeController.php [Controller] >>
<?php
namespace App\Http\Controllers;
use App\Models\cafe;
use Illuminate\Http\Request;
use App\Models\cafebooking;
class CafeController extends Controller
{
public function order_action(Request $req){
$data= new cafebooking;
$data->person = implode(', ',$req->person);
$data->orders = implode(', ',$req->orders);
$data->save();
return redirect('all_orders');
}
public function all_orders(){
$data=cafebooking::all();
return view('order_data',compact('data'));
}
}
Comments
Post a Comment