-
Notifications
You must be signed in to change notification settings - Fork 0
/
myLikes.aspx
88 lines (76 loc) · 2.47 KB
/
myLikes.aspx
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
<%@ Language="javascript" %>
<%
//Find Favorites
var query = "SELECT * FROM Likes WHERE RefProfile = " +Session("refProfile");
var myRec = new ActiveXObject("ADODB.Recordset");
myRec.Open( query , Session("mycon") );
var count = 0;
var colLikes = [];
var i=0;
while(!myRec.EOF)
{
colLikes.push(myRec.Fields['RefProfileYouLike'].Value);
i++;
myRec.MoveNext();
}
count=i+1;
myRec.Close();
%>
<!DOCTYPE html>
<html>
<head>
<title>My Likes</title>
<style type="text/css">
.auto-style4 {
width: 150px;
}
.auto-style5 {
height: 116px;
text-align: center;
}
.auto-style6 {
width: 142px;
height: 137px;
}
.auto-style9 {
float: left;
width: 174px;
}
.auto-style10 {
text-align: center;
}
</style>
</head>
<body style="background-color:whitesmoke;" >
<p style="text-align:center; font-size: 50px; font-weight: bolder; font-family: 'Brush Script MT'; font-style: normal">My Likes</p>
<hr />
<div class="auto-style10">
<a href="welcome.aspx" style="font-family: cursive; font-size: 22px">Back</a>
</div>
<div style="background-color:floralwhite; width:1330px; height: 400px" class="auto-style10">
<%
for(var j in colLikes)
{
query = "SELECT FirstName, LastName, Country, City, (YEAR(NOW()) - YEAR(Birthday)) AS Age FROM Profiles WHERE RefProfile= " +colLikes[j];
myRec = new ActiveXObject("ADODB.Recordset");
myRec.Open( query , Session("mycon") );
%>
<div class="auto-style9">
<table class="auto-style4" style="border: medium double #FF9933">
<tr>
<td class="auto-style5">
<img src="img/yourLikes.png" alt="Photo" class="auto-style6" style="border-bottom-style: solid; border-bottom-width: medium; border-bottom-color: #FF9933" /></td>
</tr>
<tr>
<td><%= myRec.Fields['FirstName'].Value %> <%= myRec.Fields['LastName'].Value %><br /><%= myRec.Fields['Age'].Value %> years</td>
</tr>
<tr>
<td><%= myRec.Fields['Country'].Value %>, <%= myRec.Fields['City'].Value %></td>
</tr>
</table>
</div>
<% myRec.Close();
} %>
</div>
</body>
</html>