我是 incinga2 框架的新手，如何在 incinga2 中運行 sql raw 或自定義查詢，如下所示SELECT `user`, COUNT(0) as Total_Count, MAX(range_count) Max_Range_CountFROM ( SELECT a.`user`, a.change_time, COUNT(0) range_count FROM audit_log a INNER JOIN audit_log b ON a.`user` = b.`user` WHERE b.change_time BETWEEN a.change_time AND a.change_time + INTERVAL 30 MINUTE GROUP BY a.`user`, a.change_time) AS user_range_countGROUP BY `user`icinga2 中的這個數(shù)據(jù)庫對象，用于連接數(shù)據(jù)庫和獲取數(shù)據(jù)。他們使用適配器，但 pdo 是空的。A 可以在這里添加我的 pdo 嗎？icniga2框架對嗎？ipl\Sql\Connection Object( [config:protected] => ipl\Sql\Config Object ( [db] => mysql [host] => localhost [port] => 3306 [dbname] => auditlog [username] => root [password] => [charset] => utf8 [options] => [type] => db [persistent] => 0 ) [pdo:protected] => [queryBuilder:protected] => [adapter:protected] => ipl\Sql\Adapter\Mysql Object ( [quoteCharacter:protected] => Array ( [0] => ` [1] => ` ) [escapeCharatcer:protected] => `` [escapeCharacter:protected] => \" [options:protected] => Array ( [8] => 0 [20] => [3] => 2 [11] => 0 [17] => ) ) [pluginLoaders:protected] => Array ( [adapter] => Array ( [0] => ipl\Stdlib\Loader\AutoLoadingPluginLoader Object ( [namespace:protected] => ipl\Sql\Adapter [postfix:protected] => [uppercaseFirst:protected] => 1 ) ) ))
2 回答
BIG陽
TA貢獻1859條經(jīng)驗 獲得超6個贊
首先在 incinga 中安裝任何數(shù)據(jù)庫資源模塊，例如Icinga Web 2 - IPL ，它將幫助我們在 incinga 中調(diào)用 pdo 查詢，然后您可以查看其文檔如何運行任何帶有綁定參數(shù)的語句。例子：
use ipl\Sql\Select;
use PDO;
$stmt = 'Select * from table where id=?';
$id=1;
$execute=$this->dbConnection->fetchAll($stmt,[$id]);
慕尼黑8549860
TA貢獻1818條經(jīng)驗 獲得超11個贊
您可以使用PDO。
非常好的文章開始使用 PDO。
$strQuery = "SELECT
`user`,
COUNT(0) as Total_Count,
MAX(range_count) Max_Range_Count
FROM (
SELECT
a.`user`,
a.change_time,
COUNT(0) range_count
FROM audit_log a
INNER JOIN audit_log b ON a.`user` = b.`user`
WHERE b.change_time BETWEEN a.change_time AND a.change_time + INTERVAL 30 MINUTE
GROUP BY a.`user`, a.change_time
) AS user_range_count
GROUP BY `user`";
foreach ($conn->query($strQuery) as $row) {
print_r($row);
}
- 2 回答
- 0 關(guān)注
- 196 瀏覽
添加回答
舉報
0/150
提交
取消