php-based data-entry mini-site

Closed

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 !

Skills: HTML, MySQL, PHP, Website Design

See more: writing test questions, what's wrong with my website, what is the data entry work, what is system ui, what is online data entry work, what is online data, what is data entry test, what is data entry projects, what is a data entry test like, what is a data entry test, what is a data entry form, small writing table, screen writing website, question answer in php developer, primary data, php mysql developer near me, php developer test questions, php developer means, php developer foreign, php create table, package design online order, online projects of data entry, online php projects for developer, one key data, number data entry test

Project ID: #4772841

Awarded to:

kaleshwarchand83

Please see pm

$88 USD in 5 days
(17 Reviews)
3.6

36 freelancers are bidding on average $207 for this job

zeee

please see pmb.

$277 USD in 10 days
(226 Reviews)
8.1
pan09

Let me do it for you

$210 USD in 5 days
(191 Reviews)
7.3
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$773 USD in 4 days
(448 Reviews)
7.2
gopalvora

Hi ready to start Thanks

$185 USD in 6 days
(198 Reviews)
7.0
DeamonBizz

We are expert in designing and development.Please check private message for sample work...

$157 USD in 7 days
(93 Reviews)
6.9
websky7

FIRST let us WORK on your project THEN pay us. If you don't like the WORK, you don't have to pay a single penny. Please check PMB for further details.

$242 USD in 9 days
(83 Reviews)
6.7
surajitsaha24484

We have gone through the project description.We are very interested about the job and ready to start the job.We are sending you some links of our previous custom php jobs as we are suggesting you to go for custom php a More

$157 USD in 3 days
(126 Reviews)
6.7
pytho

Hi, I am confident i am able to help you with this project. Just give me the chance!

$257 USD in 30 days
(26 Reviews)
6.3
zeke

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 profes More

$206 USD in 2 days
(72 Reviews)
6.2
wsfreelanzer

HI, I reviewed your requirement. I can develop this system. Please check your private message. Thanks, Raj

$244 USD in 3 days
(62 Reviews)
6.1
csajit

LETS DO IT!!!

$263 USD in 20 days
(137 Reviews)
5.7
steven6

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 1 More

$157 USD in 0 days
(31 Reviews)
5.7
trivediinfo

Ready to start your Trivia system for your writers. Please check PMB :)

$166 USD in 6 days
(60 Reviews)
5.2
rajibdebslg

Hi! I am experienced developer. I can do this, please see PMB for more details. Thanks, Rajib

$166 USD in 3 days
(43 Reviews)
5.1
truongnx15fl

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-e More

$150 USD in 5 days
(44 Reviews)
4.9
avisolutions01

Hello, We have reviewed your scope in detail. Request to kindly review PMB for details on very similar application developed by us. Regards

$445 USD in 15 days
(21 Reviews)
4.8
Codomotive

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 More

$200 USD in 10 days
(12 Reviews)
4.7
wikkipk

Rready to do it. Please see my message.

$150 USD in 3 days
(27 Reviews)
4.5
rana100

Hi, I am a php mysql expert. I will provide you a best system. I am ready to work in your project.

$155 USD in 3 days
(10 Reviews)
4.4
AlexK1995

Hi, I have a lot of experience developing PHP scripts and can complete this quickly and efficiently for you. Kind Regards, Alex

$150 USD in 5 days
(4 Reviews)
4.3