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; }
<?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