Newer
Older
GpsTracker / servers / php / deleteroute.php
@brentfraser brentfraser on 21 Aug 2015 525 bytes added databases
<?php
    include 'dbconnect.php';
    
    $sessionid   = isset($_GET['sessionid']) ? $_GET['sessionid'] : '0';

    switch ($dbType) {
        case DB_MYSQL:
            $stmt = $pdo->prepare($sqlFunctionCallMethod.'prcDeleteRoute(:sessionID)');     
            break;
        case DB_POSTGRESQL:
        case DB_SQLITE3:
            $stmt = $pdo->prepare('DELETE FROM gpslocations WHERE sessionID = :sessionID');     
            break;
    }

    $stmt->execute(array(':sessionID' => $sessionid));

?>