Q&A Database Admin Pages

This project was successfully completed by codemaster7 for $388 USD in 10 days.

Get free quotes for a project like this
Project Budget
$250 - $750 USD
Completed In
10 days
Total Bids
Project Description


The goal of the project is to produce a web-based application to manage and edit the contents of a database-table which contains a set of Questions (Note: The questions are posted by users, about recipes which are featured in an online cook book). The system will also include the ability to send email (using PHP @mail) and make posts to Facebook and Twitter.

The system will be built using PHP/MySQL and will run on a standard LAMP stack and will only be used by internal, back-office admins (it is not a consumer facing site).

A SQL file with the “questions” table is attached. The table contains the name of the Chef and the name of the Recipe the question is about, the Question itself, a Status column, the name and email address of the user asking the question and some timestamp dates to track the record through the system.

The system's main (home) page contains a list of Questions pulled from the database. Data can be sorted or filtered by different criteria using drop down options and radio buttons. Rows are color-coded by status. Clicking a row displays a detail popup where the see the complete row of data for a question and can edit and save changes to the Answer and the question's status, as well as perform additional actions related to tracking and processing the question.

Full specifications are attached in the PDF. The file "[url removed, login to view]" is a .sql file with a txt extension.

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online