<%
if session("username") = "" then
utente = "
visitatore"
else
utente = "
" & session("username") & ""
end if
ID = Request.QueryString("id")
if id <> "" then
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mapPath("Db/database.mdb")
set rs = server.CreateObject ("ADODB.Recordset")
sSQL="Select * from Utenti where ID=" &ID
rs.open sSQL,conn,3,3
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Profilo Personale di <%=rs("Username") %></title>
</head>
<body>
<table align="center" cellpadding="5">
<tr>
<td colspan="2">
<b style="font-size: 1.6em; font-weight: bold;"><%= rs("Username") %>[/b]
<%= rs("MessaggioPersonale") %>
</td>
</tr>
<tr>
<td>
[img]noavatar.gif[/img]
</td>
<td>
Username:
<%= rs("Username") %>
Nome:
<%= rs("Nome") %>
</td>
</tr>
<tr>
<td>
Sesso:
<%= rs("Sesso") %>
Nato :
<%= rs("Datanascita") %>
</td>
<td>
Città:
<%= rs("Citta") %>
Email:
<%= rs("Email") %>
</td>
</tr>
<tr>
<td colspan="2">
<p align="center">
Torna all'elenco</td>
</tr>
</table>
</body>
</html>
<%
rs.Close
set rs = nothing
else
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mapPath("Db/database.mdb")
set recordset = server.CreateObject ("ADODB.Recordset")
sql="select id, username from utenti"
recordset.open sql,conn,3,3
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Lista Account</title>
</head>
<body>
<table align="center">
<tr>
<td colspan="6" align="center">
Ciao <%=utente%>, ecco la ista degli account. Con loro si potrà visualizzare anche il loro profilo
<hr>
</td>
</tr>
</table>
<table align="center">
<tr>
<%
dim cont
cont = 1
do until recordset.eof
if cont<6 then
response.write("<td>")
response.write("
" & recordset("username") & "")
response.write("</td>")
cont = cont + 1
else
response.write("<td>")
response.write("
" & recordset("username") & "")
response.write("</td></tr><tr>")
cont = 1
end if
recordset.movenext
loop
%>
</tr>
</table>
</body>
</html>
<%
recordset.Close
set rs = nothing
conn.Close
set conn = nothing
end if
%>