Ignore:
Timestamp:
02/08/24 16:34:49 (11 months ago)
Author:
bube-ristovska <ristovska725@…>
Branches:
main
Children:
d9c4096
Parents:
cf84baa
Message:

Cases listing

File:
1 edited

Legend:

Unmodified
Added
Removed
  • app/Http/Controllers/CrimeCaseController.php

    rcf84baa r6dec591  
    44
    55use Illuminate\Http\Request;
    6 
     6use Illuminate\Support\Facades\DB;
     7use Illuminate\Support\Facades\Session;
    78class CrimeCaseController extends Controller
    89{
    910    function cases(){
    10         return view('cases');
     11
     12        $police_station= DB::select('select * from police_station where pe_id=:pe_id;',['pe_id'=> Session::get('pe_id')]);
     13        $cases = DB::select('select * from crime_case where p_id=:p_id;',['p_id'=> $police_station[0]->p_id]);
     14
     15        return view('cases', [
     16            'cases' => $cases
     17        ]);
     18
    1119    }
    1220    function case(){
Note: See TracChangeset for help on using the changeset viewer.