Alrighty then. If I were to use the following commands they work just fine:
AES_Encrypt (PHP):
$un = david;
$pw = pass;
mysql_query(INSERT into tablename (un,pw) values ('$un',aes_encrypt('$pw','key'))",$db);
AES_Encrypt (Command Prompt):
SELECT un, aes_decrypt(pw,'key') from tablename where id=1;
However. I'm trying to write a login page based upon the encrypted data via PHP (send the data via a form and process it). I had it working perfectly - but as soon as encryption is entered things don't go my way. Here's a sample of my efforts which aren't looking too good (I am extracting from a form, but for simplicity I'm using static data).
<?php
$un = david;
$pw = pass;
$result = mysql_query("SELECT un, aes_decrypt(pw,'key') FROM table_login where un='$un' and pw='$pw' ",$db);
$array_r = mysql_fetch_array($result);
echo "User". $array_r["un"] ."<br />";
echo "Pass". $array_r["pw"];
?>
I searched google and other sites with no luck, but from what I'm told - the aes_decrypt function has to remain in the SELECT clause because it's a MySQL function and not a PHP function.
Why not fix bugs that were there from day zero such as a prompt when you tried to delete a bookmark, asking you to confirm whether this irreversible action is something you really want to do?
XFX 9060 XT 16 GB is $349 on Amazon (shipped & sold by Amazon)
https://www.amazon.com/dp/B0F8...p;previewDohDeal=1&th=1
People - never trust any neowin deals posted - they are the worst at seeking deals, and just want to peddle their own to make a quick buck. It's disgusting.
Question
DjmUK
Alrighty then. If I were to use the following commands they work just fine:
AES_Encrypt (PHP):
$un = david;
$pw = pass;
mysql_query(INSERT into tablename (un,pw) values ('$un',aes_encrypt('$pw','key'))",$db);
AES_Encrypt (Command Prompt):
SELECT un, aes_decrypt(pw,'key') from tablename where id=1;
However. I'm trying to write a login page based upon the encrypted data via PHP (send the data via a form and process it). I had it working perfectly - but as soon as encryption is entered things don't go my way. Here's a sample of my efforts which aren't looking too good (I am extracting from a form, but for simplicity I'm using static data).
I searched google and other sites with no luck, but from what I'm told - the aes_decrypt function has to remain in the SELECT clause because it's a MySQL function and not a PHP function.
Please help me and thanks in advance.
Link to comment
https://www.neowin.net/forum/topic/290091-php-mysql-aes_encrypt-aes_decrypt/Share on other sites
11 answers to this question
Recommended Posts