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 !
Dear Customer!
I am an expert PHP/MySQL developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service exciting my customers. Please contact in PMB to discuss details.
Best Regards,
Zeke
Hello, we are a group of programmers based in Sheffield, UK offering 7 years experience in php, .net, c#, jquery, css, python and c++. I am proposing to carry out tasks required for this project and deliver it within 12 hours. Let me know if you're interested. Thanks.
Hello, I can help you to build a small data entry app.
1. I would use CodeIgniter as the MVC framework
2. This is small project so I think 1 project phase is ok but we can divided into 2 phases: admin part and data-entry
3. Please see PM
4. I think there will be 2 more tables for granting permission for users.
4.1: users with id/username/password/is_admin/...
4.2: permissions: user_id/trivia_number
Thanks
Hi
We've crossed 6 months of functioning in freelancer and we have already worked on 17 projects with 11 five-star reviews and are working on 4 more. We are sending some links to show our work quality.
Please visit the Personal message Box so you can go through the work quality of us .
Hi, I am a PHP, mysql expert and can make the mini site as per your requirements. i can start the work right away.
Please message me if you are interested.