}
}
?>
</table>
<?php
//HELEN
//Car=Person
//id=color
//plate_number=time
//color=gender
// kas kustutame
// ?delete=vastav id mida kustutada on aadressireal
if (isset($_GET["delete"])) {
echo "Kustutame id " . $_GET["delete"];
//käivitan funktsiooni, saadan kaasa id!
deletePerson($_GET["delete"]);
}
//HELEN - salvestan andmebaasi uuendused
if (isset($_POST["save"])) {
updatePerson($_POST["color"], $_POST["time"], $_POST["gender"]);
}
//käivitan funktsiooni
$array_of_persons = getPersonData();
//trükin välja esimese auto
//echo $array_of_cars[0]->id." ".$array_of_cars[0]->plate;
?>
<a href="http://greeny.cs.tlu.ee/~helepuh/eksam/data.php">Tagasi</a>
$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>
