OCDDR/hoarding.php at master · CrazyCoder009/OCDDR · 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
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<html>
<head>
<link rel="stylesheet" href="style.css">
</head>
<body>

<?php
session_start();

	$servername = "localhost/html";
	$username = "root";
	$password = "ocd";
	$dbname = "pdb";
	$conn = mysqli_connect($servername,$username,$password,$dbname);
	if($conn->connect_error){ die("Connection failed: " . $conn->connect_error);}

$u = $_SESSION['username'];
$h1=$h2=$h3=$h4=$h5='';

if (isset($_POST['Submit']))
{
	if(!isset($_POST['H1']))
	{	$h1 = 0;
	}else
	{
		$h1 = $_POST['H1'];
	}
	if(!isset($_POST['H2']))
	{	$h2 = 0;
	}else
	{
		$h2 = $_POST['H2'];
	}
	if(!isset($_POST['H3']))
	{	$h3 = 0;
	}else
	{
		$h3 = $_POST['H3'];
	}
	if(!isset($_POST['H4']))
	{	$h4 = 0;
	}else
	{
		$h4 = $_POST['H4'];
	}
	if(!isset($_POST['H5']))
	{	$h5 = 0;
	}else
	{
		$h5 = $_POST['H5'];
	}

$insert_query = "insert into hoarding (
                    username,H1,H2,H3,H4,H5
                    ) values ( '$u','$h1','$h2','$h3','$h4','$h5')";

$conn->query($insert_query);

$sql_query = "SELECT * FROM hoarding WHERE username='$u'";

if ($result = $conn->query($sql_query)) {
	$row = $result->fetch_assoc();
	$field5name = $row["H1"] + $row["H2"] + $row["H3"]+ $row["H4"]+ $row["H5"];

	$qry = "UPDATE hoarding SET Total_H = '$field5name' WHERE username='$u'";
		$exc = mysqli_query($conn, $qry);
}

$conn->close();
}

?>

<br>
<input type="button" value="Go Back" id="sub_btn" onClick="javascript:history.go(-2)" />
<form method = "POST" action = "hoarding.php" id="symptom_form">
<h4>QUESTIONS ON HOARDING DISORDER:</h4>
<i>
Instructions:<br>1. If the answer to the question is "None", please ignore the question and continue with other questions.<br>
2. After attempting all the questions, click on the "Submit" button followed by "Go Back" button to return to the previous page in order to fill the remaining questions.<br>
<br>
</i>
1. Because of the clutter or number of possessions, how difficult is it for you to use the rooms in your home?<br>
<input type="radio" name="H1" value="1">1<br>
<input type="radio" name="H1" value="2">2 - Mild<br>
<input type="radio" name="H1" value="3">3<br>
<input type="radio" name="H1" value="4">4 - Moderate<br>
<input type="radio" name="H1" value="5">5<br>
<input type="radio" name="H1" value="6">6 - Severe<br>
<input type="radio" name="H1" value="7">7<br>
<input type="radio" name="H1" value="8">8 - Extremely difficult<br>
<br>
2. To what extent do you have difficulty discarding (or recycling, selling, giving away) ordinary things that other people would get rid of?<br>
<input type="radio" name="H2" value="1">1<br>
<input type="radio" name="H2" value="2">2 - Mild<br>
<input type="radio" name="H2" value="3">3<br>
<input type="radio" name="H2" value="4">4 - Moderate<br>
<input type="radio" name="H2" value="5">5<br>
<input type="radio" name="H2" value="6">6 - Severe<br>
<input type="radio" name="H2" value="7">7<br>
<input type="radio" name="H2" value="8">8 - Extreme difficulty<br>
<br>
3. To what extent do you currently have a problem with collecting free things or buying more things than you need or can use or can afford?<br>
<input type="radio" name="H3" value="1">1<br>
<input type="radio" name="H3" value="2">2 - Mild<br>
<input type="radio" name="H3" value="3">3<br>
<input type="radio" name="H3" value="4">4 - Moderate<br>
<input type="radio" name="H3" value="5">5<br>
<input type="radio" name="H3" value="6">6 - Severe<br>
<input type="radio" name="H3" value="7">7<br>
<input type="radio" name="H3" value="8">8 - Extreme<br>
<br>
4. To what extent do you experience emotional distress because of clutter, difficulty discarding or problems with buying or acquiring things?<br>
<input type="radio" name="H4" value="1">1<br>
<input type="radio" name="H4" value="2">2 - Mild<br>
<input type="radio" name="H4" value="3">3<br>
<input type="radio" name="H4" value="4">4 - Moderate<br>
<input type="radio" name="H4" value="5">5<br>
<input type="radio" name="H4" value="6">6 - Severe<br>
<input type="radio" name="H4" value="7">7<br>
<input type="radio" name="H4" value="8">8 - Extreme<br>
<br>
5. To what extent do you experience impairment in your life (daily routine, job / school, social activities, family activities, financial difficulties) because of clutter, difficulty discarding, or problems with buying or acquiring things?<br>
<input type="radio" name="H5" value="1">1<br>
<input type="radio" name="H5" value="2">2 - Mild<br>
<input type="radio" name="H5" value="3">3<br>
<input type="radio" name="H5" value="4">4 - Moderate<br>
<input type="radio" name="H5" value="5">5<br>
<input type="radio" name="H5" value="6">6 - Severe<br>
<input type="radio" name="H5" value="7">7<br>
<input type="radio" name="H5" value="8">8 - Extreme<br>
<br>
<br>
<button type="submit" name="Submit" id="sub_btn"> SUBMIT </button>
</form>
</body>
</html>