CrateDB PDO¶

The PHP Data Objects (PDO) is a standard PHP extension that defines a common interface for accessing databases in PHP. The crate/crate-pdo driver implements this specification, wrapping access to CrateDB’s HTTP interface.

Install

composer require crate/crate-pdo

Synopsis

<?php
require 'vendor/autoload.php';

use Crate\PDO\PDOCrateDB;
use PDO;

$dsn = 'crate:localhost:4200';
$user = 'crate';
$password = null;
$options = [PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC];
$connection = new PDOCrateDB($dsn, $user, $password, $options);

$stm = $connection->query("SELECT * FROM sys.summits ORDER BY height DESC LIMIT 3");
$result = $stm->fetch();
print_r($result);
?>