WebProject/sqlUtils.php at master · ksyro98/WebProject · GitHub

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
<?php

function appendLocationInsertValues(
    $uid,
    $keyTimestamp,
    $time,
    $latitude,
    $longitude,
    $activity,
    $heading,
    $confidence,
    $locTimestamp,
    $actTimestamp,
    $verticalAccuracy,
    $velocity,
    $accuracy,
    $altitude,
    $dateInfo
){
    $year = $dateInfo[0];
    $month = $dateInfo[1];
    $day = $dateInfo[2];
    $hour = $dateInfo[3];
    $dayOfWeek = $dateInfo[4];

    $res = " (\"$uid\", \"$keyTimestamp\", \"$time\", \"$latitude\", \"$longitude\", \"$activity\", ";
    $res = $res . "\"$heading\", \"$confidence\", \"$locTimestamp\", \"$actTimestamp\", \"$verticalAccuracy\", ";
    $res = $res . "\"$velocity\", \"$accuracy\", \"$altitude\", \"$year\", \"$month\", \"$day\", \"$hour\", ";
    $res = $res . "\"$dayOfWeek\")";

    return $res;
}