我在哪里可以获得PHP的AES加密，并且AES加密可以用于文档存储吗？

Question

Where can I get AES encyrption for PHP and can i use it for phpmyadmin? Any references?

I want to encrypt files that are stored in the db and other tables as well.

Answer 1

I'm going to assume you're using MySQL.

MySQL has AES encrypt/decrypt functions built in. So if you're encrypting data to be stored in the database, that would be handled in the SQL commands.

As far as I know, PHPMyAdmin doesn't offer a GUI for doing encrypted fields. You would need to type in the commands manually. Example:

CREATE TABLE `test` (
   `id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 
   `stuff` BLOB NOT NULL DEFAULT ""
);
# Encrypted fields have to be of the BLOB type (tiny/medium/large variants okay)

INSERT INTO test (stuff) VALUES (AES_ENCRYPT("My hovercraft is full of eels!", "password"));

SELECT AES_DECRYPT(stuff, "password") AS stuff FROM test;

Note that if you're encrypting stuff in your database, you should still use SSL on the connections (client to web server, and web server to database server) to protect the data while it's in transit.

Now, on the PHP side, there ARE AES encrypt/decrypt functions available if you need to do the encryption/decryption on the PHP end of things. If you wanted to integrate those into PHPMyAdmin it would mean modifying the source for the program and presumably submitting a patch. But I don't see the point really.