-
Notifications
You must be signed in to change notification settings - Fork 1
/
geo.php
24 lines (23 loc) · 831 Bytes
/
geo.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?php
session_start();
require "bd.php";
require "session.php";
$login = $_SESSION['user'];
$lat = $_POST['lat'];
$lon = $_POST['lon'];
$date = date("d.m.y");
$time = date("H:i:s");
$result = mysqli_query($link, "SELECT * FROM geo WHERE name='$login'");
$num = mysqli_num_rows($result);
if ($num > 0 )
{
$result = mysqli_query($link, "UPDATE geo SET lat='$lat' WHERE name='$login'");
$result = mysqli_query($link, "UPDATE geo SET lon='$lon' WHERE name='$login'");
$result = mysqli_query($link, "UPDATE geo SET date='$date' WHERE name='$login'");
$result = mysqli_query($link, "UPDATE geo SET time='$time' WHERE name='$login'");
}
else
{
$query = mysqli_query($link, "INSERT INTO `geo`(`name`, `lat`, `lon`, `date`, `time`) VALUES ('$login','$lat','$lon', '$date', '$time')");
}
?>