InfluxDB 
Simple PHP client for InfluxDB, an open-source, distributed, time series, events, and metrics database with no external dependencies., (*1)
InfluxDB > v0.9 support
The 0.2.0 version of this library now supports InfluxDB 0.9. Please note that InfluxDB 0.9 is still pre-release software., (*2)
InfluxDB v0.8.X users
Influxdb >=0.9.0 brings many breaking changes to the API. InfluxDB 0.8.X users may use the legacy client by using the 0.1.* series instead.
For the documentation, please have a look at the 0.1.* version!, (*3)
How to install it
The easiest way is to install it via composer, (*4)
Create a composer.json file with the following contents:, (*5)
With InfluxDB 0.9 and above:, (*6)
{
"require": {
"crodas/influx-php": "^0.9"
}
}
With InfluxDB 0.8.*:, (*7)
{
"require": {
"crodas/influx-php": "0.1.*"
}
}
How to use it
You need to create a client object., (*8)
$client = new \crodas\InfluxPHP\Client(
"localhost" /*default*/,
8086 /* default */,
"root" /* by default */,
"root" /* by default */
);
The first time you should create an database., (*9)
$db = $client->createDatabase("foobar");
$client->createUser("foo", "bar"); // <-- create user/password
You can create more users than the default root user., (*10)
$client->createUser('username', "password");
Show existing users:, (*11)
$users = $client->getUsers();
User privileges are controlled by per-databases users. Any user can have 'read', 'write' or 'all' access, represented by the constants InfluxClient::PRIV_READ, InfluxClient::PRIV_WRITE and InfluxClient::PRIV_ALL., (*12)
$client->grantPrivilege(InfluxClient::PRIV_ALL, 'database', 'username');
// revoke rights by
$client->revokePrivilege(InfluxClient::PRIV_ALL, 'database', 'username');
The cluster administrator can be set with:, (*13)
$client->setAdmin('username');
// delete admin righty by:
$client->deleteAdmin('einuser');
Create data is very simple., (*14)
$db = $client->foobar;
// single input:
$db->insert("some label", [ 'fields' => array('value' => 2)]);
// single input; the 'name' identifier will be overwritten by array content:
$db->insert("some label", ['name'=> 'some label', 'fields' => array('value' => 2)]);
// multiple insert, this is better...
// The 'name' field is optional, if not set, the default parameter (here: 'foobar') will be used
$db->insert("foobar", array(
array('name' => 'lala', 'fields' => array('type' => 'foobar', 'karma' => 25)),
array( 'fields' => array('type' => 'foobar', 'karma' => 45)),
));
It is recommended that you encode most metadata into the series Tags., (*15)
$db->insert("foobar",[['tags' => ['type' => 'one'], 'fields' => ['value' => 10]]]);
Now you can get the database object and start querying., (*16)
$db = $client->foobar;
// OR
$db = $client->getDatabase("foobar");
foreach ($db->query("SELECT * FROM foo") as $row) {
var_dump($row, $row->time);
}
If there are multiple result series, a MultipleResultSeriesObject instance will be returned. So if you are not sure about the results of the query, check the type of the returned object., (*17)
An example of getting multiple result sets is:, (*18)
// Here the 'type' value is stored as metadata in the tags entry. So if there are two 'type' tags found, you will get two result series
$result = $db->query("SELECT count(value) FROM test1 where time >= '2015-01-01T12:00:00Z' and time < '2015-01-02T00:00:00Z' group by time(1h), type");
Please have a look at the DBTest.php class, you will find some more examples there., (*19)
Wallogit.com
