Connect to the Aiven for ClickHouse® service with PHP

Learn how to connect to your Aiven for ClickHouse® service with PHP using the PHP ClickHouse client and the HTTPS port.

Prerequisites

• PHP 7.4 or later
• smi2/phpclickhouse library
• Composer

tip

You can install smi2/phpclickhouse with the following command:

composer require smi2/phpclickhouse

or

php composer.phar require smi2/phpclickhouse

Identify connection information

To run the code for connecting to your service, first identify values of the following variables:

Variable	Description
https	Required to be set to true
host	Host for the ClickHouse connection available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC
port	Port for the ClickHouse connection available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC
username	User for the ClickHouse connection available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC
password	Password for the ClickHouse connection available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC
database	Database Name in the ClickHouse service available in the Aiven console: Service Overview > Connection information > ClickHouse HTTPS & JDBC

Connect to the service

Replace the placeholders in the code with meaningful information on your service connection and run the code.

<?php
    require_once 'vendor/autoload.php';
    $db = new ClickHouseDB\Client([
        'https' => true,
        'host' => 'HOSTNAME',
        'port' => 'HTTPS_PORT',
        'username' => 'USERNAME',
        'password' => 'PASSWORD'
    ]);
    $db->database('DATABASE');
    $response = $db->select('SELECT 1');
    print_r($response->rows());

Now you have your service connection set up and you can proceed to uploading data into your database.

Related pages

• Connect with the ClickHouse client.