-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy paththankYou.php
58 lines (48 loc) · 1.64 KB
/
thankYou.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
<html>
<head>
<link rel="stylesheet" type="text/css" href="./CSS_Soft/thanks.css">
</head>
<body>
<div id="Thanks">
<h2>Thank you for submitting your survey!</h2>
<form action="http://google.com">
<input type="submit" value="View Results" />
</form>
</div>
</body>
</html>
<?php
if (!include('MyersDBConneciton.php')) {
die('error finding connect file');
}
$dbh = ConnectDB();
$sc1=$_POST['sc1'];
$sc2=$_POST['sc2'];
$sc3=$_POST['sc3'];
$sc4=$_POST['sc4'];
$sc5=$_POST['sc5'];
$distroKey = $_POST['dKey'];
include 'LoadDBLocal.php';
$dbh->beginTransaction();
if($sc1!="NaN"){
$sql1 ="INSERT INTO survey_result(user_ID, survey_ID, scores, category_ID) values('".$accountID."', '".$survey_ID."', '".$sc1."', '".$category[0][category_ID]."');";
$dbh->exec($sql1);
}
if($sc2!="NaN"){
$sql2 = "INSERT INTO survey_result(user_ID, survey_ID, scores, category_ID) values('".$accountID."', '".$survey_ID."', '".$sc2."', '".$category[1][category_ID]."');";
$dbh->exec($sql2);
}
if($sc3!="NaN"){
$sql3 ="INSERT INTO survey_result(user_ID, survey_ID, scores, category_ID) values('".$accountID."', '".$survey_ID."', '".$sc3."', '".$category[2][category_ID]."');";
$dbh->exec($sql3);
}
if($sc4!="NaN"){
$sql4 ="INSERT INTO survey_result(user_ID, survey_ID, scores, category_ID) values('".$accountID."', '".$survey_ID."', '".$sc4."', '".$category[3][category_ID]."');";
$dbh->exec($sql4);
}
if($sc5!="NaN"){
$sql5 ="INSERT INTO survey_result(user_ID, survey_ID, scores, category_ID) values('".$accountID."', '".$survey_ID."', '".$sc5."', '".$category[4][category_ID]."');";
$dbh->exec($sql5);
}
$dbh->commit();
?>