Changeset cf84baa for app/Http/Controllers/PeopleController.php

Timestamp:

02/08/24 16:15:01 (11 months ago)

Author:

bube-ristovska <ristovska725@…>

Branches:

main

Children:

6dec591

Parents:

6b10b67

Message:

Added querries half done

File:

• app/Http/Controllers/PeopleController.php (modified) (1 diff)

app/Http/Controllers/PeopleController.php

@@ -4 +4 @@
 
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
 
 class PeopleController extends Controller
 {
     function filter(){
-        return view('filter');
+        $peoples = DB::select('select * from people;');
+
+        return view('filter', [
+            'peoples' => $peoples
+        ]);
+    }
+    function filter_post(){
+        $credentials = request()->validate([
+            'embg' => 'required'
+        ]);
+        $embg = $credentials['embg'];
+
+        $peoples = DB::select('SELECT * FROM people WHERE embg ~ :embg', ['embg' =>  '^' . $embg]);
+
+        return view('filter', [
+            'peoples' => $peoples
+        ]);
     }
 }