Setting Up Laravel for API CRUD Operations on WampServer

1. Install Laravel

Open a terminal and navigate to the directory where you want to create your Laravel project. Run the following command:

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

Replace api-project with your desired project name.

2. Set Up Database

Open PHPMyAdmin and create a new database for your project.

3. Configure Environment

Rename the .env.example file in your project root directory to .env. Update the database connection settings in the .env file:

            
                DB_CONNECTION=mysql
                DB_HOST=127.0.0.1
                DB_PORT=3306
                DB_DATABASE=your_database_name
                DB_USERNAME=your_database_username
                DB_PASSWORD=your_database_password
            
        

4. Generate Application Key

Run the following command to generate an application key:

php artisan key:generate

5. Create User Model and Migration

Run the following command to create a user model and migration:

php artisan make:model User -m

6. Define User Schema

Open the migration file created for the user table and define the schema:

            
                public function up()
                {
                    Schema::create('users', function (Blueprint $table) {
                        $table->id();
                        $table->string('name');
                        $table->string('email')->unique();
                        $table->timestamp('email_verified_at')->nullable();
                        $table->string('password');
                        $table->rememberToken();
                        $table->timestamps();
                    });
                }
            
        

7. Run Migration

Run the following command to migrate the user table to your database:

php artisan migrate

8. Create API Routes

Open the routes/api.php file and define the API routes for CRUD operations:

            
                use App\Http\Controllers\UserController;
                Route::resource('users', UserController::class);
                Route::middleware('auth:sanctum')->get('/user', function (Request $request) {
                    return $request->user();
                });
            
        

9. Create UserController

Run the following command to create a UserController:

php artisan make:controller UserController

10. Implement CRUD Operations in UserController

Open the UserController and implement the CRUD operations:

            
                namespace App\Http\Controllers;
                use App\Models\User;
                use Illuminate\Http\Request;
                class UserController extends Controller
                {
                    public function index()
                    {
                        return User::all();
                    }
    
                    public function store(Request $request)
                    {
                        return User::create($request->all());
                    }
    
                    public function show(User $user)
                    {
                        return $user;
                    }
    
                    public function update(Request $request, User $user)
                    {
                        $user->update($request->all());
                        return $user;
                    }
    
                    public function destroy(User $user)
                    {
                        $user->delete();
                        return response()->json(['message' => 'User deleted']);
                    }
                }
            
        

11. Test the API

Run the Laravel Development Server

Run the following command:

php artisan serve

Use a tool like Postman to test your API endpoints (GET /users, POST /users, PUT /users/{id}, DELETE /users/{id}).

Use Postman to Test API Endpoints

• GET /users: Set the request type to GET and the URL to http://127.0.0.1:8000/api/users.
• POST /users: Set the request type to POST and the URL to http://127.0.0.1:8000/api/users. Add a JSON body with user data.
• PUT /users/{id}: Set the request type to PUT and the URL to http://127.0.0.1:8000/api/users/{id}. Add a JSON body with updated user data.
• DELETE /users/{id}: Set the request type to DELETE and the URL to http://127.0.0.1:8000/api/users/{id}.