<?php
require __DIR__ . '/vendor/autoload.php';

use PsrHttpMessageServerRequestInterface;
use PsrHttpMessageResponseInterface;
$app = new SlimApp();

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Headers: Content-Type');
header('Access-Control-Allow-Methods: GET, PUT, POST, DELETE, OPTIONS');


$app->options('/test', function() use($app) {
    $response = $app->response();
    $app->response()->status(200);
    $response->header('Access-Control-Allow-Origin', '*');
    $response->header('Access-Control-Allow-Headers', 'Content-Type, X-Requested-With, X-authentication, X-client');
    $response->header('Access-Control-Allow-Methods', 'GET, POST, PUT, DELETE, OPTIONS');
});


$app->get('/test/', function(SlimHttpRequest $request, SlimHttpResponse $response, array $args) {

    $id = $args['id'];
    $sql = "SELECT * FROM wp_osoft_orders";

    $dbhost = "host";
    $dbuser = "user";
    $dbpass = "pass";
    $dbname = "db";

    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

    $headers = $response->getHeaders();
    $response = $response->withHeader('Content-type', 'application/json');
    $response = $response->withHeader('Access-Control-Allow-Origin', '*');
    $headers = $response->getHeaders();

    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $conn->set_charset("utf8");
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        $resultsArray = array();
        while($row = $result->fetch_assoc()) {
            array_push($resultsArray, $row);
        }
        $response->write(json_encode($resultsArray));
    }
    else {
        $response->write("0 results");
    }
    $conn->close();
});
$app->delete('/test/{id}', function(SlimHttpRequest $request, SlimHttpResponse $response, array $args) {

    $response = $response->withHeader('Access-Control-Allow-Origin', '*');
    $response->write("delete is OK");
});
    $app->run();
?>

function getOrders(){
    $http.get("http://mydomain.com/test/").success(function(data){
        $scope.orders = data;
    });

};

getOrders();
$scope.deleteOrder = function (orderId) {
    console.log("order to delete id: " + orderId);
    $http.delete("http://mydomain.com/test/"+orderId).success(function(response){
        console.log('delete response: ' + response);
    });
    getOrders();
};