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.
Well you could be more clear and more factual. When did SpaceX crash 7 rockets during their hop tests? If you're referring to the Starship test flights, then I'm not sure why you think an orbital rocket should be compared to a simple hop test. What is similar between those?
If you're going to make weird and irrelevant comparisons, you should expect to be called out on it.
To answer the question, no. I do not like what Microsoft did to the Start menu in Windows 11. As far as layouts go I prefer even the classic Start menu over that one.
4. Go back to the Windows 10-style Start menu - Nope (3.4K+ upvotes)
The Windows 10 Start Menu is easily my favorite. I loved the tiles on my main desktop and I liked the ability to shrink the window, hiding the tiles on my media server so it was just the All Applications list
9. Bring back live tiles - Nope (1K+ upvotes)
Carrying on from point 4. I loved the tiles but hated that they were animated. It would be awesome if they'd bring back the tile groups and various tile sizes and just let users change the icons as desired. I hate the current start menu and app grouping. I don't want my Windows PC to feel like my Android phone.
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