1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
<?php
header('Content-Type: text/html; charset=utf-8');
header('Cache-Control: no-cache, no-store, must-revalidate');
header('Pragma: no-cache');
header('Expires: 0');
$server="127.0.0.1";
$log="root";
$pass="";
$dbase="test";
$cnx=mysqli_connect($server,$log,$pass,$dbase);
if (!$cnx) {
echo "erreur de connexion";
} else {
echo "connexion au serveur sql réussit<br><br>";
}
$req=mysqli_query($cnx,"INSERT INTO datas VALUES ('',AES_ENCRYPT('email@site.com', UNHEX(SHA2('cle',512))),'données en claire')");
$select=mysqli_query($cnx,"select aes_decrypt(email, UNHEX(SHA2('cle',512))) as email from datas");
while ($s=mysqli_fetch_assoc($select)) {
$email=htmlspecialchars($s["email"]);
$donnee_claire=htmlspecialchars($s["donnee_claire"]);
echo "".$email." - ".$donnee_claire."<br><br>";
}
?> |
Partager