PHP 连接 clickhouse 数据库

php 没有直接的包来连接数据库 需要自己搭建或者找到相应的包 我是从网站上直接找打包 直接使用可以成功的连接https://github.com/smi2/phpClickHouse/tree/e27b04d482e9922df8bf1ea0880bf2985d2e06d0

连接数据库并获取数据

<?php
include_once __DIR__ . '/phpClickHouse-master/include.php';

$config =[ //connect db
    'host' => '',
    'port' => '',
    'username' => '',
    'password' => '',
    'auth_method' => 1, // On of HTTP::AUTH_METHODS_LIST
];

$db = new ClickHouseDB\Client($config);
//$db->verbose();
$db->settings()->readonly(false);

$result = $db->select(
    'SELECT * from tb where date>\'2022-01-01\' and date<\'2022-02-01\' order by date desc limit 100',
);
$result->fetchOne();
$result->rows();
print_r($result);
?>