1. Go to this page and download the library: Download duoshuo/php-cassandra library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
duoshuo / php-cassandra example snippets
$nodes = [
'127.0.0.1', // simple way, hostname only
'192.168.0.2:9042', // simple way, hostname with port
[ // advanced way, array including username, password and socket options
'host' => '10.205.48.70',
'port' => 9042, //default 9042
'username' => 'admin',
'password' => 'pass',
'socket' => [SO_RCVTIMEO => ["sec" => 10, "usec" => 0], //socket transport only
],
],
[ // advanced way, using Connection\Stream, persistent connection
'host' => '10.205.48.70',
'port' => 9042,
'username' => 'admin',
'password' => 'pass',
'class' => 'Cassandra\Connection\Stream',//use stream instead of socket, default socket. Stream may not work in some environment
'connectTimeout' => 10, // connection timeout, default 5, stream transport only
'timeout' => 30, // write/recv timeout, default 30, stream transport only
'persistent' => true, // use persistent PHP connection, default false, stream transport only
],
[ // advanced way, using SSL
'class' => 'Cassandra\Connection\Stream', // "class" must be defined as "Cassandra\Connection\Stream" for ssl or tls
'host' => 'ssl://10.205.48.70',// or 'tls://10.205.48.70'
'port' => 9042,
'username' => 'admin',
'password' => 'pass',
],
];
// Create a connection.
$connection = new Cassandra\Connection($nodes, 'my_keyspace');
//Connect
try
{
$connection->connect();
}
catch (Cassandra\Exception $e)
{
echo 'Caught exception: ', $e->getMessage(), "\n";
exit;//if connect failed it may be good idea not to continue
}
// Set consistency level for farther requests (default is CONSISTENCY_ONE)
$connection->setConsistency(Request::CONSISTENCY_QUORUM);
// Run query synchronously.
try
{
$response = $connection->querySync('SELECT * FROM "users" WHERE "id" = ?', [new Cassandra\Type\Uuid('c5420d81-499e-4c9c-ac0c-fa6ba3ebc2bc')]);
}
catch (Cassandra\Exception $e)
{
}
// Return a SplFixedArray containing all of the result set.
$rows = $response->fetchAll(); // SplFixedArray
// Return a SplFixedArray containing a specified index column from the result set.
$col = $response->fetchCol(); // SplFixedArray
// Return a assoc array with key-value pairs, the key is the first column, the value is the second column.
$col = $response->fetchPairs(); // assoc array
// Return the first row of the result set.
$row = $response->fetchRow(); // ArrayObject
// Return the first column of the first row of the result set.
$value = $response->fetchOne(); // mixed
// Return a statement immediately
try
{
$statement1 = $connection->queryAsync($cql1);
$statement2 = $connection->queryAsync($cql2);
// Wait until received the response, can be reversed order
$response2 = $statement2->getResponse();
$response1 = $statement1->getResponse();
$rows1 = $response1->fetchAll();
$rows2 = $response2->fetchAll();
}
catch (Cassandra\Exception $e)
{
}
$batchRequest = new Cassandra\Request\Batch();
// Append a prepared query
$preparedData = $connection->prepare('UPDATE "students" SET "age" = :age WHERE "id" = :id');
$values = [
'age' => 21,
'id' => 'c5419d81-499e-4c9c-ac0c-fa6ba3ebc2bc',
];
$batchRequest->appendQueryId($preparedData['id'], Cassandra\Request\Request::strictTypeValues($values, $preparedData['metadata']['columns']));
// Append a query string
$batchRequest->appendQuery(
'INSERT INTO "students" ("id", "name", "age") VALUES (:id, :name, :age)',
[
'id' => new Cassandra\Type\Uuid('c5420d81-499e-4c9c-ac0c-fa6ba3ebc2bc'),
'name' => new Cassandra\Type\Varchar('Mark'),
'age' => 20,
]
);
$response = $connection->syncRequest($batchRequest);
$rows = $response->fetchAll();
// Ascii
new Cassandra\Type\Ascii('string');
// Bigint
new Cassandra\Type\Bigint(10000000000);
// Blob
new Cassandra\Type\Blob('string');
// Boolean
new Cassandra\Type\Boolean(true);
// Counter
new Cassandra\Type\Counter(1000);
// Decimal
new Cassandra\Type\Decimal('0.0123');
// Double
new Cassandra\Type\Double(2.718281828459);
// Float
new Cassandra\Type\PhpFloat(2.718);
// Inet
new Cassandra\Type\Inet('127.0.0.1');
// Int
new Cassandra\Type\PhpInt(1);
// CollectionList
new Cassandra\Type\CollectionList([1, 1, 1], [Cassandra\Type\Base::INT]);
// CollectionMap
new Cassandra\Type\CollectionMap(['a' => 1, 'b' => 2], [Cassandra\Type\Base::ASCII, Cassandra\Type\Base::INT]);
// CollectionSet
new Cassandra\Type\CollectionSet([1, 2, 3], [Cassandra\Type\Base::INT]);
// Timestamp (unit: millisecond)
new Cassandra\Type\Timestamp((int) (microtime(true) * 1000));
new Cassandra\Type\Timestamp(1409830696263);
// Uuid
new Cassandra\Type\Uuid('62c36092-82a1-3a00-93d1-46196ee77204');
// Timeuuid
new Cassandra\Type\Timeuuid('2dc65ebe-300b-11e4-a23b-ab416c39d509');
// Varchar
new Cassandra\Type\Varchar('string');
// Varint
new Cassandra\Type\Varint(10000000000);
// Custom
new Cassandra\Type\Custom('string', 'var_name');
// Tuple
new Cassandra\Type\Tuple([1, '2'], [Cassandra\Type\Base::INT, Cassandra\Type\Base::VARCHAR]);
// UDT
new Cassandra\Type\UDT(['intField' => 1, 'textField' => '2'], ['intField' => Cassandra\Type\Base::INT, 'textField' => Cassandra\Type\Base::VARCHAR]); // in the order defined by the type