问下有没有人用laravel连接过金仓数据库的？

sudo apt-get install php-odbcCopy

extension=odbcCopy

DB_CONNECTION=kingbase
DB_HOST=your-kingbase-host
DB_PORT=54321
DB_DATABASE=your-database-name
DB_USERNAME=your-username
DB_PASSWORD=your-passwordCopy

'connections' => [
    // Other connections...

    'kingbase' => [
        'driver' => 'pgsql',  // 如果是基于 PostgreSQL 的 KingbaseES，可以使用 pgsql 驱动
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '54321'),
        'database' => env('DB_DATABASE', 'your-database-name'),
        'username' => env('DB_USERNAME', 'your-username'),
        'password' => env('DB_PASSWORD', 'your-password'),
        'charset' => 'utf8',
        'prefix' => '',
        'schema' => 'public',  // 根据你的金仓数据库的实际情况调整
        'sslmode' => 'prefer',
    ],
],Copy

php artisan migrateCopy

use Illuminate\Support\Facades\DB;

Route::get('/test-kingbase', function () {
    $results = DB::connection('kingbase')->select('SELECT * FROM your_table');
    return response()->json($results);
});Copy

wget -O kbodbc.tar.gz https://kingbase.oss-cn-beijing.aliyuncs.com/KES_INTERFACE/V9/odbc/x86/v9r1_odbc_x86_64.tar.gz

mkdir -p /mnt/kingbase && tar xvf kbodbc.tar.gz --directory=/mnt/kingbase && chown -R 755 /mnt/kingbase

# debian / ubuntu
# 使用sury源
apt install unixodbc php7.4-odbc

# RHEL / Alma / Rocky 使用 remi 源
dnf install php74-php-odbc unixODBCCopy