1<?php 2 3include_once __DIR__ . '/../include.php'; 4 5$config = include_once __DIR__ . '/00_config_connect.php'; 6 7 8$db = new ClickHouseDB\Client($config); 9 10$input_params = [ 11 'select_date' => ['2000-10-10', '2000-10-11', '2000-10-12'], 12 'limit' => 5, 13 'from_table' => 'table' 14]; 15 16 17$db->enableQueryConditions(); 18 19 20$select = ' 21SELECT * FROM {from_table} 22WHERE 23{if select_date} 24event_date IN (:select_date) 25{else} 26event_date=today() 27{/if} 28{if limit} 29LIMIT {limit} 30{/if} 31'; 32 33$statement = $db->selectAsync($select, $input_params); 34echo $statement->sql(); 35echo "\n"; 36 37/* 38SELECT * FROM table 39WHERE 40event_date IN ('2000-10-10','2000-10-11','2000-10-12') 41LIMIT 5 42FORMAT JSON 43*/ 44 45$input_params['select_date'] = false; 46 47 48$statement = $db->selectAsync($select, $input_params); 49echo $statement->sql(); 50echo "\n"; 51 52/* 53SELECT * FROM table 54WHERE 55event_date=today() 56LIMIT 5 57FORMAT JSON 58*/