Completed

php-based data-entry mini-site

This project was successfully completed by kaleshwarchand83 for $88 USD in 5 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
5 days
Total Bids
37
Project Description

I need a very small, php-based site which I’ll install on my hosting package.
The site will be used to enter data into one MySQL table.
I employ a few people around the world, each of them is working on writing Trivia questions and answers. I would like to be able to give them a form for entering the questions and answers.
The form will have the following items :

1. Question : a text field which is limited to 70 characters. The caption near it will tell what is the questions number
2. Correct Answer : a text field which is limited to 60 characters
3. Wrong answer 1 : a text field which is limited to 60 characters
4. Wrong answer 2 : a text field which is limited to 60 characters
5. Wrong answer 3 : a text field which is limited to 60 characters
6. Submit field for submitting the questions/answers
7. A table with all the questions(questions number + text) which have already been entered. When clicking on a question, it becomes editable in the fields above. This is the way to update a question.

The data will be inserted into the table trivia_questions(see DDL below).


CREATE TABLE trivia_questions (
`trivia_number` int not null,
`question_number` int NOT NULL ,
`question_text` varchar(70) NOT NULL,
`correct_answer` varchar(60) NOT NULL,
`wrong_answer1` varchar(60) NOT NULL,
`wrong_answer2` varchar(60) NOT NULL,
`wrong_answer3` varchar(60) NOT NULL,
`last_update_time` datetime NOT NULL,
PRIMARY KEY (`trivia_number`,`question_number`),
FOREIGN KEY (trivia_number) REFERENCES trivia_games(trivia_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

The table it references is :

create table trivia_games(
trivia_number int not null,
trivia_name varchar(50),
primary key(trivia_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

But I’ll take care of setting up data in trivia_games, you only need to worry about inserting/updating/selecting from trivia_questions. You may suggest a different ERD
if you see a good reason to do so.

The UI can be very basic as it’s used for me and my guys, internally.

Data validation should be as described above - very simple test of fields length.

Until here this is pretty simple. Now the tricky part.
When I create a new trivia, I would like to assign it to a specific writer. For that, I need to create a dedicated user(login) and send him the details. This means that a unique user should be created for each trivia(in an admin page), and the user will need to login in order to enter the trivia questions. If someone is working on two trivia projects, he will either have two logins(less prefered) or have one, and after login will choose which trivia he wants to work on. When the work on a trivia is done, I’ll be able to delete the user or revoke permissions from an existing user.
Sessions should also be managed, with a configurable timeout.

You need to use well-known PHP frameworks.

Ideally I would like to test the system online, on the developer’s server.

You will need to supply detailed and simple installation instructions - I’ll do the installation, and you’ll need to provide support for any issue found.

Bidders should provide :
1. Explanation of the technology that is going to be used
2. Suggest project phases
3. Mockup of the data entry screen
4. Data model(probably 2-3 tables) for users and permissions management
5.


Good luck !

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