πŸ§ͺ GPS Tracking System - Test Dashboard

πŸ‘€ Current User: test_user

1️⃣ Database Connection Test

βœ… Database connection successful!
βœ… Table s_autolocations exists

Table Structure:

FieldTypeNullKeyDefault
idint(11)NOPRI
user_namevarchar(50)YESMUL
latitudedecimal(10,8)YES
longitudedecimal(11,8)YES
sdatetimestampYESMULCURRENT_TIMESTAMP
sal_exvarchar(10)YES
πŸ“Š Total GPS records in database: 24282

2️⃣ Browser Geolocation API Test

⏳ Checking GPS support...

3️⃣ Test Logs

4️⃣ Recent GPS Records (Last 10)

IDUserDate/TimeLatitudeLongitudeMap
25048Malinda2026-11-17 13:56:556.9338317079.86459830πŸ—ΊοΈ View
25047Malinda2026-11-17 13:55:576.9338303079.86460260πŸ—ΊοΈ View
25046Malinda2026-11-17 13:55:296.9338259079.86460100πŸ—ΊοΈ View
25045Chanka2026-11-17 13:54:266.9338307079.86459790πŸ—ΊοΈ View
25044Chanka2026-11-17 13:50:176.9338307079.86459790πŸ—ΊοΈ View
25043Chanka2026-11-17 13:48:536.9338260079.86459900πŸ—ΊοΈ View
25042Chanka2026-11-17 13:48:056.9338290079.86459710πŸ—ΊοΈ View
25041Chanka2026-11-17 13:47:126.9338240079.86459710πŸ—ΊοΈ View
25040Chanka2026-11-17 13:46:136.9337264079.86482270πŸ—ΊοΈ View
25039Chanka2026-11-17 12:31:256.9338312079.86459760πŸ—ΊοΈ View

5️⃣ How to Use

Automatic Tracking: Manual Testing: Troubleshooting:

6️⃣ Useful SQL Queries

-- View all GPS records for current user
SELECT * FROM s_autolocations WHERE user_name = 'test_user' ORDER BY sdate DESC;

-- View GPS records from today
SELECT * FROM s_autolocations WHERE DATE(sdate) = CURDATE() ORDER BY sdate DESC;

-- Count records per user
SELECT user_name, COUNT(*) as total FROM s_autolocations GROUP BY user_name;

-- Delete all test records
DELETE FROM s_autolocations WHERE user_name = 'test_user';