-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathrecordTime.php
36 lines (33 loc) · 1.25 KB
/
recordTime.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
<?php
//$fname = "QUICKFINANCE";
//$startTime = time();
//$dttime = date("Y-m-d H:i:s",$startTime);
$userID = "default_no_data";
//$endTime = time();
//$fsucc = "fail";
function recordUse($fname, $dttime, $startTime, $endTime, $userid, $fsucc) {
$remote =$_SERVER['REMOTE_ADDR'];
if ($remote =="") {$remote="EMPTY";}
$forward =$_SERVER['HTTP_X_FORWARDED_FOR'];
if ($forward =="") {$forward="EMPTY";}
include 'config.php';
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO function_usage (functName, startMills, endMills, startTime, userid, typesucc, remote_addr, forwarded_for)
VALUES ('$fname', '$startTime', '$endTime', '$dttime', '$userid', '$fsucc', '$remote', '$forward')";
// use exec() because no results are returned
$conn->exec($sql);
//echo "New record created successfully";
} catch(PDOException $e) {
//echo $sql . "<br>" . $e->getMessage();
}
// echo "$fname Refsnes.<br>";
// echo "$dttime Refsnes.<br>";
// echo "$startTime Refsnes.<br>";
// echo "$endTime Refsnes.<br>";
// echo "$userid Refsnes.<br>";
}
//recordUse($fname, $dttime, $startTime, $endTime, $userid, $fsucc);
?>