php開發Hive Web查詢

$GLOBALS['THRIFT_ROOT'] = '/data/center_a0001/www/libs/classes/Thrift/';

require_once $GLOBALS['THRIFT_ROOT'] 。 GLOBALS['THRIFT_ROOT'] 。 'transport/TSocket.php';

require_once $GLOBALS['THRIFT_ROOT'] 。 ”

require_once $GLOBALS['THRIFT_ROOT'] 。 ;

$protocol = new TBinaryProtocol($transport);

$client = new ThriftHiveClient($protocol);

$transport->open(); );

$sql = '從訂單中選擇* '.$whereGame.' ORDER BY `time` DESC';

$client->execute($sql);

as $arrList k=>$v) {

$arrTemp = Explore("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');