Find Jobs
Hire Freelancers

php-based data-entry mini-site

$30-250 USD

Terminado
Publicado hace casi 11 años

$30-250 USD

Pagado a la entrega
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 !
ID del proyecto: 4772841

Información sobre el proyecto

36 propuestas
Proyecto remoto
Activo hace 11 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Please see pm
$88 USD en 5 días
5,0 (17 comentarios)
3,6
3,6
36 freelancers están ofertando un promedio de $207 USD por este trabajo
Avatar del usuario
please see pmb.
$277 USD en 10 días
4,9 (226 comentarios)
8,1
8,1
Avatar del usuario
Let me do it for you
$210 USD en 5 días
4,8 (191 comentarios)
7,3
7,3
Avatar del usuario
Quality work assured. Ready to get started. Thanks.
$773 USD en 4 días
5,0 (448 comentarios)
7,2
7,2
Avatar del usuario
Hi ready to start Thanks
$185 USD en 6 días
4,9 (198 comentarios)
7,0
7,0
Avatar del usuario
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 en 9 días
4,9 (83 comentarios)
6,7
6,7
Avatar del usuario
Hi, I am confident i am able to help you with this project. Just give me the chance!
$257 USD en 30 días
5,0 (26 comentarios)
6,3
6,3
Avatar del usuario
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
$206 USD en 2 días
4,6 (72 comentarios)
6,2
6,2
Avatar del usuario
HI, I reviewed your requirement. I can develop this system. Please check your private message. Thanks, Raj
$244 USD en 3 días
4,8 (62 comentarios)
6,1
6,1
Avatar del usuario
LETS DO IT!!!
$263 USD en 20 días
5,0 (137 comentarios)
5,7
5,7
Avatar del usuario
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.
$157 USD en 0 día
4,7 (31 comentarios)
5,7
5,7
Avatar del usuario
Ready to start your Trivia system for your writers. Please check PMB :)
$166 USD en 6 días
4,9 (60 comentarios)
5,2
5,2
Avatar del usuario
Hi! I am experienced developer. I can do this, please see PMB for more details. Thanks, Rajib
$166 USD en 3 días
5,0 (43 comentarios)
5,1
5,1
Avatar del usuario
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
$150 USD en 5 días
5,0 (44 comentarios)
4,9
4,9
Avatar del usuario
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 en 15 días
4,9 (21 comentarios)
4,8
4,8
Avatar del usuario
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 .
$200 USD en 10 días
4,9 (12 comentarios)
4,7
4,7
Avatar del usuario
Rready to do it. Please see my message.
$150 USD en 3 días
5,0 (27 comentarios)
4,5
4,5
Avatar del usuario
Hi, I am a php mysql expert. I will provide you a best system. I am ready to work in your project.
$155 USD en 3 días
5,0 (10 comentarios)
4,4
4,4
Avatar del usuario
Hi, I have a lot of experience developing PHP scripts and can complete this quickly and efficiently for you. Kind Regards, Alex
$150 USD en 5 días
5,0 (4 comentarios)
4,3
4,3
Avatar del usuario
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.
$266 USD en 7 días
5,0 (26 comentarios)
4,3
4,3
Avatar del usuario
I can do this project in CakePHP or Codeigniter both are very good PHP framework for Web application
$147 USD en 4 días
5,0 (23 comentarios)
4,2
4,2

Sobre este cliente

Bandera de NEW ZEALAND
Wellington, New Zealand
5,0
16
Forma de pago verificada
Miembro desde dic 19, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.