LARAVEL: DATA FETCH USING COMPACT AND ARRAY [[ DB QUERY ]]
bunny>> index.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>
{{-- Bunny cafe data show table --}}
<table>
<tr>
<td>Persons</td>
<td>Orders</td>
<td></td>
</tr>
@foreach($data as $i)
<tr>
<td>{{$i->person}}</td>
<td>{{$i->orders}}</td>
</tr>
@endforeach
</table>
<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>
Controllers >> bunnyController.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use DB;
class bunnyController extends Controller
{
//
public function show_data(){
$data = DB::table('cafebookings')->get();
// return view('bunny.index',compact('data'));
return view('bunny.index',['data'=>$data]);
}
}
Routes >> Web.php
Route::get('/',[BunnyController::class,'show_data']);
Comments
Post a Comment