BASE DE HASH MD5

------------------------------
Création de la table sql
------------------------------

CREATE TABLE IF NOT EXISTS `table_md5` (
  `ID` mediumint(8) unsigned NOT NULL auto_increment,
  `mot` varchar(300) collate latin1_general_ci NOT NULL,
  `sum` varchar(32) collate latin1_general_ci NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1215 ;

------------------------------
fin de la table sql
------------------------------


------------------------------
index.php
------------------------------
//crypte le mot en md5 et si il n'existe pas dans la base de donnée il l'enregistre 
<?
echo ' <form method="post" action="index.php"> ';
echo ' Mot : <input type="text" name="md5" value="'.$md5.'"> ';
echo " <input type='submit' name='Submit' value='Crypter'> ";
echo ' </form> ';
echo '<br> </br>';
if( isset( $md5 ) and ($md5 != '') ){ echo ' <br>Sum md5 : '.md5( $md5 ); }
echo '</p></font>';

$db = mysql_connect('sql.server', 'sql.login', 'sql.pwd');
mysql_select_db('sql.db',$db); 

    $sql_query = "SELECT mot FROM table_md5 where mot='$md5'";
    $result = mysql_query($sql_query);
	if(!$result)
        return; 

    if(mysql_num_rows($result) == 0)
    { 
	$req = mysql_query('SELECT * FROM table_md5');          
	$res = mysql_num_rows($req);   
	mysql_query("INSERT INTO table_md5 (ID, mot, sum) VALUES ('', '$md5', '$md5')");
	mysql_query("UPDATE `table_md5` SET `sum` = MD5( '$md5' ) WHERE `mot` =('$md5') LIMIT 1 ;");
 	if(!$result)
            return;
    } 
    else
    {
	echo '';
    }


mysql_close($db);

?>
------------------------------
fin index.php
------------------------------

------------------------------
decrypt_md5.php
------------------------------
<form method="post" action="decrypt.php">
md5 : <input type="text" name="md5">&nbsp;&nbsp;<input type='submit' name='Submit' value='Decrypter'></br>
</form>
<?php
$db = mysql_connect('sql.server', 'sql.login', 'sql.pwd');
mysql_select_db('sql.db',$db);                    
$req = mysql_query('SELECT * FROM table_md5');          
$res = mysql_num_rows($req);
echo '<br> </br>';                    
echo 'Il y a '.$res.' mots de passe dans la base de donnée';  
mysql_close($db);
?>
------------------------------
fin decrypt_md5.php
------------------------------

------------------------------
decrypt.php
------------------------------

<?php
$db = mysql_connect('sql.server', 'sql.login', 'sql.pwd');
mysql_select_db('sql.db',$db);  
                  
$req = mysql_query("SELECT * FROM table_md5 WHERE `sum` =('$md5') ");
$resultat = mysql_fetch_array($req);


echo '<center>';
echo '<table border="0" cellpadding="0" cellspacing="0" width="50%" height="95">';
echo '  <tr>';
echo '    <td width="100%" height="95">';
echo '<p><font color="#ffffff" size="2">';
echo '[+]Password  => ';
echo 		htmlentities($resultat["mot"]);
echo '</br>';
echo '[+]Checksum => ';
echo 		htmlentities($resultat["sum"]);
echo '<br> </br>';
echo '[ <a href="decrypt_md5.php">Back</a> ]';
echo '</p></font>';
echo '    </td>';
echo '  </tr>';
echo '</table>';
echo '</center>';


mysql_close($db);
?>
------------------------------
fin decrypt.php
------------------------------

29 avril 2008 14:03:26 :

changement de niveau