Index: app/Http/Controllers/CrimeCaseController.php
===================================================================
--- app/Http/Controllers/CrimeCaseController.php	(revision cf84baa56f694b471c891665131a4f1cabaa2e6f)
+++ app/Http/Controllers/CrimeCaseController.php	(revision 6dec591cfad31fdb54669591faf1e2b0a02bcb64)
@@ -4,9 +4,17 @@
 
 use Illuminate\Http\Request;
-
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Session;
 class CrimeCaseController extends Controller
 {
     function cases(){
-        return view('cases');
+
+        $police_station= DB::select('select * from police_station where pe_id=:pe_id;',['pe_id'=> Session::get('pe_id')]);
+        $cases = DB::select('select * from crime_case where p_id=:p_id;',['p_id'=> $police_station[0]->p_id]);
+
+        return view('cases', [
+            'cases' => $cases
+        ]);
+
     }
     function case(){
Index: app/Http/Controllers/SessionsController.php
===================================================================
--- app/Http/Controllers/SessionsController.php	(revision cf84baa56f694b471c891665131a4f1cabaa2e6f)
+++ app/Http/Controllers/SessionsController.php	(revision 6dec591cfad31fdb54669591faf1e2b0a02bcb64)
@@ -13,5 +13,4 @@
     public function store()
     {
-
         $credentials = request()->validate([
             'badge_no' => 'required',
@@ -42,4 +41,5 @@
             Session::put('badge_no', $badge_no);
             Session::put('is_policeman', $policeman);
+            Session::put('pe_id', $exists[0]->pe_id);
             return redirect()->intended('/');
         }
Index: resources/views/cases.blade.php
===================================================================
--- resources/views/cases.blade.php	(revision cf84baa56f694b471c891665131a4f1cabaa2e6f)
+++ resources/views/cases.blade.php	(revision 6dec591cfad31fdb54669591faf1e2b0a02bcb64)
@@ -153,28 +153,14 @@
                         </thead>
                         <tbody class="text-gray-700">
-                        <tr>
-                            <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/namehere">Подморница</a></td>
-                            <td class="w-1/3 text-left py-3 px-4">2023-11-27</td>
-                            <td class="w-1/3 text-left py-3 px-4">A</td>
-                            <td class="w-1/3 text-left py-3 px-4">Кире Петков</td>
-                        </tr>
-                        <tr>
-                            <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/namehere">Хакери</a></td>
-                            <td class="w-1/3 text-left py-3 px-4">2011-03-03</td>
-                            <td class="w-1/3 text-left py-3 px-4">Z</td>
-                            <td class="w-1/3 text-left py-3 px-4">Петко Кирев</td>
-                        </tr>
-                        <tr>
-                            <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/namehere">Тероризам</a></td>
-                            <td class="w-1/3 text-left py-3 px-4">2016-02-01</td>
-                            <td class="w-1/3 text-left py-3 px-4">A</td>
-                            <td class="w-1/3 text-left py-3 px-4">Наташа Илиева</td>
-                        </tr>
-                        <tr>
-                            <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/namehere">Киднапирање</a></td>
-                            <td class="w-1/3 text-left py-3 px-4">2022-08-27</td>
-                            <td class="w-1/3 text-left py-3 px-4">A</td>
-                            <td class="w-1/3 text-left py-3 px-4">Наташа Илиева</td>
-                        </tr>
+                        @foreach($cases as $case)
+                            <tr>
+                                <td class="text-left py-3 px-4"><a class="hover:text-blue-500" href="/case/{{$case->c_id}}">{{$case->c_name}}</a></td>
+                                <td class="w-1/3 text-left py-3 px-4">{{$case->opening_date}}</td>
+                                <td class="w-1/3 text-left py-3 px-4">{{$case->c_status}}</td>
+                                <td class="w-1/3 text-left py-3 px-4">{{$case->p_id}}</td>
+                            </tr>
+                        @endforeach
+
+
                         </tbody>
                     </table>