Small mySQL AES Encrypt Decrypt example

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Web Development Posted 1 year ago

Fixed Price

Delivery by May 16, 2014




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

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.


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


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

About the Client

(5.00) 29 reviews

Cesena 04:23 AM

57 Jobs Posted
74% Hire Rate, 1 Open Job

$7,772 Total Spent
61 Hires, 6 Active

$13.60/hr Avg Hourly Rate Paid
26 Hours

Member Since Oct 15, 2010