There are three components to the system:

• A) The exhibitor upload page
  This is a password protected page in the Exhibitor Zone only registered exhibitors have access to.
  http://www.ewea.org/offshore2015/exhibition/exhibitor-zone/press-services/
• B) The public listing page
  This is where anyone can view the approved press releases.
  http://www.ewea.org/offshore2015/media-and-press/exhibitors-press-releases/
• C) Administration page
  This is in the back end of WordPress, where you can edit, approve and delete press releases.
  http://www.ewea.org/offshore2015/wp-admin/admin.php?page=fm-edit-form&sec=data&id=15

A) The exhibitor upload page

The first thing we need to do is build the form using the “WordPress Form Manager” plugin.
We create a form with the following fields: “Company name”, “Document title” and “Select document”. We also add a note field to display additional information about accepted file formats and file size, etc. Pay attention to the upload document section as to restrict the document types.

We also add a “Private Field” at the bottom of the “Form extra” tab. This is what our administrator will use to approve each press release.

Once you have created the form, add it to the exhibitor upload page with the following shortcode format:
[form form-XYZ]

B) The public listing page

We include a simple PHP script into the WordPress page to pull data off the database. The code I used can be obtained here.

To summarise, the script will need to be modified in the following places:

1. Database name
2. Form table
3. User (an account with read-only access just to the form table was created for this application)
4. Password
5. The blob variables in the loop

C) Administration page

The administrator logs into WordPress and navigates to the Submission Data tab of the form being used.
Using the checkboxes and the “Edit selected” function from the dropdown list of actions, the admin can edit…

and approve each press release.