Cara menggunakan mysql decrypt

MySQL DES_DECRYPT() function

DES_DECRYPT() function

MySQL DES_DECRYPT() function decrypts an encrypted string and returns the original string.

Syntax:

DES_DECRYPT(crypt_str, [key_str]);

Arguments:

Syntax Diagram:

MySQL Version: 5.6

Example:

Code:

SELECT DES_DECRYPT(DES_ENCRYPT('mytext','mypassward'),'mypassward');

Explanation:

The above MySQL statement decrypts the encrypted string 'mytext' as specified in the argument and returns the original string.

Sample Output:

mysql> SELECT DES_DECRYPT(DES_ENCRYPT('mytext','mypassward'),'mypassward');
+--------------------------------------------------------------+
| DES_DECRYPT(DES_ENCRYPT('mytext','mypassward'),'mypassward') |
+--------------------------------------------------------------+
| mytext                                                       | 
+--------------------------------------------------------------+
1 row in set (0.01 sec)

PHP script:

Decrypting the encrypt string 'mytext' :";
echo "";
echo "";
echo "";
echo "";
include("../dbopen.php");
$result = mysql_query("SELECT DES_DECRYPT(DES_ENCRYPT('mytext','mypassward'),'mypassward')");
while($row=mysql_fetch_array($result))
{
echo "";
echo "";
echo "";
}
echo "
DES_DECRYPT(DES_ENCRYPT('mytext','mypassward'),'mypassward')
" . $row["DES_DECRYPT(DES_ENCRYPT('mytext','mypassward'),'mypassward')"] . "
";
?>

View the example in browser

Example of MySQL des_decrypt() function using table

Sample table: testtable

Code:

SELECT description,DES_DECRYPT(description,'mydespassw')
FROM testtable;

Explanation:

The above MySQL statement retrieves the decrypted data from encrypted 'description' column from 'testtable'.

Output:

PHP script:

Retrieving the decrypted data from encrypted 'description' column from 'testtable' :";
echo "";
echo "";
echo "";
echo "";
include("../dbopen.php");
$result = mysql_query("SELECT description,DES_DECRYPT(description,'mydespassw') 
FROM testtable");
while($row=mysql_fetch_array($result))
{
echo "";
echo "";
echo "";
echo "";
}
echo "
Description
DES_DECRYPT(description,'mydespassw')
" . $row['description'] . "
" . $row["DES_DECRYPT(description,'mydespassw')"] . "
";
?>

Online Practice Editor:

Previous: DECODE()
Next: DES_ENCRYPT()