} } if ($_SESSION['delId'][$delId]['Total'] > 0) { $eventsDeletedCount = deleteEventsByFilter(); $_SESSION['delId'][$delId]['Deleted'] += $eventsDeletedCount; $deletedPercent = $_SESSION['delId'][$delId]['Deleted'] * 100 / $_SESSION['delId'][$delId]['Total']; if ($_SESSION['delId'][$delId]['Deleted'] - $_SESSION['delId'][$delId]['Total'] == 0) { $deleteSensorResult = deleteSensor($_SESSION['delFilter']['src_sensor']); $result = array('Total' => $_SESSION['delId'][$delId]['Total'], 'Current' => $_SESSION['delId'][$delId]['Deleted'], 'Percent' => $deletedPercent, 'SensorDelete' => $deleteSensorResult); unset($_SESSION['delFilter']); unset($_SESSION['delId']); } else { $result = array('Total' => $_SESSION['delId'][$delId]['Total'], 'Current' => $_SESSION['delId'][$delId]['Deleted'], 'Percent' => $deletedPercent, 'SensorDelete' => $deleteSensorResult); } } else { $deleteSensorResult = deleteSensor($_SESSION['delFilter']['src_sensor']); unset($_SESSION['delFilter']); unset($_SESSION['delId']); $result = array('Total' => 0, 'Current' => 0, 'Percent' => 100, 'SensorDelete' => $deleteSensorResult); } sleep(2); print json_encode($result); } elseif (isset($_GET['getWebHostsPartial'])) { // Query web hostnames partially, using autocomplete from filter interface. if (strlen($_GET['getWebHostsPartial']) > 2) { $webHostsList = getWebHostsPartial($_GET['getWebHostsPartial']); } else { $webHostsList = "{}"; } print json_encode($webHostsList); } else {
$stid = oci_parse($conn, $sql); $res = oci_execute($stid); while ($row = oci_fetch_array($stid, OCI_ASSOC)) { foreach ($row as $id) { echo "<option value={$id}>{$id}</option>"; } } ?> </select> <input type="submit" name="delete_person" value="Delete"> </form> </div> <br /> <span style="color:green"> <?php addPerson($conn); addUser($conn); addSensor($conn); deleteUser($conn); deletePerson($conn); deleteSensor($conn); updatePerson($conn); updateUser($conn); ?> </span> </body> </html>