Show the Map of Gpstracker3 username only

[pharidali]

Dear sir,

How to show the map of GpsTracker3 only and avoid dropdown Selecter?

Please help me

Thank you.

[pharidali]

please help me

[brentfraser]

GpsTracker uses Leaflet for map display. You can experiment with showing a Leaflet map in your web page, then you will have to write some PHP (similar to GpsTracker's getrouteformap.php) to get locations based on a userid.

[pharidali]

In the DropDown Box if we click on the GpsTracker3 , The Map shows GpsTracker3 Location only. So i think it open on a link. Can we find the link?

[pharidali]

??

[brentfraser]

Not really a link, it's a URL with a session ID (a route and a session are the same thing):

https://www.websmithing.com/gpstracker/getrouteformap.php?sessionid=50053a16-e56a-49fc-99d7-cf19455892e3

One user may have many routes listed in the dropdown and the sessionid changes everytime the user stops and starts tracking.

[pharidali]

Please help me, I am getting confused

[brentfraser]

I thought I was helping. What is your level of experience with:

• JavaScript?
• PHP?
• web servers?
• databases?
• web mapping?

[pharidali]

php

[brentfraser]

PHP is a good start, but you need to know JavaScript. Find a good online tutorial for Javascript.

[pharidali]

ok

[pharidali]

hello sir,

In getroutes.php
I have edit this but not working

prepare('CALL prcGetRoutes(:userName);'); break; case DB_POSTGRESQL: case DB_SQLITE3: $stmt = $pdo->prepare('select * from v_GetRoutes;'); break; } $stmt->execute(array(':userName' => momo)); $json = '{ "routes": ['; foreach ($stmt as $row) { $json .= $row['json']; $json .= ','; } $json = rtrim($json, ","); $json .= '] }'; header('Content-Type: application/json'); echo $json; ?>

but not working

[pharidali]

`<?php
include 'dbconnect.php';

switch ($dbType) {
    case DB_MYSQL:
        $stmt = $pdo->prepare('CALL prcGetRoutes(:userName);');
        break;
    case DB_POSTGRESQL:
    case DB_SQLITE3:
        $stmt = $pdo->prepare('select * from v_GetRoutes;');
        break;
}
$stmt->execute(array(':userName' => momo));
$json = '{ "routes": [';
foreach ($stmt as $row) {
    $json .= $row['json'];
    $json .= ',';
}

$json = rtrim($json, ",");
$json .= '] }';
header('Content-Type: application/json');
echo $json;

?>`

[pharidali]

I think we can get one selected User on DropDown ??

[brentfraser]

I'm not sure I understand. The drop down has sessions/routs for a user. If you want to change that you will have to edit the JavaScript, the PHP, and possibly the database functions.

[brentfraser]

And this staement is a problem:
$stmt->execute(array(':userName' => momo));
if momo is supposed to be a variable name it is not defined. If it is a value (string) is is not quoted.