PHP instance_actions::get_instance_by_serverの例

コード例 #1

ファイル: class_server_actions.php プロジェクト: ghoneycutt/Oracle-DB-parameter-monitor

 static function get_all_server()
 {
     $db = mysqli_connect($_SESSION['db_host'], $_SESSION['db_user'], $_SESSION['db_password'], $_SESSION['db_database']);
     $result = mysqli_query($db, "SELECT * FROM `server` where test_system != 'true'");
     while ($row = mysqli_fetch_object($result)) {
         $i = $row->server_id;
         $obj_name = "server" . $i;
         ${$obj_name} = new server();
         ${$obj_name}->server_id = $row->server_id;
         ${$obj_name}->hostname = $row->hostname;
         # Fra Space
         $result2 = mysqli_query($db, "SELECT * FROM `system_parameter` WHERE `server_id` = {$row->server_id} and `parameter_name` = 'fra-space' order by time desc");
         while ($row2 = mysqli_fetch_object($result2)) {
             ${$obj_name}->fra_space = $row2->value_string;
         }
         # Fra Used Space
         $result2 = mysqli_query($db, "SELECT * FROM `system_parameter` WHERE `server_id` = {$row->server_id} and `parameter_name` = 'fra-used-space' order by time desc");
         while ($row2 = mysqli_fetch_object($result2)) {
             ${$obj_name}->fra_used_space = $row2->value_string;
         }
         # Build all instance objects
         ${$obj_name}->instances = instance_actions::get_instance_by_server($row->hostname);
         $arr_obj[] = ${$obj_name};
     }
     return $arr_obj;
 }

コード例 #2

ファイル: fra_monitor_dialog.php プロジェクト: ghoneycutt/Oracle-DB-parameter-monitor

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');
session_start();
if ($_SESSION['login'] != true) {
    header("Location: login.php");
    exit;
}
include_once "../classes/class_parameter.php";
include_once "../classes/class_parameter_actions.php";
include_once "../classes/class_instance.php";
include_once "../classes/class_instance_actions.php";
$instances_arr = instance_actions::get_instance_by_server($_POST['hostname']);
foreach ($instances_arr as $instance) {
    $fra_space_obj = parameter_actions::get_parameter_by_id(1089, $instance->db_id);
    $fra_data[$instance->db_id]['fra_space'] = $fra_space_obj->get_current_value();
    $fra_used_space_obj = parameter_actions::get_parameter_by_id(9003, $instance->db_id);
    $fra_data[$instance->db_id]['used_fra_space'] = $fra_used_space_obj->get_current_value();
    $fra_reclaimable_space_obj = parameter_actions::get_parameter_by_id(9004, $instance->db_id);
    $fra_data[$instance->db_id]['reclaimable_fra_space'] = $fra_reclaimable_space_obj->get_current_value();
    $fra_data[$instance->db_id]['used_fra_percentage'] = round($fra_used_space_obj->current_value / $fra_space_obj->current_value * 100, 0);
    $fra_data[$instance->db_id]['reclaimable_fra_percentage'] = round(($fra_used_space_obj->current_value - $fra_reclaimable_space_obj->current_value) / $fra_space_obj->current_value * 100, 0);
}
?>
<script>
	<?php 
foreach ($instances_arr as $instance) {
    ?>
		  $(function() {
			var instance_fra_usage = <?php