Snippets

Jenny Rasmussen RSVP Site

Updated by Jenny Rasmussen
View revision

File AttendeeCheckController Deleted

  • Ignore whitespace
  • Hide word diff 
-<?php
-
-namespace App\Http\Controllers;
-
-use Illuminate\Http\Request;
-use Illuminate\Support\Facades\DB;
-
-class AttendeeCheckController extends Controller
-{
-    function checkAttendee() {
-        $first_name = $_POST['first_name'];
-        $last_name = $_POST['last_name'];
-        $building_num = $_POST['building_num'];
-
-        $data = DB::table('invites')
-            ->join('invites_names AS invite_name_first', function($join){
-                $join->on('invites.invite_id', '=', 'invite_name_first.invite_id')
-                    ->where('invite_name_first.name_type', '=', 'first');
-            })
-            ->join('names AS name_first', function($join){
-                $join->on('invite_name_first.name_id', '=', 'name_first.name_id');
-            })
-            ->join('invites_names AS invite_name_last', function($join){
-                $join->on('invites.invite_id', '=', 'invite_name_last.invite_id')
-                    ->where('invite_name_last.name_type', '=', 'last');
-            })
-            ->join('names AS name_last', function($join){
-                $join->on('invite_name_last.name_id', '=', 'name_last.name_id');
-            })
-            ->where([['name_first.name_text', '=', $first_name],['name_last.name_text', '=', $last_name],['invites.building_num', '=', $building_num]])
-            ->select('invites.invite_id')
-            ->get();
-
-        return $data;
-    }
-
-    function attendeeRsvp() {
-        $first_name = $_POST['first_name'];
-        $last_name = $_POST['last_name'];
-        $building_num = $_POST['building_num'];
-        $rsvp_num = (int)$_POST['rsvp_num'];
-
-        $data = DB::table('invites')
-            ->join('invites_names AS invite_name_first', function($join){
-                $join->on('invites.invite_id', '=', 'invite_name_first.invite_id')
-                    ->where('invite_name_first.name_type', '=', 'first');
-            })
-            ->join('names AS name_first', function($join){
-                $join->on('invite_name_first.name_id', '=', 'name_first.name_id');
-            })
-            ->join('invites_names AS invite_name_last', function($join){
-                $join->on('invites.invite_id', '=', 'invite_name_last.invite_id')
-                    ->where('invite_name_last.name_type', '=', 'last');
-            })
-            ->join('names AS name_last', function($join){
-                $join->on('invite_name_last.name_id', '=', 'name_last.name_id');
-            })
-            ->where([['name_first.name_text', '=', $first_name],['name_last.name_text', '=', $last_name],['invites.building_num', '=', $building_num]])
-            ->select('invites.invite_id')
-            ->get();
-
-        $result = DB::table('invites')
-            ->where([['invite_id', '=', $data->first()->invite_id], ['building_num', '=', $building_num]])
-            ->update(['rsvp_num' => $rsvp_num]);
-
-        if ($result === false) {
-            return view('try_again');
-        }
-
-        if ($rsvp_num === 0) {
-            return view('miss_you');
-        }
-
-        if($rsvp_num !== 0) {
-            return view('thank_you');
-        }
-    }
-}

File AttendeeCheckController.php Added

  • Ignore whitespace
  • Hide word diff 
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+
+class AttendeeCheckController extends Controller
+{
+    function checkAttendee() {
+        $first_name = $_POST['first_name'];
+        $last_name = $_POST['last_name'];
+        $building_num = $_POST['building_num'];
+
+        $data = DB::table('invites')
+            ->join('invites_names AS invite_name_first', function($join){
+                $join->on('invites.invite_id', '=', 'invite_name_first.invite_id')
+                    ->where('invite_name_first.name_type', '=', 'first');
+            })
+            ->join('names AS name_first', function($join){
+                $join->on('invite_name_first.name_id', '=', 'name_first.name_id');
+            })
+            ->join('invites_names AS invite_name_last', function($join){
+                $join->on('invites.invite_id', '=', 'invite_name_last.invite_id')
+                    ->where('invite_name_last.name_type', '=', 'last');
+            })
+            ->join('names AS name_last', function($join){
+                $join->on('invite_name_last.name_id', '=', 'name_last.name_id');
+            })
+            ->where([['name_first.name_text', '=', $first_name],['name_last.name_text', '=', $last_name],['invites.building_num', '=', $building_num]])
+            ->select('invites.invite_id')
+            ->get();
+
+        return $data;
+    }
+
+    function attendeeRsvp() {
+        $first_name = $_POST['first_name'];
+        $last_name = $_POST['last_name'];
+        $building_num = $_POST['building_num'];
+        $rsvp_num = (int)$_POST['rsvp_num'];
+
+        $data = DB::table('invites')
+            ->join('invites_names AS invite_name_first', function($join){
+                $join->on('invites.invite_id', '=', 'invite_name_first.invite_id')
+                    ->where('invite_name_first.name_type', '=', 'first');
+            })
+            ->join('names AS name_first', function($join){
+                $join->on('invite_name_first.name_id', '=', 'name_first.name_id');
+            })
+            ->join('invites_names AS invite_name_last', function($join){
+                $join->on('invites.invite_id', '=', 'invite_name_last.invite_id')
+                    ->where('invite_name_last.name_type', '=', 'last');
+            })
+            ->join('names AS name_last', function($join){
+                $join->on('invite_name_last.name_id', '=', 'name_last.name_id');
+            })
+            ->where([['name_first.name_text', '=', $first_name],['name_last.name_text', '=', $last_name],['invites.building_num', '=', $building_num]])
+            ->select('invites.invite_id')
+            ->get();
+
+        $result = DB::table('invites')
+            ->where([['invite_id', '=', $data->first()->invite_id], ['building_num', '=', $building_num]])
+            ->update(['rsvp_num' => $rsvp_num]);
+
+        if ($result === false) {
+            return view('try_again');
+        }
+
+        if ($rsvp_num === 0) {
+            return view('miss_you');
+        }
+
+        if($rsvp_num !== 0) {
+            return view('thank_you');
+        }
+    }
+}
Created by Jenny Rasmussen
View revision

File AttendeeCheckController Added

  • Ignore whitespace
  • Hide word diff 
+<?php
+
+namespace App\Http\Controllers;
+
+use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+
+class AttendeeCheckController extends Controller
+{
+    function checkAttendee() {
+        $first_name = $_POST['first_name'];
+        $last_name = $_POST['last_name'];
+        $building_num = $_POST['building_num'];
+
+        $data = DB::table('invites')
+            ->join('invites_names AS invite_name_first', function($join){
+                $join->on('invites.invite_id', '=', 'invite_name_first.invite_id')
+                    ->where('invite_name_first.name_type', '=', 'first');
+            })
+            ->join('names AS name_first', function($join){
+                $join->on('invite_name_first.name_id', '=', 'name_first.name_id');
+            })
+            ->join('invites_names AS invite_name_last', function($join){
+                $join->on('invites.invite_id', '=', 'invite_name_last.invite_id')
+                    ->where('invite_name_last.name_type', '=', 'last');
+            })
+            ->join('names AS name_last', function($join){
+                $join->on('invite_name_last.name_id', '=', 'name_last.name_id');
+            })
+            ->where([['name_first.name_text', '=', $first_name],['name_last.name_text', '=', $last_name],['invites.building_num', '=', $building_num]])
+            ->select('invites.invite_id')
+            ->get();
+
+        return $data;
+    }
+
+    function attendeeRsvp() {
+        $first_name = $_POST['first_name'];
+        $last_name = $_POST['last_name'];
+        $building_num = $_POST['building_num'];
+        $rsvp_num = (int)$_POST['rsvp_num'];
+
+        $data = DB::table('invites')
+            ->join('invites_names AS invite_name_first', function($join){
+                $join->on('invites.invite_id', '=', 'invite_name_first.invite_id')
+                    ->where('invite_name_first.name_type', '=', 'first');
+            })
+            ->join('names AS name_first', function($join){
+                $join->on('invite_name_first.name_id', '=', 'name_first.name_id');
+            })
+            ->join('invites_names AS invite_name_last', function($join){
+                $join->on('invites.invite_id', '=', 'invite_name_last.invite_id')
+                    ->where('invite_name_last.name_type', '=', 'last');
+            })
+            ->join('names AS name_last', function($join){
+                $join->on('invite_name_last.name_id', '=', 'name_last.name_id');
+            })
+            ->where([['name_first.name_text', '=', $first_name],['name_last.name_text', '=', $last_name],['invites.building_num', '=', $building_num]])
+            ->select('invites.invite_id')
+            ->get();
+
+        $result = DB::table('invites')
+            ->where([['invite_id', '=', $data->first()->invite_id], ['building_num', '=', $building_num]])
+            ->update(['rsvp_num' => $rsvp_num]);
+
+        if ($result === false) {
+            return view('try_again');
+        }
+
+        if ($rsvp_num === 0) {
+            return view('miss_you');
+        }
+
+        if($rsvp_num !== 0) {
+            return view('thank_you');
+        }
+    }
+}
HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.