WD - Dev
33 lines
1.1 KiB
PHP
33 lines
1.1 KiB
PHP
<?php
|
|
include "../config/connect.php";
|
|
|
|
// Menggunakan PDO untuk koneksi database
|
|
try {
|
|
|
|
// Mengambil parameter 'dropdown' dan 'option' dari query string
|
|
$dropdown = isset($_GET['dropdown']) ? $_GET['dropdown'] : '';
|
|
$option = isset($_GET['option']) ? $_GET['option'] : '';
|
|
|
|
$options = array();
|
|
|
|
switch ($dropdown) {
|
|
case 'dropoption2':
|
|
// Query untuk data paket
|
|
$stmt = $pdo->prepare("SELECT id,id_data_server, nama, keluar, sisa, start_time FROM v_jumlah_data_gudang WHERE id_data_server = :id_data_server and sisa > '0'");
|
|
$stmt->execute([':id_data_server' => $option]);
|
|
$options = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
break;
|
|
default:
|
|
$options = [];
|
|
break;
|
|
}
|
|
// Mengembalikan data dalam format JSON
|
|
header('Content-Type: application/json');
|
|
echo json_encode($options);
|
|
|
|
} catch (PDOException $e) {
|
|
// Mengembalikan error dalam format JSON
|
|
header('Content-Type: application/json');
|
|
echo json_encode(['error' => $e->getMessage()]);
|
|
}
|
|
?>
|