limeSql.php

<?php

session_start();
include 'database.php'; 

$httpMethod = strtoupper($_SERVER['REQUEST_METHOD']);

switch($httpMethod) {
  case "OPTIONS":
    // Allows anyone to hit your API, not just this c9 domain
    header("Access-Control-Allow-Headers: X-ACCESS_TOKEN, Access-Control-Allow-Origin, Authorization, Origin, X-Requested-With, Content-Type, Content-Range, Content-Disposition, Content-Description");
    header("Access-Control-Allow-Methods: POST, GET");
    header("Access-Control-Max-Age: 3600");
    exit();
  case "GET":
    // Allow any client to access
    header("Access-Control-Allow-Origin: *");
    
    http_response_code(401);
    echo "Not Supported";
    
    break;
  case 'POST':
    // Get the body json that was sent
    $rawJsonString = file_get_contents("php://input");

    //var_dump($rawJsonString);

    // Make it a associative array (true, second param)
    $jsonData = json_decode($rawJsonString, true);

    $data = limeToDatabase($jsonData["referralCode"], $jsonData["rides"]);
    
    $results = ["statusCode" => "0", "data" => $data];

    // Allow any client to access
    header("Access-Control-Allow-Origin: *");
    // Let the client know the format of the data being returned
    header("Content-Type: application/json");

    // Sending back down as JSON
    echo json_encode($results);

    break;
  case 'PUT':
    // Allow any client to access
    header("Access-Control-Allow-Origin: *");
    
    http_response_code(401);
    echo "Not Supported";
    break;
  case 'DELETE':
    // Allow any client to access
    header("Access-Control-Allow-Origin: *");
    
    http_response_code(401);
    break;
}
?>

<?php

function limeToDatabase($referralCode, $rides) {
    
    $dbConn = getDatabaseConnection();
    $sql = "SELECT * FROM `lime` WHERE `userID` =:userID"; 
    $statement = $dbConn->prepare($sql); 
    
    $statement->execute(array(':userID' => $_SESSION['user_id'])); 
    $records = $statement->fetchAll(); 
    if(count($records) == 1){
        $sql = "UPDATE `lime` SET referralCode = :referralCode, rides = :rides WHERE userID = :userID";
        $statement = $dbConn->prepare($sql); 
        $statement->execute(array(':referralCode'=>$referralCode, ':rides'=>$rides, ':userID'=>$_SESSION['user_id'])); 
    }
    else{
        $dbConn = getDatabaseConnection(); 
        $sql = "INSERT INTO `lime` (`limeID`, `userID`, `referralCode`, `rides`) VALUES (NULL, :user_id, :referralCode, :rides)";
        $statement = $dbConn->prepare($sql); 
        $statement->execute(array(':user_id'=>$_SESSION['user_id'], ':referralCode'=>$referralCode, ':rides'=>$rides)); 
    }
    return true;
    
    
    
        
}

?>