在Laravel中从外部数据库导入数据

DB_CONNECTION=external
DB_HOST=external-host
DB_PORT=external-port
DB_DATABASE=external-db
DB_USERNAME=external-user
DB_PASSWORD=external-password

'connections' => [
    'external' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST', 'external-host'),
        'port' => env('DB_PORT', 'external-port'),
        'database' => env('DB_DATABASE', 'external-db'),
        'username' => env('DB_USERNAME', 'external-user'),
        'password' => env('DB_PASSWORD', 'external-password'),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'strict' => true,
        'engine' => null,
    ],
],

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class ExternalData extends Model
{
    protected $connection = 'external';
    protected $table = 'external_table';
}

$externalData = ExternalData::all();
foreach ($externalData as $data) {
    // 处理数据导入逻辑，例如将数据插入本地数据库
}