How to update profile picture in Laravel Database

Step 1: Install Laravel 5.7 Project

To create a new Laravel 5.7 project, open your terminal or command prompt and run the following command:

composer create-project --prefer-dist laravel/laravel blog

Step 2: Database Configuration

After installation, configure your database connection in the .env file. Set the following environment variables for MySQL:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=management_system
DB_USERNAME=root
DB_PASSWORD=123456

Ensure that your MySQL database is running and the database management_system exists.

Step 3: Define Routes

In routes/web.php, Define the routes for the user profile and avatar upload functionality:

// ======================== avatar ======================== //
Route::post('profile', 'HomeController@update_avatar');

This route will handle the avatar update functionality via a POST request.

Step 4: Create the HomeController

Now, create a controller HomeController.php where the logic for updating the user's profile picture will reside.

Run the following command to generate the controller:

php artisan make:controller HomeController

Add the following methods to HomeController.php:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Auth;
use Image;

class HomeController extends Controller
{
    // Display profile page with user information
    public function profile()
    {
        $user = Auth::user();
        return view('dashboard.index', compact('user'));
    }

    // Handle avatar update
    public function update_avatar(Request $request)
    {
        // Validate the uploaded avatar
        $request->validate([
            'avatar' => 'required|image|mimes:jpeg,png,jpg,gif,svg|max:2048',
        ]);

        // Get authenticated user
        $user = Auth::user();

        // Handle avatar file upload
        $avatar = $request->file('avatar');
        $avatarName = $user->id . '_profile_' . time() . '.' . $avatar->getClientOriginalExtension();

        // Resize and save the avatar
        Image::make($avatar)->resize(300, 300)->save(public_path('/files/assets/images/' . $avatarName));

        // Store the avatar name and save to the user's profile
        $request->avatar->storeAs('avatar', $avatarName);
        $user->avatar = $avatarName;
        $user->save();

        // Redirect back with success message
        return back()->with('success', 'Profile updated successfully!');
    }
}

Step 5: Add Image Intervention Service Provider

Next, you need to add the Intervention Image package to handle image resizing and manipulation.

First, install the Intervention Image package via composer:

composer require intervention/image

'providers' => [
    // Other providers
    Intervention\Image\ImageServiceProvider::class,
],

Add the alias in the aliases array:

'aliases' => [
    // Other aliases
    'Image' => Intervention\Image\Facades\Image::class,
],

This will enable the image manipulation functionality in your application.

Step 6: Frontend Form for Avatar Upload

Create a form in the frontend where the user can upload their avatar. For example, in resources/views/dashboard/index.blade.php:

<form action="{{ url('profile') }}" method="POST" enctype="multipart/form-data">
    @csrf
    <div class="form-group">
        <label for="avatar">Update Profile Picture</label>
        <input type="file" name="avatar" id="avatar" class="form-control" required>
    </div>

    @if(session('success'))
        <div class="alert alert-success">{{ session('success') }}</div>
    @endif

    <button type="submit" class="btn btn-primary">Update Avatar</button>
</form>

This form will send the uploaded avatar to the update_avatar method in HomeController.

Step 7: Displaying the Avatar

In your view, you can display the user's avatar using the following:

<img src="{{ asset('files/assets/images/' . $user->avatar) }}" alt="User Avatar" width="100" height="100">

Final Notes:

Ensure the public folder is properly configured to store and access the image files.
You can customize the validation rules and image resizing and save locations per your project’s requirements.
Ensure the proper setup of storage symlink if you're storing avatars in the storage folder by running:

php artisan storage:link

This will make sure that your images stored in storage/app/public are publicly accessible.

Souy Soeng