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

W trakcie realizacji
Opublikowano prawie 11 lat temu

$30-250 AUD

Płatne przy odbiorze
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
Identyfikator projektu: 4452046

Informację o projekcie

10 ofert
Zdalny projekt
Aktywny 11 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
10 freelancerzy składają oferty o średniej wysokości $81 AUD dla tej pracy
Awatar Użytkownika
I can get this done by tomorrow morning. Ready to start now.
$128 AUD w 1 dzień
5,0 (181 opinii)
6,8
6,8
Awatar Użytkownika
Being a Professional !
$60 AUD w 1 dzień
4,9 (528 opinii)
7,0
7,0
Awatar Użytkownika
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 w 3 dni
5,0 (95 opinii)
6,9
6,9
Awatar Użytkownika
Ready for this now and will be completing it 4 hours from now.
$99 AUD w 1 dzień
4,9 (83 opinii)
7,0
7,0
Awatar Użytkownika
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 w 1 dzień
4,9 (113 opinii)
6,6
6,6
Awatar Użytkownika
Hello, Can make this. I complete many php project(including project with mysql/css). Can start right now. Regards. Dima
$54 AUD w 1 dzień
5,0 (71 opinii)
5,9
5,9
Awatar Użytkownika
Let me complete it first, then we will mark this project as complete. Thanks.
$45 AUD w 1 dzień
5,0 (16 opinii)
5,3
5,3
Awatar Użytkownika
Hi - I'd love to work with you on this and would get it done quickly ! Thanks Martin
$99 AUD w 1 dzień
5,0 (22 opinii)
4,3
4,3
Awatar Użytkownika
senior web developer , let's get started now
$110 AUD w 0 dzień
4,9 (7 opinii)
3,4
3,4
Awatar Użytkownika
Hi sir, please check your inbox.
$50 AUD w 1 dzień
4,6 (10 opinii)
3,2
3,2

O kliencie

Flaga AUSTRALIA
Malaga, Australia
5,0
3
Zweryfikowana metoda płatności
Członek od mar 13, 2013

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.