Find Jobs
Hire Freelancers

A single php script to return html table/CSV file from mySQL database with user name/password verification

$30-250 AUD

En curso
Publicado hace alrededor de 11 años

$30-250 AUD

Pagado a la entrega
Hello, This is a very simple php coding job that I need ASAP. I urgently need a SINGLE php script to take the data from a html form that I have already created and display the results in a html table sorted by a field. I will place the code on the server - it does not need any HTML attributes. (eg. you don't have to worry about the background color or fonts etc) I have used this format: [table/[login to view URL]] eg. [[login to view URL]] means the password field on the form and [[login to view URL]] means the uid field in the user table. The form fields are: - email_uid (the user's email address OR user id) - password - start_date - end_date The mySQL database has three tables - 'user', 'work_det' and 'type' The code needs to do the following: - access my existing mySQL database (use 'dbname', 'dbusername', 'dbpassword' and 'dbserver' in your code) - confirm that the user's email address OR user id [form.email_uid] exist in either the [[login to view URL]] or [[login to view URL]] fields - confirm that the user's password [[login to view URL]] matches with the [[login to view URL]] field in the same record in the [user] table - if either is incorrect or not found display a message "Incorrect email/password. Please try again" and return user to this page. - search the [work_det] table for all records that have a [[login to view URL]] = [[login to view URL]] within the date range of [form.start_date] - [form.end_date] - display the results in a html table with the following columns: - "User ID" [uid] - "Work type" [[login to view URL]] where [type.type_id] = [[login to view URL]] - "Start location" [work_det.start_loc] - "End location" [work_det.end_loc] - "Start time" [work_det.start_time] - "End time" [work_det.end_time] - "Total time" [work_det.end_time] - [work_det.start_time] - The table should have a title of "[[login to view URL]] work summary for [form.start_date] - [form.end_date]" - The table should be grouped by [[login to view URL]] and sorted by [work_det.start_time] - The last line in each group should be empty other than a subtotal of the "Total time" column - The last line of the table should be empty other than a final total of the "Total time" column Here's a quick text mock up of what the table should look like (sort of): [[login to view URL]] work summary for [form.start_date] - [form.end_date] | User ID | Work type | Start location | End location | Start time | End time | Total time | | 12345 | Admin | XYZ | XYZ | 2013-04-15 18:34:42 | 2013-04-15 19:54:42 | 0 days 1 hours 20 minutes 00 seconds | | 12345 | Admin | XYZ | XYZ | 2013-04-17 14:24:10 | 2013-04-17 18:34:10 | 0 days 4 hours 10 minutes 00 seconds | | | | | | | Subtotal | 0 days 5 hours 30 minutes 00 seconds | | | | | | | | | | 12345 | Travel | ABC | XYZ | 2013-04-15 17:24:30 | 2013-04-15 18:34:41 | 0 days 1 hours 10 minutes 11 seconds | | 12345 | Travel | ABC | XYZ | 2013-04-16 17:24:30 | 2013-04-16 18:34:41 | 0 days 1 hours 10 minutes 11 seconds | | 12345 | Travel | ABC | XYZ | 2013-04-17 17:24:30 | 2013-04-17 18:34:41 | 0 days 1 hours 10 minutes 11 seconds | | | | | | | Subtotal | 0 days 3 hours 30 minutes 33 seconds | | | | | | | Total | 0 days 9 hours 00 minutes 33 seconds | As I said, this is urgent so please only bid if you're able to ASAP
ID del proyecto: 4452046

Información sobre el proyecto

10 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
10 freelancers están ofertando un promedio de $81 AUD por este trabajo
Avatar del usuario
I can get this done by tomorrow morning. Ready to start now.
$128 AUD en 1 día
5,0 (181 comentarios)
6,8
6,8
Avatar del usuario
Being a Professional !
$60 AUD en 1 día
4,9 (528 comentarios)
7,0
7,0
Avatar del usuario
i'm a professional web developer , i can write the script that will take the data from your form , get all the data from the db and displays it as you want , kindly check PM
$78 AUD en 3 días
5,0 (95 comentarios)
6,9
6,9
Avatar del usuario
Ready for this now and will be completing it 4 hours from now.
$99 AUD en 1 día
4,9 (83 comentarios)
7,0
7,0
Avatar del usuario
Need 1 day to implement this functionality to site with Php/Mysql as I'm Expert Php/Mysql Programmer and always get positive feedback from Client. Thank you.
$89 AUD en 1 día
4,9 (113 comentarios)
6,6
6,6
Avatar del usuario
Hello, Can make this. I complete many php project(including project with mysql/css). Can start right now. Regards. Dima
$54 AUD en 1 día
5,0 (71 comentarios)
5,9
5,9
Avatar del usuario
Let me complete it first, then we will mark this project as complete. Thanks.
$45 AUD en 1 día
5,0 (16 comentarios)
5,3
5,3
Avatar del usuario
Hi - I'd love to work with you on this and would get it done quickly ! Thanks Martin
$99 AUD en 1 día
5,0 (22 comentarios)
4,3
4,3
Avatar del usuario
senior web developer , let's get started now
$110 AUD en 0 día
4,9 (7 comentarios)
3,4
3,4
Avatar del usuario
Hi sir, please check your inbox.
$50 AUD en 1 día
4,6 (10 comentarios)
3,2
3,2

Sobre este cliente

Bandera de AUSTRALIA
Malaga, Australia
5,0
3
Forma de pago verificada
Miembro desde mar 13, 2013

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.