-
Notifications
You must be signed in to change notification settings - Fork 2
/
pre_result.php
242 lines (241 loc) · 13.2 KB
/
pre_result.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
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
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
<style type="text/css">
.pga { width: 100%; }
body{background-color: lightgrey;}
</style>
<body style="margin: 0px; font-family: sans-serif;">
<div class = "pga">
<?php
include 'init.php';
if(!logged_in())
{
header('Location: index.php');
exit();
}
include 'template/header.php';
?>
<div style="border:10px;">
<?php
$a=$_SESSION['user_id'];
$conn = new PDO("mysql:host=localhost;dbname=project",'root','12345');
$data_query = $conn->query("select * from preference where user_id =$a");
$preference = $data_query->fetchAll(PDO::FETCH_ASSOC);
$data_query = $conn->query("select * from users");
$users = $data_query->fetchAll(PDO::FETCH_ASSOC);
//var_dump($preference);
//var_dump($users);
$i=0;
echo '<br/>1st<br/>';
foreach($users as $user)
{
$data_query = $conn->query("select * from details");
$details = $data_query->fetchAll(PDO::FETCH_ASSOC);
//var_dump($details);
$users[$i]['printed']=0;
if($user['gender'] === $preference[0]['looking'] &&
$details[0]['maritalstatus'] === $preference[0]['marital_status'] &&
$user['religion'] === $preference[0]['religion'] &&
$details[0]['mothertongue'] === $preference[0]['mother_tongue'] &&
$user['state'] === $preference[0]['state'] &&
$details[0]['education'] === $preference[0]['education'] &&
$details[0]['course'] === $preference[0]['course'] &&
$details[0]['occupation'] === $preference[0]['occupation'] &&
$details[0]['income'] === $preference[0]['income'] &&
$details[0]['height'] >= $preference[0]['height_from'] &&
$details[0]['height'] <= $preference[0]['height_to'] &&
$details[0]['age'] >= $preference[0]['agefrom'] &&
$details[0]['age'] <= $preference[0]['ageto'] )
{
echo "NAME ".$user['name'],'<br/>';echo "AGE ".$details[0]['age'],'<br/>';echo "RELIGION ".$user['religion'],'<br/>';echo "EDUCATION ".$details[0]['education'],'<br/>';echo "OCCUPATION ".$details[0]['occupation'],'<br/>';echo "INCOME ".$details[0]['income'],'<br/>';echo "HEIGHT ".$details[0]['height'],'<br/>';echo "COMPLEXION ".$details[0]['complexion'],'<br/>';echo "MARITAL STATUS ".$details[0]['maritalstatus'],'<br/>','<br/>','<br/>','<br/>';
$users[$i]['printed']=1;
}
$i = $i +1;
}
$i=0;
echo '<br/>2nd<br/>';
foreach($users as $user)
{
$data_query = $conn->query("select * from details");
$details = $data_query->fetchAll(PDO::FETCH_ASSOC);
//var_dump($details);
$users[$i]['printed']=0;
if($user['gender'] === $preference[0]['looking'] &&
$details[0]['maritalstatus'] === $preference[0]['marital_status'] &&
$user['religion'] === $preference[0]['religion'] &&
$details[0]['mothertongue'] === $preference[0]['mother_tongue'] &&
$user['state'] === $preference[0]['state'] &&
$details[0]['education'] === $preference[0]['education'] &&
$details[0]['course'] === $preference[0]['course'] &&
//$details[0]['occupation'] === $preference[0]['occupation'] &&
$details[0]['income'] === $preference[0]['income'] &&
$details[0]['height'] >= $preference[0]['height_from'] &&
$details[0]['height'] <= $preference[0]['height_to'] &&
$details[0]['age'] >= $preference[0]['agefrom'] &&
$details[0]['age'] <= $preference[0]['ageto'] )
{
echo "NAME ".$user['name'],'<br/>';echo "AGE ".$details[0]['age'],'<br/>';echo "RELIGION ".$user['religion'],'<br/>';echo "EDUCATION ".$details[0]['education'],'<br/>';echo "OCCUPATION ".$details[0]['occupation'],'<br/>';echo "INCOME ".$details[0]['income'],'<br/>';echo "HEIGHT ".$details[0]['height'],'<br/>';echo "COMPLEXION ".$details[0]['complexion'],'<br/>';echo "MARITAL STATUS ".$details[0]['maritalstatus'],'<br/>','<br/>','<br/>','<br/>';
$users[$i]['printed']=1;
}
$i = $i +1;
}
$i=0;
echo '<br/>3rd<br/>';
foreach($users as $user)
{
$data_query = $conn->query("select * from details");
$details = $data_query->fetchAll(PDO::FETCH_ASSOC);
//var_dump($details);
$users[$i]['printed']=0;
if($user['gender'] === $preference[0]['looking'] &&
$details[0]['maritalstatus'] === $preference[0]['marital_status'] &&
$user['religion'] === $preference[0]['religion'] &&
$details[0]['mothertongue'] === $preference[0]['mother_tongue'] &&
//$user['state'] === $preference[0]['state'] &&
$details[0]['education'] === $preference[0]['education'] &&
$details[0]['course'] === $preference[0]['course'] &&
$details[0]['occupation'] === $preference[0]['occupation'] &&
$details[0]['income'] === $preference[0]['income'] &&
$details[0]['height'] >= $preference[0]['height_from'] &&
$details[0]['height'] <= $preference[0]['height_to'] &&
$details[0]['age'] >= $preference[0]['agefrom'] &&
$details[0]['age'] <= $preference[0]['ageto'] )
{
echo "NAME ".$user['name'],'<br/>';echo "AGE ".$details[0]['age'],'<br/>';echo "RELIGION ".$user['religion'],'<br/>';echo "EDUCATION ".$details[0]['education'],'<br/>';echo "OCCUPATION ".$details[0]['occupation'],'<br/>';echo "INCOME ".$details[0]['income'],'<br/>';echo "HEIGHT ".$details[0]['height'],'<br/>';echo "COMPLEXION ".$details[0]['complexion'],'<br/>';echo "MARITAL STATUS ".$details[0]['maritalstatus'],'<br/>','<br/>','<br/>','<br/>';
$users[$i]['printed']=1;
}
$i = $i +1;
}
$i=0;
echo '<br/>4th<br/>';
foreach($users as $user)
{
$data_query = $conn->query("select * from details");
$details = $data_query->fetchAll(PDO::FETCH_ASSOC);
//var_dump($details);
$users[$i]['printed']=0;
if($user['gender'] === $preference[0]['looking'] &&
$details[0]['maritalstatus'] === $preference[0]['marital_status'] &&
$user['religion'] === $preference[0]['religion'] &&
$details[0]['mothertongue'] === $preference[0]['mother_tongue'] &&
$user['state'] === $preference[0]['state'] &&
$details[0]['education'] === $preference[0]['education'] &&
//$details[0]['course'] === $preference[0]['course'] &&
$details[0]['occupation'] === $preference[0]['occupation'] &&
$details[0]['income'] === $preference[0]['income'] &&
$details[0]['height'] >= $preference[0]['height_from'] &&
$details[0]['height'] <= $preference[0]['height_to'] &&
$details[0]['age'] >= $preference[0]['agefrom'] &&
$details[0]['age'] <= $preference[0]['ageto'] )
{
echo "NAME ".$user['name'],'<br/>';echo "AGE ".$details[0]['age'],'<br/>';echo "RELIGION ".$user['religion'],'<br/>';echo "EDUCATION ".$details[0]['education'],'<br/>';echo "OCCUPATION ".$details[0]['occupation'],'<br/>';echo "INCOME ".$details[0]['income'],'<br/>';echo "HEIGHT ".$details[0]['height'],'<br/>';echo "COMPLEXION ".$details[0]['complexion'],'<br/>';echo "MARITAL STATUS ".$details[0]['maritalstatus'],'<br/>','<br/>','<br/>','<br/>';
$users[$i]['printed']=1;
}
$i = $i +1;
}
$i=0;
echo '<br/>5th<br/>';
foreach($users as $user)
{
$data_query = $conn->query("select * from details");
$details = $data_query->fetchAll(PDO::FETCH_ASSOC);
//var_dump($details);
$users[$i]['printed']=0;
if($user['gender'] === $preference[0]['looking'] &&
$details[0]['maritalstatus'] === $preference[0]['marital_status'] &&
$user['religion'] === $preference[0]['religion'] &&
$details[0]['mothertongue'] === $preference[0]['mother_tongue'] &&
$user['state'] === $preference[0]['state'] &&
//$details[0]['education'] === $preference[0]['education'] &&
$details[0]['course'] === $preference[0]['course'] &&
$details[0]['occupation'] === $preference[0]['occupation'] &&
$details[0]['income'] === $preference[0]['income'] &&
$details[0]['height'] >= $preference[0]['height_from'] &&
$details[0]['height'] <= $preference[0]['height_to'] &&
$details[0]['age'] >= $preference[0]['agefrom'] &&
$details[0]['age'] <= $preference[0]['ageto'] )
{
echo "NAME ".$user['name'],'<br/>';echo "AGE ".$details[0]['age'],'<br/>';echo "RELIGION ".$user['religion'],'<br/>';echo "EDUCATION ".$details[0]['education'],'<br/>';echo "OCCUPATION ".$details[0]['occupation'],'<br/>';echo "INCOME ".$details[0]['income'],'<br/>';echo "HEIGHT ".$details[0]['height'],'<br/>';echo "COMPLEXION ".$details[0]['complexion'],'<br/>';echo "MARITAL STATUS ".$details[0]['maritalstatus'],'<br/>','<br/>','<br/>','<br/>';
$users[$i]['printed']=1;
}
$i = $i +1;
}
$i=0;
echo '<br/>6th<br/>';
foreach($users as $user)
{
$data_query = $conn->query("select * from details");
$details = $data_query->fetchAll(PDO::FETCH_ASSOC);
//var_dump($details);
$users[$i]['printed']=0;
if($user['gender'] === $preference[0]['looking'] &&
$details[0]['maritalstatus'] === $preference[0]['marital_status'] &&
$user['religion'] === $preference[0]['religion'] &&
$details[0]['mothertongue'] === $preference[0]['mother_tongue'] &&
$user['state'] === $preference[0]['state'] &&
$details[0]['education'] === $preference[0]['education'] &&
$details[0]['course'] === $preference[0]['course'] &&
$details[0]['occupation'] === $preference[0]['occupation'] &&
//$details[0]['income'] === $preference[0]['income'] &&
$details[0]['height'] >= $preference[0]['height_from'] &&
$details[0]['height'] <= $preference[0]['height_to'] &&
$details[0]['age'] >= $preference[0]['agefrom'] &&
$details[0]['age'] <= $preference[0]['ageto'] )
{
echo "NAME ".$user['name'],'<br/>';echo "AGE ".$details[0]['age'],'<br/>';echo "RELIGION ".$user['religion'],'<br/>';echo "EDUCATION ".$details[0]['education'],'<br/>';echo "OCCUPATION ".$details[0]['occupation'],'<br/>';echo "INCOME ".$details[0]['income'],'<br/>';echo "HEIGHT ".$details[0]['height'],'<br/>';echo "COMPLEXION ".$details[0]['complexion'],'<br/>';echo "MARITAL STATUS ".$details[0]['maritalstatus'],'<br/>','<br/>','<br/>','<br/>';
$users[$i]['printed']=1;
}
$i = $i +1;
}
$i=0;
echo '<br/>7th<br/>';
foreach($users as $user)
{
$data_query = $conn->query("select * from details");
$details = $data_query->fetchAll(PDO::FETCH_ASSOC);
//var_dump($details);
$users[$i]['printed']=0;
if($user['gender'] === $preference[0]['looking'] &&
$details[0]['maritalstatus'] === $preference[0]['marital_status'] &&
$user['religion'] === $preference[0]['religion'] &&
$details[0]['mothertongue'] === $preference[0]['mother_tongue'] &&
//$user['state'] === $preference[0]['state'] &&
//$details[0]['education'] === $preference[0]['education'] &&
//$details[0]['course'] === $preference[0]['course'] &&
//$details[0]['occupation'] === $preference[0]['occupation'] &&
$details[0]['income'] === $preference[0]['income'] &&
$details[0]['height'] >= $preference[0]['height_from'] &&
$details[0]['height'] <= $preference[0]['height_to'] &&
$details[0]['age'] >= $preference[0]['agefrom'] &&
$details[0]['age'] <= $preference[0]['ageto'] )
{
echo "NAME ".$user['name'],'<br/>';echo "AGE ".$details[0]['age'],'<br/>';echo "RELIGION ".$user['religion'],'<br/>';echo "EDUCATION ".$details[0]['education'],'<br/>';echo "OCCUPATION ".$details[0]['occupation'],'<br/>';echo "INCOME ".$details[0]['income'],'<br/>';echo "HEIGHT ".$details[0]['height'],'<br/>';echo "COMPLEXION ".$details[0]['complexion'],'<br/>';echo "MARITAL STATUS ".$details[0]['maritalstatus'],'<br/>','<br/>','<br/>','<br/>';
$users[$i]['printed']=1;
}
$i = $i +1;
}
$i=0;echo '<br/>8th<br/>';
foreach($users as $user)
{ $data_query = $conn->query("select * from details");$details = $data_query->fetchAll(PDO::FETCH_ASSOC);//var_dump($details);
$users[$i]['printed']=0;
if($user['gender'] === $preference[0]['looking'] &&
$details[0]['maritalstatus'] === $preference[0]['marital_status'] &&
$user['religion'] === $preference[0]['religion'] &&
$details[0]['mothertongue'] === $preference[0]['mother_tongue'] &&
//$user['state'] === $preference[0]['state'] &&
//$details[0]['education'] === $preference[0]['education'] &&
//$details[0]['course'] === $preference[0]['course'] &&
//$details[0]['occupation'] === $preference[0]['occupation'] &&
$details[0]['income'] === $preference[0]['income'] &&
$details[0]['height'] >= $preference[0]['height_from'] &&
$details[0]['height'] <= $preference[0]['height_to'] &&
$details[0]['age'] >= $preference[0]['agefrom'] &&
$details[0]['age'] <= $preference[0]['ageto'] )
{ echo "NAME ".$user['name'],'<br/>';echo "AGE ".$details[0]['age'],'<br/>';echo "RELIGION ".$user['religion'],'<br/>';echo "EDUCATION ".$details[0]['education'],'<br/>';echo "OCCUPATION ".$details[0]['occupation'],'<br/>';echo "INCOME ".$details[0]['income'],'<br/>';echo "HEIGHT ".$details[0]['height'],'<br/>';echo "COMPLEXION ".$details[0]['complexion'],'<br/>';echo "MARITAL STATUS ".$details[0]['maritalstatus'],'<br/>','<br/>','<br/>','<br/>';$users[$i]['printed']=1;
} $i = $i +1;
}
?>
</div>
<?php
include 'template/footer.php';
?>
</div>
</body>