/
query.php
executable file
·68 lines (56 loc) · 1.67 KB
/
query.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
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<?php
session_start();
require("dbase/dbFunction.php");
$cmd=$_POST['cmd'];
switch($cmd){
case 'checkNameExist':
$name=$_POST['name'];
$res=checkuser("name",$name);
echo $res;
break;
case 'checkEmailExist':
$email=$_POST['email'];
$res=checkuser("email",$email);
echo $res;
break;
case 'getUserPos':
if(isset($_SESSION['name'])){
$name=$_SESSION['name'];
$res=getUserPos($name);
echo $res;
}
else{ echo "0 0";}
break;
case 'setUserPos':
if(isset($_SESSION['name'])){
$name=$_SESSION['name'];
$longitude=$_POST['longitude'];
$latitude=$_POST['latitude'];
$res=setUserPos($longitude, $latitude);
}
break;
case 'getUserPic':
if(isset($_SESSION['name'])){
$name=$_SESSION['name'];
$longMin=floatval($_POST['longMin']);
$longMax=floatval($_POST['longMax']);
$latMin=floatval($_POST['latMin']);
$latMax=floatval($_POST['latMax']);
$num=intval($_POST['num']);
$res=getUserPic($name,$num,$longMin,$longMax,$latMin,$latMax);
echo $res;
}
else{echo "";}
break;
case 'getAllPic':
$longMin=floatval($_POST['longMin']);
$longMax=floatval($_POST['longMax']);
$latMin=floatval($_POST['latMin']);
$latMax=floatval($_POST['latMax']);
$num=intval($_POST['num']);
$res=getAllPic($num,$longMin,$longMax,$latMin,$latMax);
echo $res;
break;
default:break;
}
?>