-
Notifications
You must be signed in to change notification settings - Fork 0
/
writeLogs2db.php
54 lines (44 loc) · 1.34 KB
/
writeLogs2db.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
<?php
/**
* Created by PhpStorm.
* User: Andi Zhou
* Date: 2018/1/21
* Time: 15:15
*/
require "PATH/dbconnect.php"; //path and name for the db connection file
/*
* got posted data from mouselog.js through $.post(),
* INSERT the posted data into db.
*/
function insertDB(PDO $dbh, $sql_insert, $data) {
$stmt = $dbh->prepare($sql_insert);
$stmt->execute($data);
}
function sanitizePOST($post) {
$post = trim($post, "'");
$post = trim($post, '"');
return $post;
}
$sql_insert = "INSERT INTO searchlogs (pid, tid, query, etype, etarget, edesc, tstamp) VALUES "
. "(:pid, :tid, :query, :etype, :etarget, :edesc, :tstamp)";
if (isset($_POST['PID'], $_POST['TID'], $_POST['QUERY'],
$_POST['ETYPE'], $_POST['ETARGET'], $_POST['EDESC'], $_POST['TSTAMP'])) {
$pid = sanitizePOST($_POST['PID']);
$tid = sanitizePOST($_POST['TID']);
$query = sanitizePOST($_POST['QUERY']);
$etype = $_POST['ETYPE'];
$etarget = $_POST['ETARGET'];
$edesc = $_POST['EDESC'];
$tstamp = $_POST['TSTAMP'];
$data = array(
":pid" => $pid,
":tid" => $tid,
":query" => $query,
":etype" => $etype,
":etarget" => $etarget,
":edesc" => $edesc,
":tstamp" => $tstamp
);
insertDB($dbh, $sql_insert, $data);
}
?>