sabato 13 ottobre 2018

PAGINA DI LOGIN in PHP



(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;
$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>&nbsp;</td>
<td>
<b><FONT size=\"7\">Accesso</FONT></b></td>
</tr>
<tr>
<td height=\"74\"></td>
<td height=\"74\">
</td>
</tr>
<tr>
<td>&nbsp;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>&nbsp;</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>&nbsp;</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: