php-orientdb
5A fast PHP driver for the OrientDB binary protocol.
PHP-OrientDB
A fast PHP driver for the OrientDB binary protocol.
status: alpha This is work in progress, alpha quality software. Please report any bugs you find so that we can improve the library for everyone.
Usage
Configuring the client
$client = new OrientDB\Client([
'hostname' => 'localhost',
'port' => 2424,
'username' => 'root',
'password' => 'yourpassword'
]);
List the databases on the server.
foreach($client->getDatabases() as $name => $db) {
echo $name, "<br>";
}
Use a particular database
$db = $client->getDatabases()->mydatabase;
Use a particular database, with custom credentials
$db = $client->getDatabases()->mydatabase;
$db->username = 'me';
$db->password = 'mypassword';
Create a new database
$db = $client->getDatabases()->create('mydatabase', 'plocal');
Drop an existing database
$client->getDatabases()->drop('mydatabase', 'plocal');
Query builder: Insert record
$record = $db->insert(['name' => 'Me'])->into('MyClass')->one();
Query builder: Update record
$db->update('MyClass')->set(['name' => 'Charles'])->where(['name' => 'Me'])->one();
Query builder: Delete record
$db->delete('MyClass')->where(['name' => 'Charles'])->one();
Query builder: Select records
$results = $db->select('name')->from('OUser')->groupBy('status')->all();
Query builder: Select records with fetch plan.
$results = $db->select()->from('OUser')->where(['status' => 'ACTIVE'])->fetch(['roles' => 2])->all();
Query builder: Select expression
$totalUsers = $db->select('count(*)')->from('OUser')->scalar();
Query builder: Traverse records
$rows = $db->traverse()->from('OUser');
List all the clusters in the database.
foreach($db->clusters as $name => $cluster) {
echo 'Cluster '.$name.' has '.$cluster->count()." records.\n";
}
List all the classes in the database.
foreach($db->classes as $name => $class) {
echo $name."\n";
}
License
MIT, see LICENSE.md.