$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);