php开发Hive Web查询

jiabanl

$GLOBALS['THRIFT_ROOT'] = '/data/center_a0001/www/libs/classes/Thrift/';
require_once $GLOBALS['THRIFT_ROOT'] . 'packages/hive_service/ThriftHive.php';
require_once $GLOBALS['THRIFT_ROOT'] . 'transport/TSocket.php';
require_once $GLOBALS['THRIFT_ROOT'] . 'protocol/TBinaryProtocol.php';
$transport = new TSocket('127.0.0.1', 10000);
$protocol = new TBinaryProtocol($transport);
$client = new ThriftHiveClient($protocol);
$transport->open();
$client->execute('use fycenter');
$sql = 'SELECT * FROM orders '.$whereGame.' ORDER BY `time` DESC';
$client->execute($sql);
$result=$client->fetchAll();
$arrList = array();
foreach ($result as $k=>$v) {
$arrTemp = explode("\t", $v);
$arrList[$k]['accountName'] = $arrTemp[0];
$arrList[$k]['roleName'] = $arrTemp[1];
$arrList[$k]['orderNumber'] = $arrTemp[2];
$arrList[$k]['money'] = $arrTemp[3];
$arrList[$k]['moneyType'] = $arrTemp[4];
$arrList[$k]['moneyRmb'] = $arrTemp[5];
$arrList[$k]['coin'] = $arrTemp[6];
$arrList[$k]['time'] = $arrTemp[7];
$arrList[$k]['isFirst'] = $arrTemp[8];
}
$smarty->assign('user_list',$arrList);
$smarty->display('gen_user_table.html');