php 链接 clickhouse

一、通过pypclickhouse插件连接ck数据库

　　　博主用的1.1.2因为我们公司使用的php5点几版本，这是最高支持
　　   插件地址：https://github.com/smi2/phpClickHouse/tree/e27b04d482e9922df8bf1ea0880bf2985d2e06d0

　　

 

使用默认配置去连接 clickhouse
错误：Fatal error: Call to undefined function curl_init()
解决：在php.ini 文件中 将 extension=php_curl.dll 前的分号去掉
错误：Warning: PHP Startup: Unable to load dynamic library 'C:phpextphp_curl.dll
因为刚才php.ini文件引入的 php_curl.dll 文件系统默认在 ‘C:/php/ext/’下去找
两种解决方式，把该文件拷贝过去，或者php.ini中配置查找路径：
; extension_dir = "./"
; On windows:
extension_dir = "ext" #将此行前面分号去掉

 

 

<?php
include_once __DIR__ . '/third_party/phpclickhouse1.1.2/include.php';

$config = [
    'host' => '10.222.1.213',
    'port' => '8123',
    'username' => 'sangfor',
    'password' => 'sangfor123'
];
$tb_name = 'netflow';


$db_conn = new ClickHouseDBClient($config);
$db_conn->database('test');
$db_conn->setTimeout(1.5);      // 1500 ms
$db_conn->setTimeout(10);       // 10 seconds
$db_conn->setConnectTimeOut(5); // 5 seconds

$db_conn->ping();

function zifll($param,$char='0')
{
    if(!is_string($param))
    {
        $param = (string)$param;
    }
    if(strlen($param)<2)
    {
        $param = "0".$param;
    }
    else if(strlen($param)>2)
    {
        $param = substr($param,strlen($param)-2);
    }
    return $param;
}

$sql = "update {$tb_name} set record_time=";

$param = array(
    'time_range'=>"2020-05-03 00:00:00|2020-07-07 00:00:00",
    'src_ip'=>"192.168.0.1",
    'src_port'=>8080,
    'dst_ip'=>'',
    'dst_port'=>null,
    'page'=>0
);

function get_query_sql($param)
{
    $query_sql = "select * from test.netflow ";
    if(empty($param)||!is_array($param))
    {
        echo "No paramter!";
        exit();
    }
    $time_rage = explode("|",$param["time_range"]);
    if($time_rage[0])
    {
       $query_sql .= "where ";
       $query_sql .= "record_time > '{$time_rage[0]}' ";
    }
    if($time_rage[1])
    {
        $query_sql .= "and ";
        $query_sql .= "record_time < '{$time_rage[1]}' ";
    }
//    array_splice($param,"time_range");
    unset($param["time_range"]);
    foreach($param as $key=>$value)
    {
        if(isset($param[$key]))
        {
            if ($key=="page"){
                $offset = $value==0?"0":(string)$value*20;
                $query_sql .= "limit 20 offset {$offset}";
            }
            else if($value)
            {
                $query_sql .= "and ";
                if(is_string($value))
                {
                    $query_sql .= "{$key} = '{$value}' ";
                }
                else
                {
                    $query_sql .= "{$key} = {$value} ";
                }
            }


        }
    }
//    $query_sql = $query_sql.trim();
    $query_sql = trim($query_sql);
    $query_sql .= ";";
    return $query_sql;
}

$result = $db_conn->select(get_query_sql($param));
$cur_info_all = $result->rawData();
$cur_data = $cur_info_all["data"];
echo(json_encode($cur_data));
?>