Example #1
0
<?php

$id = htmlspecialchars($_GET["id"]);
function delete_person($id)
{
    include 'dbconnect.php';
    $query = "Delete FROM Person WHERE id='" . $id . "'";
    $result = mysqli_query($connection, $query);
    if ($result) {
        echo "ok";
    } else {
        echo "nicht ok";
    }
}
function delete_notes($person_id)
{
    include 'dbconnect.php';
    $query = "Delete FROM Notiz WHERE person_id='" . $person_id . "'";
    $result = mysqli_query($connection, $query);
    if ($result) {
        echo "ok";
    } else {
        echo "nicht ok";
    }
}
delete_person($id);
delete_notes($id);
Example #2
0
 //note: remove 'data' from equation
 $reply = array();
 $request = json_decode($_POST['data'], true);
 //note: clean up post before use
 //echo 'request > ', var_dump($request);
 if (isset($request['action'])) {
     $userId = $_SESSION['userId'];
     switch ($request['action']) {
         case 'get_notes':
             get_notes($userId);
             break;
         case 'save_notes':
             save_notes($userId, $request['notas']);
             break;
         case 'delete_notes':
             delete_notes($userId, $request['ids']);
             break;
         case 'getUserPrefs':
             getUserPrefs($userId);
             break;
         case 'setUserPrefs':
             setUserPrefs($userId, $request['arg']);
             break;
         case 'logout':
             logoutUser();
             break;
         default:
             $reply['errors'] = array('Invalid Action or no Action');
             replyJson($reply);
     }
 } else {