(File dbconnect.php)
mysql_connect("localhost","","")
or
die ("Could not connect to database");
mysql_select_db("newtable") or
die ("Could not select database");
(File login.php)
<?php
include("dbconnect.php");
#---------------------PAGINA
HTML Login ------------------------------------------
$query1 = "insert into UTENTI (NOME,PSW,RESET,MSG) values ('$username','$password','$reset','$messaggio')";
mysql_query($query1)
or die(mysql_error());
echo
"<script>alert('Registrazione
effettuata con successo')</script>";
include("index.html");
exit;
exit;
$query2
= "delete from UTENTI where NOME
= ('$username') AND PSW = (‘$password’) ";
mysql_query($query2)
or die(mysql_error());
echo
"<script>alert('Cancellazione
Avvenuta con successo')</script>";
include("index.html");
exit;
($pagina == 2)
#---------------------PAGINA
HTML aggiorna password ------------------------------------------
echo
"<script>alert('PASSWORD AGGIONATA')</script>";
$pagina = 0;
include("home.html");
exit;
}
($pagina == 0)
#---------------------PAGINA
HTML utente e password ------------------------------------------
echo"
<html>
<head>
<meta
http-equiv=\"Content-Type\" content=\"text/html;
charset=windows-1252\">
<title> LOGIN
</title>
</head>
<head><FONT></FONT></HEAD>
<body
bgcolor=#e0ffff>
<form
action=index.php>
<br>
<center>
<table
border=\"0\" width=\"10%\" id=\"table1\">
<tr>
<td> </td>
<td>
<b><FONT size=\"7\">Accesso</FONT></b></td>
</tr>
<tr>
<td
height=\"74\"></td>
<td
height=\"74\">
</td>
</tr>
<tr>
<td> USERNAME:</td>
<td>
<p
align=\"center\">
<input type=text
name=username value='' size=\"31\" style=\"width: 228; height:
40\" ></td>
</tr>
<tr>
<td>PASSWORD:</td>
<td>
<input type=text
name=password value='' size=\"31\" style=\"width: 228; height:
40\"></td>
</tr>
<tr>
<td> </td>
<td>
<p
align=\"center\">
<br>
<input type=submit
name=bottone value=Accedi style=\"height: 40;
width:115\"></td>
</tr>
</table>
<br>
<input type=hidden
name=pagina
value=1>
</center>
</form>
</body>
</html>
";
#FINE PAGINA
HTML-----------------------------------------------------------------
}
($pagina == 1)
#---------------------PAGINA
HTML controllo dei dati immessi ------------------------------------------
$Righe=@mysql_num_rows($Risultato);
while ($Row = mysql_fetch_array($Risultato))
{
$dato01 = $Row["NOME"];
$dato02 = $Row["PSW"];
$dato03 = $Row["RESET"];
$dato04 = $Row["MSG"];
} = 1)
----------------------se i dati
sono esatti fa cambio password Password ----------------------------
{
#----------------------se
RESET = 1 vado alla pagina principale -----------------------------------
($dato03 == 1)
{
$pagina = 0;
include("home.html");
exit;
}
#----------------------se
RESET = 0 devo inserire una nuova password ------------------------------Else
{
#---------------------PAGINA
HTML nuova password ------------------------------------------
echo "
<html>
#---------------------
PAGINA HTML ------------------------------------------
<head>
<meta
http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1252\">
<title> LOGIN </title>
</head>
<head><FONT></FONT></HEAD>
<body bgcolor=#e0ffff>
<form action=index.php>
<br>
<center>
<br><br>
<table border=\"0\"
width=\"10%\" id=\"table1\">
<tr>
<td colspan=\"2\">
<b><FONT
size=\"6\">NUOVA PASSWORD</FONT></b>
</td>
</tr>
<tr>
<td
height=\"74\"></td>
<td height=\"74\">
</td>
</tr>
<tr>
<td>NUOVA PASSWORD:</td>
<td>
<p align=\"center\">
<input type=text name=passwordnew
value='' size=\"31\"
style=\"width:
228; height: 40\"></td>
</tr>
<tr>
<td>RIPETI PASSWORD:</td>
<td>
<input type=text name=passwordnew1
value='' size=\"31\"
style=\"width:
228; height: 40\"></td>
</tr>
<tr>
<td> </td>
<td>
<p align=\"center\">
<br>
<input type=submit name=bottone
value=SALVA style=\"height: 40; width:115\"></td>
</tr>
</table>
<br>
<input type=hidden name=pagina
value=2>
<input type=hidden name=username
value=$username>
<input type=hidden name=password
value=$password>
</center>
</form>
</body>
</html>
#---------------------FINE
PAGINA HTML------------------------------------------
";
}
}
#------------------------se i
dati sono sbagliati MESSAGGIO DI ERRORE ------------------
else$Righe=@mysql_num_rows($Risultato);
$Conta = 0;
while ($Row = mysql_fetch_array($Risultato))
{
$dato01 = $Row["NOME"];
$dato02 = $Row["PSW"];
$dato03 = $Row["RESET"];
$dato04 = $Row["MSG"];
If ($username == $dato01)
{
$Conta++;
}
}
If ($Righe == 0)
{
echo "<script>alert('USERNAME E PASSWORD ERRATI')</script>";
$pagina = 0;
include("index.php");
exit;
}
else
{
If ($Conta == 1)
{
echo "<script>alert('PASSWORD ERRATA')</script>";
$pagina = 0;
include("index.php");
exit;
}
else
{
echo "<script>alert('USERNAME O PASSWORD ERRATI')</script>";
$pagina = 0;
include("index.php");
exit;
}
?>
Nessun commento:
Non sono consentiti nuovi commenti.