connect_error) { die("Connection failed: " . $conn->connect_error); } $data = []; mysqli_set_charset($conn,"utf8"); $result = $conn->query("SELECT gjinia as `name`, perqindja as y, color FROM aktiv_gjinia"); while($row = $result->fetch_assoc()) { $row['y'] = floatval($row['y']); $data['aktiv_gjinia'][] = $row; } $result = $conn->query("SELECT gjinia as `name`, perqindja as y, color FROM sheruar_gjinia"); while($row = $result->fetch_assoc()) { $row['y'] = floatval($row['y']); $data['sheruar_gjinia'][] = $row; } $result = $conn->query("SELECT gjinia as `name`, perqindja as y, color FROM vdekur_gjinia"); while($row = $result->fetch_assoc()) { $row['y'] = floatval($row['y']); $data['vdekur_gjinia'][] = $row; } $result = $conn->query("SELECT grupmosha as `name`, perqindja as y, color FROM aktiv_grupmoshe"); while($row = $result->fetch_assoc()) { $row['y'] = floatval($row['y']); $data['aktiv_grupmoshe'][] = $row; } $result = $conn->query("SELECT grupmosha as `name`, numri as y, color FROM sheruar_grupmoshe"); while($row = $result->fetch_assoc()) { $row['y'] = floatval($row['y']); $data['sheruar_grupmoshe'][] = $row; } $result = $conn->query("SELECT grupmosha as `name`, numri as y, color FROM vdekur_grupmoshe"); while($row = $result->fetch_assoc()) { $row['y'] = floatval($row['y']); $data['vdekur_grupmoshe'][] = $row; } $result = $conn->query("SELECT qarku as `name`, numri as y, color FROM sheruar_vendbanim"); while($row = $result->fetch_assoc()) { $row['y'] = floatval($row['y']); $data['sheruar_vendbanim'][] = $row; } header('Content-Type: application/json'); echo json_encode($data); // echo '

';
// var_dump($data);
// echo '

'; // die(); $conn->close(); ?>