$host = '192.168.100.2';
$port = 9090;
$socket = new TSocket($host, $port);
$socket->setSendTimeout(10000);
$socket->setRecvTimeout(20000);
$transport = new TBufferedTransport($socket);
$protocol = new TBinaryProtocol($transport);
$client = new HbaseClient($protocol);
$transport->open();
$table_name = 'facerecord';
$getId = $_GET['id'];
$row_name = "r" . $getId;
//$row_name = "r0";
$fam_col_name = array('count', 'info');
$arr = array();
$arr = $client->getRow($table_name, $row_name, $fam_col_name);
$transport->close();
$time_list = $arr[0]->columns;
$count_num = $time_list['count:num']->value;
//foreach($time_list as $mas);
for ($i = $count_num; $i > 0; $i--) {
$index = "info:" . $i;
$msg = $time_list[$index]->value;
$arr = str_split($msg);
$st = substr($msg, 0, 10);
$channel = $arr[22];
$date = date('Y-m-d H:i:s', intval($st));
echo "<li><a href='videoPlayByPhoto.php?id=" . $getId . "&time=" . $msg . "'>";
echo $date;
echo " 监控点" . $channel;
echo "</a></li>";
// open connection
$socket = new TSocket(HBASE_HOST, HBASE_PORT);
$transport = new TBufferedTransport($socket);
$protocol = new TBinaryProtocol($transport);
$transport->open();
// create hbase client
$client = new HbaseClient($protocol);
// show all tables
echo "Existing tables:\n";
$tables = $client->getTableNames();
foreach ($tables as $name) {
echo " found: {$name}\n";
}
// create a table with name 'tableName'
echo "\nCreate table: tableName\n";
try {
$columns = array(new ColumnDescriptor(array('name' => 'colFamily:', 'maxVersions' => 10)));
$client->createTable("tableName", $columns);
} catch (AlreadyExists $ae) {
echo "WARN: {$ae->message}\n";
}
// insert data to table
echo "\nInsert data to table: tableName\n";
$mutations = array(new Mutation(array('column' => 'colFamily:Col', 'value' => 'value123')));
$client->mutateRow("tableName", "ID_1237846634624", $mutations);
// get table data
echo "\nData in table: tableName\n";
$rows = $client->getRow("tableName", "ID_1237846634624");
foreach ($rows as $row) {
var_dump($row);
}
while (true) {
printRow($client->scannerGet($scanner));
}
} catch (NotFound $nf) {
$client->scannerClose($scanner);
echo "Scanner finished\n";
}
#
# Run some operations on a bunch of rows.
#
for ($e = 100; $e >= 0; $e--) {
# format row keys as "00000" to "00100"
$row = str_pad($e, 5, '0', STR_PAD_LEFT);
$mutations = array(new Mutation(array('column' => 'unused:', 'value' => "DELETE_ME")));
$client->mutateRow($t, $row, $mutations);
printRow($client->getRow($t, $row));
$client->deleteAllRow($t, $row);
$mutations = array(new Mutation(array('column' => 'entry:num', 'value' => "0")), new Mutation(array('column' => 'entry:foo', 'value' => "FOO")));
$client->mutateRow($t, $row, $mutations);
printRow($client->getRow($t, $row));
$mutations = array(new Mutation(array('column' => 'entry:foo', 'isDelete' => 1)), new Mutation(array('column' => 'entry:num', 'value' => '-1')));
$client->mutateRow($t, $row, $mutations);
printRow($client->getRow($t, $row));
$mutations = array(new Mutation(array('column' => "entry:num", 'value' => $e)), new Mutation(array('column' => "entry:sqr", 'value' => $e * $e)));
$client->mutateRow($t, $row, $mutations);
printRow($client->getRow($t, $row));
$mutations = array(new Mutation(array('column' => 'entry:num', 'value' => '-999')), new Mutation(array('column' => 'entry:sqr', 'isDelete' => 1)));
$client->mutateRowTs($t, $row, $mutations, 1);
# shouldn't override latest
printRow($client->getRow($t, $row));
$versions = $client->getVer($t, $row, "entry:num", 10);
