Connect to Managed ClickHouse® with PHP

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

Prerequisites

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

composer require smi2/phpclickhouse

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:

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
• Connect to Managed ClickHouse®