在数据库(Laravel)中以JSON的形式存储来自PHP Guzzle的响应

composer require guzzlehttp/guzzle

php artisan make:model ApiResponse -m

// database/migrations/xxxx_xx_xx_xxxxxx_create_api_responses_table.php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateApiResponsesTable extends Migration
{
    public function up()
    {
        Schema::create('api_responses', function (Blueprint $table) {
            $table->id();
            $table->json('response');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('api_responses');
    }
}

php artisan migrate

php artisan make:controller ApiController

// app/Http/Controllers/ApiController.php

namespace App\Http\Controllers;

use App\Models\ApiResponse;
use GuzzleHttp\Client;

class ApiController extends Controller
{
    public function fetchData()
    {
        $client = new Client();
        $response = $client->get('https://api.example.com/data');

        $data = json_decode($response->getBody(), true);

        $apiResponse = new ApiResponse();
        $apiResponse->response = $data;
        $apiResponse->save();

        return response()->json(['message' => 'Data fetched and saved successfully.']);
    }
}

use App\Http\Controllers\ApiController;

Route::get('/fetch-data', [ApiController::class, 'fetchData']);