اتصال به دیتابیس ClickHouse در برنامه‌های PHP

composer require smi2/phpclickhouse

CLICKHOUSE_HOST=rainier.liara.cloud
CLICKHOUSE_PORT=33273
CLICKHOUSE_DATABASE=default
CLICKHOUSE_USERNAME=root
CLICKHOUSE_PASSWORD=x4y2LJvdFyG5wVO87VbXDrpg

<?php

require __DIR__ . '/vendor/autoload.php';

use DotenvDotenv;
use ClickHouseDBClient;

$dotenv = Dotenv::createImmutable(__DIR__);
$dotenv->load();

$client = new Client([
  'host' => $_ENV['CLICKHOUSE_HOST'],
  'port' => $_ENV['CLICKHOUSE_PORT'],
  'username' => $_ENV['CLICKHOUSE_USERNAME'],
  'password' => $_ENV['CLICKHOUSE_PASSWORD'],
]);

$client->database($_ENV['CLICKHOUSE_DATABASE']);

try {

  $result = $client->select('SELECT 1');

  echo json_encode([
      'success' => true,
      'message' => 'ClickHouse connection successful',
      'result' => $result->rows(),
  ], JSON_PRETTY_PRINT);

} catch (Exception $e) {

  echo json_encode([
      'success' => false,
      'message' => $e->getMessage(),
  ], JSON_PRETTY_PRINT);

}