Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
69 lines (65 sloc) 3.37 KB
<?php
include 'dbconnect.php';
$latitude = isset($_GET['latitude']) ? $_GET['latitude'] : '0';
$latitude = (float)str_replace(",", ".", $latitude); // to handle European locale decimals
$longitude = isset($_GET['longitude']) ? $_GET['longitude'] : '0';
$longitude = (float)str_replace(",", ".", $longitude);
$speed = isset($_GET['speed']) ? $_GET['speed'] : 0;
$direction = isset($_GET['direction']) ? $_GET['direction'] : 0;
$distance = isset($_GET['distance']) ? $_GET['distance'] : '0';
$distance = (float)str_replace(",", ".", $distance);
$date = isset($_GET['date']) ? $_GET['date'] : '0000-00-00 00:00:00';
$date = urldecode($date);
$locationmethod = isset($_GET['locationmethod']) ? $_GET['locationmethod'] : '';
$locationmethod = urldecode($locationmethod);
$username = isset($_GET['username']) ? $_GET['username'] : 0;
$phonenumber = isset($_GET['phonenumber']) ? $_GET['phonenumber'] : '';
$sessionid = isset($_GET['sessionid']) ? $_GET['sessionid'] : 0;
$accuracy = isset($_GET['accuracy']) ? $_GET['accuracy'] : 0;
$extrainfo = isset($_GET['extrainfo']) ? $_GET['extrainfo'] : '';
$eventtype = isset($_GET['eventtype']) ? $_GET['eventtype'] : '';
// doing some validation here
if ($latitude == 0 && $longitude == 0) {
exit('-1');
}
$params = array(':latitude' => $latitude,
':longitude' => $longitude,
':speed' => $speed,
':direction' => $direction,
':distance' => $distance,
':date' => $date,
':locationmethod' => $locationmethod,
':username' => $username,
':phonenumber' => $phonenumber,
':sessionid' => $sessionid,
':accuracy' => $accuracy,
':extrainfo' => $extrainfo,
':eventtype' => $eventtype
);
switch ($dbType) {
case DB_MYSQL:
$stmt = $pdo->prepare( $sqlFunctionCallMethod.'prcSaveGPSLocation(
:latitude,
:longitude,
:speed,
:direction,
:distance,
:date,
:locationmethod,
:username,
:phonenumber,
:sessionid,
:accuracy,
:extrainfo,
:eventtype);'
);
break;
case DB_POSTGRESQL:
case DB_SQLITE3:
$stmt = $pdo->prepare('INSERT INTO gpslocations (latitude, longitude, speed, direction, distance, gpsTime, locationMethod, userName, phoneNumber, sessionID, accuracy, extraInfo, eventType) VALUES (:latitude, :longitude, :speed, :direction, :distance, :date, :locationmethod, :username, :phonenumber, :sessionid, :accuracy, :extrainfo, :eventtype)');
break;
}
$stmt->execute($params);
$timestamp = $stmt->fetchColumn();
echo $timestamp;
?>
You can’t perform that action at this time.