function read_from_cache($table) { $db_data = get_last_data($table); $servername = "mysql4.000webhost.com"; $username = "******"; $password = "******"; $dbname = "a2124875_cache"; $conn = new mysqli($servername, $username, $password, $dbname); $sql = " SELECT * FROM " . $table . " WHERE data like '" . $db_data . "'"; $name = array(); $owner = array(); $image_owner = array(); $image_api = array(); $desc = array(); $prices = array(); $links = array(); if ($result = $conn->query($sql)) { while ($row = $result->fetch_row()) { array_push($name, urldecode($row[1])); array_push($owner, urldecode($row[2])); array_push($image_owner, urldecode($row[3])); array_push($image_api, urldecode($row[4])); array_push($desc, urldecode($row[5])); array_push($prices, urldecode($row[6])); array_push($links, urldecode($row[7])); } /* free result set */ $result->close(); } else { echo "Error: " . $sql . "<br>" . $conn->error; } $conn->close(); $array = array("name" => $name, "owner" => $owner, "image_owner" => $image_owner, "image_api" => $image_api, "desc" => $desc, "prices" => $prices, "links" => $links); return $array; }
function get_count_days($table, $data) { $db_data = get_last_data($table); $data1 = $db_data; $data2 = $data; $days = get_diff_between_two_date($data1, $data2); return $days; }
} return $res_array; } function get_last_data($nodes, $type_mea) { /* The user must specify the type of measurement that wants to query */ $meas = array(); foreach ($nodes as $node) { $node_id = $node['id']; $query = "SELECT * FROM meas WHERE node_id =" . $node_id . " and type_mea = " . $type_mea . " ORDER by id DESC LIMIT 1"; $res = mysql_query($query); $row = mysql_fetch_array($res); $tmp_array = array("id" => $row[0], "node_id" => $row[1], "date" => $row[2], "mea" => $row[3], "type_mea" => $row[4]); array_push($meas, $tmp_array); } return $meas; } if (!isset($_GET['nodes']) && !isset($_GET['data'])) { echo "Action not specified"; } $con = connect_db(); if (isset($_GET['nodes'])) { echo json_encode(get_nodes()); } else { if (isset($_GET['data'])) { $type_data = $_GET['data']; $nodes = get_nodes(); $data = get_last_data($nodes, $type_data); echo json_encode($data); } }