}
}
?>
</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>
//Search, add, or remove
define("projectID", "10-31-14-10-16");
define("NameFirst", "John");
//A person, project, or shift from the
define("NameLast", "Smith");
//Table; First check to see if
//John Smith is already in the table - GIOVI
echo 'testing reportsAjax.php</br>';
error_log('testing reportsAjax.php</br>');
createPerson();
createShift();
createProject();
addPersontoShift();
addPersontoProject();
getReport();
deletePerson();
deleteShift();
deleteProject();
echo 'reportsAjax.php testing complete</br>';
error_log('testing reportsAjax.php</br>');
function createPerson()
{
$m = new Person("John", "Smith", "10-12-87", "Male", "555 Main Street", "Flushing", "NY", "11111", "7188475582", "2072654046", "*****@*****.**", "volunteer", " ", "Schedule", "I like helping out", "55555", "03-14-14", "email");
$result = add_person($m);
echo 'result is ' . $result . '</br>';
if ($result) {
echo "person was added </br>";
} else {
echo "person already exists in db, not added</br>";
}
}
$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>
# ----
$resource = getResource();
$request_method = getMethod();
$parameters = getParameters();
# Redirect to appropriate handlers.
if ($resource[0] == "staffapi") {
if ($request_method == "POST" && $resource[1] == "person") {
postPerson($parameters);
} else {
if ($request_method == "GET" && $resource[1] == "persons") {
getPersons();
} else {
if ($request_method == "GET" && $resource[1] == "person") {
getPerson($resource[2]);
} else {
if ($request_method == "DELETE" && $resource[1] == "person") {
deletePerson($resource[2]);
} else {
http_response_code(405);
# Method not allowed
}
}
}
}
} else {
http_response_code(405);
# Method not allowed
}
?>