Small mySQL AES Encrypt Decrypt example

Closed - This job posting has been filled and work has been completed.

Job Description

I need a simple simple example of encrypting / decrypting text data into a mySQL database using PHP and the AES Encrypt / Decrypt functions:

http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html

This is required purely for the purpose of a proof of concept for another project.

The solution should have two pages.

Page 1

A form with a single text field and a 'submit' button.

Stored the text in a mySQL database table.

The text must be encrypted using mySQL AES Encrypt.

The field should have the label 'Enter text:' and have room for 50 characters.

Table name: text
Field name: the_text


Page 2

This page reads the database, decrypts the data using AES Decrypt and displays the decrypted the text on the page.

If there are multiple 'text' records, display them in an unordered list.

We will want to view the encrypted data in the database.

Deliverables:

1. The PHP files
2. The mySQL database.
3. The files must be documented. Your approach must be explained in commented within the file.

Constraints:

1. Must use the PHP PDO interface to mySQL.
2. Do not use an OOP approach.

Other open jobs by this client