Skip to content

Instantly share code, notes, and snippets.

@stevencorona
Created June 14, 2011 00:07
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save stevencorona/1024060 to your computer and use it in GitHub Desktop.
Save stevencorona/1024060 to your computer and use it in GitHub Desktop.
<?php
require_once "./phpcassa/columnfamily.php";
// Create new ConnectionPool like you normally would
$pool = new ConnectionPool("KeyspaceName", array("127.0.0.1"));
// Retrieve a raw connection from the ConnectionPool
$raw = $pool->get();
$rows = $raw->client->execute_cql_query("SELECT * FROM ColumnFamily WHERE KEY = 1", cassandra_Compression::NONE);
// Return the connection to the pool so it may be used by other callers. Otherwise,
// the connection will be unavailable for use.
$pool->return_connection($raw);
unset($raw);
@tamilmani58
Copy link

Hi,
How do I get counter column value using execute_cql_query? Since the value is by default stored as hex, result set couldn't recognize the value. I'm getting some weird symbols in the values column. Ex: ["value"]=> string(8) "�" (There is a value between the quotes, Copy paste in some editor) It looks like Hex Representation of 14, but I dunno what encoding it is.

@stevencorona
Copy link
Author

I'm not sure if counters are supported with CQL yet. Either way, you might have to use unpack('H*', $return) to convert from hex.

@tamilmani58
Copy link

That worked :) Thank you :)
I found one more solution for the same coz I dint know "unpack"
http://itsallabtamil.blogspot.com
Regards
Tamil

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment