Form Data & HTTP Post Handlers

In this episode, we begin capturing and storing survey data!

We’ll design the database schema for responses and answers, build out models, and wire up the controller logic to handle incoming survey submissions.

This continues our journey of transforming a static survey page into a dynamic Laravel application — step by step, the pragmatic way.

🧠 What You’ll Learn
- Designing survey_responses and survey_response_answers tables
- Creating migrations and Eloquent models
- Defining relationships between surveys, responses, and answers
- Updating POST routes to save incoming data
- Setting up a foundation for validation and fingerprinting

🧩 Commands Used
- php artisan make:migration create_survey_responses_table
- php artisan make:model SurveyResponse

🧱 Database Schema
survey_responses
- id (PK)
- survey_id (FK: surveys)
- user_fingerprint
- completed_at (nullable)
- created_at / updated_at

survey_response_answers
- id (PK)
- survey_response_id (FK: survey_responses)
- survey_question_id (FK: survey_questions)
- answer (json)
- created_at / updated_at

🔗 Resources
- Migrations Docs: https://laravel.com/docs/12.x/migrations
- Eloquent Docs: https://laravel.com/docs/12.x/eloquent
- Routing Docs: https://laravel.com/docs/12.x/routing

#Laravel #PHP #WebDevelopment #Eloquent #DatabaseDesign #Migrations #TekCasts #LearnLaravel #FullStackDevelopment #Controllers