Originariamente inviato da michele.santoro
Ecco il codice intero della pagina "alunni"
codice:<html> <head> <p align="center"><font size="1"> </p> <meta http-equiv="Content-Language" content="it"> <meta name="GENERATOR" content="Microsoft FrontPage 6.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title></title> <link rel="stylesheet" href="manufacture.css" type="text/css"> </head> <body link="#000000" vlink="#000000" alink="#000000" bgcolor="#83A6D2"> <% password = trim(request.form("password")) password = replace(password, "'", "''") username = trim(request.form("username")) username = replace(username, "'", "''") SMS="" IF password="" then response.write "MANCA PASSWORD" dbconn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../mdb-database/alunni.mdb") Set conn=Server.CreateObject ("ADODB.Connection") conn.open dbConn Set rstusername=Server.CreateObject ("ADODB.Recordset") Sql = "Select * from studenti where username ='"&USERNAME&"'and password='"&Password&"'" rstusername.Open sql,conn,3,3 totrecord = rstusername.recordcount %> <div align="center"> <center> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="450" id="AutoNumber3" height="163"> <tr> <td width="558" bgcolor="#000080" height="34"> <p align="center"><font face="Verdana" color="#FFFFFF">Controlla le assenze e il profitto di tuo figlio</font></td> </tr> <tr> <td width="558" height="1"> <p align="center"><font color="#000080"><font size="1"></font><font style="font-size: 3pt"> </font> </font><font size="1" face="Verdana"><a target="_self" href="index.asp"> <font color="#000080">Riservato ai Docenti</font></a><font color="#000080"> (usare nomeutente= </font><font color="#0000FF">tizio</font><font color="#000080"> e Password= </font><font color="#0000FF">caio</font><font color="#000080">)</font></font> <font size="1"></font></td> </tr> <tr> <td width="558" height="19"> <p align="center"><font size="1" color="#000080" face="Verdana">Potete controllare se vostro/a figlio/a è presente a scuola e il suo profitto, inserendo l'</font><font size="1" color="#FFFFFF" face="Verdana">username</font><font size="1" color="#000080" face="Verdana"> e la </font><font size="1" color="#FFFFFF" face="Verdana">Password</font><font size="1" color="#000080" face="Verdana"> che vi sono stati consegnati dalla Segreteria della scuola. Se non vi fossero stati ancora consegnati, potete ritirarli personalmente in Segreteria. Poiché questa è solo una simulazione, sono presenti solo 3 nominativi di alunni. Per provarla procedere come di seguito: (per l'Alunno Bianchini Eolo: username=celeste password=1a2bc3) (per l'Alunna Rossi Biancaneve: username=biancaneve password=sette) (per l'alunno Verdi Giuseppe: username=bianco password=12356) Lo script funziona con un database Access. Cchi fosse interessato allo script può richiederlo GRATUITAMENTE <a title="Richiedi il registro di classe!" href="mailto:tecnico@iis-montefeltro.it?subject=Richiesta file script Registro di Classe"> qui</a>, dopo aver firmato il GUESTBOOK</font></td> </tr> <tr> <td width="558" height="8"><font size="1"></font></td> </tr> <tr> <td width="558" height="119"> <div align="center"> <center> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="386" id="AutoNumber4"> <tr> <td> <form method="POST" action="alunni.asp"non serve il linguaggio> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="503" id="AutoNumber1"> <tr> <td width="150"> <p align="right"><font face="Verdana" size="1" color="#000080">username</font></td> <td width="353"> <input type="text" name="username" size="20" NON SERVE IL VALUE! è un input!class="formstyle" style="border: 1 solid #808080"></td> </tr> <tr> <td width="150"> <p align="right"><font face="Verdana" size="1" color="#000080">Password</font></td> <td width="353"> <input type="password" name="password" size="20" class="formstyle" style="border: 1 solid #808080"> <input type="submit" value="Entra >>" name="cerca_studente" class="formstyle" style="border: 1px solid #808080; background-color: #000080; color:#FFFFFF; font-family:Verdana; height:20"></td> </tr> </table> </form> <%Do while not rstusername.EOF%> <tr> <td width="1%" style="border: 1px solid #808080; background-color: #000080" align="right" height="25" > <font color="#FFFFFF" face="Verdana" size="2">Cognome </font></td> <td width="91%" style="border: 1px solid #808080; background-color: #EEEEEE" height="25" ><font face="Verdana" size="2"><%=rstusername("cognome")%></font></td> </tr> <tr> <td width="1%" style="border: 1px solid #808080; background-color: #000080" align="right" height="25" > <font color="#FFFFFF" face="Verdana" size="2">Nome </font></td> <td width="90%" style="border: 1px solid #808080; background-color: #EEEEEE" height="25" ><font face="Verdana" size="2"><%=rstusername("nome")%></font></td> </tr> <tr> <td width="1%" style="border: 1px solid #808080; background-color: #000080" align="right" height="25" > <font color="#FFFFFF" face="Verdana" size="2">Classe </font></td> <td width="91%" style="border: 1px solid #808080; background-color: #EEEEEE" height="25" ><font face="Verdana" size="2"><%=rstusername("classe")%></font></td> </tr> <tr> <td width="1%" style="border: 1px solid #808080; background-color: #000080" align="right" height="25" > <font color="#FFFFFF" face="Verdana" size="2">Assenze </font></td> <td width="99%" style="border: 1px solid #808080; background-color: #EEEEEE" height="25" ><font face="Verdana" size="2"><%=rstusername("assenze")%></font></td> </tr> <tr> <td width="8%" style="border: 1px solid #808080; background-color: #000080" align="right" height="25" > <font color="#FFFFFF" face="Verdana" size="2">Profitto </font></td> <td width="158%" style="border: 1px solid #808080; background-color: #EEEEEE" height="25" ><font face="Verdana" size="2"><%=rstusername("profitto")%></font></td> </tr> <% rstusername.movenext loop %> </table> <% end if rstusername.close set rstusername = Nothing%> </center> </div> </td> </tr> </table> </center> </div> </td> </tr> </table> </center> </div> <div align="center"> <center> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="503"> <tr> <td width="76"> </td> <td width="76"></td> <td width="76"></td> <td width="76"></td> <td width="73"></td> <td width="126"> </td> </tr> </table> </center> </div> </body> </html>![]()
Grazie per l'aiuto

Rispondi quotando