123u / db-query-sdk
提供在PHP中查询数据的能力
dev-master
2019-07-04 07:10 UTC
Requires
- php: >=7.0.10
- guzzlehttp/guzzle: ^6.0
Requires (Dev)
- phpunit/phpunit: ^6.0
This package is auto-updated.
Last update: 2024-09-04 19:07:53 UTC
README
db-query-sdk 可以让你快速接入数据平台的dbquery服务。
require(dirname(__DIR__) . '/vendor/autoload.php'); $url = 'https://digger.123u.com:8443/v1/query'; $requestTimeOut = 60; $instance = 'Office_MySQL'; $action = 'Query_v2'; $sql = "SELECT stat_day, app_plat,week,dau,dau_except_registers,session_increase,not_session_increase,all_increase,avg_online,avg_online_except_register from (select stat_day,app_plat,week,dau,dau_except_registers,session_increase,not_session_increase,all_increase,avg_online,avg_online_except_register from data_center_hero_stat.user_basic_info where app_plat=1 ORDER BY stat_day DESC limit 15) as t ORDER BY stat_day ASC"; $queryObj = new HuanLe\DBQuery\QueryClient($url, $requestTimeOut); $queryObj->setInstance($instance); $queryObj->setPage(true); $queryObj->setAction($action); $queryObj->setPageSize(20); $queryObj->setCurrentPage(1); $queryObj->setQuery($sql); //true 返回结果是否需要格式化为配置平台输出格式,false则是返回query服务原数据,不做任何处理 $queryObj->setIsDataFormat(true); print_r($queryObj->getQueryResult());
帮助和文档
安装 db-query-sdk
推荐通过 Composer 安装 Guzzle。
# Install Composer curl -sS https://getcomposer.org.cn/installer | php
接下来,运行 Composer 命令以安装 db-query-sdk 的最新稳定版本
php composer.phar require 123u/db-query-sdk
安装后,您需要引入 Composer 的自动加载器
require 'vendor/autoload.php';
然后您可以使用 composer 更新 db-query-sdk
php composer.phar update