How to store data to database in LARAVEL 5.2

Title: Handling Form Data and Storing it in Database using Laravel 5.2 Introduction: In this comprehensive tutorial, we'll focus on how to handle form data from user input and store the values into a database using Laravel 5.2. We'll start by explaining how the form data is accessed through controller actions, then go over the basics of model creation and data manipulation, and finally discuss some best practices for ensuring data integrity in your application. Step 1: Understanding Form Data Access with Laravel 5.2 In Laravel, you can access form data using the request object provided by the framework. The request object is a convenient way to receive user input from any incoming requests. Here's an example of a controller action that handles storing data related to users:

public function store(Request $request) {
    // Access form data using the request object
    $name = $request->input('job');
    $selected_machine = $request->select('machine');
    // Save the data in your database using Eloquent or Query Builder
}

Step 2: Creating Models for Data Storage In order to store and retrieve data from the database, you need to define your models. You can either extend Laravel's base model Eloquent or use the Query Builder approach. In this example, we'll create a Job model using Eloquent:

class Job extends Model {
    protected $table = 'jobs'; // Define table name for your model in the database

    // Define fillable attributes (columns) of your model
    protected $fillable = ['user_job', 'machine'];
}

Step 3: Handling Form Fields with Different Names Sometimes, you may encounter cases where the name on a form field differs from the column name in the database. In such scenarios, you can use Eloquent's Mass Assignment feature to map the fields as per your requirement. Here's an example:

class Job extends Model {
    protected $table = 'jobs';

    // Define custom attributes and their mapping to columns in the database
    protected $casts = [
        'user_job' => 'user-name',
        'machine' => 'machine-id'
    ];
}

Step 4: Storing Data in Your Database with Eloquent With the model defined, you can store data from form inputs using the create method of your job model. Here's an example:

public function store(Request $request) {
    $this->validate($request, [
        'job' => 'required',
        'machine' => 'required'
    ]);

    // Access form data as before and create a new Job object
    $input = $request->all();
    SpkAdmin::create($input);
}

Step 5: Handling Data Errors and Exceptional Cases To ensure proper handling of user input, it's crucial to validate the data before storing it in the database. This can be accomplished by adding validation rules to your controller action's method signature or using Laravel's built-in validation features. In case of any errors, you should also handle them appropriately by showing relevant error messages or redirecting the user back to the form with the input values preserved. Conclusion: With these steps in mind, you can now build a robust system for handling and storing data from forms in your Laravel 5.2 application. This process involves understanding request data access, defining models for data storage, mapping fields as per database requirements, and validating user input before saving it to the database. Remember that proper data integrity and security are crucial aspects of any web application, so always take necessary measures to ensure the data is stored accurately and securely in your database.