Online PHP editor | refs for lhqMFm

<?php header("Content-type: application/json"); require_once "config/database.php"; $db = new database(); $mysqli = $db->connect(); $balai = mysqli_real_escape_string($mysqli, $_GET['balai']); if ($balai == 'bl-1') { $sql = "SELECT plan, actual FROM scurve1 ORDER BY id ASC"; } else if ($balai == 'bl-2') { $sql = "SELECT plan, actual FROM scurve2 ORDER BY id ASC"; } else if ($balai == 'bl-3') { $sql = "SELECT plan, actual FROM scurve3 ORDER BY id ASC"; } $hasil = array(); $result = $mysqli->query($sql); while ($data = $result->fetch_assoc()) { $hasil['data'][]=['name'=>'Plan', 'data' => $data['plan']]; $hasil['data'][]=['name'=>'Actual', 'data' => $data['actual']]; } print json_encode($hasil, JSON_NUMERIC_CHECK); $mysqli->close();